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

[phalek]

Hi

First disable the "Sourceguardian" module, the "enabled" should actuall be highlighted in red ( sorry for any color blinded, I need to change that ... )

Then look into the CereusReporting logfile in the /path/to/cacti/plugins/CereusReporting/tmp directory and check that for any issues. Enable the "debug logging" first on the Console -> Settings -> NMID tab.

[zachburdick]

Sorry for my lack of knowledge, how do I disable that?

[zachburdick]

This is what I am seeing:

Code: Select all

Apr 15 15:26:02 [Notice] [CereusReporting] [cron] Starting Scheduled Report Check.
Apr 15 15:26:02 [Debug] [CereusReporting] [functions] Retrieving active report schedules.
Apr 15 15:26:02 [Notice] [CereusReporting] [cron] Scheduled Report Check Finished.
Apr 15 15:26:02 [Notice] [CereusReporting] [system] CEREUSREPORTING STATS: Time:0.3399 
Apr 15 15:26:48 [Notice] [CereusReporting] [scheduler] Starting Scheduled Report Check
Apr 15 15:26:48 [Notice] [CereusReporting] [scheduler] Scheduled Report Check Finished
Apr 15 15:27:02 [Notice] [CereusReporting] [cron] Starting Scheduled Report Check.
Apr 15 15:27:02 [Debug] [CereusReporting] [functions] Retrieving active report schedules.
Apr 15 15:27:02 [Notice] [CereusReporting] [cron] Scheduled Report Check Finished.
Apr 15 15:27:02 [Notice] [CereusReporting] [system] CEREUSREPORTING STATS: Time:0.2035 
Apr 15 15:28:02 [Notice] [CereusReporting] [cron] Starting Scheduled Report Check.
Apr 15 15:28:02 [Debug] [CereusReporting] [functions] Retrieving active report schedules.
Apr 15 15:28:02 [Notice] [CereusReporting] [cron] Scheduled Report Check Finished.
Apr 15 15:28:02 [Notice] [CereusReporting] [system] CEREUSREPORTING STATS: Time:0.1536 
Apr 15 15:29:02 [Notice] [CereusReporting] [cron] Starting Scheduled Report Check.
Apr 15 15:29:02 [Debug] [CereusReporting] [functions] Retrieving active report schedules.
Apr 15 15:29:02 [Notice] [CereusReporting] [cron] Scheduled Report Check Finished.
Apr 15 15:29:02 [Notice] [CereusReporting] [system] CEREUSREPORTING STATS: Time:0.2261 
Apr 15 15:29:17 [Notice] [CereusReporting] [PDFCreation] Creating Report [Testing CPU and Memory]
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] PDF Cover Page: [/usr/share/cacti/plugins/CereusReporting/templates/coverpages/]
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] PDF Append Page: []
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] Print Header : []
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] Print Footer: []
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] Skipping Cover Page: []
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 94 -> /usr/bin/php create_image.php 94 0   120 500 > tmp/1429126157-1--/94--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 94 -> /usr/bin/php create_image.php 94 0   120 500 > tmp/1429126157-1--/94--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 65 -> /usr/bin/php create_image.php 65 0   120 500 > tmp/1429126157-1--/65--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 71 -> /usr/bin/php create_image.php 71 0   120 500 > tmp/1429126157-1--/71--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 59 -> /usr/bin/php create_image.php 59 0   120 500 > tmp/1429126157-1--/59--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 22 -> /usr/bin/php create_image.php 22 0   120 500 > tmp/1429126157-1--/22--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 28 -> /usr/bin/php create_image.php 28 0   120 500 > tmp/1429126157-1--/28--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 34 -> /usr/bin/php create_image.php 34 0   120 500 > tmp/1429126157-1--/34--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 40 -> /usr/bin/php create_image.php 40 0   120 500 > tmp/1429126157-1--/40--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 8 -> /usr/bin/php create_image.php 8 0   120 500 > tmp/1429126157-1--/8--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 16 -> /usr/bin/php create_image.php 16 0   120 500 > tmp/1429126157-1--/16--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 173 -> /usr/bin/php create_image.php 173 0   120 500 > tmp/1429126157-1--/173--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 5 -> /usr/bin/php create_image.php 5 0   120 500 > tmp/1429126157-1--/5--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [system] Adding Graph 46 -> /usr/bin/php create_image.php 46 0   120 500 > tmp/1429126157-1--/46--.png
Apr 15 15:29:17 [Debug] [CereusReporting] [PDFCreation] Starting Preview Mode

[phalek]

look through your php.ini file and the php.d for any reference to the sourceguardian module and comment out the extension line which enables it. Afterwards restart/reload your webserver

[zachburdick]

Ok, I have this now:

Code: Select all

Loaded PHP Modules:
mbstring	enabled
gd	enabled
SourceGuardian	disabled
IonCube Loader	enabled
zip	enabled
soap	disabled
gettext	enabled

Still get blank pages and no errors in the logs

[zachburdick]

I did find this in my Cacti Log File:

Code: Select all

04/15/2015 04:07:38 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(id) FROM plugin_nmidCreatePDF_Availability_Table"
04/15/2015 04:07:38 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT MAX(id) FROM plugin_nmidCreatePDF_Availability_Table"
04/15/2015 04:07:33 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(id) FROM plugin_nmidCreatePDF_Availability_Table"
04/15/2015 04:07:33 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT MAX(id) FROM plugin_nmidCreatePDF_Availability_Table" 

[phalek]

please enable php error loging ( in php.ini set "error_log = syslog" ) then check the log for any php related errors.

Next, don't use the preview now, enable the "on-demand" report generation, by disabling the "CereusReporting -> View Archive" realm permission for your user, then click on the "Cereus" tab and generate the report from there.

[zachburdick]

Disabling that allows me to generate a report. Thanks so much. Any idea on why when the report is generated that is places each graph on its own page and not two per page? Their is plenty of space for more graphs on the page.

Again Thanks

[phalek]

Can you send me a sample report to support@urban-software.de so I can have a look at it ?

[zachburdick]

Looks like the report template might have been the issue I was using: CereusReporting now I am using nmidCreartePDF. Im gonna play around with it some more today and try to update my documentation on installation. Hopefully I wont need to bother you again.


But....you never know.

Thanks again.

[phalek]

Try this then:

Code: Select all

Report Template:   templates/Urban-Software.pdf
Report Cover Logo: images/transparent_logo.png
Report Cover Page: None

[zachburdick]

That worked as well. Thanks

[phalek]

There's a small (a bit outdated) userguide available here: http://www.network-outsourcing.de/uploa ... rGuide.pdf

It explains the templating part a bit.

[laxmiit]

Dear All ,

Any one Please suggest me i 've an Issue in Cereus Reporting that it Generates report but only header & footer Not showing Graphs
on Reports .

Please help me Or Reply laxmi.iteng@gmail.com


Many Many thanks in Advance ..



Thank u

[phalek]

Can you please post your "Debug Info" page ?