Problem in storing cdr in mysql database using ODBC

I am using asterisk 11.18 and following are my configuration.

[MySQL] Description = ODBC for MySQL Driver = /usr/lib/x86_64-linux-gnu/odbc/ Setup = /usr/lib/x86_64-linux-gnu/odbc/ FileUsage = 1

Verified that the system is able to see the driver.

$ odbcinst -q -d [MySQL]

configuration in odbc.ini

[asterisk-connector] Description = MySQL connection to 'voiceinn-ncell' database Driver = MySQL Database = mydatabese Server = localhost UserName = root Password = dev Port = 3306 Option = 3 Socket = /var/run/mysqld/mysqld.sock

its also verified.

‘mydatabase’ is a name of database which login from ‘root’ user with password ‘dev’ .

[asterisk] enabled => yes dsn => asterisk-connector username => root password => dev pooling => no limit => 1 pre-connect => yes

*CLI> odbc show

ODBC DSN Settings

Name: asterisk
DSN: asterisk-connector
Last connection attempt: 1970-01-01 05:30:00
Pooled: No
Connected: Yes[/code]
i have created cdr table in mydatabase database and here is sql


[mydatabase] connection=asterisk table= cdr alias start=>calldate

then after i reload

[quote]*CLI> module reload
– Reloading module ‘’ (ODBC resource)
== Parsing ‘/etc/asterisk/res_odbc.conf’: Found
[Jun 24 14:44:33] NOTICE[30175]: res_odbc.c:1529 odbc_obj_connect: Connecting asterisk
[Jun 24 14:44:33] NOTICE[30175]: res_odbc.c:1568 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Jun 24 14:44:33] NOTICE[30175]: res_odbc.c:919 load_odbc_config: Registered ODBC class ‘asterisk’ dsn->[asterisk-connector]
*CLI> module reload
– Reloading module ‘’ (Adaptive ODBC CDR backend)
== Parsing ‘/etc/asterisk/cdr_adaptive_odbc.conf’: Found
– Found adaptive CDR table cdr@asterisk.
– Found alias start for column calldate in cdr@asterisk

but it can’t store cdr in database. asterisk give error message

i can’t figure out what is problem with it. same problem after re-installation of asterisk.

make menuselect
make install[/quote]
Please help to find out problem.

Anyone have any idea what wrong with my configuration.