No CDR data going to SQL database (Asterisk 1.4.19 + FreePBX 2.4.0.0)

FreePBX Installation / Upgrade
1

Compiled asterisk-1.4.19, asterisk-addons-1.4-current and freepbx-2.4.0.tar.gz from source, followed all centos 5.1 install directions, but no data is appearing in “Reports” nor in the asteriskcdrdb MySQL db. It seems like the Asterisk addon modules have deviated from the instructions I’ve read? Not sure. This is my first install from source, so I must be missing something. Any ideas?

Thanks,

Bobby

2

This was the fix (on CentOS 5.1):

Then recompile asterisk-addons-1.4-current and restart asterisk. Before doing this, configuring asterisk-addons looked like this:

# ./configure | grep sql
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient... no

But afterward:

# ./configure | grep sql
checking for mysql_config... /usr/bin/mysql_config
[b]checking for mysql_init in -lmysqlclient... yes[/b]

Finally, ‘mysql’ shows up in asterisk CLI:

maryland*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: yes
CDR registered backend: cdr-custom
CDR registered backend: csv
CDR registered backend: cdr_manager
[b]CDR registered backend: mysql[/b]
3

I am using asteriskNow 2.4 based on Asterisk 1.4 I am getting no CDR and my recorded calls do not show up in the ARI Call Monitor, from everything I have seen I think these are related. I tried

yum install mysql-devel.x86_64

but it said

No package mysql-devel.x86_64 available.

How can I install the Asterisk-addons?

4

First of all, do not Hijack an old thread, create a new one instead.
The reason you did not find mysql-devel.x86_64 is that the author of the first post used a x64 based install and you probably don’t. Try yum install mysql-devel

5

Well I upgraded asterisk to 1.4.27 this made it so i had the source files then I added the add-ons and it fixed the Call Monitor and CDR issue. However it did break MOH and i will start a new thread for that

6