[Asterisk-Users] cdr_mysql does not write to mysql db

[sylvain garcia]

Kib Eki a écrit :

> Hi,
>
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the
> mysql db.
>
> The problem is that no records are written to the db. Why?
>
> I can import the csv-file to the db. so i assume the db is setup correct.
>
> Is there any chance to get debug from cdr_mysql to find his problem?
>
> This is my cdr_mysql.conf file:
> [global]
> hostname=localhost
> dbname=cdr
> password=passw0rd
> user=root
> ;port=3306
> ;sock=/tmp/mysql.sock
> userfield=1
>
> Thanks and Regards
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users


Asterisk don't use directly mysql database for cdr, astersisk use odbc
and odbc connect to mysql.

So you must configure odbc corectly wiyt libmyodbc (on debian)
the config file are here:

/etc/odbcinst.ini :

[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
CPTimeout =
CPReuse =
FileUsage = 1




/etc/odbc.ini :

[MySQL-asterisk]
Description = MySQL Asterisk Database
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = @ipofMysqlddatabase (not domain name)
User =
Password =
Database = asterisk
Option = 3
#Port =



/etc/asterisk/cdr_odbc.conf :

[global]
dsn=MySQL-asterisk
username=database_username
password=database_password
loguniqueid=yes


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050727/817e0c17/attachment.htm