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 AM To: freeswitch-users@lists.freeswitch.org Subject: 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.db select sip_subscriptions.proto,sip_subscriptions.sip_user,sip_subscriptions.sip_hos t,sip_subscriptions.sub_to_user,sip_subscriptions.sub_to_host,sip_subscripti ons.event,sip_subscriptions.contact,sip_subscriptions.call_id,sip_subscripti ons.full_from,sip_subscriptions.full_via,sip_subscriptions.expires,sip_subsc riptions.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> 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] Sent: Thursday, October 01, 2009 8:14 PM To: 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> 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] Sent: Thursday, October 01, 2009 10:29 AM To: '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] Sent: Thursday, October 01, 2009 9:36 AM To: 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> wrote: By the way, I see the following lines at the FS console, which might be a clue as to why this is happening. Could someone point me toward what might cause this? I set the "manage-presence" parameter to "true" in each XML file 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, skipping Best Regards, Jerry -----Original Message----- From: Jerry Richards [mailto:jerry.richards@teotech.com] Sent: Wednesday, September 30, 2009 9:12 AM To: 'freeswitch-users@lists.freeswitch.org' Subject: FS Does Not Relay Presence PUBLISH To Subscribing Phones I 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 PUBLISH message going to FS, but I don't see FS relaying that presence status to the subscribing phone. Does anyone know why? Best Regards, Jerry _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400 _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400