After upgrade to 2.8 beta, CDR stopped functioning

Basildane's picture
Posted June 23rd, 2010 by Basildane (tadpole)

I tried manually running retrieve_conf, and get the following errors:

Checking for PEAR DB..OK
Checking for PEAR Console::Getopt..OK
Checking for /etc/amportal.conf ..OK
Bootstrapping /etc/amportal.conf ..OK
Parsing /etc/amportal.conf ..OK
Parsing /etc/asterisk/asterisk.conf ..OK
Connecting to database..OK
Connecting to Asterisk manager interface..OK
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = admin
Added to globals: AMPMGRPASS = amp111
Added to globals: AMPDBENGINE = mysql
Added to globals: AMPDBHOST = localhost
Added to globals: AMPDBNAME = asterisk
Added to globals: AMPDBUSER = asteriskuser
Added to globals: AMPDBPASS = amp109
Notice: no iax trunks defined
Notice: no AMP Users defined
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Table does not exist: custom
Please update your modules and reload Asterisk by browsing to your server.

What should I do next?


__________________


‹ Confirm button problem Loop when the call is not answered by the extension ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Additional info: httpd/error_log has hundreds of errors

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:

A short example:

[Wed Jun 23 07:50:16 2010] [error] [client 128.231.41.132] PHP Notice:  Undefined variable: letter in /var/www/html/admin/cdr/call-log.php on line 741, referer: http://basildane.dnsalias.net:8081/admin/repor
ts.php
[Wed Jun 23 07:50:16 2010] [error] [client 128.231.41.132] PHP Notice:  Undefined variable: Period in /var/www/html/admin/cdr/call-log.php on line 742, referer: http://basildane.dnsalias.net:8081/admin/repor
ts.php
[Wed Jun 23 07:50:16 2010] [error] [client 128.231.41.132] PHP Notice:  Undefined variable: frommonth in /var/www/html/admin/cdr/call-log.php on line 742, referer: http://basildane.dnsalias.net:8081/admin/re
ports.php

Hi, I've the same problem

tomarch's picture
On June 23rd, 2010 tomarch (tadpole) said:

Hi,

I've the same problem here.

I was already on 2.8beta, but since the 21 june and the upgrade to beta2.4, cdr no longer work (nothing is log into mysql, but i have some log in /var/log/asterisk/cdr-csv/Master.csv).

asterisk 1.6.2.8
centos 5.5

Thanks.


Yes

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:

Mine stopped on June 20...

I tried doing an ./install_amp --force-ver 2.7.0
But didn't help.


I don't think it is a FreePBX issue

p_lindheimer's picture
On June 23rd, 2010 p_lindheimer (Developer) said:

you may want to look harder at what else you may have updated at the time.

This does not look like a FreePBX issue.

There is almost nothing that has changed on the reporting application (if anything at all).

The last thing that was touched was on 5/25 (#4256 : r9750).

One thing you should check, is the MySQL CDR database being populated still? If not, then it is almost certainly nothing to do with FreePBX. If so, then there is a slight chance that the change to normalize the parsing algorithm for amportal.conf might be related though that looks like it was introduced in the 2.8.0beta2.1 of framework, so if you were running something past that successfully, there were no other changes in that part of the code.


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


But what about

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:

But what about the errors about the missing fields and stuff I mentioned in an earlier post?

When I upgraded from 2.7 to 2.8 beta, the upgrade hung at "pinsets".
I had to restart it.

I suspect it did not properly migrate some of the tables because of this.


The Table does not exist

p_lindheimer's picture
On June 23rd, 2010 p_lindheimer (Developer) said:

The Table does not exist comes from the FOP script that generates the FOP config, it has nothing to do with anything.

The Undefined Variables warnings are common in the reporting application. Although they are not "correct" they are harmless.

The reporting application is primarily on minimum "maintenance" mode as it has not had an 'owner' in a long time. (But that also means it is rarely touched, thus minimal bugs can be introduced).

Going back to a previous question though, is the cdr table being populated with new calls or not?


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


Quote: Going back to a

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:
Quote:
Going back to a previous question though, is the cdr table being populated with new calls or not?

It is not populated with new entries after 6/20.


I just checked Master.csv

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:

and it IS up to date.

What would prevent it from getting to the database?


lack of cdr_addon_msyql.so,

p_lindheimer's picture
On June 23rd, 2010 p_lindheimer (Developer) said:

lack of cdr_addon_msyql.so, res_config_mysql.so and/or app_addon_sql_mysql.so being loaded.

incorrect credentials in your cdr_mysql.conf config file

those are at least a couple things that could cause this.


__________________

Philippe Lindheimer - FreePBX Project Leader
FreePBX Training Opportunities - Click Here
Get Official Paid Support - Click Here


Fixed!

Basildane's picture
On June 23rd, 2010 Basildane (tadpole) said:

Thanks for your suggestions!
I found I was missing cdr_addon_mysql.so.


fixed too

tomarch's picture
On June 24th, 2010 tomarch (tadpole) said:

I have reinstall asterisk16-addons-mysql, reboot the server and now it's work.
I might have done some mistake with my fax configuration.

thanks for your help.