может быть у меня не там собака зарыта?
внес изменения:
config.php
'column_name' => 'UNIQUEID',
extensions.conf
закоментировал макрос записи,
exten => _X.,1,MixMonitor(/var/calls/${UNIQUEID}.wav)
в sql попадет, файл с именем UNIQUEID.wav создается, а в веб интерфейсе не отображается...да что же ты будешь делать.
== Using SIP RTP CoS mark 5
    -- Executing [6388@incoming:1] MixMonitor("SIP/ntel-0000000f", "/var/calls/1508927061.23.wav") in new stack
    -- Executing [6388@incoming:2] Answer("SIP/ntel-0000000f", "") in new stack
  == Begin MixMonitor Recording SIP/ntel-0000000f
    -- Executing [6388@incoming:3] Goto("SIP/ntel-0000000f", "menu,s,1") in new stack
    -- Goto (menu,s,1)
    -- Executing [s@menu:1] BackGround("SIP/ntel-0000000f", "/var/lib/asterisk/moh/voicemail/sagamenu2") in new stack
    -- <SIP/ntel-0000000f> Playing '/var/lib/asterisk/moh/voicemail/sagamenu2.slin' (language 'ru')
       > 0x7fccbc001200 -- Probation passed - setting RTP source address to 109.71.241.71:13214
[Oct 25 13:24:27] DTMF[2460][C-0000000d]: channel.c:4126 __ast_read: DTMF begin '1' received on SIP/ntel-0000000f
[Oct 25 13:24:27] DTMF[2460][C-0000000d]: channel.c:4130 __ast_read: DTMF begin ignored '1' on SIP/ntel-0000000f
[Oct 25 13:24:27] DTMF[2460][C-0000000d]: channel.c:4040 __ast_read: DTMF end '1' received on SIP/ntel-0000000f, duration 280 ms
[Oct 25 13:24:27] DTMF[2460][C-0000000d]: channel.c:4110 __ast_read: DTMF end passthrough '1' on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4126 __ast_read: DTMF begin '2' received on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4130 __ast_read: DTMF begin ignored '2' on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4040 __ast_read: DTMF end '2' received on SIP/ntel-0000000f, duration 255 ms
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4110 __ast_read: DTMF end passthrough '2' on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4126 __ast_read: DTMF begin '0' received on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4130 __ast_read: DTMF begin ignored '0' on SIP/ntel-0000000f
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4040 __ast_read: DTMF end '0' received on SIP/ntel-0000000f, duration 280 ms
[Oct 25 13:24:28] DTMF[2460][C-0000000d]: channel.c:4110 __ast_read: DTMF end passthrough '0' on SIP/ntel-0000000f
[Oct 25 13:24:29] DTMF[2460][C-0000000d]: channel.c:4126 __ast_read: DTMF begin '7' received on SIP/ntel-0000000f
[Oct 25 13:24:29] DTMF[2460][C-0000000d]: channel.c:4130 __ast_read: DTMF begin ignored '7' on SIP/ntel-0000000f
[Oct 25 13:24:29] DTMF[2460][C-0000000d]: channel.c:4040 __ast_read: DTMF end '7' received on SIP/ntel-0000000f, duration 255 ms
[Oct 25 13:24:29] DTMF[2460][C-0000000d]: channel.c:4110 __ast_read: DTMF end passthrough '7' on SIP/ntel-0000000f
    -- Executing [1207@menu:1] Dial("SIP/ntel-0000000f", "SIP/1207,,Tt&m") in new stack
  == Using SIP RTP CoS mark 5
    -- Called SIP/1207
    -- Started music on hold, class 'default', on channel 'SIP/ntel-0000000f'
    -- SIP/1207-00000010 is ringing
    -- SIP/1207-00000010 answered SIP/ntel-0000000f
    -- Stopped music on hold on SIP/ntel-0000000f
    -- Channel SIP/1207-00000010 joined 'simple_bridge' basic-bridge <1bd2c321-ade1-4abd-bd7f-1a76a75ff48f>
    -- Channel SIP/ntel-0000000f joined 'simple_bridge' basic-bridge <1bd2c321-ade1-4abd-bd7f-1a76a75ff48f>
       > 0x7fccc401ee80 -- Probation passed - setting RTP source address to 10.0.0.119:5062
    -- Channel SIP/1207-00000010 left 'simple_bridge' basic-bridge <1bd2c321-ade1-4abd-bd7f-1a76a75ff48f>
    -- Channel SIP/ntel-0000000f left 'simple_bridge' basic-bridge <1bd2c321-ade1-4abd-bd7f-1a76a75ff48f>
  == Spawn extension (menu, 1207, 1) exited non-zero on 'SIP/ntel-0000000f'
  == MixMonitor close filestream (mixed)
  == End MixMonitor Recording SIP/ntel-0000000f
 
