Anyone using ODBC for cdr records?


#1

Hi,

Just wondering if anyone was using ODBC for their cdr records? I have tried to set this up but I couldn’t get it to write to the MySQL database.

Are these the only requirements for it to work with ODBC/MySQL?

unixODBC
myODBC

Thanks. I have a suspicion it might just be the RPMS i used for unixODBC that are causing the problems, but just wanted to get some feedback.
Cheers.


#2

Yup. I’m suing Gentoo without problems. Make sure you have the table created and permissions set. Here is my setup.

;
; cdr_unixodbc.conf
;

[global]
dsn=myodbc-asterisk
username=dba
password=yaright
loguniqueid=yes
table=cdr

;
;odbcinst.ini
;
[myodbc]
Description = MySQL ODBC myodbc-3.51.11 Driver
Driver = /usr/lib/libmyodbc3.so
FileUsage = 1

;
;obdc.ini
;
[ODBC Data Sources]
myodbc-asterisk = MySQL Asterisk

[myodbc-asterisk]
Description = MySQL Asterisk
Driver = myodbc
Socket = /var/run/mysqld/mysqld.sock
Server = 10.0.0.3
Database = asterisk
Option = 3