[Freeswitch-users] FS Does Not Relay Presence PUBLISHToSubscribing Phones

Fri Oct 2 10:52:17 PDT 2009

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 at 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 at freeswitch.org]
> *Sent:* Thursday, October 01, 2009 8:14 PM
>
> *To:* freeswitch-users at 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 at 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 at teotech.com]
>> *Sent:* Thursday, October 01, 2009 10:29 AM
>> *To:* 'freeswitch-users at 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 at gmail.com]
>> *Sent:* Thursday, October 01, 2009 9:36 AM
>> *To:* freeswitch-users at 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 at 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 at teotech.com]
>>> Sent: Wednesday, September 30, 2009 9:12 AM
>>> To: 'freeswitch-users at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
>> IRC: irc.freenode.net #freeswitch
>>
>> FreeSWITCH Developer Conference
>> sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
>> iax:guest at conference.freeswitch.org/888
>> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
>> pstn:213-799-1400
>>
>>
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091002/73d9f3e4/attachment-0002.html 