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.<br><br><br><div class="gmail_quote">On Fri, Oct 9, 2009 at 3:06 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">
<div dir="ltr" align="left"><span><font face="Arial"><font color="#0000ff"><font size="2">I put the sqlite3 select query in the paste bin<span> again</span>, and prior to that, I entered the .dump
command. The select command came back with <span>the sqlite3 </span>prompt<span>,</span> which I <span>guess means it didn't find an entry. How do
I go about isolating this problem</span>?<span>
I'm using CounterPath's Bria Professional softphone. They are
the same company that make the Eyebeam.</span></font></font></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial"><font color="#0000ff"><font size="2"><span></span></font></font></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial"><font color="#0000ff"><font size="2"><span>Any
ideas?</span></font></font></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></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Jerry Richards
[mailto:<a href="mailto:jerry.richards@teotech.com" target="_blank">jerry.richards@teotech.com</a>] <br><b>Sent:</b> Friday, October 02, 2009
11:28 AM<div class="im"><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 PresencePUBLISHToSubscribing
Phones<br></font><br></div><div class="im">
<div></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">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><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>
</div><blockquote style="margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Anthony Minessale
[mailto:<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>] <br><b>Sent:</b> Friday, October 02, 2009
10:52 AM<div class="im"><br><b>To:</b>
<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br></div><div class="im"><b>Subject:</b> Re:
[Freeswitch-users] FS Does Not Relay PresencePUBLISHToSubscribing
Phones<br></div></font><br></div><div class="im">
<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>192.168</span><span>.72</span><span>.38</span>',sip_presence.status,sip_presence.rpid from
sip_subscriptions left join sip_presence on <span>(</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>)</span> where <span>(</span>event='presence' or
event='presence'<span>)</span> and sub_to_user='<span>1001</span>' and <span>(</span>sub_to_host='<span>192.168</span><span>.72</span><span>.38</span>'
or presence_hosts like '%<span>192.168</span><span>.72</span><span>.38</span>%'<span>)</span> and
<span>(</span>sip_subscriptions.profile_name = 'external' or
sip_subscriptions.presence_hosts != sip_subscriptions.sub_to_host<span>)<br><br></span><br>
</div><div class="gmail_quote"><div class="im">On Fri, Oct 2, 2009 at 12:12 PM, Jerry Richards <span dir="ltr"><<a href="mailto:jerry.richards@teotech.com" target="_blank">jerry.richards@teotech.com</a>></span>
wrote:<br>
</div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div><div class="im">
<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>
</div><blockquote style="margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><div class="im"><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>
<div><br><div class="im"><b>To:</b> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br></div><div class="im"><b>Subject:</b>
Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISHToSubscribing
Phones<br></div></div></div></font><br></div>
<div>
<div></div>
<div><div class="im">
<div></div>Piece of advice, don't ask, just do it.
;)<br><br>jmesquita<br><br>
</div><div class="gmail_quote"><div class="im">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>
</div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div><div class="im">
<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>
</div><blockquote style="margin-right: 0px;" dir="ltr">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><div class="im">
<div><b>From:</b> Jerry Richards [mailto:<a href="mailto:jerry.richards@teotech.com" target="_blank">jerry.richards@teotech.com</a>] <br></div></div><b>Sent:</b>
Thursday, October 01, 2009 10:29 AM
<div class="im"><div><br><b>To:</b> '<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a>'<br></div></div><div class="im"><b>Subject:</b>
RE: [Freeswitch-users] FS Does Not Relay Presence PUBLISH
ToSubscribing Phones<br></div></font><br></div><div class="im">
<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>
</div><blockquote style="margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><div class="im">
<div><b>From:</b> Anthony Minessale [mailto:<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>]
<br></div></div><b>Sent:</b> Thursday, October 01, 2009 9:36 AM
<div class="im"><div><br><b>To:</b> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br></div></div><div class="im"><b>Subject:</b>
Re: [Freeswitch-users] FS Does Not Relay Presence PUBLISH
ToSubscribing Phones<br></div></font><br></div>
<div>
<div></div>
<div><div class="im">
<div></div>which phone is it,<br>we tested it with eyebeam and it
appears to work for us.<br><br><br>
</div><div class="gmail_quote"><div class="im">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>
</div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote"><div class="im"><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></div>Best Regards,<br><font color="#888888">Jerry<br></font>
<div>
<div></div>
<div><div class="im"><br><br>-----Original Message-----<br>From: Jerry Richards
[mailto:<a href="mailto:jerry.richards@teotech.com" target="_blank">jerry.richards@teotech.com</a>]<br></div><div class="im">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></div><div class="im">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></div><div class="im">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></div></blockquote></div><br><br clear="all"><br><div class="im">-- <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></div></blockquote></blockquote></div><br>_______________________________________________<div class="im">
<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></div></blockquote></div><br></div></div></blockquote></div><div class="im"><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></div></blockquote></div><br><br clear="all"><br><div class="im">-- <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></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>