I am using asterisk 11.18 and following are my configuration.
odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
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.
echo "select 1" | isql -v asterisk-connector root dev‘mydatabase’ is a name of database which login from ‘root’ user with password ‘dev’ .
res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
username => root
password => dev
pooling => no
limit => 1
pre-connect => yes
[code]
*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 https://gist.github.com/achyutdev/dd5c16dfa11bf2695f7d
cdr_adaptive_odbc.conf
[mydatabase]
connection=asterisk
table= cdr
alias start=>calldate
then after i reload
[quote]*CLI> module reload res_odbc.so
– Reloading module ‘res_odbc.so’ (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 cdr_adaptive_odbc.so
– Reloading module ‘cdr_adaptive_odbc.so’ (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
[/quote]
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.
[quote]./configure
make menuselect
make install[/quote]
Please help to find out problem.