Asterisk cdr

How to install and configure asterisk cdr module in CentOS 5.2

1. ODBC stuff
   yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel
2. Install MySQL ODBC interface/connector
   yum -y install mysql-connector-odbc
   
   Edit '/etc/odbcinst.ini' and include following text.
   #[MySQL],Description = ODBC for MySQL
   #Driver = /usr/lib/libmyodbc.so
   Driver = /usr/lib/libmyodbc3.so
   Setup = /usr/lib/libodbcmyS.so
   FileUsage = 1
   
   
3. Edit /etc/asterisk/cdr_mysql.conf
   [global]
   hostname=localhost
   dbname=asterisk
   table=cdr
   password=MYPASS
   user=astrealtime
   port=3306
   sock=/var/lib/mysql/mysql.sock
   userfield=1
   loguniqueid=yes
   
   [columns]