Hello All,<div><br></div><div>I have difficulty with Inbound SLA. Outbound SLA working without any issue. Inbound SLA not working.</div><div><br></div><div>FreeSWITCH Version - FreeSWITCH Version 1.0.head (git-6875a97 2010-09-08 16-33-50 -0500)</div>
<div><br></div><div>Linksys SPA942 - 6.1.5(a)</div><div><br></div><div>Once the inbound call answered the following SQL Error appear on the debug log. Please let me know how to fix this issue.</div><div><br></div><div><br>
</div><div><div>2010-09-08 23:06:25.086299 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT</div><div>2010-09-08 23:06:25.086299 [ERR] sofia_presence.c:1827 PRES SQL select sip_from_user,sip_from_host,call_info,call_info_state,uuid from sip_dialogs where hostname='li176-12' and sip_from_user='200' and sip_from_host='<a href="http://mydomain.com">mydomain.com</a>'</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1848 PRES SQL select call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions where expires > -1 and hostname='li176-12' and sub_to_user='200' and sub_to_host='<a href="http://mydomain.com">mydomain.com</a>' and (event='call-info' or event='line-seize')</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[<a href="mailto:5c0f4043-aaa7bbd0@192.168.240.104">5c0f4043-aaa7bbd0@192.168.240.104</a>]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1 [expires]=[1284008633]</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2 [sub_to_user]=[200]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3 [sub_to_host]=[<a href="http://mydomain.com">mydomain.com</a>]</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4 [event]=[call-info]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[<a href="mailto:696f8b47-50fa4cba@192.168.240.110">696f8b47-50fa4cba@192.168.240.110</a>]</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1 [expires]=[1284008691]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2 [sub_to_user]=[200]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3 [sub_to_host]=[<a href="http://mydomain.com">mydomain.com</a>]</div>
<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4 [event]=[call-info]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1863 CLEAR SQL delete from sip_dialogs where sip_from_user='200' and sip_from_host='<a href="http://mydomain.com">mydomain.com</a>' and call_info_state='seized'</div>
<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:680 STATE SQL update sip_dialogs set call_info='appearance-index=1',call_info_state='active' where hostname='li176-12' and uuid='00f17b14-2e0b-4711-b082-a7c5a90621d8'</div>
<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT</div><div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:1827 PRES SQL select sip_from_user,sip_from_host,call_info,call_info_state,uuid from sip_dialogs where hostname='li176-12' and sip_from_user='200' and sip_from_host='<a href="http://mydomain.com">mydomain.com</a>'</div>
<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:1848 PRES SQL select call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions where expires > -1 and hostname='li176-12' and sub_to_user='200' and sub_to_host='<a href="http://mydomain.com">mydomain.com</a>' and (event='call-info' or event='line-seize')</div>
<div>2010-09-08 23:06:25.089546 [ERR] sofia_presence.c:1863 CLEAR SQL delete from sip_dialogs where sip_from_user='200' and sip_from_host='<a href="http://mydomain.com">mydomain.com</a>' and call_info_state='seized'</div>
</div><div><br></div><div><br></div><div><br clear="all">Thanks</div><div>Lloyd<br><br>
</div>