EDIT: Forgot to inform you guys that I am running the latest version of asterisk and FreePBX Distro. I used the easy installer from freepbx.org and burned it do a cd then installed it on a new computer. Everything else works great, this seems to be the only real problem.
Hello everyone,
I have run into a bit of a annoying problem with my first install of FreePBX. When I try to use CDR reports , it shows no calls have been made. I did some basic troubleshooting.
1.“md*CLI> module show like mysql” shows that there are 0 modules running so
3.I ran "md*CLI> module show like mysql "again and it STILL shows there are 0 modules running.
3.This may mean something though, under End Point Configuration Manager, I used to have big red letters saying that it is unable to save the confirguration file or something but after doing step two , the warning was gone. At least I mistakenly solved something lol.
the latest distro of freepbx doesnt require you to install any additional modules. However there is a bug reported for this.
CDR reports in the distro version (2.10) are not working because the default (autogenerated) password to connect to the mysql server is different in the /etc/asterisk/cdr_mysql.conf file. It should be the same as the one in /etc/freepbx.conf.
SSH into the machine, and copy the password in /etc/freepbx.conf and paste it in the /etc/asterisk/cdr_mysql.conf file. CDR reports should start functioning.
I had the same problem - got help from #freepbx on IRC to sort it out.
Connected to Asterisk 1.8.14.0 currently running on phone (pid = 1556)
Verbosity is at least 3
phoneCLI> module load cdr_mysql.so
Unable to load module cdr_mysql.so
Command ‘module load cdr_mysql.so’ failed.
[2013-04-11 17:57:30] WARNING[27309]: loader.c:398 load_dynamic_module: Error loading module ‘cdr_mysql.so’: libmysqlclient.so.16: cannot open shared object file: No such file or directory
[2013-04-11 17:57:30] WARNING[27309]: loader.c:850 load_resource: Module ‘cdr_mysql.so’ could not be loaded.
phoneCLI>
It came to me from a different department. As a measure of last resort I can go that route but there are other people who depend upon this server and would frown upon me attempting to rebuild it myself. I do believe that they installed it from scratch however. It was just not me personally.
I wonder if someone updated MySQL after Asterisk was installed and it broke a dependency? Is it possible to re-compile the modules - rather, is it safe?
Yes it is possible. Is it safe?, well I would defer that decision to the folks who built your system for you.
It seems quite likely that your asterisk modules , however compiled, do not match your 64 bit kernel and your mysql deployment, chances are they need to rebuild asterisk to match whatever the rest of the system is.
It is usually a good idea to have control over your WHOLE system, good luck
I’m assuming this is a 64bit OS since you have /usr/lib64/mysql/libmysqlclient.so
Your mysql module is in /usr/lib/asterisk/modules. Technically you are supposed to have asterisk stuff in /usr/lib64/asterisk/modules for 64bit. With Asterisk 11 you now have to do it this way or Asterisk won’t work properly. I’ve always been able to get away with it on Asterisk 1.8 but maybe try put the module in the lib64 directory or create a symlink and see what happens.
Not sure how you are installing this but if you are compling from scratch you should start to compile asterisk like this for 64bit OS.
./configure --libdir=/usr/lib64 && make menuselect. You also have to change to that directory once you do this in /etc/asterisk/asterisk.conf and there is one setting in Advanced settings when you enable hidden that you have to change to that directory as well.
I’ve never seen a mysql update break any of these things so I wouldn’t spend any time looking at that if I were you.