CDR direct execute failed

Asterisk Asterisk Support
1

Hi everybody!

I’m trying to install a CDR Viewer https://github.com/g613/asterisk-cdr-viewer

I’ts work well, but my problem is to make Asterisk store to MySQL using ODBC

When I make a call the CLI returns for me, see the log below:

== Using SIP RTP CoS mark 5
    -- Executing [2021@ramais:1] Dial("SIP/2020-00000000",
"SIP/2021,60,tT") in new stack
  == Using SIP RTP CoS mark 5
    -- Called SIP/2021
    -- SIP/2021-00000001 is ringing
       > 0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
[Jan 13 11:31:07] NOTICE[2279][C-00000000]: res_rtp_asterisk.c:4441
ast_rtp_read: Unknown RTP codec 95 received from '(null)'
    -- SIP/2021-00000001 answered SIP/2020-00000000
       > 0x7fd3b4004eb0 -- Probation passed - setting RTP source
address to 192.168.25.100:8000
       > 0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
       > cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] WARNING[2279][C-00000000]: res_odbc.c:604
ast_odbc_direct_execute: SQL Execute error! Verifying connection to
asterisk [asterisk-connector]...
       > cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] ERROR[2279][C-00000000]: cdr_odbc.c:177 odbc_log:
CDR direct execute failed

See my res_odbc.conf

[asterisk]
enabled = yes
dsn = asterisk-connector
username = root
password = 100567
pooling = no
limit = 1
pre-connect = yes

What can be happened? I use Asterisk 11 with Ubuntu Server 14.04.

Thank in advanced.

2

Did You already verify wheter the ODBC-connection itself is running (You may check this with isql for the connection description asterisk-connector). And: How do the configuration cdr_adaptive_odbc.conf look like ? What’s the output of cdr show status in the Asterisk-CLI?