[Freeswitch-users] FW: FS Does Not Relay PresencePUBLISHToSubscribing Phones

Anthony Minessale anthony.minessale at gmail.com
Fri Oct 9 15:53:13 PDT 2009


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
<jerry.richards at teotech.com>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:jerry.richards at teotech.com]
> *Sent:* Friday, October 02, 2009 11:28 AM
> *To:* 'freeswitch-users at 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 at gmail.com]
> *Sent:* Friday, October 02, 2009 10:52 AM
> *To:* freeswitch-users at 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 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
>
>
> _______________________________________________
> 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/20091009/72061e0b/attachment-0002.html 


More information about the FreeSWITCH-users mailing list