Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISH To Subscribing Phones
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
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 <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
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
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
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 <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<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
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
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 *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 <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<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 <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
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
You are missing the trailing ; On Fri, Oct 2, 2009 at 1:28 PM, Jerry Richards <jerry.richards@teotech.com> wrote:
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
-- -Rupa
Okay, I added the ";" at the end of the sqlite3 "select" command and it just returned to the "sqlite>" prompt. No error was returned. Do you see anything in my database (in the pastebin) that is incorrect? By the way, the "select" command I put in the pastebin refers to the "external" config, but the "internal" config does the same thing. Best Regards, Jerry -----Original Message----- From: Rupa Schomaker [mailto:rupa@rupa.com] Sent: Friday, October 02, 2009 11:42 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] FS Does Not RelayPresencePUBLISHToSubscribing Phones You are missing the trailing ; On Fri, Oct 2, 2009 at 1:28 PM, Jerry Richards <jerry.richards@teotech.com> wrote:
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
-- -Rupa
participants (4)
-
Anthony Minessale
-
Jerry Richards
-
João Mesquita
-
Rupa Schomaker