CDR reports not working

FreePBX Installation / Upgrade
1

I did a fresh install of freepbx 2.4.1 and asterisk 1.4.21.2 but the cdr reports are not working can anyone help with this?

2

select * from cdr ; show nothing

so I don’t know if the calls are being logged.

how would i got about fixing this problem?

3

Have you installed the matching asterisk addons package which contains the items needed for the CDR to work?

4

do I need to compile them after I install freepbx

I have asterisk addons 1.4.7 I compiled them along with asterisk

5

no installing it before hand should be good enough.

what does your /etc/asterisk/cdr_mysql.conf look like?

6

;
; 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
; file.
;
;[global]
;hostname=database.host.name
;dbname=asteriskcdrdb
;table=cdr
;password=password
;user=asteriskcdruser
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

pbxmike*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: no
CDR registered backend: cdr-custom
CDR registered backend: cdr_manager
CDR registered backend: csv

7

it should look like this:


; 
; 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 
; file. 
; 
[global] 
hostname = localhost
dbname=asteriskcdrdb 
password = amp109
user = asteriskuser
userfield=1
;port=3306 
;sock=/tmp/mysql.sock
8

the problem was that I didn’t have the mysqlclientlib15-dev package on my system

after installing that recompiling asterisk addons
the fixing my cdr_mysql.conf

I was able to resolve the issue

thank you for all your help

9

Hi…

I have the same problem, but that didn’t resolve nothing…

Any Idea??

What about cdr_custom.conf ¿? or cdr.conf or cdr_manager.conf ¿?

I don’t understand…

There is any secret for this??
…

10

Debian Echt, Asterisk 1.4.22.1 FreePBX 2.5.1.1
Installation neu: libmysqlclient15-dev
AdOns neu installieren

…und es läuft OK

11

I have upgraded my system (trixbox CE current release is 2.6.1.13) and it is working perfect! I can see the CDR records with PHPadmin, but I want to use CDR report from the browser interface.

Is there anybody who recognize this (instead of the selecting page) after selecting CDR report via the PBX-menu and who knows the solutions for this problem?

I am not sure if this the same error as mentioned above by the other asterisk-lovers.

Index of /maint/modules/cdrreport/cdrreport
Name Last modified Size Description

Parent Directory -
var/ 07-Jul-2008 22:14 -

12

Please don’t hijack another thread. Specially when it involves trixbox as they have forked FreePBX for there own purposes.

Start a new thread please.

When you do please provide veriosn info for asterisk and FreePBX so that we can tell if you are using a forked version of FreePBX or the real thing. Thanks.