[Freeswitch-users] vars from sip_registrations table

Tue Mar 9 11:06:07 PST 2010

Also, when you are done insulting me, maybe try sofia_contact api command
that will resolve your destination to the exact contact string that the
phone registered with which is really the only bit of info
that you would possibly need rather than asking for another expensive
database lookup per call.

On Tue, Mar 9, 2010 at 12:45 PM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> ORLY,
>
> So maybe if you *think* you know what you are talking about, you should go
> do some research on the average amount of code I write on a daily basis
> nonstop for the last several years without "ask money".  This includes most
> of the core, and 90% of the modules you are playing with right now including
> the 24 thousand lines of code in mod_sofia alone.
> So frankly, since I don't see an urgent need for your request, and I am too
> busy to do it, this particular feature would require a bounty to complete.
>
> By the way, you have sent like 2 dozen emails in the same week asking for
> all kinds of help, that's also being shared to you for free so I think you
> are getting the better side of the bargain here.  Asking for a bounty on a
> feature that only helps one individual is very common.............
>
>
>
>
>
> On Tue, Mar 9, 2010 at 12:25 PM, Madovsky <infos at madovsky.org> wrote:
>
>>  I said I OFFER it in case of I finish my (no money no profit but big
>> potential) experimental project.
>> I understand perfectly your mind of how to manage an open source project,
>> but don't forget
>> that there are guys like you on this emailist who don't even make any
>> decent salary, that is why
>> I use and develop open source : share -> evovle your minds -> make all
>> people happy -> money comes
>> but not                                         share -> ask money -> make
>> people weird -> money won't come
>> it's my point of view.
>>
>> Regards
>>
>> ----- Original Message -----
>>  *From:* Anthony Minessale <anthony.minessale at gmail.com>
>> *To:* freeswitch-users at lists.freeswitch.org
>>  *Sent:* Tuesday, March 09, 2010 1:10 PM
>> *Subject:* Re: [Freeswitch-users] vars from sip_registrations table
>>
>> 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
>>
>> ------------------------------
>>
>> _______________________________________________
>> 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
>

-- 
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/2905240b/attachment-0002.html 