CereusReporting - PDF Reports - 3.01 for Cacti 1.x out!

Announcements concerning Plugins for Cacti

Moderators: Moderators, Developers

Post Reply
Author
Message
User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#916 Post by phalek » Mon May 23, 2016 8:03 am

Version 2.90 has been released. It contains some bug fixes and code rewrites to prepare for the 3.00 version:
  • DB access Migration to PDO
  • Use Cacti integrated logging
  • Fix for scheduled reports not being send when logging set to debug
  • Preparation to separate availability module into external addon
  • Smaller plugin size
The new version can be downloaded here: https://www.urban-software.com/products ... downloads/

Updated install and setup guides will follow soon.
Last edited by phalek on Mon May 23, 2016 9:15 am, edited 1 time in total.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#917 Post by phalek » Mon May 23, 2016 9:11 am

The installation guides have been corrected with the new URLs
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

thewizard
Posts: 11
Joined: Sun Jun 07, 2015 3:19 pm

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#918 Post by thewizard » Mon Jun 13, 2016 12:43 pm

Using latest 2.90.1 express on CentOS 6 (with it's php 5.3) with Cacti 0.8.8h from EPEL repo.
The "Add graphs to report" button doesn't work.
I am able to generate a quick report with using the "Create PDF Report" button.
This is what happens when I press the "Add graphs to report" button in the php log:

Code: Select all

Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: dsstats_name in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 41
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: ReportId in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 42
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: nmid_pdfAddSubLeafs in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 45
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined variable: val in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 49
Of course this immediately gives the following in Cacti's log:

Code: Select all

Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Another few oddities:
  • CereusReporting_messages.log is empty, regardless of the level. I do not see any permissions error (and via eye inspection it looks fine), is there a way to set its directory to /tmp (instead of under Cacti's plugins)?
  • If I enable "Add availaibility table to tree view", I get "CereusReporting/modules/availability/polling_functions.php was encoded#012with the PHP 5.5 ionCube Encoder and requires PHP 5.5 to be installed." and no graphs displayed when browsing graphs (reminder CentOS 6 with php 5.3).
  • I am able to create report by manually adding items from the console -> Manage Reports -> <report> -> Items for this report -> add. however there is a small glitch there too, on the first empty report it immediately shows a broken image under "preview" because of a "Validation error." from the query string: "graph_image.php?local_graph_id=&rra_id=0&view_type=tree&graph_start=1465835727&graph_end=1465839327"
  • This is not really a problem but just an eyesore: If I define a report with many empty fields I get multiple undefined variable notices in php:
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printHeader in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 208
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printFooter in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 214
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_skipHFCoverPage in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 220
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printHeader in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 278
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printFooter in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 278
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_skipHFCoverPage in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 279
  • I had to disable the CSRF in Cacti as the plugin didn't work with it.
Hope someone will be able to help me... :(
Thanks

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#919 Post by phalek » Tue Jun 14, 2016 2:32 am

Hi

CereusReporting_messages.log is empty due to 2.90 using the Cacti.log for logging. The particular isssues you are seeing doesn't have any log messags though :-)

All other errors should be fixed in 2.90.02 which you can get here: https://www.urban-software.com/products ... downloads/

You can open bug reports like these on the Support Portal as well

Thanks again for reporting this issue.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#920 Post by phalek » Tue Jun 14, 2016 6:09 am

Feature List for Version 3.0 ( Beta version to be released in July 2016 ):

Standard Edition
  • Compliance with the CSRF addon (csrf-magic )
  • Integration of the parallelGraphRetriever tool
  • On-Demand reports are created in the background. Users will be notfied when completed ( non-blocking mode )
  • Ability to add graphs/hosts using RegEXP
  • Send-via-email feature for on-demand reports
Additional Personal/Professional/Business Edition Features
  • Additional Report templates
  • Email Templates for scheduled reports
  • New report items ( e.g Pie Charts for interface utilization )
Last edited by phalek on Tue Jun 14, 2016 9:18 am, edited 1 time in total.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

thewizard
Posts: 11
Joined: Sun Jun 07, 2015 3:19 pm

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#921 Post by thewizard » Tue Jun 14, 2016 6:17 am

phalek wrote:Hi
All other errors should be fixed in 2.90.02 which you can get here: https://www.urban-software.com/products ... downloads/

You can open bug reports like these on the Support Portal as well

Thanks again for reporting this issue.
Thank you very much!
While at it, there was another similar issue with StoreLastPoll which gave the following errors in the log, thus disabled, perhaps it's the same/related/similar issue:

Code: Select all

php: PHP Notice:  Undefined index:  in /usr/share/cacti/plugins/storeLastPoll/setup.php on line 27
php: PHP Warning:  Variable passed to each() is not an array or object in /usr/share/cacti/plugins/storeLastPoll/setup.php on line 28
Again, be happy to assist in any way possible, kind regards, Nitzan.
I've posted it also in the support portal.

thewizard
Posts: 11
Joined: Sun Jun 07, 2015 3:19 pm

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#922 Post by thewizard » Tue Jun 14, 2016 7:10 am

phalek wrote:Feature List for Version 3.0 ( Beta version to be released in July 2016 ):

Standard Edition
  • Compliance with the CSRF adding (csrf-magic )
  • Integration of the parallelGraphRetriever tool
  • On-Demand reports are created in the background. Users will be notfied when completed ( non-blocking mode )
  • Ability to add graphs/hosts using RegEXP
  • Send-via-email feature for on-demand reports
Additional Personal/Professional/Business Edition Features
  • Additional Report templates
  • Email Templates for scheduled reports
  • New report items ( e.g Pie Charts for interface utilization )
Hi, Thanks for this. I actually personally bought and read your book (even bought outside work).

My use case is a lab for testing applications on various hardware, so this is hardly your primary IT/enterprise environment, thus most of the enterprise and even the standard edition's features are not/won't be used...
But I have a very unique use case that hadn't been tackled yet: I often compare tests, meaning 'times' are meaningful sometimes for different tests.
An ability to compare tests from different times or maybe create 'aggregate' graphs of different times... I'm not sure.

Thank you for the hard work and the great book.

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#923 Post by phalek » Tue Jun 14, 2016 7:23 am

Hm. That's a feature that can be added.

If I get it correct, you probably want to have 2 different time-frames within the same report. E.g.


Test 1 - Start 08:00 - End 08:30
<Graph of Device 1 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 1 - DataSource 1>

Test 1 - Start 08:00 - End 08:30
<Graph of Device 2 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 2 - DataSource 1>


Would this be helpful ?
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

thewizard
Posts: 11
Joined: Sun Jun 07, 2015 3:19 pm

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#924 Post by thewizard » Tue Jun 14, 2016 9:31 am

phalek wrote:Hm. That's a feature that can be added.

If I get it correct, you probably want to have 2 different time-frames within the same report. E.g.


Test 1 - Start 08:00 - End 08:30
<Graph of Device 1 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 1 - DataSource 1>

Test 1 - Start 08:00 - End 08:30
<Graph of Device 2 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 2 - DataSource 1>


Would this be helpful ?
YES! Sounds exactly right! AND (though it's hardly a straight reporting issue) sometimes it's even useful to see things on the same graphs (like aggregate does but can't do between different timeframes. but that's another issue).
Edit: just to clarify: your proposal is fantastic as is.

Had a chance to check the StoreLastPoll similar issue (which still exists. BTW what is it used for?).

Your insights and responses are very appreciated.

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#925 Post by phalek » Wed Jun 15, 2016 12:28 am

storeLastPoll is only used for getting Windows Service Availability.

If you only want the PDF part, then it's not required at all.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

thewizard
Posts: 11
Joined: Sun Jun 07, 2015 3:19 pm

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#926 Post by thewizard » Wed Jun 15, 2016 8:43 am

That's great to know.
Generally speaking I hadn't found any descent documentation about it (not how it works [like what you've just said] nor how to work with it [inc. tempting, etc.]).

nikdubois
Posts: 3
Joined: Thu Sep 08, 2016 8:48 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#927 Post by nikdubois » Thu Sep 08, 2016 8:50 am

anyone who wants to use this on windows: make sure the path to php.exe does not contain blank spaces. if needed, replace it with PROGRA~2 or the equivalent in you path (dir /X).

This solved the issue with graph images being replaced with 'Error opening the file' images for me.

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#928 Post by phalek » Thu Sep 08, 2016 9:01 am

Thanks nikdubois for reporting this.

I'll check if I can put some error message to that into the plugin
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

madcrang
Posts: 1
Joined: Thu Sep 08, 2016 11:15 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#929 Post by madcrang » Thu Sep 08, 2016 11:21 am

Hi administrator`s Cereus,

hi have a license EXPRESS, but I do not meet the requirements following:
Edition: Express Edition . Requirements for SMB Edition not met: [ 1740 out of 200 used ]- Get Corporate Professional or Business Edition

this can cause me not generate reports ?

Thanks

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !

#930 Post by phalek » Fri Sep 09, 2016 4:09 am

Hi

Report scheduling will not work as well as some other features.

Look here fore more details:
https://www.urban-software.com/products ... for-cacti/
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code: Select all

CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
[/size]

Post Reply