After upgrade to 2.8 beta, CDR stopped functioning

Beta Program Issues
1

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?

2

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
3

Mine stopped on June 20…

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

4

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.

5

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.

6

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.

7

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?

8

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

9

and it IS up to date.

What would prevent it from getting to the database?

10

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.

11

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

12

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.