CereusReporting Not working in 1.2.4

[bmfmancini]

Hello Everyone

I am seeing issues with CereusReporting on 1.2.4
When trying to create a PDF the plugin crashes I have tried both Mpdf and TCPDF

2019/05/07 14:16:28 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'CereusReporting'
2019/05/07 14:16:28 - ERROR PHP COMPILE_ERROR in Plugin 'CereusReporting': Switch statements may only contain one default clause in file: /var/www/html/cacti/plugins/CereusReporting/ReportEngines/mpdf/mpdf.php on line: 1417
2019/05/07 14:05:50 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'CereusReporting'
2019/05/07 14:05:49 - ERROR PHP PARSE in Plugin 'CereusReporting': syntax error, unexpected 'new' (T_NEW) in file: /var/www/html/cacti/plugins/CereusReporting/ReportEngines/fpdf/fpdi.php on line: 98
2019/05/07 14:02:22 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'CereusReporting'
2019/05/07 14:02:22 - ERROR PHP PARSE in Plugin 'CereusReporting': syntax error, unexpected 'new' (T_NEW) in file: /var/www/html/cacti/plugins/CereusReporting/ReportEngines/fpdf/fpdi.php on line: 98
2019/05/07 13:58:51 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'CereusReporting'
2019/05/07 13:58:51 - ERROR PHP PARSE in Plugin 'CereusReporting': syntax error, unexpected 'new' (T_NEW) in file: /var/www/html/cacti/plugins/CereusReporting/ReportEngines/fpdf/fpdi.php on line: 98
2019/05/07 13:57:13 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'CereusReporting'
2019/05/07 13:57:13 - ERROR PHP PARSE in Plugin 'CereusReporting': syntax error, unexpected 'new' (T_NEW) in file: /var/www/html/cacti/plugins/CereusReporting/ReportEngines/fpdf/fpdi.php on line: 98
2019/05/07 13:55:44 - CMDPHP SQL Backtrace: (/plugins/CereusReporting/CereusReporting_addWeathermapReport.php[59]:form_display(), /plugins/CereusReporting/CereusReporting_addWeathermapReport.php[105]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2019/05/07 13:24:37 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[626]:plugin_CereusReporting_install(), /plugins/CereusReporting/setup.php[58]:CereusReporting_setup_table_new(), /plugins/CereusReporting/include/setup_database.php[606]:db_execute(), /lib/database.php[191]:db_execute_prepared())



Dir: /var/www/html/cacti/plugins/CereusReporting
Main Dir: /var/www/html/cacti/
PHP_SELF: /cacti/plugins/CereusReporting/CereusReporting_debug.php
Cacti URL: /cacti/
PIA Version: integrated
Edition: SMB Edition [84 out of 200 used ]- Get Corporate Professional or Business Edition
License Expiry: never
Licensed Server: TRUE
Operating System: Linux 3.13.0-165-generic #215-Ubuntu SMP Wed Jan 16 11:46:48 UTC 2019 i686
File Version $Id: CereusReporting_debug.php,v 6de4bc63a72b 2017/11/01 15:05:58 thurban $
Plugin Settings:
PHP Path /usr/bin/php
PHP Version PHP 7.3.4-1+ubuntu16.04.1+deb.sury.org+3 (cli) (built: Apr 10 2019 10:50:34) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.3.4, Copyright (c) 2002-2019, by ionCube Ltd. with Zend OPcache v7.3.4-1+ubuntu16.04.1+deb.sury.org+3, Copyright (c) 1999-2018, by Zend Technologies
PDF Engine mPDF
Plugin Version 3.01.32
Licensed Modules:
Availability module licensed
Report Scheduling module licensed
DSStats module licensed
MultiReports module licensed
Archiving module licensed
Templatingmodule licensed
File/Directory Settings:
tmp directory /tmp
tmp directory exists yes
tmp directory writeable yes
tmp directory - can create dirs yes
Loaded PHP Modules:
mbstring enabled
gd enabled
SourceGuardian disabled
IonCube Loader enabled
zip enabled
curl enabled
Required Cacti Plugins:
settings missing
Optional PHP Modules:
ChartDirector PHP API disabled

PHP info

PHP 7.3.4-1+ubuntu16.04.1+deb.sury.org+3 (cli) (built: Apr 10 2019 10:50:34) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.3.4, Copyright (c) 2002-2019, by ionCube Ltd.
with Zend OPcache v7.3.4-1+ubuntu16.04.1+deb.sury.org+3, Copyright (c) 1999-2018, by Zend Technologies

Cacti Info

Date Tue, 07 May 2019 14:27:42 -0400
Cacti Version 1.2.4
Cacti OS unix
RSA Fingerprint 5f:c6:e7:c5:42:82:af:57:cb:65:cf:fb:38:d7:67:51
NET-SNMP Version NET-SNMP version: 5.7.3
RRDtool Version Configured 1.7.0+
RRDtool Version Found 1.7.0
Devices 11
Graphs 89
Data Sources Script/Command: 9
SNMP Get: 8
SNMP Query: 32
Script Server: 35
Total: 84

[bmfmancini]

Weird enough if you switch from TCPDF to MPDF and back to TCPDF it seems to work but im still testing

[bmfmancini]

Ok so the report generates but it doesn't archive the report ... No errors in log show up

[phalek]

Hi

I've created a ticket in the Code Management system for the mysql_escape_string function to be replaced with prepare statements.

For the archive. Can you check if the following directories are writeable:

Code: Select all

archive
tmp
images

[phalek]

3.90.08 fixes these issues for PHP 7.1 and newer systems running Cacti 1.2.x