Re: [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@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

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@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