Ok just went through hell re-building this system, updated php 5.1 to 5.3 and killed free pbx admin panel. currently running Asterisk Now 1.7 with free pbx updated to 2.8.1.4
successfully able to access the database with the same credentials as in my cdr_mysql.conf file.
Verified calls are being recorded within /var/spool/asterisk/monitor, but can not access them through the cdr database nor the website.
all files are chown asterisk:asterisk
accepting all ideas for further troubleshooting…
how can I get this feature back?
Please help.
Any help will be greatly appreciated.
Thanks in advance,
Joe
Kool nope just started working again… Well it sucks that I lost a month of recorded calls but at least it is working again now 
Is there any form of extra grant permissions that need to be done to give free pbx access to the cdr database?
If you look at the install guide for FreePBX it explains how to set permissions form the asteriskcdrdb. I don’t know the commands off the top of my head.
This database is seperate from the main FreePBX database called Asterisk.
I think this is correct… http://www.powerpbx.org/content/set-mysql-centos-v5x-asterisk-v16x-freepbx-v24x
I have done this will keep posted if problem still exist.
Nope no new calls are showing up in database or website.
Any more ideas would be appreciated.
Thanks in advance,
Joe
Can you tell us what you did to fix it?
What is the contents of your /etc/asterisk/cdr_mysql.conf?
What about the Asterisk command ‘cdr mysql status’
I didn’t get this to work still a problem, but have noticed that we can see voice mails from today’s date just not anything monitored…
/etc/asterisk/cdr_mysql.conf:
[global]
hostname = localhost
dbname=asteriskcdrdb
password = dbpassword
user = admin
userfield=1
port=3306
;sock=/tmp/mysql.sock
cdr show status:
Call Detail Record (CDR) settings
Logging: Enabled
Mode: Simple
Log unanswered calls: No
-
Registered Backends
(none)
cd /var/www/
oh what I have done to try and fix this was mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY ‘amp109’;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY ‘amp109’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
but now have found that it is not the problem since we can see voice mails
Also noticed even though I had chowned the /var/spool/asterisk/monitor directory to asterisk:asterisk today and since then the new files created are root:root ?
Could this be the problem?
I doubt it because the files that were changed Friday are still at asterisk:asterisk and are still not being displayed in the database or website.
OK here are the permissions of the files within the monitor directory
-rw-rw-r-- 1 asterisk asterisk
and on the directory itself:
drwxrwxr-x 2 asterisk asterisk 3846144 Aug 22 12:07 monitor
I asked you to run ‘cdr mysql status’ not ‘cdr show status’
Anyone have any solutions?
Please I don’t want to have to rebuild this system again …
Thanks in advance,
Joe
OK also
ok tried:
yum install asterisk16-addons
now when i use the asterisk cli ‘cdr show status’:
Call Detail Record (CDR) settings
Logging: Enabled
Mode: Simple
Log unanswered calls: No
-
Registered Backends
mysql
Still no luck though…