Cdr_odbc: Error In ExecDirect: -1

Home » Asterisk Users » Cdr_odbc: Error In ExecDirect: -1
Asterisk Users 1 Comment

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@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.

One thought on - Cdr_odbc: Error In ExecDirect: -1

  • Just a guess but try setting “pooling” to yes and “limit” to a higher value.

    Best, Patrick