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

phalek · Post by **phalek** » Mon Feb 01, 2010 4:29 pm

0.83 has just been released.

New features:
* HTML report capability for Multi Reports and Graph reports. This can be selected separately for each report. ( mPDF ReportEngine required for this to work!)
* Reports can be scheduled using Cron
* Some bug-fixing for report scheduling

A new requirement for the HTML report is the php zip module to be installed. ( "yum install php-pecl-zip" on CentOs/RHEL )

An updated documentation will follow soon.

L0gRuS · Post by **L0gRuS** » Tue Feb 02, 2010 3:09 am

Good Day!
Today installed 0.83 and cant generated reports

files and permissions:

8 -rwxr-xr-x 1 apache apache 7392 Feb 2 00:26 addToDSStatsReport.php
28 -rwxr-xr-x 1 apache apache 28352 Feb 2 00:26 addToGraphReport.php
4 drwxr-xr-- 2 apache apache 4096 Feb 2 00:25 archive
8 -rwxr-xr-x 1 apache apache 7058 Feb 2 00:26 create_image.php
72 -rwxr-xr-x 1 apache apache 66644 Feb 2 00:26 createPDFReport_defined.php
24 -rwxr-xr-x 1 apache apache 23220 Feb 2 00:26 createPDFReport_mrtgStyle.php
32 -rwxr-xr-x 1 apache apache 29576 Feb 2 00:26 createPDFReport.php
68 -rwxr-xr-x 1 apache apache 65492 Feb 2 00:26 createPDFReport_scheduler.php
12 -rwxr-xr-x 1 apache apache 8916 Feb 2 00:26 cron_pdf_scheduler.php
4 drwxr-xr-x 2 apache apache 4096 Dec 31 02:12 dsstats_reports
16 -rw-r--r-- 1 apache apache 14005 Feb 2 11:29 fpdf_tpl.php
192 -rwxr-xr-x 1 apache apache 192168 Feb 2 00:26 functions.php
4 drwxr-xr-- 2 apache apache 4096 Feb 2 10:48 images
4 -rwxr-xr-x 1 apache apache 44 Feb 2 00:26 index.php
4 drwxr-xr-x 2 apache apache 4096 Feb 2 10:03 ixed
24 -rwxr-xr-x 1 apache apache 21908 Feb 2 00:26 nmidCreatePDF_addDSStatsReport.php
32 -rw-r--r-- 1 apache apache 28744 Feb 2 00:26 nmidCreatePDF_addMultiReport.php
108 -rwxr-xr-x 1 apache apache 104520 Feb 2 00:26 nmidCreatePDF_addReport.php
56 -rwxr-xr-x 1 apache apache 50164 Feb 2 00:26 nmidCreatePDF_addScheduledReport.php
24 -rwxr-xr-x 1 apache apache 22336 Feb 2 00:26 nmidCreatePDF_Archive.php
68 -rwxr-xr-x 1 apache apache 65024 Feb 2 00:26 nmidCreatePDF_createTemplateReport.php
16 -rwxr-xr-x 1 apache apache 13608 Feb 2 00:26 nmidCreatePDF_doArchiveReport.php
36 -rwxr-xr-x 1 apache apache 35904 Feb 2 00:26 nmidCreatePDF_GenerateReport_now.php
20 -rwxr-xr-x 1 apache apache 20020 Feb 2 00:26 nmidCreatePDF_GenerateReports.php
12 -rwxr-xr-x 1 apache apache 10408 Feb 2 00:26 nmidCreatePDF_orderDSStatsGraphs.php
12 -rwxr-xr-x 1 apache apache 10452 Feb 2 00:26 nmidCreatePDF_orderGraphs.php
12 -rw-r--r-- 1 apache apache 10408 Feb 2 00:26 nmidCreatePDF_orderMultiGraphs.php
24 -rwxr-xr-x 1 apache apache 21760 Feb 2 00:26 nmidCreatePDF_Reports.php
24 -rwxr-xr-x 1 apache apache 23348 Feb 2 00:26 nmidCreatePDF_scheduler.php
4 -rw-r--r-- 1 apache apache 136 Feb 2 00:26 nmidCreatePDF.sglic
892 -rwxrwxrwx 1 apache apache 906400 Feb 2 11:35 parallelGraphRetriever
20 -rwxr-xr-x 1 apache apache 19488 Feb 2 00:26 reportEngine.php
4 drwxrwxrwx 3 apache apache 4096 Feb 2 00:26 ReportEngines
48 -rwxr-xr-x 1 apache apache 48215 Feb 2 00:26 setup.php
4 drwxrwxrwx 9 apache apache 4096 Feb 2 11:36 tmp

tmp directory permissions = 777

When PDF file is generated it have 1 kb size and no extension.

php createPDFReport.php

PHP Notice: Undefined index: starttime in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 35

Notice: Undefined index: starttime in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 35
PHP Notice: Undefined index: endtime in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 36

