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
asteriskCLI> cdr mysql status
Not currently connected to a MySQL server.
asterisk*CLI>
From Linux CLI :
root@asterisk:/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