弹性cdr停止工作

Question

CDR在3月19日前开始工作。不幸的是，我不记得我对配置做了什么样的更改，但这完全不是对CDR配置的更改。

弹性2.4.0星号11.7.0 mysql 5.0.95

elastix*CLI> cdr show status

Call Detail Record (CDR) settings
----------------------------------
  Logging:                    Disabled
  Mode:                       Simple

/etc/asterisk/cdr.conf
[general]
enable=yes
unanswered = yes


/etc/asterisk/cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = *MYPASSWROD*
user = asteriskcdruser
userfield=1
;port=3306
;sock=/tmp/mysql.sock
loguniqueid=yes


mysql> SHOW GRANTS FOR 'asteriskcdruser'@'localhost';
+-----------------------------------------------------------------------------------------------+
| Grants for asteriskcdruser@localhost                                                          |
+-----------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'asteriskcdruser'@'localhost' IDENTIFIED BY PASSWORD 'HASHHERE' |
| GRANT ALL PRIVILEGES ON `asteriskcdrdb`.* TO 'asteriskcdruser'@'localhost'                    |
+-----------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

Answer 1

您是否查看过加载时的星号控制台，以查看mysql通道驱动程序中是否存在错误？还可以查看mysql服务器日志，以确定是否存在连接或身份验证问题。

Answer 2

删除：

/var/log/asterisk/cdr-csv/Master.csv

和重新加载模块