2009-05-26 17:37:50 [INFO] sofia_presence.c:617 actual_sofia_presence_event_handler() IN END_PRESENCE_SQL (internal)
2009-05-26 17:37:50 [WARNING] sofia_presence.c:571 actual_sofia_presence_event_handler() external is passive, skipping
2009-05-26 17:37:50 [NOTICE] switch_core_session.c:1020 switch_core_session_thread() Close Channel sofia/internal/97719006@163.28.2.7:5060 [CS_DONE]
2009-05-26 17:37:50 [WARNING] sofia_presence.c:564 actual_sofia_presence_event_handler() 203.64.215.209 is an alias, skipping
2009-05-26 17:37:50 [WARNING] sofia_presence.c:564 actual_sofia_presence_event_handler() default is an alias, skipping
2009-05-26 17:37:50 [WARNING] sofia_presence.c:564 actual_sofia_presence_event_handler() nat is an alias, skipping
2009-05-26 17:37:50 [WARNING] sofia_presence.c:564 actual_sofia_presence_event_handler() outbound is an alias, skipping
2009-05-26 17:37:50 [INFO] sofia_presence.c:601 actual_sofia_presence_event_handler() IN START_PRESENCE_SQL (internal)
2009-05-26 17:37:50 [ERR] sofia_presence.c:609 actual_sofia_presence_event_handler() DUMP PRESENCE SQL:
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,'Call Ended','unknown','163.28.2.7',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 (event='presence' or event='dialog') and sub_to_user='97719006' and (sub_to_host='163.28.2.7' or presence_hosts like '%163.28.2.7%') and (sip_subscriptions.profile_name = 'internal' or sip_subscriptions.presence_hosts != sip_subscriptions.sub_to_host)
EVENT DUMP:
Event-Name: [PRESENCE_IN]
Core-UUID: [0cfc45ae-5cb5-0148-aa9b-3ed9fb0f8255]
FreeSWITCH-Hostname: [xpp-8435d6cb386]
FreeSWITCH-IPv4: [203.64.215.209]
FreeSWITCH-IPv6: [::1]
Event-Date-Local: [2009-05-26 17:37:50]
Event-Date-GMT: [Tue, 26 May 2009 09:37:50 GMT]
Event-Date-Timestamp: [1243330670130868]
Event-Calling-File: [switch_channel.c]
Event-Calling-Function: [switch_channel_presence]
Event-Calling-Line-Number: [467]
Channel-State: [CS_HANGUP]
Channel-State-Number: [10]
Channel-Name: [sofia/internal/97719006@163.28.2.7:5060]
Unique-ID: [9218a3e4-04be-1d4a-97ea-8bdcb20ae3b7]
Call-Direction: [inbound]
Presence-Call-Direction: [inbound]
Answer-State: [ringing]
Channel-Read-Codec-Name: [PCMU]
Channel-Read-Codec-Rate: [8000]
Channel-Write-Codec-Name: [PCMU]
Channel-Write-Codec-Rate: [8000]
Caller-Username: [97719006]
Caller-Dialplan: [XML]
Caller-Caller-ID-Name: [97719006]
Caller-Caller-ID-Number: [97719006]
Caller-Network-Addr: [163.28.32.51]
Caller-Destination-Number: [97730009]
Caller-Unique-ID: [9218a3e4-04be-1d4a-97ea-8bdcb20ae3b7]
Caller-Source: [mod_sofia]
Caller-Context: [public]
Caller-Channel-Name: [sofia/internal/97719006@163.28.2.7:5060]
Caller-Profile-Index: [1]
Caller-Profile-Created-Time: [1243330670083993]
Caller-Channel-Created-Time: [1243330670083993]
Caller-Channel-Answered-Time: [0]
Caller-Channel-Progress-Time: [0]
Caller-Channel-Progress-Media-Time: [0]
Caller-Channel-Hangup-Time: [1243330670130868]
Caller-Channel-Transfer-Time: [0]
Caller-Screen-Bit: [true]
Caller-Privacy-Hide-Name: [false]
Caller-Privacy-Hide-Number: [false]
proto: [..\..\src\switch_channel.c]
login: [..\..\src\switch_channel.c]
from: [97719006@163.28.2.7]
rpid: [unknown]
status: [CS_HANGUP]
event_type: [presence]
alt_event_type: [dialog]
event_count: [3]