Nothing in CDR db since 7/21 (SOLVED)

General Help
1

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

2

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 :slight_smile:

3

Is there any form of extra grant permissions that need to be done to give free pbx access to the cdr database?

4

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.

5

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.

6

Nope no new calls are showing up in database or website.

Any more ideas would be appreciated.

Thanks in advance,
Joe

7

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’

8

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/

9

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

10

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.

11

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

12

I asked you to run ‘cdr mysql status’ not ‘cdr show status’

13

Anyone have any solutions?

Please I don’t want to have to rebuild this system again …

Thanks in advance,
Joe

14

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…