elastix cdr stop working

Question

CDR was working before 19 march. Unfortunately i dont remember what kind of changes i made to configuration, but this exactly not changes to CDR config.

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)

What do you mean "stop working"? – Andrew Schulman May 26 '14 at 15:36 — Andrew Schulman, May 26 '14 at 15:36
it means CDR worked before, but now does not work – dreddko May 28 '14 at 06:30 — dreddko, May 28 '14 at 06:30

score 0 · Answer 1 · answered Jun 02 '14 at 20:57

0

Have you looked at the Asterisk console at load to see if there are errors in mysql channel driver? Look at the mysql server logs as well so see if there are connection or authentication issues.

answered Jun 02 '14 at 20:57

mxtreme311

11
2

score -1 · Answer 2 · answered Jun 11 '14 at 06:24

-1

Fix it by deleting:

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

and reload modules

answered Jun 11 '14 at 06:24

dreddko

9
1
2

elastix cdr stop working

2 Answers2