Cacti Reports crashed - Reportit Plugin

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
niranga1127
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Cacti Reports crashed - Reportit Plugin

Post by 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
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by 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?
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
niranga1127
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Re: Cacti Reports crashed - Reportit Plugin

Post by 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
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by TheWitness »

Dude, is that a RHEL variant?
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by TheWitness »

I've posted a fix to the development branch of reportit. Please test it out.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
niranga1127
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Re: Cacti Reports crashed - Reportit Plugin

Post by 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
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Re: Cacti Reports crashed - Reportit Plugin

Post by 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
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by TheWitness »

What do the backtraces in the cacti_log look like?
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by 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.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
niranga1127
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Re: Cacti Reports crashed - Reportit Plugin

Post by niranga1127 »

Back Trace logs are there at the start of running the report
Image
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
Attachments
Screenshot_382.png
Screenshot_382.png (176.74 KiB) Viewed 2408 times
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by 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.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
niranga1127
Posts: 26
Joined: Mon Apr 03, 2023 6:10 am

Re: Cacti Reports crashed - Reportit Plugin

Post by 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
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Cacti Reports crashed - Reportit Plugin

Post by TheWitness »

That seems like a different issue altogether. Should be logged on GitHub.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests