Trouble with CDR & MySQL

Hello,

i have problem with cdr_mysql addon. In debug i see:

[Jun 6 13:51:43] DEBUG[4939] res_config_mysql.c: MySQL RealTime Host: localhost
[Jun 6 13:51:43] DEBUG[4939] res_config_mysql.c: MySQL RealTime Port: 3306
[Jun 6 13:51:43] DEBUG[4939] res_config_mysql.c: MySQL RealTime User: asterisk
[Jun 6 13:51:43] DEBUG[4939] res_config_mysql.c: MySQL RealTime Password: asterisk
[Jun 6 13:51:43] DEBUG[4939] res_config_mysql.c: MySQL RealTime: Successfully connected to database.

by directly in asterisk i see:

asteriskCLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: no
CDR registered backend: cdr-custom
CDR registered backend: cdr_manager
CDR registered backend: mysql
asterisk
CLI> cdr mysql status
Not currently connected to a MySQL server.
asterisk*CLI>

From Linux CLI :

[email protected]:/var/log/asterisk#mysql -u asterisk -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 219
Server version: 5.0.32-Debian_7etch5-log Debian etch distribution

Here is my res_mysql.conf:

[general]
dbhost = localhost
dbname = asterisk
dbuser = asterisk
dbpass = asterisk
dbport = 3306
dbsock = /var/run/mysqld/mysqld.sock

I was on google about 24 hours, but i don’t know where is the problem…Can anyone help me?

Thank you…Igor

I’ve solve this issue before…I found that cdr table was crash…What I do is repair the cdr table using “mysql>repair table cdr” then restart MySQL service “service mysqld restart” and finally restart the http services “service httpd restart”…That’s all