Не работают звонки через SIP Trunk

nechushki91 · Сообщение **nechushki91** » 24 окт 2018, 15:00

Всем привет! Есть две АТС в одной сети, между ними SIP Trunk, на одной АТС номера 63XX, на другой 65XX. Не получается совершать звонок с номера 6500 на номер 6333 и наоборот, автоответчик говорит, что абонент занят. Вот лог:
[2018-10-24 14:22:51] WARNING[5267]: res_odbc.c:459 ast_odbc_print_errors: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'
[2018-10-24 14:22:51] WARNING[5267]: res_odbc.c:403 ast_odbc_prepare_and_execute: SQL Execute error -1!
[2018-10-24 14:22:51] WARNING[5267]: cel_odbc.c:772 odbc_log: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('LINKEDID_END',{ts '2018-10-24 14:22:51.113934'},'Yuliana Kirillovykh','6500','6500','','6333','h','from-internal','SIP/6500-00000006','','',3,'','1540380168.6','1540380168.6','','','')

Всю голову сломал в чём дело, все остальные номера работают идеально, кроме одного косячного 6500 (настройки идентичны)

Лог звонка:

[table=][2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:1] Macro("SIP/6500-00000001", "user-callerid,LIMIT,EXTERNAL,") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:1] Set("SIP/6500-00000001", "TOUCH_MONITOR=1540382339.1") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:2] Set("SIP/6500-00000001", "AMPUSER=6500") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:3] GotoIf("SIP/6500-00000001", "0?report") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:4] ExecIf("SIP/6500-00000001", "1?Set(REALCALLERIDNUM=6500)") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:5] Set("SIP/6500-00000001", "AMPUSER=6500") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:6] GotoIf("SIP/6500-00000001", "0?limit") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:7] Set("SIP/6500-00000001", "AMPUSERCIDNAME=Yuliana Kirillovykh") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:8] GotoIf("SIP/6500-00000001", "0?report") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:9] Set("SIP/6500-00000001", "AMPUSERCID=6500") in new stack
[2018-10-24 14:58:59] WARNING[1973] res_odbc.c: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'
[2018-10-24 14:58:59] WARNING[1973] res_odbc.c: SQL Execute error -1!
[2018-10-24 14:58:59] WARNING[1973] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('CHAN_START',{ts '2018-10-24 14:58:59.970343'},'Yuliana Kirillovykh','6500','','','','6333','from-internal','SIP/6500-00000001','','',3,'','1540382339.1','1540382339.1','','','')
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:10] Set("SIP/6500-00000001", "__DIAL_OPTIONS=Tt") in new stack
[2018-10-24 14:58:59] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:11] Set("SIP/6500-00000001", "CALLERID(all)="Yuliana Kirillovykh" <6500>") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:12] GotoIf("SIP/6500-00000001", "0?limit") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:13] ExecIf("SIP/6500-00000001", "1?Set(GROUP(concurrency_limit)=6500)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:14] ExecIf("SIP/6500-00000001", "0?Set(CHANNEL(language)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:15] GotoIf("SIP/6500-00000001", "1?continue") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-user-callerid,s,29)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:29] Set("SIP/6500-00000001", "CALLERID(number)=6500") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:30] Set("SIP/6500-00000001", "CALLERID(name)=Yuliana Kirillovykh") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:31] GotoIf("SIP/6500-00000001", "0?cnum") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:32] Set("SIP/6500-00000001", "CDR(cnam)=Yuliana Kirillovykh") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:33] Set("SIP/6500-00000001", "CDR(cnum)=6500") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-user-callerid:34] Set("SIP/6500-00000001", "CHANNEL(language)=en") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:2] Gosub("SIP/6500-00000001", "sub-record-check,s,1(out,6333,dontcare)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:1] GotoIf("SIP/6500-00000001", "0?initialized") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:2] Set("SIP/6500-00000001", "__REC_STATUS=INITIALIZED") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:3] Set("SIP/6500-00000001", "NOW=1540382340") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:4] Set("SIP/6500-00000001", "__DAY=24") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:5] Set("SIP/6500-00000001", "__MONTH=10") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:6] Set("SIP/6500-00000001", "__YEAR=2018") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:7] Set("SIP/6500-00000001", "__TIMESTR=20181024-145900") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:8] Set("SIP/6500-00000001", "__FROMEXTEN=6500") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:9] Set("SIP/6500-00000001", "__MON_FMT=wav") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:10] NoOp("SIP/6500-00000001", "Recordings initialized") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:11] ExecIf("SIP/6500-00000001", "0?Set(ARG3=dontcare)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:12] Set("SIP/6500-00000001", "REC_POLICY_MODE_SAVE=") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:13] ExecIf("SIP/6500-00000001", "0?Set(REC_STATUS=NO)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:14] GotoIf("SIP/6500-00000001", "3?checkaction") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (sub-record-check,s,17)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@sub-record-check:17] GotoIf("SIP/6500-00000001", "1?sub-record-check,out,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (sub-record-check,out,1)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [out@sub-record-check:1] NoOp("SIP/6500-00000001", "Outbound Recording Check from 6500 to 6333") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [out@sub-record-check:2] Set("SIP/6500-00000001", "RECMODE=dontcare") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [out@sub-record-check:3] ExecIf("SIP/6500-00000001", "1?Goto(routewins)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (sub-record-check,out,7)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [out@sub-record-check:7] Gosub("SIP/6500-00000001", "recordcheck,1(dontcare,out,6333)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [recordcheck@sub-record-check:1] NoOp("SIP/6500-00000001", "Starting recording check against dontcare") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [recordcheck@sub-record-check:2] Goto("SIP/6500-00000001", "dontcare") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (sub-record-check,recordcheck,3)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [recordcheck@sub-record-check:3] Return("SIP/6500-00000001", "") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [out@sub-record-check:8] Return("SIP/6500-00000001", "") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:3] ExecIf("SIP/6500-00000001", "0 ?Set(CDR(accountcode)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:4] Set("SIP/6500-00000001", "MOHCLASS=default") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:5] Set("SIP/6500-00000001", "_NODEST=") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:6] Macro("SIP/6500-00000001", "dialout-trunk,3,6333,,off") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:1] Set("SIP/6500-00000001", "DIAL_TRUNK=3") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:2] GosubIf("SIP/6500-00000001", "0?sub-pincheck,s,1()") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:3] GotoIf("SIP/6500-00000001", "0?disabletrunk,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:4] Set("SIP/6500-00000001", "DIAL_NUMBER=6333") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:5] Set("SIP/6500-00000001", "DIAL_TRUNK_OPTIONS=Tt") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:6] Set("SIP/6500-00000001", "OUTBOUND_GROUP=OUT_3") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:7] GotoIf("SIP/6500-00000001", "1?nomax") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-dialout-trunk,s,9)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:9] GotoIf("SIP/6500-00000001", "0?skipoutcid") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:10] Set("SIP/6500-00000001", "DIAL_TRUNK_OPTIONS=Tt") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:11] Macro("SIP/6500-00000001", "outbound-callerid,3") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:1] ExecIf("SIP/6500-00000001", "0?Set(CALLERPRES(name-pres)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:2] ExecIf("SIP/6500-00000001", "0?Set(CALLERPRES(num-pres)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:3] ExecIf("SIP/6500-00000001", "0?Set(REALCALLERIDNUM=6500)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:4] GotoIf("SIP/6500-00000001", "1?normcid") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-outbound-callerid,s,7)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:7] Set("SIP/6500-00000001", "USEROUTCID=") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:8] Set("SIP/6500-00000001", "EMERGENCYCID=") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:9] Set("SIP/6500-00000001", "TRUNKOUTCID=") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:10] GotoIf("SIP/6500-00000001", "1?trunkcid") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-outbound-callerid,s,15)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:15] ExecIf("SIP/6500-00000001", "0?Set(CALLERID(all)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:16] ExecIf("SIP/6500-00000001", "0?Set(CALLERID(all)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:17] ExecIf("SIP/6500-00000001", "0?Set(CALLERID(all)=)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:18] ExecIf("SIP/6500-00000001", "0?Set(CALLERPRES(name-pres)=prohib_passed_screen)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:19] ExecIf("SIP/6500-00000001", "0?Set(CALLERPRES(num-pres)=prohib_passed_screen)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:20] Set("SIP/6500-00000001", "CDR(outbound_cnum)=6500") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outbound-callerid:21] Set("SIP/6500-00000001", "CDR(outbound_cnam)=Yuliana Kirillovykh") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:12] GosubIf("SIP/6500-00000001", "0?sub-flp-3,s,1()") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:13] Set("SIP/6500-00000001", "OUTNUM=6333") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:14] Set("SIP/6500-00000001", "custom=SIP/Tushino_office_TRUNK") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:15] ExecIf("SIP/6500-00000001", "0?Set(DIAL_TRUNK_OPTIONS=M(setmusic^default)Tt)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:16] ExecIf("SIP/6500-00000001", "0?Set(DIAL_TRUNK_OPTIONS=TtM(confirm))") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:17] Macro("SIP/6500-00000001", "dialout-trunk-predial-hook,") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk-predial-hook:1] MacroExit("SIP/6500-00000001", "") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:18] GotoIf("SIP/6500-00000001", "0?bypass,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:19] ExecIf("SIP/6500-00000001", "1?Set(CONNECTEDLINE(num,i)=6333)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:20] ExecIf("SIP/6500-00000001", "1?Set(CONNECTEDLINE(name,i)=CID:6500)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:21] ExecIf("SIP/6500-00000001", "0?Set(CONNECTEDLINE(name,i)=CID:(Hidden)6500)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:22] GotoIf("SIP/6500-00000001", "0?customtrunk") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:23] Dial("SIP/6500-00000001", "SIP/Tushino_office_TRUNK/6333,300,Tt") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] netsock2.c: Using SIP RTP TOS bits 184
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] netsock2.c: Using SIP RTP CoS mark 5
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute error -1!
[2018-10-24 14:59:00] WARNING[1973] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('CHAN_START',{ts '2018-10-24 14:59:00.122693'},'','','','','','s','from-trunk','SIP/Tushino_office_TRUNK-00000002','','',3,'','1540382340.2','1540382339.1','','','')
[2018-10-24 14:59:00] NOTICE[2006][C-00000001] chan_sip.c: Failed to authenticate on INVITE to '"Yuliana Kirillovykh" <sip:6500@10.200.84.240>;tag=as02659733'
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] app_dial.c: Called SIP/Tushino_office_TRUNK/6333
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] app_dial.c: SIP/Tushino_office_TRUNK-00000002 is circuit-busy
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute error -1!
[2018-10-24 14:59:00] WARNING[1973] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('HANGUP',{ts '2018-10-24 14:59:00.131402'},'CID:6500','6333','','','','6333','from-trunk','SIP/Tushino_office_TRUNK-00000002','AppDial','(Outgoing Line)',3,'','1540382340.2','1540382339.1','','','{"hangupcause":21,"dialstatus":"","hangupsource":""}')
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'
[2018-10-24 14:59:00] WARNING[1973] res_odbc.c: SQL Execute error -1!
[2018-10-24 14:59:00] WARNING[1973] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('CHAN_END',{ts '2018-10-24 14:59:00.132486'},'CID:6500','6333','','','','6333','from-trunk','SIP/Tushino_office_TRUNK-00000002','AppDial','(Outgoing Line)',3,'','1540382340.2','1540382339.1','','','')
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] app_dial.c: Everyone is busy/congested at this time (1:0/1/0)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:24] NoOp("SIP/6500-00000001", "Dial failed for some reason with DIALSTATUS = CONGESTION and HANGUPCAUSE = 21") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-dialout-trunk:25] GotoIf("SIP/6500-00000001", "0?continue,1:s-CONGESTION,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-dialout-trunk,s-CONGESTION,1)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s-CONGESTION@macro-dialout-trunk:1] Set("SIP/6500-00000001", "RC=21") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s-CONGESTION@macro-dialout-trunk:2] Goto("SIP/6500-00000001", "21,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-dialout-trunk,21,1)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [21@macro-dialout-trunk:1] Goto("SIP/6500-00000001", "continue,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-dialout-trunk,continue,1)
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [continue@macro-dialout-trunk:1] NoOp("SIP/6500-00000001", "TRUNK Dial failed due to CONGESTION HANGUPCAUSE: 21 - failing through to other trunks") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [continue@macro-dialout-trunk:2] ExecIf("SIP/6500-00000001", "1?Set(CALLERID(number)=6500)") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [6333@from-internal:7] Macro("SIP/6500-00000001", "outisbusy,") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outisbusy:1] Progress("SIP/6500-00000001", "") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outisbusy:2] GotoIf("SIP/6500-00000001", "0?emergency,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outisbusy:3] GotoIf("SIP/6500-00000001", "0?intracompany,1") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outisbusy:4] Playback("SIP/6500-00000001", "all-circuits-busy-now&pls-try-call-later, noanswer") in new stack
[2018-10-24 14:59:00] VERBOSE[2253][C-00000001] file.c: <SIP/6500-00000001> Playing 'all-circuits-busy-now.alaw' (language 'en')
[2018-10-24 14:59:01] VERBOSE[2253][C-00000001] file.c: <SIP/6500-00000001> Playing 'pls-try-call-later.alaw' (language 'en')
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-outisbusy:5] Congestion("SIP/6500-00000001", "20") in new stack
[2018-10-24 14:59:04] WARNING[2253][C-00000001] channel.c: Prodding channel 'SIP/6500-00000001' failed
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] app_macro.c: Spawn extension (macro-outisbusy, s, 5) exited non-zero on 'SIP/6500-00000001' in macro 'outisbusy'
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Spawn extension (from-internal, 6333, 7) exited non-zero on 'SIP/6500-00000001'
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Executing [h@from-internal:1] Macro("SIP/6500-00000001", "hangupcall") in new stack
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-hangupcall:1] GotoIf("SIP/6500-00000001", "1?theend") in new stack
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx_builtins.c: Goto (macro-hangupcall,s,3)
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-hangupcall:3] ExecIf("SIP/6500-00000001", "0?Set(CDR(recordingfile)=)") in new stack
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Executing [s@macro-hangupcall:4] Hangup("SIP/6500-00000001", "") in new stack
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] app_macro.c: Spawn extension (macro-hangupcall, s, 4) exited non-zero on 'SIP/6500-00000001' in macro 'hangupcall'
[2018-10-24 14:59:04] VERBOSE[2253][C-00000001] pbx.c: Spawn extension (from-internal, h, 1) exited non-zero on 'SIP/6500-00000001'[/table]

ded · Сообщение **ded** » 24 окт 2018, 15:08

nechushki91 писал(а): автоответчик говорит, что абонент занят.

Ну да, мы дебажим по автоотвечику и коротким гудкам, как же иначе?
Вы с первым сообщением
1. не можете уложиться под спойлер - такую портянку выкладывать!
2. не видете очевидного, в этой портянке:
chan_sip.c: Failed to authenticate on INVITE to '"Yuliana Kirillovykh"
и
res_odbc.c: SQL Execute returned an error: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Duplicate entry '3525461' for key 'PRIMARY'

Я бы вас в платный суппорт направил или на курсы английского языка.

nechushki91 · Сообщение **nechushki91** » 24 окт 2018, 16:46

Спасибо за наводку! Учту Ваши замечания)

nechushki91 · Сообщение **nechushki91** » 24 окт 2018, 17:35

ошибка Mysql решилась таким образом:
1) Зашёл в mysql
2) use asteriskcdrdb;
3) DELETE FROM cel WHERE id=3525461; (таблица у меня была повреждена, перед вводом команды DELETE, выполнил REPAIR TABLE cel; )

Вдруг кому-то в будущем пригодится)

Не работают звонки через SIP Trunk

Не работают звонки через SIP Trunk

Re: Не работают звонки через SIP Trunk

Re: Не работают звонки через SIP Trunk

Re: Не работают звонки через SIP Trunk