Reporting Graph Errors after CentOS Upgrade

Hi,

I upgraded two PIAF servers over the weekend (live and a standby that uses the fantastic FreePBX remote backup). Both running FreePBX 2.8.07 on CentOS 5.5 x64 with Asterisk 1.6.2.9.

The upgrade appeared to go fine (upgraded to CentOS 5.6 and Asterisk 1.6.2.19) except I now have Reporting Graph Errors on the live server. The Standby one is working fine with a restore of all the live data (including CDR).

The errors are:

  • On Monthly Traffic I get a JpGraph Error: 15009 - Illegal pie plot. Sum of all data is zero for the Pie Plot

  • On the Daily Load the Load by Hours graph doesn’t appear at all and all the Watch Calls Graphs just appear as a single bar up the left hand side and says the number of calls is 1 rather than the 1300+ it should be.

I know the data is OK, as the graphs work fine on the copy restored onto the standby server.

I have obviously broken something in the upgrade but I can’t see what. Is there any way to tell is a dependency is missing or the wrong version?

Thanks for any help.

Graham

Hi,

Following on from the error above, I have now discovered that if you try to record a new system recording Asterisk stops working. I appears to be ok, but the list of active channels doesn’t change and phones all go to no service.

Graham

Hi,

I have just gone through the installed packages (yum list installed) and checked them against the working PBX. There were a few missing which I have added, but still got the graph errors.

I have also tried re-installing FreePBX from the tarball but still getting the same jPGraph errors.

Anyone any ideas?

Thanks

Graham

I get nothing in the error_log and “Stat Graph” on the monthly and Compare Calls page. On the Daily Load under Fluctuation Graph I get “JpGraph Error: 25121 Empty input data array specified for plot. Must have at least one data point.”

Any suggestions as to where else I can look for the actual error?

If you find a solution please post it as I am having the same difficulty with 2 pbxinaflash purple version servers.

Common thing here is PBX in a Flash.
How did you upgrade your systems?
Check your /var/log/httpd/error_log for any errors.

Hi,

The PIAF upgrade was via update-source, but I did have an issue in the middle of the yum update with a missing dependancy. After running the update-source I then did a manaul yum update after resolving the dependancy issue.

On the errors, I get the following in the httpd erros_log:
[Wed Jul 13 08:53:03 2011] [error] [client ] script not found or unable to stat: /var/www/cgi-bin/awstats.pl
[Wed Jul 13 08:53:20 2011] [error] [client ] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/admin/libraries/php-asmanager.php on line 274, referer: http:///admin/config.php?type=setup&display=did&extdisplay=%2F&extension=&cidnum=&didfilter=&rnavsort=description

entries are me removing system specfic data.

Graham