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_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 <[email protected]>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:[email protected]] > *Sent:* Thursday, October 01, 2009 8:14 PM > > *To:* [email protected] > *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 <[email protected] > > wrote: > >> If you have time to take a look, I could put a trace in the pastebin? >> >> Jerry >> >> ------------------------------ >> *From:* Jerry Richards [mailto:[email protected]] >> *Sent:* Thursday, October 01, 2009 10:29 AM >> *To:* '[email protected]' >> *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:[email protected]] >> *Sent:* Thursday, October 01, 2009 9:36 AM >> *To:* [email protected] >> *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 < >> [email protected]> 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:[email protected]] >>> Sent: Wednesday, September 30, 2009 9:12 AM >>> To: '[email protected]' >>> 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 >>> [email protected] >>> 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:[email protected] <msn%[email protected]> >> GTALK/JABBER/PAYPAL:[email protected]<paypal%[email protected]> >> IRC: irc.freenode.net #freeswitch >> >> FreeSWITCH Developer Conference >> sip:[email protected] <sip%[email protected]> >> iax:[email protected]/888 >> googletalk:[email protected]<googletalk%3aconf%[email protected]> >> pstn:213-799-1400 >> >> >> _______________________________________________ >> FreeSWITCH-users mailing list >> [email protected] >> 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 > [email protected] > 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:[email protected] <msn%[email protected]> GTALK/JABBER/PAYPAL:[email protected]<paypal%[email protected]> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:[email protected] <sip%[email protected]> iax:[email protected]/888 googletalk:[email protected]<googletalk%3aconf%[email protected]> pstn:213-799-1400
_______________________________________________ FreeSWITCH-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
