<!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>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT face=Arial><FONT 
color=#0000ff><FONT size=2>I put the sqlite3 select query in the paste bin<SPAN 
class=135120420-09102009> again</SPAN>, and prior to that, I entered the .dump 
command.&nbsp; The select command came back with&nbsp;<SPAN 
class=135120420-09102009>the sqlite3 </SPAN>prompt<SPAN 
class=135120420-09102009>,</SPAN> which I&nbsp;<SPAN 
class=135120420-09102009>guess means it didn't find an entry.&nbsp;&nbsp;How do 
I go about isolating this problem</SPAN>?<SPAN class=135120420-09102009>&nbsp; 
I'm using&nbsp;CounterPath's&nbsp;Bria Professional softphone.&nbsp; They are 
the same company that make the Eyebeam.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT face=Arial><FONT 
color=#0000ff><FONT size=2><SPAN 
class=135120420-09102009></SPAN></FONT></FONT></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT face=Arial><FONT 
color=#0000ff><FONT size=2><SPAN class=135120420-09102009>Any 
ideas?</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=859122418-02102009><FONT color=#0000ff 
size=2 face=Arial></FONT></SPAN>&nbsp;</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></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Jerry Richards 
[mailto:jerry.richards@teotech.com] <BR><B>Sent:</B> Friday, October 02, 2009 
11:28 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>
<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.&nbsp; The select command came back with a 
"...&gt;" prompt which I don't understand.&nbsp; 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>&nbsp;</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>&lt;<A 
  href="mailto:jerry.richards@teotech.com">jerry.richards@teotech.com</A>&gt;</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.&nbsp; 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>&nbsp;</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>&lt;<A href="mailto:jerry.richards@teotech.com" 
      target=_blank>jerry.richards@teotech.com</A>&gt;</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>&nbsp;</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>&nbsp;</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>&lt;<A 
            href="mailto:jerry.richards@teotech.com" 
            target=_blank>jerry.richards@teotech.com</A>&gt;</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. 
              &nbsp;Could someone point me toward what might<BR>cause this? 
              &nbsp;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 &nbsp;DUMP PRESENCE SQL<BR>&nbsp; 
              ...<BR>[INFO] sofia_presence.c:603 IN START_PRESENCE_SQL 
              (internal-ipv6)<BR>[ERR] sofia_presence.c:611 &nbsp;DUMP PRESENCE 
              SQL<BR>&nbsp; ...<BR>[INFO] sofia_presence.c:603 IN 
              START_PRESENCE_SQL (external)<BR>[ERR] sofia_presence.c:611 
              &nbsp;DUMP PRESENCE SQL<BR>&nbsp; ...<BR>[WARNING] 
              sofia_presence.c:565 &nbsp;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. 
              &nbsp;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>