TIPS NO CDR after fresh install latest PIAF

turalo · Jul 11, 2014

Hi guys,

I have installed the latest version of PIAF ( cent os version)

all went well, I have imported my trunks / routes / etc.. via database,

all works fine but, the CDR.

I dont have any cdr in CDR section. i have made calls, and all goes ok, but CDR are not generated.

Please help.

much much thanks in advance.

turalo · Jul 13, 2014

Hi guys,

so I just made a completely new fresh install of of the latest piaf green.

and didnot change anything, only added an extension, trunk / outbound route.

and tried to make a kall, call goes, but no CDR.

so is there a BUG ?

wardmundy · Jul 15, 2014

What response do you get with this:

Code:

asterisk -rx "module show like mysql"

turalo · Jul 15, 2014

wardmundy said:
What response do you get with this:

Code:

asterisk -rx "module show like mysql"

First of all, I'm honored ! WARD hemself ...

thanks.

this is the output :

root@pbx:~ $ asterisk -rx "module show like mysql"
Module Description Use Count
0 modules loaded

and this is if I try it manually :

Connected to Asterisk 11.10.2 currently running on pbx (pid = 1720)
pbx*CLI> module load app_addon_sql_mysql.so
Unable to load module app_addon_sql_mysql.so
Command 'module load app_addon_sql_mysql.so' failed.
[2014-07-15 15:53:28] WARNING[26531]: loader.c:439 load_dynamic_module: Error loading module 'app_addon_sql_mysql.so': /usr/lib/asterisk/modules/app_addon_sql_mysql.so: cannot open shared object file: No such file or directory
[2014-07-15 15:53:28] WARNING[26531]: loader.c:918 load_resource: Module 'app_addon_sql_mysql.so' could not be loaded.
pbx*CLI> module load res_config_mysql.so
Unable to load module res_config_mysql.so
Command 'module load res_config_mysql.so' failed.
[2014-07-15 15:53:51] WARNING[26531]: loader.c:439 load_dynamic_module: Error loading module 'res_config_mysql.so': /usr/lib/asterisk/modules/res_config_mysql.so: cannot open shared object file: No such file or directory
[2014-07-15 15:53:51] WARNING[26531]: loader.c:918 load_resource: Module 'res_config_mysql.so' could not be loaded.
pbx*CLI> module load cdr_addon_mysql.so
Unable to load module cdr_addon_mysql.so
Command 'module load cdr_addon_mysql.so' failed.
[2014-07-15 15:54:06] WARNING[26531]: loader.c:439 load_dynamic_module: Error loading module 'cdr_addon_mysql.so': /usr/lib/asterisk/modules/cdr_addon_mysql.so: cannot open shared object file: No such file or directory
[2014-07-15 15:54:06] WARNING[26531]: loader.c:918 load_resource: Module 'cdr_addon_mysql.so' could not be loaded.
pbx*CLI>

turalo · Jul 15, 2014

Also, with the 2 installs that I had tried (that had this problem ), I got the menu config question and I said no, I did press N for no, and it said I'm glad you choose no to menu config. but still it showed it, and I pressed save an quit.

wardmundy · Jul 15, 2014

The menuconfig setup for the latest release of Asterisk appears to be missing. We'll have a fix shortly.

james · Jul 15, 2014

wardmundy darmock

Code:

./addons/cdr_mysql.c-    <defaultenabled>no</defaultenabled>
./addons/cdr_mysql.c:    <support_level>deprecated</support_level>
./addons/cdr_mysql.c-    <replacement>cdr_adaptive_odbc</replacement>

Asterisk has depricated cdr_mysql and will soon (relative term) remove it. It has been replaced with cdr_adaptive_odbc

Code:

yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel  mysql-connector-odbc

Code:

apt-get install unixODBC unixODBC-devlibmyodbc

wardmundy · Jul 15, 2014

Please post your status results. I just installed PIAF-Green with Asterisk 11.10.2 and MySQL components are all functioning properly??

turalo · Jul 17, 2014

root@pbx:~ $ yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel mysql-connector-odbc
Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
* base: ftp.nluug.nl
* extras: mirror.nl.leaseweb.net
* updates: nl.mirror.eurid.eu
Setting up Install Process
Package unixODBC-2.2.14-12.el6_3.x86_64 already installed and latest version
Package unixODBC-devel-2.2.14-12.el6_3.x86_64 already installed and latest version
Package libtool-ltdl-2.2.6-15.5.el6.x86_64 already installed and latest version
Package libtool-ltdl-devel-2.2.6-15.5.el6.x86_64 already installed and latest version
Package mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 already installed and latest version
Nothing to do
root@pbx:~ $

turalo · Jul 17, 2014

james said:
wardmundy darmock

Code:

./addons/cdr_mysql.c- <defaultenabled>no</defaultenabled> ./addons/cdr_mysql.c: <support_level>deprecated</support_level> ./addons/cdr_mysql.c- <replacement>cdr_adaptive_odbc</replacement>

Asterisk has depricated cdr_mysql and will soon (relative term) remove it. It has been replaced with cdr_adaptive_odbc

Code:

yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel mysql-connector-odbc

Code:

