☰

elastix cdr 停止工作

tag-icon • tag-icon asterisk freepbx elastix
elastix cdr 停止工作

CDR 在 3 月 19 日之前一直正常工作。不幸的是，我不记得我对配置做了哪些更改，但这确实没有更改 CDR 配置。

elastix 2.4.0 asterisk 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)

答案1

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

答案2

通过删除来修复它：

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

并重新加载模块

相关内容