Cacti Reports crashed - Reportit Plugin

[niranga1127]

Hi,

We have installed Reportit plugin 1.1.3 version with Cacti Version 1.2.23 (Server version 5.5.68-MariaDB)
We have added 30000 graphs to the cacti & we are trying to generate report using reportit with date items around 500.
But it always crashes but it runs if we reduce data items to less than 100.
We can see below warnings in the log
2023-09-28 16:13:20 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[513]:array_intersect(), CactiErrorHandler())
2023-09-28 16:13:20 - ERROR PHP WARNING in Plugin 'reportit': array_intersect(): Argument #2 is not an array in file: /data/cacti/cacti-1.2.23/plugins/reportit/runtime.php on line: 513
2023-09-28 16:13:20 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared())

Is there anyway sort out this issue?
Please help

[TheWitness]

Looks like a compatibility problem or the plugin was disabled. Check if it's disable from Plugin Management. If it's disabled, you have to find the source. Did you update PHP recently? What version of PHP?

[niranga1127]

Hi,

Thank you very much for the reply.
Plugin is enabled and active and I havent updated anything related to Cacti. All are running with initially installed versions

[root@localhost ~]# php -v
PHP 5.4.45 (cli) (built: Jun 23 2022 08:21:52)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologie

[root@localhost ~]# mysql -V
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1


Thanks

[TheWitness]

Dude, is that a RHEL variant?

[TheWitness]

I've posted a fix to the development branch of reportit. Please test it out.

[niranga1127]

Hi,

Thank you very much for the update.
This is CentOS 7
I have updated reportit plugin folder from github & reinstalled & try to run it again
but it still crashed with below error log

2023-09-30 09:42:36 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:36 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:42:36 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:36 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport_no_formatting, report_autoexport_no_formatting): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport_no_formatting, report_autoexport_no_formatting): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport_max_records, report_autoexport_max_records): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport_max_records, report_autoexport_max_records): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport, report_autoexport): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoexport, report_autoexport): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, auto_email, report_email): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, auto_email, report_email): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoarchive, report_autoarchive): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autoarchive, report_autoarchive): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autorrdlist, report_autorrdlist): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, autorrdlist, report_autorrdlist): set? No
2023-09-30 09:42:31 - CMDPHP set_field_data(array, scheduled, report_schedule): val:
2023-09-30 09:42:31 - CMDPHP set_field_data(array, scheduled, report_schedule): set? No
2023-09-30 09:42:23 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:23 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:42:23 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:23 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[48]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:42:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:42:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:42:15 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:36:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:36:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:36:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:36:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:36:21 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:36:21 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[44]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())
2023-09-30 09:36:21 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3726]:CactiErrorHandler())
2023-09-30 09:36:21 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/reportit/reports.php[54]:top_header(), /lib/functions.php[4596]:include_once(), /include/top_header.php[27]:draw_navigation_text(), /lib/functions.php[3724]:CactiErrorHandler())

Regards
Niranga

[niranga1127]

Hi,

Here is the latest update when i run a report ( Console -> Management -> Reports) , it goes to CRASHED state after couple of seconds. Even though it seems report generation is running in the background & after report generation completed , it shows under ReportIT tab. Then its state change to Idle

So in summary , your fix is working and reports are generating. Only issue is that it shows as CRASHED in Cacti GUI

Regards
Niranga

[TheWitness]

What do the backtraces in the cacti_log look like?

[TheWitness]

I think I might know now. Can you upgrade to at least PHP 7.2? You can use Remi's PHP repos. Remi supports PHP 7.4 and 8.x on RHEL/CentOS 7.x. Might want to consider moving to Rocky 9.

[niranga1127]

Back Trace logs are there at the start of running the report

Can it affect to the report generation correctly ?

I can try to upgrade PHP. My concern is that can it affect any other current running functions in cacti. ( Due to version compatibilites in the code )
Becoz i have added around 26000 graphs to the cacti and if something goes wrong i might face lot of problems

[TheWitness]

No, it's not an issue. In fact, all development by the Cacti Group is at least PHP8.1 these days, even on RHEL7/CentOS7.

[niranga1127]

Hi,

We encountered a new issue Reportit plugin was disabled automatically.
Any idea about the reason for this behavior ?

2023-10-03 11:47:55 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'reportit'
2023-10-03 11:47:55 - ERROR PHP ERROR in Plugin 'reportit': Call to undefined function export_to_0() in file: /data/cacti/cacti-1.2.23/plugins/reportit/view.php on line: 100
2023-10-03 11:47:09 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'reportit'

Regards
Niranga

[TheWitness]

That seems like a different issue altogether. Should be logged on GitHub.