My FreePBX installation (CentOS, Asterisk, FreePBX 188.8.131.52, FreePBX 184.108.40.206, MySQL 5.0.77, all on the same server) is not recording CDR data into the database, nor to CSV files.
I can access the database by logging in to mysql as freepbx, or as root. The file owner of the database files is mysql. Any suggestions to start chasing this down would be appreciated!
Below is the contents of /etc/asterisk/cdr_mysql.conf.
[root@localhost asterisk]# cat cdr_mysql.conf
; Note - if the database server is hosted on the same machine as the
; asterisk server, you can achieve a local Unix socket connection by
; setting hostname = localhost
; port and sock are both optional parameters. If hostname is specified
; and is not "localhost", then cdr_mysql will attempt to connect to the
; port specified or use the default port. If hostname is not specified
; or if hostname is "localhost", then cdr_mysql will attempt to connect
; to the socket file specified by sock or otherwise use the default socket
hostname = localhost
password = fpbx
user = freepbx