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: 2725
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#901 Post by phalek » Wed Apr 15, 2015 1:44 pm

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.
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]

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#902 Post by zachburdick » Wed Apr 15, 2015 2:00 pm

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

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#903 Post by zachburdick » Wed Apr 15, 2015 2:30 pm

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

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#904 Post by phalek » Wed Apr 15, 2015 2:45 pm

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
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]

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#905 Post by zachburdick » Wed Apr 15, 2015 3:03 pm

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
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#906 Post by zachburdick » Wed Apr 15, 2015 3:11 pm

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" 

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#907 Post by phalek » Wed Apr 15, 2015 3:40 pm

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.
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]

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#908 Post by zachburdick » Thu Apr 16, 2015 7:14 am

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

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#909 Post by phalek » Thu Apr 16, 2015 7:17 am

Can you send me a sample report to [email protected] so I can have a look at it ?
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]

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#910 Post by zachburdick » Thu Apr 16, 2015 8:09 am

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.

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#911 Post by phalek » Thu Apr 16, 2015 8:39 am

Try this then:

Code: Select all

Report Template:   templates/Urban-Software.pdf
Report Cover Logo: images/transparent_logo.png
Report Cover Page: None
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]

zachburdick
Posts: 12
Joined: Thu Jul 31, 2014 9:17 am

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#912 Post by zachburdick » Thu Apr 16, 2015 8:48 am

That worked as well. Thanks

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#913 Post by phalek » Thu Apr 16, 2015 8:56 am

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.
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]

laxmiit
Posts: 3
Joined: Thu Apr 02, 2015 8:13 am
Location: India

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#914 Post by laxmiit » Wed Apr 22, 2015 7:29 am

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 [email protected]


Many Many thanks in Advance ..



Thank u

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

Re: CereusReporting - PDF/HTML Cacti Reports - v2.80 FINAL o

#915 Post by phalek » Wed Apr 22, 2015 7:31 am

Can you please post your "Debug Info" page ?
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