On Wed, Sep 8, 2010 at 10:16 PM, Aloysius Lloyd
<
lloyd.aloysius@gmail.com> wrote:
> 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@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@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
>
>