; CALL to user tester03, who has number *102233 <--- SIP read from UDP:109.195.38.121:50767 ---> INVITE sip:*102233@testsrv:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-796b085dfa676a6d-1---d8754z-;rport Max-Forwards: 70 Contact: To: From: "userA";tag=c650ee7b Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 1 INVITE Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REGISTER, SUBSCRIBE, NOTIFY, REFER, INFO, MESSAGE Content-Type: application/sdp Supported: replaces User-Agent: 3CXPhone 6.0.26523.0 Content-Length: 409 v=0 o=3cxVCE 276725520 92340600 IN IP4 109.195.38.121 s=3cxVCE Audio Call c=IN IP4 109.195.38.121 t=0 0 m=audio 40042 RTP/AVP 0 8 3 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:3 GSM/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv m=video 40040 RTP/AVP 34 c=IN IP4 109.195.38.121 a=rtpmap:34 H263/90000 a=fmtp:34 QCIF=1;CIF=1;SQCIF=1;CIF4=1 a=sendrecv <-------------> --- (13 headers 18 lines) --- Sending to 109.195.38.121:50767 (NAT) Sending to 109.195.38.121:50767 (NAT) Using INVITE request as basis request - ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. Found peer 'userA' for 'userA' from 109.195.38.121:50767 <--- Reliably Transmitting (NAT) to 109.195.38.121:50767 ---> SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-796b085dfa676a6d-1---d8754z-;received=109.195.38.121;rport=50767 From: "userA";tag=c650ee7b To: ;tag=as3f619514 Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 1 INVITE Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer WWW-Authenticate: Digest algorithm=MD5, realm="testsrv", nonce="1cc10f6f" Content-Length: 0 <------------> Scheduling destruction of SIP dialog 'ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ.' in 32000 ms (Method: INVITE) <--- SIP read from UDP:109.195.38.121:50767 ---> ACK sip:*102233@testsrv:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-796b085dfa676a6d-1---d8754z-;rport Max-Forwards: 70 To: ;tag=as3f619514 From: "userA";tag=c650ee7b Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 1 ACK Content-Length: 0 <-------------> --- (8 headers 0 lines) --- <--- SIP read from UDP:109.195.38.121:50767 ---> INVITE sip:*102233@testsrv:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;rport Max-Forwards: 70 Contact: To: From: "userA";tag=c650ee7b Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 INVITE Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REGISTER, SUBSCRIBE, NOTIFY, REFER, INFO, MESSAGE Content-Type: application/sdp Supported: replaces User-Agent: 3CXPhone 6.0.26523.0 Authorization: Digest username="userA",realm="testsrv",nonce="1cc10f6f",uri="sip:*102233@testsrv:5060",response="c47c8b897f8df4e70dd7feeaa984d1c5",algorithm=MD5 Content-Length: 409 v=0 o=3cxVCE 276725520 92340600 IN IP4 109.195.38.121 s=3cxVCE Audio Call c=IN IP4 109.195.38.121 t=0 0 m=audio 40042 RTP/AVP 0 8 3 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:3 GSM/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv m=video 40040 RTP/AVP 34 c=IN IP4 109.195.38.121 a=rtpmap:34 H263/90000 a=fmtp:34 QCIF=1;CIF=1;SQCIF=1;CIF4=1 a=sendrecv <-------------> --- (14 headers 18 lines) --- Sending to 109.195.38.121:50767 (NAT) Using INVITE request as basis request - ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. Found peer 'userA' for 'userA' from 109.195.38.121:50767 == Using SIP RTP CoS mark 5 Found RTP audio format 0 Found RTP audio format 8 Found RTP audio format 3 Found RTP audio format 101 Found audio description format PCMU for ID 0 Found audio description format PCMA for ID 8 Found audio description format GSM for ID 3 Found audio description format telephone-event for ID 101 Found RTP video format 34 Found video description format H263 for ID 34 Capabilities: us - (ulaw|alaw|g729|g723|gsm|speex), peer - audio=(ulaw|gsm|alaw)/video=(h263)/text=(nothing), combined - (ulaw|alaw|gsm) Non-codec capabilities (dtmf): us - 0x1 (telephone-event|), peer - 0x1 (telephone-event|), combined - 0x1 (telephone-event|) Peer audio RTP is at port 109.195.38.121:40042 Looking for *102233 in plan_common (domain testsrv) sip_route_dump: route/path hop: <--- Transmitting (NAT) to 109.195.38.121:50767 ---> SIP/2.0 100 Trying Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;received=109.195.38.121;rport=50767 From: "userA";tag=c650ee7b To: Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 INVITE Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Contact: Content-Length: 0 <------------> -- Executing [*102233@plan_common:1] Verbose("SIP/userA-00000033", "2,plan_common CDR(accountcode)=5149, CHANNEL(peername)=userA, EXTEN=*102233, CALLER=79833817950") in new stack == plan_common CDR(accountcode)=5149, CHANNEL(peername)=userA, EXTEN=*102233, CALLER=79833817950 -- Executing [*102233@plan_common:2] Set("SIP/userA-00000033", "ARRAY(db_result,db_ac1,db_ac2,db_server,db_channel,db_dst,db_gate_id,db_zone_id,db_max_duration,db_timeout,db_options,db_exten,db_caller_id_pstn,db_caller_id_alfa,db_caller_id_office,db_unconditional_num,db_noanswer_num,db_ivr)=0,5149,2233,ics0002,tester03,,-2,-2,3600,60,rtT,*102233,79833817950,*105149,79833817950,,,") in new stack -- Executing [*102233@plan_common:3] GotoIf("SIP/userA-00000033", "1?s-RESULTOK") in new stack -- Goto (plan_common,*102233,6) -- Executing [*102233@plan_common:6] NoOp("SIP/userA-00000033", "") in new stack -- Executing [*102233@plan_common:7] Goto("SIP/userA-00000033", "ptr,*102233,fromplancommon") in new stack -- Goto (ptr,*102233,22) -- Executing [*102233@ptr:22] NoOp("SIP/userA-00000033", "5149,2233,ics0002-1430901883.60") in new stack [2015-05-06 04:44:43] WARNING[32458][C-00000069]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.23-72.1-log]PROCEDURE abill.user_record_settings_check_COP does not exist (112) [2015-05-06 04:44:43] WARNING[32458][C-00000069]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call abill.user_record_settings_check_COP(5149, 2233, 'ics0002-1430901883.60')] [2015-05-06 04:44:43] WARNING[32458][C-00000069]: res_odbc.c:612 ast_odbc_direct_execute: SQL Execute error! Verifying connection to MySQL-Asterisk [MySQL-Asterisk]... [2015-05-06 04:44:43] WARNING[32458][C-00000069]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.23-72.1-log]PROCEDURE abill.user_record_settings_check_COP does not exist (112) [2015-05-06 04:44:43] WARNING[32458][C-00000069]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call abill.user_record_settings_check_COP(5149, 2233, 'ics0002-1430901883.60')] [2015-05-06 04:44:43] ERROR[32458][C-00000069]: func_odbc.c:542 acf_odbc_read: Unable to execute query [call abill.user_record_settings_check_COP(5149, 2233, 'ics0002-1430901883.60')] -- Executing [*102233@ptr:23] Set("SIP/userA-00000033", "db_rec=") in new stack -- Executing [*102233@ptr:24] NoOp("SIP/userA-00000033", "") in new stack -- Executing [*102233@ptr:25] Verbose("SIP/userA-00000033", "2,ptr 0, 5149, 2233, tester03, , -2, -2, 3600, 60, rtT, *102233, 79833817950, *105149, 79833817950, , ") in new stack == ptr 0, 5149, 2233, tester03, , -2, -2, 3600, 60, rtT, *102233, 79833817950, *105149, 79833817950, , -- Executing [*102233@ptr:26] Set("SIP/userA-00000033", "CALLERID(num)=79833817950") in new stack -- Executing [*102233@ptr:27] ExecIf("SIP/userA-00000033", "0?SET(CALLERID(num)=79833817950)") in new stack -- Executing [*102233@ptr:28] ExecIf("SIP/userA-00000033", "1?SET(CALLERID(num)=*105149)") in new stack -- Executing [*102233@ptr:29] GotoIf("SIP/userA-00000033", "1?s-DIAL:s-UNCONDITIONAL") in new stack -- Goto (ptr,*102233,30) -- Executing [*102233@ptr:30] ExecIf("SIP/userA-00000033", "1?NoOp():SET(db_channel=tester03/)") in new stack -- Executing [*102233@ptr:31] Set("SIP/userA-00000033", "db_options=rtTL(3600000:30000)") in new stack -- Executing [*102233@ptr:32] Set("SIP/userA-00000033", "LIMIT_CONNECT_FILE=beep") in new stack -- Executing [*102233@ptr:33] Set("SIP/userA-00000033", "LIMIT_TIMEOUT_FILE=") in new stack -- Executing [*102233@ptr:34] Set("SIP/userA-00000033", "LIMIT_WARNING_FILE=clk/30sec") in new stack -- Executing [*102233@ptr:35] GotoIf("SIP/userA-00000033", "0?offices_ivr,ivr,1") in new stack -- Executing [*102233@ptr:36] GotoIf("SIP/userA-00000033", "1?SKIP2") in new stack -- Goto (ptr,*102233,42) -- Executing [*102233@ptr:42] NoOp("SIP/userA-00000033", "") in new stack -- Executing [*102233@ptr:43] GotoIf("SIP/userA-00000033", "0?s-OUTNUM") in new stack -- Executing [*102233@ptr:44] Dial("SIP/userA-00000033", "SIP/tester03_wrtc&SIP/tester03,60,rtTL(3600000:30000)") in new stack Really destroying SIP dialog '28b928b001f6aaac44d6416f27fbd6f7@testsrv' Method: INVITE [2015-05-06 04:44:43] WARNING[32458][C-00000069]: app_dial.c:2431 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Subscriber absent) == Using SIP RTP CoS mark 5 Audio is at 54442 Adding codec ulaw to SDP Adding codec alaw to SDP Adding codec g729 to SDP Adding codec g723 to SDP Adding codec gsm to SDP Adding codec speex to SDP Adding non-codec 0x1 (telephone-event) to SDP Reliably Transmitting (NAT) to 188.232.162.244:60060: INVITE sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: testsrv Date: Wed, 06 May 2015 08:44:43 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Remote-Party-ID: "userA" ;party=calling;privacy=off;screen=no Content-Type: application/sdp Content-Length: 405 v=0 o=billy 2132457 2132457 IN IP4 144.76.198.218 s=testsrv c=IN IP4 144.76.198.218 t=0 0 m=audio 54442 RTP/AVP 0 8 18 4 3 110 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:4 G723/8000 a=fmtp:4 annexa=no a=rtpmap:3 GSM/8000 a=rtpmap:110 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:60 a=sendrecv --- -- Called SIP/tester03 <--- Transmitting (NAT) to 109.195.38.121:50767 ---> SIP/2.0 180 Ringing Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;received=109.195.38.121;rport=50767 From: "userA";tag=c650ee7b To: ;tag=as35ef517d Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 INVITE Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Contact: Content-Length: 0 <------------> Retransmitting #1 (NAT) to 188.232.162.244:60060: INVITE sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: testsrv Date: Wed, 06 May 2015 08:44:43 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Remote-Party-ID: "userA" ;party=calling;privacy=off;screen=no Content-Type: application/sdp Content-Length: 405 v=0 o=billy 2132457 2132457 IN IP4 144.76.198.218 s=testsrv c=IN IP4 144.76.198.218 t=0 0 m=audio 54442 RTP/AVP 0 8 18 4 3 110 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:4 G723/8000 a=fmtp:4 annexa=no a=rtpmap:3 GSM/8000 a=rtpmap:110 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:60 a=sendrecv --- Retransmitting #2 (NAT) to 188.232.162.244:60060: INVITE sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: testsrv Date: Wed, 06 May 2015 08:44:43 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Remote-Party-ID: "userA" ;party=calling;privacy=off;screen=no Content-Type: application/sdp Content-Length: 405 v=0 o=billy 2132457 2132457 IN IP4 144.76.198.218 s=testsrv c=IN IP4 144.76.198.218 t=0 0 m=audio 54442 RTP/AVP 0 8 18 4 3 110 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:4 G723/8000 a=fmtp:4 annexa=no a=rtpmap:3 GSM/8000 a=rtpmap:110 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:60 a=sendrecv --- <--- SIP read from UDP:109.195.38.121:50767 ---> CANCEL sip:*102233@testsrv:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;rport Max-Forwards: 70 To: From: "userA";tag=c650ee7b Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 CANCEL User-Agent: 3CXPhone 6.0.26523.0 Authorization: Digest username="userA",realm="testsrv",nonce="1cc10f6f",uri="sip:*102233@testsrv:5060",response="a1056a043373438e5697b16d1f38dbbd",algorithm=MD5 Content-Length: 0 <-------------> --- (10 headers 0 lines) --- Sending to 109.195.38.121:50767 (NAT) <--- Reliably Transmitting (NAT) to 109.195.38.121:50767 ---> SIP/2.0 487 Request Terminated Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;received=109.195.38.121;rport=50767 From: "userA";tag=c650ee7b To: ;tag=as35ef517d Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 INVITE Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Content-Length: 0 <------------> <--- Transmitting (NAT) to 109.195.38.121:50767 ---> SIP/2.0 200 OK Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;received=109.195.38.121;rport=50767 From: "userA";tag=c650ee7b To: ;tag=as35ef517d Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 CANCEL Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Content-Length: 0 <------------> Scheduling destruction of SIP dialog '0e3e4c0f69f4f24a231220c01f3a0066@testsrv' in 32000 ms (Method: INVITE) == Spawn extension (ptr, *102233, 44) exited non-zero on 'SIP/userA-00000033' -- Executing [h@ptr:1] NoOp("SIP/userA-00000033", "") in new stack -- Executing [h@ptr:2] NoOp("SIP/userA-00000033", ""userA" <*105149>") in new stack -- Executing [h@ptr:3] NoOp("SIP/userA-00000033", "*105149") in new stack -- Executing [h@ptr:4] NoOp("SIP/userA-00000033", "*102233") in new stack -- Executing [h@ptr:5] NoOp("SIP/userA-00000033", "ptr") in new stack -- Executing [h@ptr:6] NoOp("SIP/userA-00000033", "SIP/userA-00000033") in new stack -- Executing [h@ptr:7] NoOp("SIP/userA-00000033", "SIP/tester03-00000034") in new stack -- Executing [h@ptr:8] NoOp("SIP/userA-00000033", ""`Dial`"") in new stack -- Executing [h@ptr:9] NoOp("SIP/userA-00000033", "SIP/tester03_wrtc&SIP/tester03,60,rtTL(3600000:30000)") in new stack -- Executing [h@ptr:10] NoOp("SIP/userA-00000033", "2") in new stack -- Executing [h@ptr:11] NoOp("SIP/userA-00000033", "0") in new stack -- Executing [h@ptr:12] NoOp("SIP/userA-00000033", "NO ANSWER") in new stack -- Executing [h@ptr:13] NoOp("SIP/userA-00000033", "") in new stack -- Executing [h@ptr:14] NoOp("SIP/userA-00000033", "5149") in new stack -- Executing [h@ptr:15] NoOp("SIP/userA-00000033", "ics0002-1430901883.60") in new stack -- Executing [h@ptr:16] NoOp("SIP/userA-00000033", "db_rec=") in new stack -- Executing [h@ptr:17] GotoIf("SIP/userA-00000033", "0?s-SKIP") in new stack -- Executing [h@ptr:18] GotoIf("SIP/userA-00000033", "0?s-SKIP") in new stack -- Executing [h@ptr:19] Verbose("SIP/userA-00000033", "to=tester03&caller=*105149&extension=*102233}") in new stack to=tester03&caller=*105149&extension=*102233} <--- SIP read from UDP:109.195.38.121:50767 ---> ACK sip:*102233@testsrv:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.3:50767;branch=z9hG4bK-d8754z-a651911e8843c416-1---d8754z-;rport Max-Forwards: 70 To: ;tag=as35ef517d From: "userA";tag=c650ee7b Call-ID: ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ. CSeq: 2 ACK Content-Length: 0 <-------------> --- (8 headers 0 lines) --- -- Executing [h@ptr:20] Set("SIP/userA-00000033", "MyPOST={"status": "ERR", "func": "push_notification"}") in new stack -- Executing [h@ptr:21] Set("SIP/userA-00000033", "cdrdialstr=0.5149.2233.tester03..-2.-2.3600.60.rtTL(3600000:30000).*102233.79833817950.*105149.79833817950...") in new stack -- Executing [h@ptr:22] Set("SIP/userA-00000033", "ODBC_GET_CDR("userA"<*105149>,*105149,0.5149.2233.tester03..-2.-2.3600.60.rtTL(3600000:30000).*102233.79833817950.*105149.79833817950...,ptr,SIP/userA-00000033,SIP/tester03-00000034,Dial,"SIP/tester03_wrtc&SIP/tester03,60,rtTL(3600000:30000)",2,0,NO_ANSWER,3,5149,ics0002-1430901883.60,2233)=CDR") in new stack [2015-05-06 04:44:45] WARNING[32458][C-00000069]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.23-72.1-log]PROCEDURE voice.ast_cdr_wrt does not exist (93) [2015-05-06 04:44:45] WARNING[32458][C-00000069]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call voice.ast_cdr_wrt('userA<*105149>', '*105149', '0.5149.2233.tester03..-2.-2.3600.60.rtTL(3600000:30000).*102233.79833817950.*105149.79833817950...', 'ptr', 'SIP/userA-00000033', 'SIP/tester03-00000034', 'Dial', 'SIP/tester03_wrtc&SIP/tester03,60,rtTL(3600000:30000)', '2', '0', 'NO_ANSWER', '3', '5149', 'ics0002-1430901883.60', '2233')] [2015-05-06 04:44:45] WARNING[32458][C-00000069]: res_odbc.c:612 ast_odbc_direct_execute: SQL Execute error! Verifying connection to MySQL-Asterisk [MySQL-Asterisk]... [2015-05-06 04:44:45] WARNING[32458][C-00000069]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.2(w) Driver][mysqld-5.6.23-72.1-log]PROCEDURE voice.ast_cdr_wrt does not exist (93) [2015-05-06 04:44:45] WARNING[32458][C-00000069]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call voice.ast_cdr_wrt('userA<*105149>', '*105149', '0.5149.2233.tester03..-2.-2.3600.60.rtTL(3600000:30000).*102233.79833817950.*105149.79833817950...', 'ptr', 'SIP/userA-00000033', 'SIP/tester03-00000034', 'Dial', 'SIP/tester03_wrtc&SIP/tester03,60,rtTL(3600000:30000)', '2', '0', 'NO_ANSWER', '3', '5149', 'ics0002-1430901883.60', '2233')] -- Executing [h@ptr:23] Set("SIP/userA-00000033", "ODBC_CALL_ESTIMATE(ics0002-1430901883.60)=HHH") in new stack -- Executing [h@ptr:24] NoCDR("SIP/userA-00000033", "") in new stack ; A CALL WAS CANCELED by peer userA Really destroying SIP dialog 'ZTI2MjYxZGQxM2E0MzFkNzNkM2JlYWE4YWJkNmRmNWQ.' Method: ACK Retransmitting #3 (NAT) to 188.232.162.244:60060: INVITE sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: testsrv Date: Wed, 06 May 2015 08:44:43 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Remote-Party-ID: "userA" ;party=calling;privacy=off;screen=no Content-Type: application/sdp Content-Length: 405 v=0 o=billy 2132457 2132457 IN IP4 144.76.198.218 s=testsrv c=IN IP4 144.76.198.218 t=0 0 m=audio 54442 RTP/AVP 0 8 18 4 3 110 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:4 G723/8000 a=fmtp:4 annexa=no a=rtpmap:3 GSM/8000 a=rtpmap:110 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:60 a=sendrecv --- <--- SIP read from UDP:188.232.162.244:60060 ---> REGISTER sip:testsrv SIP/2.0 Via: SIP/2.0/UDP 192.168.0.17:60060;rport;branch=z9hG4bK743264350 From: ;tag=2095174514 To: Call-ID: 2100461982 CSeq: 1 REGISTER Contact: Max-Forwards: 70 User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Expires: 60 Content-Length: 0 <-------------> --- (11 headers 0 lines) --- Sending to 188.232.162.244:60060 (NAT) Sending to 188.232.162.244:60060 (NAT) <--- Transmitting (NAT) to 188.232.162.244:60060 ---> SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 192.168.0.17:60060;branch=z9hG4bK743264350;received=188.232.162.244;rport=60060 From: ;tag=2095174514 To: ;tag=as3731190a Call-ID: 2100461982 CSeq: 1 REGISTER Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer WWW-Authenticate: Digest algorithm=MD5, realm="testsrv", nonce="7a8781e5" Content-Length: 0 <------------> Scheduling destruction of SIP dialog '2100461982' in 32000 ms (Method: REGISTER) <--- SIP read from UDP:188.232.162.244:60060 ---> REGISTER sip:testsrv SIP/2.0 Via: SIP/2.0/UDP 192.168.0.17:60060;rport;branch=z9hG4bK506534969 From: ;tag=2095174514 To: Call-ID: 2100461982 CSeq: 2 REGISTER Contact: Authorization: Digest username="tester03", realm="testsrv", nonce="7a8781e5", uri="sip:testsrv", response="5807d417fc0399976dfc81fecf97c040", algorithm=MD5 Max-Forwards: 70 User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Expires: 60 Content-Length: 0 <-------------> --- (12 headers 0 lines) --- Sending to 188.232.162.244:60060 (NAT) ; User B logged in again <--- Transmitting (NAT) to 188.232.162.244:60060 ---> SIP/2.0 200 OK Via: SIP/2.0/UDP 192.168.0.17:60060;branch=z9hG4bK506534969;received=188.232.162.244;rport=60060 From: ;tag=2095174514 To: ;tag=as3731190a Call-ID: 2100461982 CSeq: 2 REGISTER Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Expires: 60 Contact: ;expires=60 Date: Wed, 06 May 2015 08:44:49 GMT Content-Length: 0 <------------> Scheduling destruction of SIP dialog '2100461982' in 32000 ms (Method: REGISTER) <--- SIP read from UDP:188.232.162.244:60060 ---> REGISTER sip:testsrv SIP/2.0 Via: SIP/2.0/UDP 192.168.0.17:60060;rport;branch=z9hG4bK1029879035 From: ;tag=2095174514 To: Call-ID: 2100461982 CSeq: 3 REGISTER Contact: Max-Forwards: 70 User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Expires: 60 Content-Length: 0 <-------------> --- (11 headers 0 lines) --- Sending to 188.232.162.244:60060 (NAT) <--- Transmitting (NAT) to 188.232.162.244:60060 ---> SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 192.168.0.17:60060;branch=z9hG4bK1029879035;received=188.232.162.244;rport=60060 From: ;tag=2095174514 To: ;tag=as3731190a Call-ID: 2100461982 CSeq: 3 REGISTER Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer WWW-Authenticate: Digest algorithm=MD5, realm="testsrv", nonce="3310ee96" Content-Length: 0 <------------> Scheduling destruction of SIP dialog '2100461982' in 32000 ms (Method: REGISTER) <--- SIP read from UDP:188.232.162.244:60060 ---> REGISTER sip:testsrv SIP/2.0 Via: SIP/2.0/UDP 192.168.0.17:60060;rport;branch=z9hG4bK869926741 From: ;tag=2095174514 To: Call-ID: 2100461982 CSeq: 4 REGISTER Contact: Authorization: Digest username="tester03", realm="testsrv", nonce="3310ee96", uri="sip:testsrv", response="874bec57d0896dbbd550a91a4790ff79", algorithm=MD5 Max-Forwards: 70 User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Expires: 60 Content-Length: 0 <-------------> --- (12 headers 0 lines) --- Sending to 188.232.162.244:60060 (NAT) <--- Transmitting (NAT) to 188.232.162.244:60060 ---> SIP/2.0 200 OK Via: SIP/2.0/UDP 192.168.0.17:60060;branch=z9hG4bK869926741;received=188.232.162.244;rport=60060 From: ;tag=2095174514 To: ;tag=as3731190a Call-ID: 2100461982 CSeq: 4 REGISTER Server: testsrv Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Expires: 60 Contact: ;expires=60 Date: Wed, 06 May 2015 08:44:49 GMT Content-Length: 0 ; INVITE from call which was already calnceled! <------------> Scheduling destruction of SIP dialog '2100461982' in 32000 ms (Method: REGISTER) Retransmitting #4 (NAT) to 188.232.162.244:60060: INVITE sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: testsrv Date: Wed, 06 May 2015 08:44:43 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE Supported: replaces, timer Remote-Party-ID: "userA" ;party=calling;privacy=off;screen=no Content-Type: application/sdp Content-Length: 405 v=0 o=billy 2132457 2132457 IN IP4 144.76.198.218 s=testsrv c=IN IP4 144.76.198.218 t=0 0 m=audio 54442 RTP/AVP 0 8 18 4 3 110 101 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=fmtp:18 annexb=no a=rtpmap:4 G723/8000 a=fmtp:4 annexa=no a=rtpmap:3 GSM/8000 a=rtpmap:110 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 a=maxptime:60 a=sendrecv --- <--- SIP read from UDP:188.232.162.244:60060 ---> SIP/2.0 100 Trying Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport=5060 From: "userA" ;tag=as1228009d To: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Content-Length: 0 <-------------> --- (8 headers 0 lines) --- Reliably Transmitting (NAT) to 188.232.162.244:60060: CANCEL sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 CANCEL User-Agent: testsrv Content-Length: 0 --- Scheduling destruction of SIP dialog '0e3e4c0f69f4f24a231220c01f3a0066@testsrv' in 32000 ms (Method: INVITE) <--- SIP read from UDP:188.232.162.244:60060 ---> SIP/2.0 200 OK Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport=5060 From: "userA" ;tag=as1228009d To: ;tag=1706915109 Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 CANCEL User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Content-Length: 0 <-------------> --- (8 headers 0 lines) --- <--- SIP read from UDP:188.232.162.244:60060 ---> SIP/2.0 487 Request Cancelled Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport=5060 From: "userA" ;tag=as1228009d To: ;tag=1706915109 Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 INVITE User-Agent: Linphone/3.6.1 (eXosip2/4.1.0) Content-Length: 0 <-------------> --- (8 headers 0 lines) --- Transmitting (NAT) to 188.232.162.244:60060: ACK sip:tester03@188.232.162.244:60060;line=ddb0e66640c65f3 SIP/2.0 Via: SIP/2.0/UDP 144.76.198.218:5060;branch=z9hG4bK03edaa87;rport Max-Forwards: 70 From: "userA" ;tag=as1228009d To: ;tag=1706915109 Contact: Call-ID: 0e3e4c0f69f4f24a231220c01f3a0066@testsrv CSeq: 102 ACK User-Agent: testsrv Content-Length: 0 --- Scheduling destruction of SIP dialog '0e3e4c0f69f4f24a231220c01f3a0066@testsrv' in 32000 ms (Method: INVITE) <--- SIP read from UDP:109.195.38.121:5060 ---> <-------------> <--- SIP read from UDP:109.195.38.121:50767 ---> <-------------> Really destroying SIP dialog '071ff50927201fd230c5f11b3f0b6d79@testsrv' Method: INVITE devsrv2*CLI> logger mute Console is muted.