VoIP Mailing List Archives

[jerry.richards at teot...]

I put the sqlite3 select query in the paste bin, and prior to that, I entered the .dump command. The select command came back with a "...>" prompt which I don't understand. I don't know enough about sqlite3 to know what that means? Best Regards, Jerry From: Anthony Minessale [mailto:anthony.minessale@gmail.com] Sent: Friday, October 02, 2009 10:52 AMTo: freeswitch-users@lists.freeswitch.orgSubject: Re: [Freeswitch-users] FS Does Not Relay PresencePUBLISHToSubscribing Phones connect to sqlite directly with sqlite3 app and try that sql stmt and see why it doesn't match anything.sqlite3 /usr/local/freeswitch/db/sofia_reg_internal.dbselect sip_subscriptions.proto,sip_subscriptions.sip_user,sip_subscriptions.sip_host,sip_subscriptions.sub_to_user,sip_subscriptions.sub_to_host,sip_subscriptions.event,sip_subscriptions.contact,sip_subscriptions.call_id,sip_subscriptions.full_from,sip_subscriptions.full_via,sip_subscriptions.expires,sip_subscriptions.user_agent,sip_subscriptions.accept,sip_subscriptions.profile_name,'Away','away','192.168.72.38',sip_presence.status,sip_presence.rpid from sip_subscriptions left join sip_presence on (sip_subscriptions.sub_to_user=sip_presence.sip_user and sip_subscriptions.sub_to_host=sip_presence.sip_host and sip_subscriptions.profile_name=sip_presence.profile_name) where (event='presence' or event='presence') and sub_to_user='1001' and (sub_to_host='192.168.72.38' or presence_hosts like '%192.168.72.38%') and (sip_subscriptions.profile_name = 'external' or sip_subscriptions.presence_hosts != sip_subscriptions.sub_to_host) On Fri, Oct 2, 2009 at 12:12 PM, Jerry Richards <jerry.richards@teotech.com (jerry.richards@teotech.com)> wrote: Okay, I put a log up on the pastebin that shows the PUBLISH event coming from a CounterPath Bria Professional phone. For some reason, FS is getting an error and not relaying the presence status to the subscriber. Best Regards, Jerry From: João Mesquita [mailto:jmesquita@freeswitch.org (jmesquita@freeswitch.org)] Sent: Thursday, October 01, 2009 8:14 PM To: freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)Subject: Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISHToSubscribing Phones Piece of advice, don't ask, just do it. ;)jmesquita On Thu, Oct 1, 2009 at 3:29 PM, Jerry Richards <jerry.richards@teotech.com (jerry.richards@teotech.com)> wrote: If you have time to take a look, I could put a trace in the pastebin? Jerry From: Jerry Richards [mailto:jerry.richards@teotech.com (jerry.richards@teotech.com)] Sent: Thursday, October 01, 2009 10:29 AM To: 'freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)'Subject: RE: [Freeswitch-users] FS Does Not Relay Presence PUBLISH ToSubscribing Phones I am using two Bria Professional Version 2.5.4 Build 54835 softphones. Thanks, Jerry From: Anthony Minessale [mailto:anthony.minessale@gmail.com (anthony.minessale@gmail.com)] Sent: Thursday, October 01, 2009 9:36 AM To: freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)Subject: Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISH ToSubscribing Phones which phone is it,we tested it with eyebeam and it appears to work for us. On Thu, Oct 1, 2009 at 9:57 AM, Jerry Richards <jerry.richards@teotech.com (jerry.richards@teotech.com)> wrote: By the way, I see the following lines at the FS console, which might be aclue as to why this is happening. Could someone point me toward what mightcause this? I set the "manage-presence" parameter to "true" in each XMLfile where I saw it defined.[INFO] sofia_presence.c:603 IN START_PRESENCE_SQL (internal)[ERR] sofia_presence.c:611 DUMP PRESENCE SQL ...[INFO] sofia_presence.c:603 IN START_PRESENCE_SQL (internal-ipv6)[ERR] sofia_presence.c:611 DUMP PRESENCE SQL ...[INFO] sofia_presence.c:603 IN START_PRESENCE_SQL (external)[ERR] sofia_presence.c:611 DUMP PRESENCE SQL ...[WARNING] sofia_presence.c:565 192.168.72.38 is an alias, skippingBest Regards,Jerry -----Original Message-----From: Jerry Richards [mailto:jerry.richards@teotech.com (jerry.richards@teotech.com)]Sent: Wednesday, September 30, 2009 9:12 AMTo: 'freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)'Subject: FS Does Not Relay Presence PUBLISH To Subscribing PhonesI have two phones configured to subscribe to each other's presence status.When I change the presence status in one phone, I see the SIP PUBLISHmessage going to FS, but I don't see FS relaying that presence status to thesubscribing phone. Does anyone know why?Best Regards,Jerry_______________________________________________FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.org (FreeSWITCH-users@lists.freeswitch.org)MSN:anthony_minessale@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])IRC: sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])pstn:213-799-1400_______________________________________________FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.org (FreeSWITCH-users@lists.freeswitch.org)FreeSWITCH-users@lists.freeswitch.org (FreeSWITCH-users@lists.freeswitch.org)MSN:anthony_minessale@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])IRC: sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])pstn:213-799-1400

[rupa at rupa.com]

You are missing the trailing ;

On Fri, Oct 2, 2009 at 1:28 PM, Jerry Richards
<jerry.richards@teotech.com> wrote: