Глюк с FreePBX

[Tempik]

Здравствуйте, после переноса FreePBX'а на другой сервер с последующим развертыванием из бекапа штатными средствами FreePBX'а появился непонятный глюк, в меню пользователя все записи разговора дублируются, выглядит это вот так:



В логах не чего нету. Единственный момент, когда перенес все на другой сервак забыл сменить дату и в результате все старые записи сохранились с датой 1.1.2000 г. но не думаю что это както могло повлиять
Подскажите куда копать.

[Tempik]

В базе записи тоже дублируются, но не пойму из за чего.

[awsswa]

скрипт во время звонка выложите сюда

[Tempik]

Код: Выделить всё

  == Using SIP RTP TOS bits 184
  == Using SIP RTP CoS mark 5
       > [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,userfield) VALUES ('CHAN_START',{ts '2013-07-26 13:45:54'},'test','109','','','','200','from-internal','SIP/109-00000067','','',3,'','1374831954.131','1374831954.131','','','')]
    -- Executing [200@from-internal:1] Set("SIP/109-00000067", "__RINGTIMER=15") in new stack
    -- Executing [200@from-internal:2] Macro("SIP/109-00000067", "exten-vm,200,200,0,0,0") in new stack
    -- Executing [s@macro-exten-vm:1] Macro("SIP/109-00000067", "user-callerid,") in new stack
    -- Executing [s@macro-user-callerid:1] Set("SIP/109-00000067", "TOUCH_MONITOR=1374831954.131") in new stack
    -- Executing [s@macro-user-callerid:2] Set("SIP/109-00000067", "AMPUSER=109") in new stack
    -- Executing [s@macro-user-callerid:3] GotoIf("SIP/109-00000067", "0?report") in new stack
    -- Executing [s@macro-user-callerid:4] ExecIf("SIP/109-00000067", "1?Set(REALCALLERIDNUM=109)") in new stack
    -- Executing [s@macro-user-callerid:5] Set("SIP/109-00000067", "AMPUSER=109") in new stack
    -- Executing [s@macro-user-callerid:6] Set("SIP/109-00000067", "AMPUSERCIDNAME=test") in new stack
    -- Executing [s@macro-user-callerid:7] GotoIf("SIP/109-00000067", "0?report") in new stack
    -- Executing [s@macro-user-callerid:8] Set("SIP/109-00000067", "AMPUSERCID=109") in new stack
    -- Executing [s@macro-user-callerid:9] Set("SIP/109-00000067", "__DIAL_OPTIONS=tr") in new stack
    -- Executing [s@macro-user-callerid:10] Set("SIP/109-00000067", "CALLERID(all)="test" <109>") in new stack
    -- Executing [s@macro-user-callerid:11] GotoIf("SIP/109-00000067", "0?limit") in new stack
    -- Executing [s@macro-user-callerid:12] ExecIf("SIP/109-00000067", "0?Set(GROUP(concurrency_limit)=109)") in new stack
    -- Executing [s@macro-user-callerid:13] GotoIf("SIP/109-00000067", "0?continue") in new stack
    -- Executing [s@macro-user-callerid:14] Set("SIP/109-00000067", "__TTL=64") in new stack
    -- Executing [s@macro-user-callerid:15] GotoIf("SIP/109-00000067", "1?continue") in new stack
    -- Goto (macro-user-callerid,s,26)
    -- Executing [s@macro-user-callerid:26] Set("SIP/109-00000067", "CALLERID(number)=109") in new stack
    -- Executing [s@macro-user-callerid:27] Set("SIP/109-00000067", "CALLERID(name)=test") in new stack
    -- Executing [s@macro-user-callerid:28] Set("SIP/109-00000067", "CDR(cnum)=109") in new stack
    -- Executing [s@macro-user-callerid:29] Set("SIP/109-00000067", "CDR(cnam)=test") in new stack
    -- Executing [s@macro-user-callerid:30] Set("SIP/109-00000067", "CHANNEL(language)=ru") in new stack
    -- Executing [s@macro-exten-vm:2] Set("SIP/109-00000067", "RingGroupMethod=none") in new stack
    -- Executing [s@macro-exten-vm:3] Set("SIP/109-00000067", "__EXTTOCALL=200") in new stack
    -- Executing [s@macro-exten-vm:4] Set("SIP/109-00000067", "__PICKUPMARK=200") in new stack
    -- Executing [s@macro-exten-vm:5] Set("SIP/109-00000067", "RT=15") in new stack
    -- Executing [s@macro-exten-vm:6] Gosub("SIP/109-00000067", "sub-record-check,s,1(exten,200,)") in new stack
    -- Executing [s@sub-record-check:1] Set("SIP/109-00000067", "REC_POLICY_MODE_SAVE=") in new stack
    -- Executing [s@sub-record-check:2] GotoIf("SIP/109-00000067", "1?check") in new stack
    -- Goto (sub-record-check,s,7)
    -- Executing [s@sub-record-check:7] Set("SIP/109-00000067", "__MON_FMT=wav") in new stack
    -- Executing [s@sub-record-check:8] GotoIf("SIP/109-00000067", "1?next") in new stack
    -- Goto (sub-record-check,s,11)
    -- Executing [s@sub-record-check:11] ExecIf("SIP/109-00000067", "0?Return()") in new stack
    -- Executing [s@sub-record-check:12] ExecIf("SIP/109-00000067", "0?Set(__REC_POLICY_MODE=)") in new stack
    -- Executing [s@sub-record-check:13] GotoIf("SIP/109-00000067", "0?exten,1") in new stack
    -- Executing [s@sub-record-check:14] Set("SIP/109-00000067", "__REC_STATUS=INITIALIZED") in new stack
    -- Executing [s@sub-record-check:15] Set("SIP/109-00000067", "NOW=1374831954") in new stack
    -- Executing [s@sub-record-check:16] Set("SIP/109-00000067", "__DAY=26") in new stack
    -- Executing [s@sub-record-check:17] Set("SIP/109-00000067", "__MONTH=07") in new stack
    -- Executing [s@sub-record-check:18] Set("SIP/109-00000067", "__YEAR=2013") in new stack
    -- Executing [s@sub-record-check:19] Set("SIP/109-00000067", "__TIMESTR=20130726-134554") in new stack
    -- Executing [s@sub-record-check:20] Set("SIP/109-00000067", "__FROMEXTEN=109") in new stack
    -- Executing [s@sub-record-check:21] Set("SIP/109-00000067", "__CALLFILENAME=exten-200-109-20130726-134554-1374831954.131") in new stack
    -- Executing [s@sub-record-check:22] Goto("SIP/109-00000067", "exten,1") in new stack
    -- Goto (sub-record-check,exten,1)
    -- Executing [exten@sub-record-check:1] GotoIf("SIP/109-00000067", "0?callee") in new stack
    -- Executing [exten@sub-record-check:2] Set("SIP/109-00000067", "__REC_POLICY_MODE=always") in new stack
    -- Executing [exten@sub-record-check:3] GotoIf("SIP/109-00000067", "0?caller") in new stack
    -- Executing [exten@sub-record-check:4] GotoIf("SIP/109-00000067", "0?callee") in new stack
    -- Executing [exten@sub-record-check:5] ExecIf("SIP/109-00000067", "2?Set(CALLER_PRI=10):Set(CALLER_PRI=0)") in new stack
    -- Executing [exten@sub-record-check:6] ExecIf("SIP/109-00000067", "2?Set(CALLEE_PRI=10):Set(CALLEE_PRI=0)") in new stack
    -- Executing [exten@sub-record-check:7] GotoIf("SIP/109-00000067", "1?caller:callee") in new stack
    -- Goto (sub-record-check,exten,10)
    -- Executing [exten@sub-record-check:10] Set("SIP/109-00000067", "__REC_POLICY_MODE=always") in new stack
    -- Executing [exten@sub-record-check:11] GosubIf("SIP/109-00000067", "1?record,1(exten,200,109)") in new stack
    -- Executing [record@sub-record-check:1] Set("SIP/109-00000067", "AUDIOHOOK_INHERIT(MixMonitor)=yes") in new stack
    -- Executing [record@sub-record-check:2] MixMonitor("SIP/109-00000067", "2013/07/26/exten-200-109-20130726-134554-1374831954.131.wav,,") in new stack
    -- Executing [record@sub-record-check:3] Set("SIP/109-00000067", "__REC_STATUS=RECORDING") in new stack
    -- Executing [record@sub-record-check:4] Set("SIP/109-00000067", "CDR(recordingfile)=exten-200-109-20130726-134554-1374831954.131.wav") in new stack
    -- Executing [record@sub-record-check:5] Return("SIP/109-00000067", "") in new stack
    -- Executing [exten@sub-record-check:12] Return("SIP/109-00000067", "") in new stack
    -- Executing [s@macro-exten-vm:7] Macro("SIP/109-00000067", "dial-one,15,tr,200") in new stack
    -- Executing [s@macro-dial-one:1] Set("SIP/109-00000067", "DEXTEN=200") in new stack
    -- Executing [s@macro-dial-one:2] Set("SIP/109-00000067", "DIALSTATUS_CW=") in new stack
    -- Executing [s@macro-dial-one:3] GosubIf("SIP/109-00000067", "0?screen,1()") in new stack
    -- Executing [s@macro-dial-one:4] GosubIf("SIP/109-00000067", "0?cf,1()") in new stack
    -- Executing [s@macro-dial-one:5] GotoIf("SIP/109-00000067", "1?skip1") in new stack
    -- Goto (macro-dial-one,s,8)
    -- Executing [s@macro-dial-one:8] GotoIf("SIP/109-00000067", "0?nodial") in new stack
    -- Executing [s@macro-dial-one:9] GotoIf("SIP/109-00000067", "0?continue") in new stack
    -- Executing [s@macro-dial-one:10] Set("SIP/109-00000067", "EXTHASCW=ENABLED") in new stack
    -- Executing [s@macro-dial-one:11] GotoIf("SIP/109-00000067", "0?next1:cwinusebusy") in new stack
    -- Goto (macro-dial-one,s,23)
    -- Executing [s@macro-dial-one:23] GotoIf("SIP/109-00000067", "1?next3:continue") in new stack
    -- Goto (macro-dial-one,s,24)
    -- Executing [s@macro-dial-one:24] ExecIf("SIP/109-00000067", "0?Set(DIALSTATUS_CW=BUSY)") in new stack
    -- Executing [s@macro-dial-one:25] GotoIf("SIP/109-00000067", "0?nodial") in new stack
    -- Executing [s@macro-dial-one:26] GosubIf("SIP/109-00000067", "1?dstring,1():dlocal,1()") in new stack
    -- Executing [dstring@macro-dial-one:1] Set("SIP/109-00000067", "DSTRING=") in new stack
    -- Executing [dstring@macro-dial-one:2] Set("SIP/109-00000067", "DEVICES=200") in new stack
    -- Executing [dstring@macro-dial-one:3] ExecIf("SIP/109-00000067", "0?Return()") in new stack
    -- Executing [dstring@macro-dial-one:4] ExecIf("SIP/109-00000067", "0?Set(DEVICES=00)") in new stack
    -- Executing [dstring@macro-dial-one:5] Set("SIP/109-00000067", "LOOPCNT=1") in new stack
    -- Executing [dstring@macro-dial-one:6] Set("SIP/109-00000067", "ITER=1") in new stack
    -- Executing [dstring@macro-dial-one:7] Set("SIP/109-00000067", "THISDIAL=SIP/200") in new stack
    -- Executing [dstring@macro-dial-one:8] GosubIf("SIP/109-00000067", "1?zap2dahdi,1()") in new stack
    -- Executing [zap2dahdi@macro-dial-one:1] ExecIf("SIP/109-00000067", "0?Return()") in new stack
    -- Executing [zap2dahdi@macro-dial-one:2] Set("SIP/109-00000067", "NEWDIAL=") in new stack
    -- Executing [zap2dahdi@macro-dial-one:3] Set("SIP/109-00000067", "LOOPCNT2=1") in new stack
    -- Executing [zap2dahdi@macro-dial-one:4] Set("SIP/109-00000067", "ITER2=1") in new stack
    -- Executing [zap2dahdi@macro-dial-one:5] Set("SIP/109-00000067", "THISPART2=SIP/200") in new stack
    -- Executing [zap2dahdi@macro-dial-one:6] ExecIf("SIP/109-00000067", "0?Set(THISPART2=DAHDI/200)") in new stack
    -- Executing [zap2dahdi@macro-dial-one:7] Set("SIP/109-00000067", "NEWDIAL=SIP/200&") in new stack
    -- Executing [zap2dahdi@macro-dial-one:8] Set("SIP/109-00000067", "ITER2=2") in new stack
    -- Executing [zap2dahdi@macro-dial-one:9] GotoIf("SIP/109-00000067", "0?begin2") in new stack
    -- Executing [zap2dahdi@macro-dial-one:10] Set("SIP/109-00000067", "THISDIAL=SIP/200") in new stack
    -- Executing [zap2dahdi@macro-dial-one:11] Return("SIP/109-00000067", "") in new stack
    -- Executing [dstring@macro-dial-one:9] Set("SIP/109-00000067", "DSTRING=SIP/200&") in new stack
    -- Executing [dstring@macro-dial-one:10] Set("SIP/109-00000067", "ITER=2") in new stack
    -- Executing [dstring@macro-dial-one:11] GotoIf("SIP/109-00000067", "0?begin") in new stack
    -- Executing [dstring@macro-dial-one:12] Set("SIP/109-00000067", "DSTRING=SIP/200") in new stack
    -- Executing [dstring@macro-dial-one:13] Return("SIP/109-00000067", "") in new stack
    -- Executing [s@macro-dial-one:27] GotoIf("SIP/109-00000067", "0?nodial") in new stack
    -- Executing [s@macro-dial-one:28] GotoIf("SIP/109-00000067", "0?skiptrace") in new stack
    -- Executing [s@macro-dial-one:29] GosubIf("SIP/109-00000067", "1?ctset,1():ctclear,1()") in new stack
  == Begin MixMonitor Recording SIP/109-00000067
    -- Executing [ctset@macro-dial-one:1] Set("SIP/109-00000067", "DB(CALLTRACE/200)=109") in new stack
    -- Executing [ctset@macro-dial-one:2] Return("SIP/109-00000067", "") in new stack
    -- Executing [s@macro-dial-one:30] Set("SIP/109-00000067", "D_OPTIONS=tr") in new stack
    -- Executing [s@macro-dial-one:31] ExecIf("SIP/109-00000067", "0?SIPAddHeader(Alert-Info: )") in new stack
    -- Executing [s@macro-dial-one:32] ExecIf("SIP/109-00000067", "0?SIPAddHeader()") in new stack
    -- Executing [s@macro-dial-one:33] ExecIf("SIP/109-00000067", "0?Set(CHANNEL(musicclass)=)") in new stack
    -- Executing [s@macro-dial-one:34] GosubIf("SIP/109-00000067", "0?qwait,1()") in new stack
    -- Executing [s@macro-dial-one:35] Set("SIP/109-00000067", "__CWIGNORE=") in new stack
    -- Executing [s@macro-dial-one:36] Set("SIP/109-00000067", "__KEEPCID=TRUE") in new stack
    -- Executing [s@macro-dial-one:37] GotoIf("SIP/109-00000067", "0?usegoto,1") in new stack
    -- Executing [s@macro-dial-one:38] GotoIf("SIP/109-00000067", "0?godial") in new stack
    -- Executing [s@macro-dial-one:39] Set("SIP/109-00000067", "CONNECTEDLINE(name,i)=test2") in new stack
    -- Executing [s@macro-dial-one:40] Set("SIP/109-00000067", "CONNECTEDLINE(num)=200") in new stack
    -- Executing [s@macro-dial-one:41] Set("SIP/109-00000067", "D_OPTIONS=trI") in new stack
    -- Executing [s@macro-dial-one:42] Dial("SIP/109-00000067", "SIP/200,15,trI") in new stack
  == Using SIP RTP TOS bits 184
  == Using SIP RTP CoS mark 5
       > [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,userfield) VALUES ('CHAN_START',{ts '2013-07-26 13:45:54'},'test2','200','','','','s','from-internal','SIP/200-00000068','','',3,'','1374831954.132','1374831954.131','','','')]
    -- Called SIP/200
    -- Connected line update to SIP/109-00000067 prevented.
    -- SIP/200-00000068 is ringing
       > [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,userfield) VALUES ('HANGUP',{ts '2013-07-26 13:45:58'},'test2','200','200','','','200','from-internal','SIP/200-00000068','AppDial','(Outgoing Line)',3,'','1374831954.132','1374831954.131','','','')]
  == Spawn extension (macro-dial-one, s, 42) exited non-zero on 'SIP/109-00000067' in macro 'dial-one'
       > [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,userfield) VALUES ('CHAN_END',{ts '2013-07-26 13:45:58'},'test2','200','200','','','200','from-internal','SIP/200-00000068','AppDial','(Outgoing Line)',3,'','1374831954.132','1374831954.131','','','')]
  == Spawn extension (macro-exten-vm, s, 7) exited non-zero on 'SIP/109-00000067' in macro 'exten-vm'
  == Spawn extension (from-internal, 200, 2) exited non-zero on 'SIP/109-00000067'
    -- Executing [h@from-internal:1] Hangup("SIP/109-00000067", "") in new stack
  == Spawn extension (from-internal, h, 1) exited non-zero on 'SIP/109-00000067'
  == MixMonitor close filestream (mixed)
       > [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,userfield) VALUES ('HANGUP',{ts '2013-07-26 13:45:58'},'test','109','109','','200','h','from-internal','SIP/109-00000067','','',3,'','1374831954.131','1374831954.131','','','')]
       > [INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,cnum,cnam) VALUES ({ ts '2013-07-26 13:45:54' },'"test" <109>','109','200','from-internal','SIP/109-00000067','SIP/200-00000068','Dial','SIP/200,15,trI',4,0,'NO ANSWER',3,'1374831954.131','exten-200-109-20130726-134554-1374831954.131.wav','109','test')]
       > [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,userfield) VALUES ('CHAN_END',{ts '2013-07-26 13:45:59'},'test','109','109','','200','h','from-internal','SIP/109-00000067','','',3,'','1374831954.131','1374831954.131','','','')]
  == End MixMonitor Recording SIP/109-00000067
       > [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,userfield) VALUES ('LINKEDID_END',{ts '2013-07-26 13:45:59'},'test','109','109','','200','h','from-internal','SIP/109-00000067','','',3,'','1374831954.131','1374831954.131','','','')]

[Tempik]

Есть идеи из за чего такое?

[Vlad1983]

покажите

Код: Выделить всё

asterisk -rx "module show like cdr"

[Tempik]

Module Description Use Count
app_cdr.so Tell Asterisk to not maintain a CDR for 0
app_forkcdr.so Fork The CDR into 2 separate entities 0
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0
cdr_csv.so Comma Separated Values CDR Backend 0
cdr_custom.so Customizable Comma Separated Values CDR 0
cdr_manager.so Asterisk Manager Interface CDR Backend 0
cdr_mysql.so MySQL CDR Backend 0
cdr_odbc.so ODBC CDR Backend 0
cdr_syslog.so Customizable syslog CDR Backend 0
func_cdr.so Call Detail Record (CDR) dialplan functi 0
10 modules loaded

[Vlad1983]

Код: Выделить всё

asterisk -rx "module unload cdr_mysql.so"

звоним, смотрим что упало в таблицу, если не задвояица в modules.conf запрещаем загрузку cdr_mysql.so

[Tempik]

Большое спасибо, все заработало. но для меня все равно остается загадкой какойже еще модуль тогда делает записи

[Vlad1983]

с этим предлагаю разобраться самостоятельно