ODBC Adaptive CDR is not working

1. nano /etc/asterisk/cdr_adaptive_odbc.conf
   [adaptive_connection]
   connection=asteriskcdrdb
   table=cdr
   alias start => calldate
2. Modified the /etc/odbc.ini to reflect
   [MySQL-asteriskcdrdb]
   Description=MySQL connection to 'asterisk' database
   driver=MySQL
   server=localhost
   database=asteriskcdrdb
   username=freepbx (user name and password from /etc/freepbx.conf)
   password=fpbx
   Port=3306
   Socket=/var/lib/mysql/mysql.sock
   option=3
3. module reload res_odbc.so
4. module reload cdr_adaptive_odbc.so
5. restart Asterisk

You can run below commands to confirm CDR, MySQL and ODBC connections:
cdr show status
module show cdr
module show mysql
odbc show

Posted in: Asterisk,Elastix,Mysql