Notice: Undefined index: endtime in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 36
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 142

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 142
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 143

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 143
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 144

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 144
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 145

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 145
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 146

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/createPDFReport.php on line 146
PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/plugins/nmidCreatePDF/functions.php on line 272

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/plugins/nmidCreatePDF/functions.php on line 272
PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/ReportEngines/fpdf/fpdf.php on line 1032

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/plugins/nmidCreatePDF/createPDFReport.php:35) in /var/www/html/plugins/nmidCreatePDF/ReportEngines/fpdf/fpdf.php on line 1032
<b>FPDF error:</b> Some data has already been output, can't send PDF file

how can resolve this problem?

phalek · Post by **phalek** » Tue Feb 02, 2010 3:56 am

can you try the mPDF engine ?

phalek · Post by **phalek** » Tue Feb 02, 2010 3:58 am

and look into the PDF file with a text editor, there will be an error message displayed showing what is wrong

L0gRuS · Post by **L0gRuS** » Tue Feb 02, 2010 4:05 am

phalek wrote:can you try the mPDF engine ?

what is it?)

phalek wrote:and look into the PDF file with a text editor, there will be an error message displayed showing what is wrong

checked and resolved. problem was with logo.png. delete it and now all works. Thank you.

phalek · Post by **phalek** » Tue Feb 02, 2010 4:11 am

For the mPDF Report Engine, have a look at the QuickInstall Guide. It's not up-to-date for 0.83 but the steps are nearly the same for it:

http://www.network-outsourcing.de/corpo ... ation.html

L0gRuS · Post by **L0gRuS** » Tue Feb 02, 2010 4:47 am

phalek wrote:For the mPDF Report Engine, have a look at the QuickInstall Guide. It's not up-to-date for 0.83 but the steps are nearly the same for it:

http://www.network-outsourcing.de/corpo ... ation.html

Thank you.

I have one question. When i want generate some graphs and it sub categories(Hourly,daily,weekly,monthly,yearly) i check main graph and clock Include Sub-Leafs . But when pdf generated i look only one graph. Where my steps wrong?

phalek · Post by **phalek** » Tue Feb 02, 2010 4:54 am

sub-leafs refers only to the items beneath a branch. If you want to generate a "MRTG Style" Report, you need to first click on the graph, so that you see the hourly,daily ... graphs and then you can create a repor from it using the toolbar at the top ( you need to have replaced the graph.html file with the one from http://redmine.nmid-plugins.de/projects ... dcreatepdf )

zoemu · Post by **zoemu** » Tue Feb 02, 2010 9:52 am

I've Tried to install the new posted version on my test system and everytime I try to generate a Report I get this message

Code: Select all

Server Error
502 - Web server received an invalid response while acting as a gateway or proxy server.

And when I add a graph to the report I get this

Code: Select all

Server Error
404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Thought you may want to know...

Mind you that the version that I have with all the changes that we worked on before is working fine on my live system.

Thanks

phalek · Post by **phalek** » Tue Feb 02, 2010 10:05 am

i wonder what's so special about your system ...

I've checked it on Windows 7 and CentOS Linux with not even anything like this error ...

Can you provide me with a bit more details ?
How did you want to create the report
Was it a graph report ?
Was it HTML or PDF Output ?
Maybe you can provide the link/url that was shown ?

Didn't know i was creating a proxy server ..

I guess it happens right at the end of the report generation, when the server wants to send the report data to the browser, but I need to look deeper into this ... *sigh*

zoemu · Post by **zoemu** » Tue Feb 02, 2010 10:29 am

When generating the report this is the Link

http://Cactiserver/cacti/plugins/nmidCr ... efined.php

Server Error
502 - Web server received an invalid response while acting as a gateway or proxy server.
There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server.

When generating by clicking on the PDF Button in the preview page

http://islnetmon/cacti/plugins/nmidCrea ... Report.php

Server Error
502 - Web server received an invalid response while acting as a gateway or proxy server.
There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server.

and for the detail report (hourly,daily monthly...) it works fine the report is created with both report engines, I've also noticed that the mPdf places a free version watermark on the labels... ??

Thanks

phalek · Post by **phalek** » Tue Feb 02, 2010 10:45 am

yeah, isn't that watermark soo cool ?
I may remove that one once 1.0 comes out which is to be released shortly ( when I fixed all your problems ...)

For the other things, I need a closer look into this once I get back to my office later today.

phalek · Post by **phalek** » Tue Feb 02, 2010 4:37 pm

zoemu which version was/is working for you, 0.82 ?

zoemu · Post by **zoemu** » Tue Feb 02, 2010 4:39 pm

yeap.... but i does not have the html option that you added in .3 and the scheduling

Want it all!!

zoemu

phalek · Post by **phalek** » Tue Feb 02, 2010 4:41 pm

well, but I did not change anything in the createPDFReport.php file, which makes me a bit stumped ...

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

Who is online