[Freeswitch-users] vars from sip_registrations table

Tue Mar 9 08:39:17 PST 2010

You would need to make a patch for it or pay someone to add it.

On Tue, Mar 9, 2010 at 2:04 AM, Madovsky <infos at madovsky.org> wrote:

>  forgot to say that I need it (since I didn't find any good examples)
> for a 2 FS clustered without SRV NAPTR in DNS (the client I should use is
> not compatible)
>
> Thanks
>
> F
>
> ----- Original Message -----
> *From:* Madovsky <infos at madovsky.org>
> *To:* freeswitch-users at lists.freeswitch.org
> *Sent:* Tuesday, March 09, 2010 2:59 AM
> *Subject:* vars from sip_registrations table
>
> in sip_registration table there are
> call_id<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=1&sortdir=asc&strings=collapsed&page=1>
> sip_user<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=2&sortdir=asc&strings=collapsed&page=1>
> sip_host<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=3&sortdir=asc&strings=collapsed&page=1>
> presence_hosts<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=4&sortdir=asc&strings=collapsed&page=1>
> contact<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=5&sortdir=asc&strings=collapsed&page=1>
> status<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=6&sortdir=asc&strings=collapsed&page=1>
> rpid<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=7&sortdir=asc&strings=collapsed&page=1>
> expires<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=8&sortdir=asc&strings=collapsed&page=1>
> user_agent<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=9&sortdir=asc&strings=collapsed&page=1>
> server_user<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=10&sortdir=asc&strings=collapsed&page=1>
> server_host<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=11&sortdir=asc&strings=collapsed&page=1>
> profile_name<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=12&sortdir=asc&strings=collapsed&page=1>
> hostname<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=13&sortdir=asc&strings=collapsed&page=1>
> network_ip<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=14&sortdir=asc&strings=collapsed&page=1>
> network_port<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=15&sortdir=asc&strings=collapsed&page=1>
> sip_username<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=16&sortdir=asc&strings=collapsed&page=1>
> sip_realm<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=17&sortdir=asc&strings=collapsed&page=1>
> mwi_user<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=18&sortdir=asc&strings=collapsed&page=1>
> mwi_host<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=19&sortdir=asc&strings=collapsed&page=1>
> orig_server_host<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=20&sortdir=asc&strings=collapsed&page=1>
> orig_hostname<https://secure.live-school.net/phpPgAdmin4/display.php?server=10.0.0.1%3A5432&database=freeswitch&schema=public&table=sip_registrations&subject=table&return_url=tblproperties.php%3Fserver%3D10.0.0.1%253A5432%26amp%3Bdatabase%3Dfreeswitch%26amp%3Bschema%3Dpublic%26table%3Dsip_registrations&return_desc=Back&sortkey=21&sortdir=asc&strings=collapsed&page=1>
>
> fields, so how can I get these vars from the callee before the bridge ?
> I need to replace the host of the callee in case of if he's registered on
> another FS node.
>
> thanks
>
> Franck
>
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>

-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100309/47279ff9/attachment-0002.html 