CDR Reports not working

General Help
1

Hi,

I just installed FreePBX following step-by-step the guide (http://wiki.freepbx.org/display/HTGS/Installing+FreePBX+on+Debian+Wheezy). Everything works fine so far except for the CDR Reports.

The CDR Reports in FreePBX are simply not getting displayed pressing the “Search” button does not bring anything. Although I have checked my MySQL database and the cdr and cel tables have some data.

Am I missing something? Or is this is known problem?

Any help would be greatly appreciated.

Regards,
John

2

Hi,

Have you loaded MySQL in Asterisk ? In debian it’s a new package.

3

Does FreePBX have permission to access the cdr DB?

4

Hi,

Actually I have compiled Asterisk manually on Debian wheezy as described in the following guide http://wiki.freepbx.org/display/HTGS/Installing+FreePBX+on+Debian+Wheezy so I do not have the asterisk-mysql debian package installed.

5

Yes it does, I have verified with “odbc show” on the asterisk cli and I get the following output:

hostname*CLI> odbc show

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 1970-01-01 01:00:00
Pooled: No
Connected: Yes

note here the “Connected: Yes”

6

The ODBC doesn’t have anything to do with the CDR’s or FreePBX. I did not ask if Asterisk could access to DB. It can, because you said that when you do a ‘select * from cdr’ you get records back.

The correct command is asterisk os ‘cdr mysql status’

FreePBX has to have permission to access the DB. You will find the settings in the advanced settings module.

7

Thanks for you answer. You are totally right the CDR MySQL module is not installed/enabled in my Asterisk.

I thought this module (cdr_mysql) was deprecated so I did not installed it. Furthermore the definitive Asterisk guide book (4th Ed.) explains in chapter 16 how to install the ODBC drivers for CDR (http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html) and does not mention at all anything about the MySQL CDR. That’s why I went for ODBC.

Anyway, I will have a try at the CDR MySQL module although it is deprecated.

8

There seems to be a difference in what is deprecated - Digium sees MySQL as deprecated, while “FreePBX” doesn’t (taking from installing the two “ISOs” - and from a very tired memory)

Perhaps https://issues.asterisk.org/jira/browse/ANOW-175 can help you in your quest ?

9

Great, Malcolm’s answer on that issue fixed my problem and now CDR works.

Indeed It looks like there is a clash here between FreePBX and Asterisk in the matter on how database connections are handled as you mention.

Thanks for helping!

10

I had the same issue, no CDR Report, but everything else working. When I did ‘cdr mysql status’ I also got ‘Not currently connected to a MySQLserver’

In my case, the passwords in ‘/etc/asterisk/cdr_mysql.conf’ did not match the one on ‘/etc/freepbx.conf’.

Once I corrected the password and restarted Freepbx (amportal restart), everything worked. ‘cdr mysql status’ now returns ‘Connected to asteriskcdrdb on socket file default using table cdr for 10 minutes, 49 seconds.
Wrote 1 records since last restart.’

I just figured I posted it here in the event someone else had the same issue.

11

After upgrade to 5.211.65-12 I got Asterisk 11.9, and CDR no reports anymore, but everything else working.
/etc/asterisk/cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = removedbyadmin
user = freepbxuser
userfield=1
;port=3306
;sock=/tmp/mysql.sock

/etc/freepbx.conf

<?php $amp_conf['AMPDBUSER'] = 'freepbxuser'; $amp_conf['AMPDBPASS'] = 'removedbyadmin'; $amp_conf['AMPDBHOST'] = 'localhost'; $amp_conf['AMPDBNAME'] = 'asterisk'; $amp_conf['AMPDBENGINE'] = 'mysql'; $amp_conf['datasource'] = ''; //for sqlite3 require_once('/var/www/html/admin/bootstrap.php'); Please your help!
12

In the Asterisk cli, what’s the output of

cdr show status