I am trying to set up ODBC CDR on my server and not having much luck. Can somebody help me get this set up, please? <3
When I load asterisk, I get the following:[2014-12-12 11:50:44] NOTICE[11759]: res_odbc.c:1536 odbc_obj_connect: Connecting asteriskcdrdb
[2014-12-12 11:50:44] NOTICE[11759]: res_odbc.c:1568 odbc_obj_connect: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2014-12-12 11:50:44] NOTICE[11759]: res_odbc.c:928 load_odbc_config: Registered ODBC class 'asteriskcdrdb' dsn->[MySQL-asteriskcdrdb]
When I make a test call, I get this:
[2014-12-12 11:50:58] WARNING[1407]: func_cdr.c:349 cdr_write_callback: CDR requires a value (CDR(variable)=value)
[2014-12-12 11:51:00] WARNING[12041][C-0000000b]: chan_sip.c:7349 sip_write: Can't send 10 type frames with SIP write
[2014-12-12 11:51:02] WARNING[12041][C-0000000b]: chan_sip.c:7349 sip_write: Can't send 10 type frames with SIP write
[2014-12-12 11:51:21] WARNING[1407]: cdr_odbc.c:145 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO asteriskcdrdb (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2014-12-12 11:50:58'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[2014-12-12 11:51:21] WARNING[1407]: res_odbc.c:617 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2014-12-12 11:51:21] WARNING[1407]: cdr_odbc.c:145 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO asteriskcdrdb (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2014-12-12 11:50:58'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[2014-12-12 11:51:21] ERROR[1407]: cdr_odbc.c:174 odbc_log: CDR direct execute failed
/etc/odbc.ini
[MySQL-asteriskcdrdb]
Driver = MySQL
Description = MySQL connection to ‘asteriskcdr' DB
Server = localhost
Port = 3306
Database = asteriskcdrdb
UserName = asteriskuser
Password = password
Socket = /var/lib/mysql/mysql.sock
Option = 3
/etc/odbcinst.ini
Description = MySQL Driver
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
/etc/asterisk/cdr_odbc.conf[code]
; cdr_odbc.conf
;
[global]
dsn=asteriskcdrdb
loguniqueid=yes
dispositionstring=yes
table=asteriskcdrdb ;“cdr” is default table name
;usegmtime=no ; set to “yes” to log in GMT
hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields
[/code]
/etc/asterisk/res_odbc_additional.conf
[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
pooling=>no
limit=>1
pre-connect=>yes
username=>asteriskuser
password=>secret