[Freeswitch-users] vars from sip_registrations table

Tue Mar 9 10:10:42 PST 2010

Aww, The les paul sounded nice I have one on my wishlist =D
http://bit.ly/bRHKlk

*shrug* $250.00 maybe?

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

>  OK How much ?
>
> ----- Original Message -----
> *From:* Anthony Minessale <anthony.minessale at gmail.com>
> *To:* freeswitch-users at lists.freeswitch.org
> *Sent:* Tuesday, March 09, 2010 11:39 AM
> *Subject:* Re: [Freeswitch-users] vars from sip_registrations table
>
> 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
>
> ------------------------------
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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/f9339112/attachment-0002.html 