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 class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Best Regards,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Jerry</font></span></div><br>
<blockquote style="margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><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: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><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" face="Arial" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>Jerry</span></font></div><br>
<blockquote style="margin-right: 0px;" dir="ltr">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2">
<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" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Jerry</font></span></div><br></div>
<blockquote style="margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2">
<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: 1px solid rgb(204, 204, 204); 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>