[Freeswitch-users] SPA942 - SLA - Inbound calls

[Aloysius Lloyd]

Hello All,

I have difficulty with Inbound SLA. Outbound SLA working without any issue.
Inbound SLA not working.

FreeSWITCH Version - FreeSWITCH Version 1.0.head (git-6875a97 2010-09-08
16-33-50 -0500)

Linksys SPA942 - 6.1.5(a)

Once the inbound call answered the following SQL Error appear on the debug
log.  Please let me know how to fix this issue.


2010-09-08 23:06:25.086299 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT
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='
mydomain.com'
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='
mydomain.com' and (event='call-info' or event='line-seize')
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[
5c0f4043-aaa7bbd0 at 192.168.240.104]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1
[expires]=[1284008633]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2
[sub_to_user]=[200]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3
[sub_to_host]=[mydomain.com]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4
[event]=[call-info]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[
696f8b47-50fa4cba at 192.168.240.110]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1
[expires]=[1284008691]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2
[sub_to_user]=[200]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3
[sub_to_host]=[mydomain.com]
2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4
[event]=[call-info]
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='mydomain.com' and
call_info_state='seized'
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'
2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT
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='
mydomain.com'
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='
mydomain.com' and (event='call-info' or event='line-seize')
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='mydomain.com' and
call_info_state='seized'



Thanks
Lloyd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100908/be8b6de1/attachment-0001.html