Problem With Odbc Connector With Cdr

Home » Asterisk Users » Problem With Odbc Connector With Cdr
Asterisk Users 2 Comments


I’m stuck with getting cdr records stored in MySql database. I have a working realtime environment and have verified that the db connection works fine when used via res_config_mysql.conf. I’d appreciate Your help on how to get the odbc connector working as I think there’s something wrong with its configuration.

The problem presented itself as an error when making a call that was supposed to be stored in mysql cdr: Unable to retrieve database handle. CDR failed. This kept popping up every time I was trying to have a call be stored in my mysql cdr table, and I traced the problem to the odbc connector, where my knowhow is about to end.

One problem may be that odbcinst -j outputs wrong ini files, I believe I
need these to be under /etc/ instead of /usr/local/etc/, but I’m unsure about how to change those permanently.

# odbcinst -j unixODBC 2.3.2
DRIVERS…………: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size…….: 4
SQLLEN Size……..: 4

Odbcinst does see the connection, it reads it from
# odbcinst -q -d

I tried copying my connection information onto those files listed above and I’m not getting any errors in Asterisk logs when restarting Asterisk. However:
# echo “select 1” | isql -v MySQL
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Here’s the contents of odbc.ini:

Description = MySQL Asterisk database Trace = Off TraceFile = stderr Driver = MySQL
SERVER = serverip USER = myuser PASSWORD = mypass PORT = 3306
DATABASE = asterisk

And odbcinst.ini:
Description = ODBC for MySQL
Driver = /usr/lib/ Setup = /usr/lib/ Driver64 = /usr/lib64/ Setup64 = /usr/lib64/ FileUsage = 1

And here I hit a wall, how can I fix the configuration?

MySQL-asterisk is referred to in res_odbc.conf, whose label is referred to in cdr_odbc.conf. When the odbc connector starts working, is this the correct way to configure the cdr db connection in Asterisk?

Thanks, Olli

2 thoughts on - Problem With Odbc Connector With Cdr

  • I notice you have MySQL-asterisk as your definition in your odbc.ini but you are trying to connect to simply ‘MySQL’ with your ‘isql’ command.

    Does isql work with ‘MySQL-asterisk’ as the DSN instead of simply ‘MySQL’ ?

    I have machines that use /etc/odbc.ini and machines that use
    /usr/local/etc/odbc.ini depending on if I used a package to instal ODBC or if I compiled ODBC myself.

  • Thanks John,

    At first got an error using MySQL-asterisk, but then I removed /etc/ ini files and used the DSN in /usr/local/etc/odbc.ini, that did the trick for isql. I must have created the files /etc/ while following a guide online. Nice!

    After some meddling with the Asterisk conf files to have the correct values I got the cdrs working, thanks dude!

    cheers, Olli

    2015-02-03 18:04 GMT+02:00 John Kiniston :