В базу данные не записываются (func_odbc)

[Diana92]

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

Database changed
mysql> describe count_rating;
+------------+------------------+------+-----+---------------------+----------------+
| Field      | Type             | Null | Key | Default             | Extra          |
+------------+------------------+------+-----+---------------------+----------------+
| id         | int(11) unsigned | NO   | PRI | NULL                | auto_increment |
| extension  | int(8)           | NO   |     | NULL                |                |
| calldate   | datetime         | NO   | MUL | 0000-00-00 00:00:00 |                |
| callerid   | varchar(80)      | NO   |     |                     |                |
| first_dest | int(80)          | NO   | MUL | NULL                |                |
| uniqueid   | varchar(32)      | NO   | MUL |                     |                |
| rating     | int(11)          | NO   |     | NULL                |                |
+------------+------------------+------+-----+---------------------+----------------+
7 rows in set (0.00 sec)

[Vlad1983]

writesql=INSERT INTO count_rating(extension,calldate,callerid,first_dest,uniqueid,rating) VALUES ('${ARG1}',STR_TO_DATE('${VAL1}', '%d-%m-%Y %H:%i:%s'),'${VAL2}','${VAL3}','{VAL4},'${VAL5}')

[Diana92]

Ничего не изменилось, но дублирование прекратилось)
А в сет у меня было так: exten => 2,n,Set(GET_RATE(${EXTEN})=${STRFTIME(${EPOCH},,%d-%m-%Y %H:%M:%S)}\,${CALLERID(num)}\,${ORIG_DID}\,${UNIQUEID}\,${EXTEN})

[Vlad1983]

не верю

[Diana92]

Шутишь? К чему не веришь?
То что ничего не изменилось? А зачем мне врать? Вот он последний звонок после изменений

[Vlad1983]

exten => 2,n,Set(GET_RATE(${EXTEN})=${CALLERID(num)}\,${ORIG_DID}\,${UNIQUEID}\,${EXTEN})

writesql=INSERT INTO count_rating(extension,calldate,callerid,first_dest,uniqueid,rating) VALUES ('${ARG1}', Now(), '${VAL1}', '${VAL2}', '{VAL3}, '${VAL4}')

[Diana92]

Ну в базе все так же
а в консоли даты и времени нет

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

 == Using SIP RTP CoS mark 5
    -- Executing [1121@from-internal:1] Playback("SIP/300-00000001", "Welcome") in new stack
    -- Executing [1121@from-internal:2] Set("SIP/300-00000001", "ORIG_DID=1121") in new stack
    -- Executing [1121@from-internal:3] BackGround("SIP/300-00000001", "enter-phone-number10") in new stack
    -- <SIP/300-00000001> Playing 'enter-phone-number10.gsm' (language 'RU')
  == CDR updated on SIP/300-00000001
    -- Executing [1@from-internal:1] NoOp("SIP/300-00000001", "selected 1") in new stack
    -- Executing [1@from-internal:2] Playback("SIP/300-00000001", "good") in new stack
    -- <SIP/300-00000001> Playing 'good.gsm' (language 'RU')
    -- Executing [1@from-internal:3] Set("SIP/300-00000001", "GET_RATE(1)=300\,1121\,1390887973.1\,1") in new stack
    -- Executing [1@from-internal:4] Hangup("SIP/300-00000001", "") in new stack
  == Spawn extension (from-internal, 1, 4) exited non-zero on 'SIP/300-00000001'
    -- Executing [h@from-internal:1] Macro("SIP/300-00000001", "hangupcall") in new stack
    -- Executing [s@macro-hangupcall:1] GotoIf("SIP/300-00000001", "1?endmixmoncheck") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing [s@macro-hangupcall:9] NoOp("SIP/300-00000001", "End of MIXMON check") in new stack
    -- Executing [s@macro-hangupcall:10] GotoIf("SIP/300-00000001", "1?nomeetmemon") in new stack
    -- Goto (macro-hangupcall,s,28)
    -- Executing [s@macro-hangupcall:28] NoOp("SIP/300-00000001", "End of MEETME check") in new stack
    -- Executing [s@macro-hangupcall:29] GotoIf("SIP/300-00000001", "1?noautomon") in new stack
    -- Goto (macro-hangupcall,s,34)
    -- Executing [s@macro-hangupcall:34] NoOp("SIP/300-00000001", "TOUCH_MONITOR_OUTPUT=") in new stack
    -- Executing [s@macro-hangupcall:35] GotoIf("SIP/300-00000001", "1?noautomon2") in new stack
    -- Goto (macro-hangupcall,s,41)
    -- Executing [s@macro-hangupcall:41] NoOp("SIP/300-00000001", "MONITOR_FILENAME=") in new stack
    -- Executing [s@macro-hangupcall:42] GotoIf("SIP/300-00000001", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,45)
    -- Executing [s@macro-hangupcall:45] GotoIf("SIP/300-00000001", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,48)
    -- Executing [s@macro-hangupcall:48] GotoIf("SIP/300-00000001", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,50)
    -- Executing [s@macro-hangupcall:50] AGI("SIP/300-00000001", "hangup.agi") in new stack
    -- Launched AGI Script /var/lib/asterisk/agi-bin/hangup.agi
    -- <SIP/300-00000001>AGI Script hangup.agi completed, returning 0
    -- Executing [s@macro-hangupcall:51] Hangup("SIP/300-00000001", "") in new stack
  == Spawn extension (macro-hangupcall, s, 51) exited non-zero on 'SIP/300-00000001' in 

[Vlad1983]

тогда последовательно

exten => 2,n,Set(GET_RATE(${EXTEN})=${CALLERID(num)})

writesql=INSERT INTO count_rating(extension,calldate,callerid) VALUES ('${ARG1}', Now(), '${VAL1}')

и далее прибавлять параметры пока не начнет спотыкаться

[Diana92]

Уже при первом пусто

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

exten => 2,n,Set(GET_RATE(${EXTEN})=${CALLERID(num)})

и во втором пусто

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

exten => 2,n,Set(GET_RATE(${EXTEN})=${CALLERID(num)}\,${ORIG_DID})

есть ли смысли идти дальше?

[Vlad1983]

включать дебаг и ловить