connect to sqlite directly with sqlite3 app and try that sql stmt and see why it doesn't match anything.
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
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 <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 PhonesPiece 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 Subject: RE: [Freeswitch-users] FS Does Not Relay Presence PUBLISH ToSubscribing PhonesI 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 Subject: Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISH ToSubscribing Phoneswhich 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
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@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
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org
pstn:213-799-1400