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

[Patrick Laimbock]

On 01/13/16 14:48, Vitor Mazuco wrote:
> 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.

Just a guess but try setting "pooling" to yes and "limit" to a higher value.

Best,
Patrick