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:jerry.richards@teotech.com]
Sent: Friday, October 02, 2009 11:28 AM
To: 'freeswitch-users@lists.freeswitch.org'
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: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_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 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 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 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
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