Logger.conf

[general]
queue_log => odbc,asteriskcdrdb,queue_log
queue_log_to_file  = yes
queue_adaptive_realtime = yes
dateformat=%F %T
appendhostname=no
rotatestrategy=rotate

res_odbc.conf

[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
;pooling=>no
;limit=>1
pre-connect=>yes
username=>root
password=>blabla
database=>asteriskcdrdb

/etc/odbc.ini

[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3