[solved] CDR records not showing up after upgrade

Hi Everyone,

I am on AsteriskNOW 1.7 with Asterisk 1.6.2.14. I ran yum update last Thursday (Nov 11) and that is when it quit giving me CDR records. I rebooted the system after the upgrade.

Stuff I have tried:

  • yum reinstall asterisk16-addons asterisk-addons-mysql then amportal restart

  • module load cdr_addon_mysql.so (fails but doesn’t say why)
    *CLI> module load cdr_addon_mysql
    Unable to load module cdr_addon_mysql
    Command ‘module load cdr_addon_mysql’ failed.
    *CLI> module load cdr_addon_mysql.so
    Unable to load module cdr_addon_mysql.so
    Command ‘module load cdr_addon_mysql.so’ failed.

  • logging into mysql from command line with the same credentials, works ok

  • restarting mysqld

  • verifying that cdr_addon_mysql.so is in /var/lib/asterisk/modules/ (it is)

  • verifying that modules.conf says load => cdr_addon_mysql.so (it does)

  • holy water

  • ignoring it and hoping it will go away

This worked fine until the upgrade. My test call after the upgrade is the last record in there.

Thanks!

EDIT: Solved by downloading, compiling latest source for addons from asterisk.org.

It seems like this is a distro issue, not a FreePBX issue. Sorry for the post.

[Nov 17 20:04:08] WARNING[7268] loader.c: Module 'cdr_addon_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.
[Nov 17 20:04:08] WARNING[7268] loader.c: Module 'cdr_addon_mysql.so' will not be initialized as it may cause instability.
[Nov 17 20:04:08] WARNING[7268] loader.c: Module 'cdr_addon_mysql.so' could not be loaded.

This started two days ago. No changes were made then that should have caused this. Did a ‘yum reinstall asterisk16 asterisk16-addons-mysql’ and that made cdr show status finally start to give me something besides unknown command. Still gives the same error as above though.