[incoming]
exten => _X.,1,MixMonitor(/var/calls/${UNIQUEID}.wav)
;exten => _X.,1,Macro(recording,${CALLERID(num)},${EXTEN})
;exten => _x.,1,Set(fname=${STRFTIME(${EPOCH},,%Y%m%d%H%M)}-${CALLERID(number)}-${EXTEN$
;exten => _x.,2,MixMonitor(/records/callrecords/${fname}.wav)
exten => _x.,n,Answer()
exten => _x.,n,Goto(menu,s,1) ;если мы изнутри позвоним на этот номер, то мы сможем про$
;exten => _x.4,1,dial(SIP/1207,5,t&m)
;exten => _x,5,Goto(autoanswer,s,1)       ;перевод на автоответчик
exten => _x.,n,hangup()
[root@aster ~]#  ls /var/calls/ | grep 1508927061.23.wav
1508927061.23.wav
[spoiler=select * from cdr where uniqueid='1508927061.23';]mysql> select * from cdr where uniqueid='1508927061.23';
+----+---------------------+---------------------------+------------+------+----                                                                                                                                                             -----+----------+-------------------+-------------------+---------+-------------                                                                                                                                                             ---+----------+---------+-------------+----------+----------+-------------+-----                                                                                                                                                             --------+---------------+-----------+-----+---------------+----------+----------                                                                                                                                                             +
| id | calldate            | clid                      | src        | dst  | rea                                                                                                                                                             ldst | dcontext | channel           | dstchannel        | lastapp | lastdata                                                                                                                                                                    | duration | billsec | disposition | amaflags | remoteip | accountcode | peer                                                                                                                                                             account | uniqueid      | userfield | did | linkedid      | sequence | filename                                                                                                                                                              |
+----+---------------------+---------------------------+------------+------+----                                                                                                                                                             -----+----------+-------------------+-------------------+---------+-------------                                                                                                                                                             ---+----------+---------+-------------+----------+----------+-------------+-----                                                                                                                                                             --------+---------------+-----------+-----+---------------+----------+----------                                                                                                                                                             +
| 34 | 2017-10-25 13:24:21 | "9151276136" <9151276136> | 9151276136 | 1207 |                                                                                                                                                                      | menu     | SIP/ntel-0000000f | SIP/1207-00000010 | Dial    | SIP/1207,,Tt                                                                                                                                                             &m |       17 |      17 | ANSWERED    |        3 |          |             |                                                                                                                                                                          | 1508927061.23 |           |     | 1508927061.23 |       15 | none                                                                                                                                                                  |
+----+---------------------+---------------------------+------------+------+----                                                                                                                                                             -----+----------+-------------------+-------------------+---------+-------------                                                                                                                                                             ---+----------+---------+-------------+----------+----------+-------------+-----                                                                                                                                                             --------+---------------+-----------+-----+---------------+----------+----------[/spoiler]
вроде везде все есть, но звонков в веб интерфейсе так и не отображает. я уже теряюсь...