CereusReporting - PDF Reports - 4.00 for Cacti 1.x out soon!

[phalek]

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.

[phalek]

The installation guides have been corrected with the new URLs

[thewizard]

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

[phalek]

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.

[phalek]

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 )

[thewizard]

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]

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.

[phalek]

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 ?

[thewizard]

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.

[phalek]

storeLastPoll is only used for getting Windows Service Availability.

If you only want the PDF part, then it's not required at all.

[thewizard]

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]

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.

[phalek]

Thanks nikdubois for reporting this.

I'll check if I can put some error message to that into the plugin

[madcrang]

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

[phalek]

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/