yah what i was getting at was between the sql statement and what was actually in the table you should be able to tell what's wrong.
On Fri, Oct 9, 2009 at 3:06 PM, Jerry Richards <[email protected]>wrote: > I put the sqlite3 select query in the paste bin again, and prior to that, > I entered the .dump command. The select command came back with the > sqlite3 prompt, which I guess means it didn't find an entry. How do I go > about isolating this problem? I'm using CounterPath's Bria Professional > softphone. They are the same company that make the Eyebeam. > > Any ideas? > > Best Regards, > Jerry > > > ------------------------------ > *From:* Jerry Richards [mailto:[email protected]] > *Sent:* Friday, October 02, 2009 11:28 AM > *To:* '[email protected]' > *Subject:* RE: [Freeswitch-users] FS Does Not Relay > PresencePUBLISHToSubscribing Phones > > 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:[email protected]] > *Sent:* Friday, October 02, 2009 10:52 AM > *To:* [email protected] > *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_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 > > -- 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