apt-get install unixODBC unixODBC-devlibmyodbc

I have it also in my file :

/*** MODULEINFO
<depend>mysqlclient</depend>
<defaultenabled>no</defaultenabled>
<support_level>deprecated</support_level>
<replacement>cdr_adaptive_odbc</replacement>
***/

james · Jul 18, 2014

Nothing to do
This means all the dependencies are good, unless the build wants some devel packages too...

turalo · Jul 21, 2014

thus ? will this be solved ?

burhanhd · Aug 13, 2014

Dear Mr. wardmundy
I am also facing the similar issue.
Asterisk = ONLINE | Dahdi = ONLINE | MySQL = ONLINE │
│ SSH = ONLINE | Apache = ONLINE | Iptables = ONLINE │
│ Fail2ban = ONLINE | Internet = ONLINE | Ip6Tables = ONLINE │
│ Disk Free = ADEQUATE| Mem Free = ADEQUATE| NTPD = ONLINE │
│ SendMail = ONLINE | Samba = OFFLINE | Webmin = ONLINE │
│ Ethernet0 = ONLINE | Ethernet1 = ONLINE | Wlan0 = N/A │
│ │
│ PIAF Installed Version = 2.0.6.5 under *HARDWARE* │
│ FreePBX Version = 2.11.0.38 │
│ Running Asterisk Version = 11.10.0 │
│ Asterisk Source Version = 11.10.0 MODIFIED │
│ Dahdi Source Version = 2.9.0 │
│ Libpri Source Version = 1.4.14 │
│ IP Address = 192.168.6.250 on eth0 │
│ Operating System = CentOS release 6.5 (Final) │
│ Kernel Version = 2.6.32-431.1.2.0.1.el6.i686 - 32 Bit │
the CDR does not work.
Please let me know if you resolved it.

turalo · Aug 13, 2014

I think there was some problem with online resources at the time of installation, and that's why the script was not completed 100% thats why the config menu also appears while it must not appear.

wardmundy · Aug 13, 2014

How about starting with a fresh install and let us know how it goes.

turalo · Aug 20, 2014

I'm plannig to make a full new install one of this days. I'm not sure yet which to choose the new one with ubuntu or stay with the older post?
it's for production.

gg3@2sight.net · Aug 22, 2014

I am having this same problem. It seems as if the calls are not entered into the cdr database. If I manually install data into cdr using phpMyAdmin, the data is presented in the GUI reports. When I do asterisk -rx "module show like mysql" I also get 0 modules loaded. This box was installed using this link: http://nerdvittles.com/?p=9071 that installs PIAF 3.6.5 on Centos 6.5. Following turalo with james' suggestion shows all the ODBC stuff is already loaded here as well. I think an update is needed here.

A previous install on another box using pbxinaflash20644-x86_64.iso works fine. This was done at least 6 months ago. Yesterday I tried to install PIAF-Green-32.ova on a VMware ESXi 5.5 and it had many repository issues. This ova is based on Centos 6.4. When I browsed to the repository for 6.4 it was empty. The install of course did not work.

It looks to me like multiple issues exist. First changes in Asterisk regarding mysql have broken CDR in the latest build and second older versions based on Centos 6.4 may have repository issues.

gg3@2sight.net · Aug 22, 2014

The only thing in the respository http://mirror.centos.org/centos/6.4 is this readme:

This directory (and version of CentOS) is depreciated. For normal users,
you should use /6/ and not /6.4/ in your path. Please see this FAQ
concerning the CentOS release scheme:

http://www.centos.org/modules/smartfaq/faq.php?faqid=34

If you know what you are doing, and absolutely want to remain at the 6.4
level, go to http://vault.centos.org/ for packages.

Please keep in mind that 6.0, 6.1, 6.2, 6.3 and 6.4 no longer gets any updates, nor
any security fix's.

gg3@2sight.net · Aug 22, 2014

So this is what I did.

I went back to my machine with Centos 6.4 and PIAF 2.0.6.4/FreePBX 2.11.0.38 that I installed over 6 months ago where CDR is working fine.
I executed:
asterisk -rx "module show like mysql"

and got these three .so files listed:

app_mysql.so
cdr_mysql.so
res_config_mysql.so

I used winscp to connect to this machine and copied these three files from usr/lib/asterisk/modules to my Windows PC.
I then used winscp to connect to the new box running Centos 6.5 with PIAF 3.6.6 and put those files in the same /usr/lib/asterisk/modules path on the new machine.
I then executed on the new machine:
asterisk -rx "module load app_mysql.so"
asterisk -rx "module load cdr_mysql.so"
asterisk -rx "module load res_config_mysql.so"

All modules loaded although the last complained about no db defined using default.
I tested CDR by calling the main line and leaving a message and lo an behold CDR is working.

May not be the most accepted solution but it is working. Now to see if it survives a reboot.

gg3@2sight.net · Aug 22, 2014

Survived a reboot.

TIPS NO CDR after fresh install latest PIAF

Member

Member

Nerd Uno

Member

Member

Nerd Uno

Guru

Nerd Uno

Member

Member

Guru

Member

New Member

Member

Nerd Uno

Member

Member

Member

Member

Member

Forum statistics