<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT color=#0000ff
size=2 face=Arial>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT color=#0000ff
size=2 face=Arial>Best Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT color=#0000ff
size=2 face=Arial>Jerry</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Anthony Minessale
[mailto:anthony.minessale@gmail.com] <BR><B>Sent:</B> Friday, October 02, 2009
10:52 AM<BR><B>To:</B>
freeswitch-users@lists.freeswitch.org<BR><B>Subject:</B> Re:
[Freeswitch-users] FS Does Not Relay PresencePUBLISHToSubscribing
Phones<BR></FONT><BR></DIV>
<DIV></DIV>connect to sqlite directly with sqlite3 app and try that sql stmt
and see why it doesn't match anything.<BR><BR>sqlite3
/usr/local/freeswitch/db/sofia_reg_internal.db<BR><BR>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','<SPAN
class=nu0>192.168</SPAN><SPAN class=nu0>.72</SPAN><SPAN
class=nu0>.38</SPAN>',sip_presence.status,sip_presence.rpid from
sip_subscriptions left join sip_presence on <SPAN
class=br0>(</SPAN>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<SPAN
class=br0>)</SPAN> where <SPAN class=br0>(</SPAN>event='presence' or
event='presence'<SPAN class=br0>)</SPAN> and sub_to_user='<SPAN
class=nu0>1001</SPAN>' and <SPAN class=br0>(</SPAN>sub_to_host='<SPAN
class=nu0>192.168</SPAN><SPAN class=nu0>.72</SPAN><SPAN class=nu0>.38</SPAN>'
or presence_hosts like '%<SPAN class=nu0>192.168</SPAN><SPAN
class=nu0>.72</SPAN><SPAN class=nu0>.38</SPAN>%'<SPAN class=br0>)</SPAN> and
<SPAN class=br0>(</SPAN>sip_subscriptions.profile_name = 'external' or
sip_subscriptions.presence_hosts != sip_subscriptions.sub_to_host<SPAN
class=br0>)<BR><BR></SPAN><BR>
<DIV class=gmail_quote>On Fri, Oct 2, 2009 at 12:12 PM, Jerry Richards <SPAN
dir=ltr><<A
href="mailto:jerry.richards@teotech.com">jerry.richards@teotech.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>Best
Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Jerry</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma><B>From:</B> Joćo Mesquita [mailto:<A
href="mailto:jmesquita@freeswitch.org"
target=_blank>jmesquita@freeswitch.org</A>] <BR><B>Sent:</B> Thursday,
October 01, 2009 8:14 PM
<DIV>
<DIV></DIV>
<DIV class=h5><BR><B>To:</B> <A
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A><BR><B>Subject:</B>
Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISHToSubscribing
Phones<BR></DIV></DIV></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV></DIV>Piece of advice, don't ask, just do it.
;)<BR><BR>jmesquita<BR><BR>
<DIV class=gmail_quote>On Thu, Oct 1, 2009 at 3:29 PM, Jerry Richards
<SPAN dir=ltr><<A href="mailto:jerry.richards@teotech.com"
target=_blank>jerry.richards@teotech.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN>If
you have time to take a look, I could put a trace in the
pastebin?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial><SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial><SPAN>Jerry</SPAN></FONT></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma>
<DIV><B>From:</B> Jerry Richards [mailto:<A
href="mailto:jerry.richards@teotech.com"
target=_blank>jerry.richards@teotech.com</A>] <BR></DIV><B>Sent:</B>
Thursday, October 01, 2009 10:29 AM
<DIV><BR><B>To:</B> '<A
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A>'<BR></DIV><B>Subject:</B>
RE: [Freeswitch-users] FS Does Not Relay Presence PUBLISH
ToSubscribing Phones<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>I
am using two Bria Professional Version 2.5.4 Build 54835
softphones.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Jerry</FONT></SPAN></DIV><BR></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma>
<DIV><B>From:</B> Anthony Minessale [mailto:<A
href="mailto:anthony.minessale@gmail.com"
target=_blank>anthony.minessale@gmail.com</A>]
<BR></DIV><B>Sent:</B> Thursday, October 01, 2009 9:36 AM
<DIV><BR><B>To:</B> <A
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A><BR></DIV><B>Subject:</B>
Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISH
ToSubscribing Phones<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV>
<DIV></DIV>which phone is it,<BR>we tested it with eyebeam and it
appears to work for us.<BR><BR><BR>
<DIV class=gmail_quote>On Thu, Oct 1, 2009 at 9:57 AM, Jerry
Richards <SPAN dir=ltr><<A
href="mailto:jerry.richards@teotech.com"
target=_blank>jerry.richards@teotech.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote><BR>By the way, I see the following lines at the
FS console, which might be a<BR>clue as to why this is happening.
Could someone point me toward what might<BR>cause this?
I set the "manage-presence" parameter to "true" in each
XML<BR>file where I saw it defined.<BR><BR>[INFO]
sofia_presence.c:603 IN START_PRESENCE_SQL (internal)<BR>[ERR]
sofia_presence.c:611 DUMP PRESENCE SQL<BR>
...<BR>[INFO] sofia_presence.c:603 IN START_PRESENCE_SQL
(internal-ipv6)<BR>[ERR] sofia_presence.c:611 DUMP PRESENCE
SQL<BR> ...<BR>[INFO] sofia_presence.c:603 IN
START_PRESENCE_SQL (external)<BR>[ERR] sofia_presence.c:611
DUMP PRESENCE SQL<BR> ...<BR>[WARNING]
sofia_presence.c:565 192.168.72.38 is an alias,
skipping<BR><BR><BR>Best Regards,<BR><FONT
color=#888888>Jerry<BR></FONT>
<DIV>
<DIV></DIV>
<DIV><BR><BR>-----Original Message-----<BR>From: Jerry Richards
[mailto:<A href="mailto:jerry.richards@teotech.com"
target=_blank>jerry.richards@teotech.com</A>]<BR>Sent: Wednesday,
September 30, 2009 9:12 AM<BR>To: '<A
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A>'<BR>Subject:
FS Does Not Relay Presence PUBLISH To Subscribing Phones<BR><BR>I
have two phones configured to subscribe to each other's presence
status.<BR>When I change the presence status in one phone, I see
the SIP PUBLISH<BR>message going to FS, but I don't see FS
relaying that presence status to the<BR>subscribing phone.
Does anyone know why?<BR><BR>Best
Regards,<BR>Jerry<BR><BR><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR></DIV></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Anthony Minessale II<BR><BR>FreeSWITCH <A
href="http://www.freeswitch.org/"
target=_blank>http://www.freeswitch.org/</A><BR>ClueCon <A
href="http://www.cluecon.com/"
target=_blank>http://www.cluecon.com/</A><BR>Twitter: <A
href="http://twitter.com/FreeSWITCH_wire"
target=_blank>http://twitter.com/FreeSWITCH_wire</A><BR><BR>AIM:
anthm<BR><A href="mailto:MSN%3Aanthony_minessale@hotmail.com"
target=_blank>MSN:anthony_minessale@hotmail.com</A><BR>GTALK/JABBER/<A
href="mailto:PAYPAL%3Aanthony.minessale@gmail.com"
target=_blank>PAYPAL:anthony.minessale@gmail.com</A><BR>IRC: <A
href="http://irc.freenode.net" target=_blank>irc.freenode.net</A>
#freeswitch<BR><BR>FreeSWITCH Developer Conference<BR><A
href="mailto:sip%3A888@conference.freeswitch.org"
target=_blank>sip:888@conference.freeswitch.org</A><BR><A
href="http://iax:guest@conference.freeswitch.org/888"
target=_blank>iax:guest@conference.freeswitch.org/888</A><BR><A
href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org"
target=_blank>googletalk:conf+888@conference.freeswitch.org</A><BR>pstn:213-799-1400<BR></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Anthony Minessale II<BR><BR>FreeSWITCH <A
href="http://www.freeswitch.org/">http://www.freeswitch.org/</A><BR>ClueCon <A
href="http://www.cluecon.com/">http://www.cluecon.com/</A><BR>Twitter: <A
href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</A><BR><BR>AIM:
anthm<BR><A
href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</A><BR>GTALK/JABBER/<A
href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</A><BR>IRC:
<A href="http://irc.freenode.net">irc.freenode.net</A>
#freeswitch<BR><BR>FreeSWITCH Developer Conference<BR><A
href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</A><BR><A
href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</A><BR><A
href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</A><BR>pstn:213-799-1400<BR></BLOCKQUOTE></BODY></HTML>