CDR Reports empty

General Help
1

Little confused as to what is happening in CDR Reports nothing is returned and this used to work.
Asterisk 11.16.0
FreePBX 12.0.51
from cli:
module show like mysql
Module Description Use Count
app_mysql.so Simple Mysql Interface 0
res_config_mysql.so MySQL RealTime Configuration Driver 0
CLI> module show like cdr
Module Description Use Count
app_cdr.so Tell Asterisk to not maintain a CDR for 0
app_forkcdr.so Fork The CDR into 2 separate entities 0
cdr_csv.so Comma Separated Values CDR Backend 0
cdr_custom.so Customizable Comma Separated Values CDR 0
cdr_manager.so Asterisk Manager Interface CDR Backend 0
cdr_syslog.so Customizable syslog CDR Backend 0
func_cdr.so Call Detail Record (CDR) dialplan functi 0
7 modules loaded
if you try to load module:
CLI> module load cdr_custom.so
Unable to load module cdr_custom.so
Command ‘module load cdr_custom.so’ failed.
[2015-04-08 16:26:31] WARNING[19969]: loader.c:908 load_resource: Module ‘cdr_custom.so’ already exists.
CLI> module load cdr_manager.so
Unable to load module cdr_manager.so
Command ‘module load cdr_manager.so’ failed.
[2015-04-08 16:26:48] WARNING[19969]: cdr_manager.c:79 load_config: Failed to load configuration file. Module not activated.

Looking at conf files:
cdr.conf: blank
cdr_mysql:
[global]
hostname = localhost
dbname=asteriskcdrdb
password = fpbx
user = freepbx
userfield=1
;port=3306
;sock=/tmp/mysql.sock

cdr_odbc:
[global]
dsn=asteriskcdrdb
loguniqueid=yes
dispositionstring=yes
table=cdr ;“cdr” is default table name

looking at table cdr:
ysql> select clid from cdr;
±--------------------------------+
| clid |
±--------------------------------+
| “TestLabPhone2” <703> |
| “TestLabPhone” <704> |
| “TestLabPhone2” <703> |
| “TestLabPhone” <704> |
| “elric” <705> |
| “elric” <705> |
| “TestLabPhone” <704> |
| “TestLabPhone” <704> |
| “TestLabPhone” <704> |
| “TestLabPhone” <704> |
| “TestLabPhone” <704> |
| “TestLabPhone” <704> |

mysql> select calldate from cdr;
… last row…
| 2014-10-08 10:12:30 |
±--------------------+
1069 rows in set (0.00 sec)

And all the columns:
±--------------±-------------±-----±----±--------------------±------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------------------±------+
| calldate | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| clid | varchar(80) | NO | | | |
| src | varchar(80) | NO | | | |
| dst | varchar(80) | NO | MUL | | |
| dcontext | varchar(80) | NO | | | |
| channel | varchar(80) | NO | | | |
| dstchannel | varchar(80) | NO | | | |
| lastapp | varchar(80) | NO | | | |
| lastdata | varchar(80) | NO | | | |
| duration | int(11) | NO | | 0 | |
| billsec | int(11) | NO | | 0 | |
| disposition | varchar(45) | NO | | | |
| amaflags | int(11) | NO | | 0 | |
| accountcode | varchar(20) | NO | MUL | | |
| uniqueid | varchar(32) | NO | MUL | | |
| userfield | varchar(255) | NO | | | |
| did | varchar(50) | NO | | | |
| recordingfile | varchar(255) | NO | | | |
| cnum | varchar(40) | NO | | | |
| cnam | varchar(40) | NO | | | |
| outbound_cnum | varchar(40) | NO | | | |
| outbound_cnam | varchar(40) | NO | | | |
| dst_cnam | varchar(40) | NO | | | |
±--------------±-------------±-----±----±--------------------±------+
23 rows in set (0.01 sec)

this is all old data and nothing new is being logged. Any ideas what i am missing?

2

How did you last build/install Asterisk/FreePBX?

3

Via AsteriskNow which then i rolled over to freepbx distro using
http://wiki.freepbx.org/display/FD/Converting+AsteriskNOW+3.0.X+Distro+to+a+AsteriskNOW-FreePBX+Distro+5.211.65
I just did a yum upgrade to see if anything available:
Updating:
asterisk11 x86_64 11.16.0-1.shmz65.1.60 pbx 4.5 k
asterisk11-addons x86_64 11.16.0-1.shmz65.1.60 pbx 3.6 k
asterisk11-addons-bluetooth x86_64 11.16.0-1.shmz65.1.60 pbx 33 k
asterisk11-addons-core x86_64 11.16.0-1.shmz65.1.60 pbx 27 k
asterisk11-addons-mysql x86_64 11.16.0-1.shmz65.1.60 pbx 37 k
asterisk11-addons-ooh323 x86_64 11.16.0-1.shmz65.1.60 pbx 324 k
asterisk11-core x86_64 11.16.0-1.shmz65.1.60 pbx 2.6 M
asterisk11-curl x86_64 11.16.0-1.shmz65.1.60 pbx 18 k
asterisk11-dahdi x86_64 11.16.0-1.shmz65.1.60 pbx 274 k
asterisk11-doc x86_64 11.16.0-1.shmz65.1.60 pbx 14 k
asterisk11-flite x86_64 11.16.0-1.shmz65.1.26 pbx 7.1 k
asterisk11-flite-debuginfo x86_64 11.16.0-1.shmz65.1.26 pbx 12 k
asterisk11-voicemail x86_64 11.16.0-1.shmz65.1.60 pbx 79 k
iSymphonyServerV3-fpbx noarch 3.1.1.137-1 pbx 57 M
openssl x86_64 1.0.1e-30.el6_6.7 updates 1.5 M

Not sure if i should run or no.

4

Mind you that was a while ago that i ran that conversion and CDR was working even afterwards as evidenced by the calldate record in CDR table:

| 2014-10-08 10:12:30 |
±--------------------+
1069 rows in set (0.00 sec)

5

Well the old cdr_mysql.so is deprecated but still works, apparently your system doesn’t build it anymore nor was it properly updated to it’s replacement, cdr_adaptive_odbc, if you can’t

module load cdr_mysql.so

nor

module load cdr_adaptive_odbc

then it will need configuring.

6

thank you Dicko now is there any documentation as to the steps i would need to take to update the CDR ? I will search around as well. Thanks again for the input.

7

Thought i would share what i got to work: YMMV.

yum install asterisk11-odbc.x86-64…

Checked this posting:

Modified the /etc/odbc.ini to reflect
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asterisk’ database
driver=MySQL
server=localhost
database=asteriskcdrdb
username=freepbx
password=fpbx
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3

From CLI:
module reload res_odbc.so
module reload cdr_adaptive_odbc.so
cdr show status

Call Detail Record (CDR) settings

Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

  • Registered Backends

    ODBC
    Adaptive ODBC
    cdr-custom

Checked for new entries in mysql:
select calldate from cdr;
| 2015-04-09 09:35:50 |
±--------------------+
1161 rows in set (0.00 sec)

VIOLA! We back in CDR Buidness…