[asterisk-users] cdr_odbc: Error in ExecDirect: -1

[Vitor Mazuco]

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:
== Using SIP RTP CoS mark 5
    -- Executing [2021 at 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?

Thank in advanced.