<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18876"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=068535420-26012010><FONT color=#0000ff
size=2 face=Arial>Okay, I setup my FS to force SUBSCRIBE Expires to 3600
seconds. Then I captured a FS console trace of a Bria softphone changing
it's presence state from 'Busy' to 'Away' (see <A
href="http://pastebin.freeswitch.org/11953">http://pastebin.freeswitch.org/11953</A>)
and observed that the subscribing Bria softphone did not update to 'Away'.
At the same time, I executed the sqlite3 app and pasted each of the 3 SQL select
statements I saw in the FS console log, and pasted them below. I'm new to
sqlite3. Do you see what my issue is?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=068535420-26012010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=068535420-26012010><FONT color=#0000ff
size=2 face="Courier New">sqlite><BR>sqlite> 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.79',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
sip_subscriptions.expires > -1 and (event='presence' or event='presence') and
sub_to_user='5401' and (sub_to_host='192.168.72.79' or presence_hosts like
'%192.168.72.79%') and (sip_subscriptions.profile_name = 'internal' or
sip_subscriptions.presence_hosts !=
sip_subscriptions.sub_to_host);<BR>sip|5382|192.168.72.79|5401|192.168.72.79|presence|"5382
on 79"
<sip:5382@192.168.72.150:34672>|ZTQ2ZWQwZGRlZjRiNTdkYTJjNGM5NTgzOWIyNmIwZmU.|"5382
on 79" <sip:5382@192.168.72.79>;tag=68bb4eb6|SIP/2.0/UDP
192.168.72.150:34672;branch=z9hG4bK-d8754z-eafc60166305eaef-1---d8754z-;rport=34672|1264546204|Teo
Softphone release 2.5.4 stamp
55958||internal|Away|away|192.168.72.79|Away|away<BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite>
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.79',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
sip_subscriptions.expires > -1 and (event='presence' or event='presence') and
sub_to_user='5401' and (sub_to_host='192.168.72.79' or presence_hosts like
'%192.168.72.79%') and (sip_subscriptions.profile_name = 'internal-ipv6' or
sip_subscriptions.presence_hosts !=
sip_subscriptions.sub_to_host);<BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite><BR>sqlite>
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.79',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
sip_subscriptions.expires > -1 and (event='presence' or event='presence') and
sub_to_user='5401' and (sub_to_host='192.168.72.79' or presence_hosts like
'%192.168.72.79%') and (sip_subscriptions.profile_name = 'external' or
sip_subscriptions.presence_hosts !=
sip_subscriptions.sub_to_host);<BR>sqlite><BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=068535420-26012010><FONT color=#0000ff
size=2 face=Arial>Thanks and Best Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=068535420-26012010><FONT color=#0000ff
size=2 face=Arial>Jerry</DIV></FONT></SPAN><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> Monday, January 25, 2010
11:05 AM<BR><B>To:</B>
freeswitch-users@lists.freeswitch.org<BR><B>Subject:</B> Re:
[Freeswitch-users] Presence Change Distribution<BR></FONT><BR></DIV>
<DIV></DIV>the notify will be instant after the publish<BR>the notify you see
are not triggered by the publish or they would be instant.<BR><BR>Same drill,
turn on presence debugging in sofia.conf.xml <BR>and look at the sql stmts and
see why<BR><BR><BR>
<DIV class=gmail_quote>On Mon, Jan 25, 2010 at 12:30 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
notice that if I reduce the Presence SUBSCRIBE Expires duration (from 3600
seconds to 60 seconds), then the delay between PUBLISH's and NOTIFY's is
reduced, but FS still waits nearly 45 seconds to send the NOTIFY's
after it receives a PUBLISH.</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>Can a
change be made in FS so that NOTIFYs are sent as a direct result of receipt
of the PUBLISH message? And not tied to the SUBSCRIBE
expiration? I really don't want to configure all my phones to
re-subscribe every 30 or 15 seconds.</FONT></SPAN></DIV>
<DIV class=im>
<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
and Best Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial>Jerry</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV><BR></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma><B>From:</B> RobertT [mailto:<A
href="mailto:siniypin@gmail.com" target=_blank>siniypin@gmail.com</A>]
<BR><B>Sent:</B> Tuesday, December 29, 2009 12:02 AM<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] Presence Change Distribution<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV></DIV>You can try to reduce your registration time. <BR>I for one
made my client apps send PUBLISH message every minute in addition to
reduced registration time.<BR><BR>Regards, Robert.<BR><BR>
<DIV class=gmail_quote>2009/12/28 Jerry Richards <SPAN dir=ltr><<A
href="mailto:jerry.richards@teotech.com"
target=_blank>jerry.richards@teotech.com</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Is there a setting to control how fast FS distributes
presence changes to<BR>subscribers? Currently, it appears to take
several minutes before I see<BR>presence changes. I would like to
see them almost instantaneously, if<BR>possible.<BR><BR>Thanks and 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></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:+19193869900<BR></BLOCKQUOTE></BODY></HTML>