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

[nandozzi]

Hi think that you have to install parallelGraphRetriever.
As i can see from your reported lorg there is a missing component.
Let me know if you resolve this problem

[jbaribeault]

When I enable the "storelastpoll" plugin it seems to enable a lot of extra logging - it <looks> like an "informational" entry for each value stored. Can this be turned off? Thanks!

ie:

Code: Select all

1/29/2013 04:55:13 PM - CMDPHP: Poller[0] Poller Item : 781[ 5min_cpu -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ trustedMissing -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ knownContained -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ containedPending -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ threat -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ contained -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ acknowledge -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ known -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ detectedLrad -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ alert -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ pending -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3183[ initializing -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 1 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 2 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 3 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 4 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 5 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 6 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 7 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3185[ 8 -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3192[ bsnAPRadioPoorSNRCl -> 0 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3192[ bsnAPRadioClients -> 3 ]
01/29/2013 04:55:07 PM - CMDPHP: Poller[0] Poller Item : 3193[ bsnAPRadioPoorSNRCl -> 0 ]

[phalek]

Download a new file from here:

http://blog.network-outsourcing.de/prod ... reporting/

the logging has been removed from that version.

ukzerosniper: As your output states:

Code: Select all

File parallelGraphRetriever [b]does not exists[/b] ( /usr/share/cacti/plugins/nmidCreatePDF/parallelGraphRetriever

So please download that file and place it to the correct directory.

[phalek]

Version 2.10 has been released today.

Release Notes – CereusReporting – Version 2.10

Bug
[CRC-2] – Add Weathermap drop down points to the wrong id
[CRC-6] – Deleting a report does not delete associated schedule
[CRC-16] – WinServices do not show up on host level
[CRC-17] – Add support for "Structured RRA Path" for Windows Services addon
[CRC-18] – Change "Free Version" to "Express Edition" on PDF footers
[CRC-21] – Long Description gets overwritten by short description on SLA Item page
[CRC-22] – Drop down on SLA Item list is not sorted by hostname
[CRC-23] – Date format change causes jscript calendar to malfunction due to wrong date format
[CRC-24] – Use different colors to highlight the different issues on Availability Charts

Improvement
[CRC-9] – Add Database Maintenance tools
[CRC-12] – Rename Realm Permissions to new naming convention
[CRC-20] – Calculate next run date to be a date in the future

New Feature
[CRC-3] – Add Thold based availability charts
[CRC-7] – Add copy function at report page and report schedule page
[CRC-11] – SLA of the Subtree containing the customer devices
[CRC-26] – Add BCC functionality for report email functionality

Head over here for the Express and Corporate Editions.

http://blog.network-outsourcing.de/prod ... reporting/

Please note, you will need a valid Support contract or valid v2 license key for the Corporate Edition.

[phalek]

The next release is going support multiple languages. The first language being supported will be German.

Please have a look at the attached image for an example of the current development code.

[juliop]

Hi,

I have a problem and i dont know how to solve it, i tried everything i could but cant get php mbstring to work, so PDF reports are generating with errors.

My OS is windows 7 and i have installed Cacti with BSOD installation.

CACTI --> 0.8.8
PHP --> 5.3.17
APACHE --> 2.2.22

Cereus Debug Page:

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


PHP log error:

PHP Warning: PHP Startup: mbstring: Unable to initialize module Module compiled with module API=20060613 PHP compiled with module API=20090626 These options need to match in Unknown on line 0

PHP.ini

[mbstring]
; language for internal character representation.
; http://php.net/mbstring.language
mbstring.language = Neutral

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
; http://php.net/mbstring.internal-encoding
mbstring.internal_encoding = UTF-8

; http input encoding.
; http://php.net/mbstring.http-input
mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
; http://php.net/mbstring.http-output
mbstring.http_output = UTF-8

; enable automatic encoding translation according to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
; portable libs/applications.
; http://php.net/mbstring.encoding-translation
mbstring.encoding_translation = On

; automatic encoding detection order.
; auto means
; http://php.net/mbstring.detect-order
mbstring.detect_order = UTF-8

; substitute_character used when character cannot be converted
; one from another
; http://php.net/mbstring.substitute-character
mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
; http://php.net/mbstring.func-overload
mbstring.func_overload = 0

; enable strict encoding detection.
;mbstring.strict_detection = Off

; This directive specifies the regex pattern of content types for which mb_output_handler()
; is activated.
; Default: mbstring.http_output_conv_mimetype=^(text/|application/xhtml\+xml)
;mbstring.http_output_conv_mimetype=

; Allows to set script encoding. Only affects if PHP is compiled with --enable-zend-multibyte
; Default: ""
mbstring.script_encoding= off



I googled and tried different things with no results.

Hope someone can help me.

I attached the entire Cereus debug page.

Thanks in advance.

Julio

[phalek]

2 things,

First: Can you check if the plugin_nmidCreatePDF_* tables exist ?

Second: It seems like the mbstring is from an older PHP version, you will need to find/download the one for PHP 5.3 and replace that existing module with that one ( My guess is this module is for PHP 5.2)

[juliop]

phalek,

Tnks for the quick reply!! =D !!!

Php Mbstring extension is now working! As you said before it was a .dll version problem. I downloaded the correct for my PHP version from: http://fossies.org/windows/www/php-5.3. ... 9-x86.zip/

Mbstring enabled.

Anyway Cereus still not working, i cheked on Cacti technical page if tables are created as you told me to do and i found this:

Cacti Technical page:

plugin_nmidcreatepdf_archives 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availability_change_table 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availability_change_type 3 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availability_slatimeframe_table 1 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availability_slatimeframeitems_table 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availability_table 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_availabilityfailedpolls_table 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_dsstatsreports 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_graphreports 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_multigraphreports 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_reports 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_reports_scheduler 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_reports_types 16 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_usergrouplist 1 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_usergroupreports 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_usergroups 1 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_userreportlist 0 MyISAM latin1_swedish_ci
plugin_nmidcreatepdf_zenossreports 0 MyISAM latin1_swedish_ci

But in Cereus debug page it says:

Cereus debug page:

plugin_nmidCreatePDF_Reports_scheduler does not exist
plugin_nmidCreatePDF_Reports does not exist
plugin_nmidCreatePDF_Archives does not exist
plugin_nmidCreatePDF_UserGroups does not exist
plugin_nmidCreatePDF_UserGroupList does not exist
plugin_nmidCreatePDF_UserReportList does not exist
plugin_nmidCreatePDF_UserGroupReports does not exist
plugin_nmidCreatePDF_GraphReports does not exist
plugin_nmidCreatePDF_MultiGraphReports does not exist
plugin_nmidCreatePDF_DSStatsReports does not exist
plugin_nmidCreatePDF_ZenossReports does not exist
plugin_nmidCreatePDF_Reports_Types does not exist
plugin_nmidCreatePDF_Availability_Table does not exist
plugin_nmidCreatePDF_Availability_Change_Table does not exist
plugin_nmidCreatePDF_Availability_SLATimeFrame_Table does not exist
plugin_nmidCreatePDF_Availability_SLATimeFrameItems_Table does not exist
plugin_nmidCreatePDF_Availability_Change_Type does not exist

Maybe it can help, but when i installed weathermap i had to manually insert tables on mysql because PIA didnt do it.

What should i do ?

tnks in advance.

[phalek]

What exactly do you mean with "it does not work" can you provide error messages, a screenshot, the PDF being generated or anything the like ?

[juliop]

Sorry, my bad for not posting enough info from the error.

I attached some relevant pics:

1.jpg ---> i tried to generate a quick report from a device so i pick an interface graph (select graph option to pick wich graph you want is unavailable) and then click on pdf logo at the left top of the screen.

2.jpg ---> it generates a pdf file and i clicked on it.

3.jpg ---> cereus debug screenshot.

Maybe its working but i didnt configured it well ?

Dont know why its saying tables doesnt exist...

Tnks in advance.

[juliop]

I forgot to attach the pdf itself, here it is.

[juliop]

Sorry about this, i realized i wasnt trying to generate the report from the TREE view so now i see graph ok and i can pick wich i want in the report, select cell is available at the right of the graph.

When i try to generate the report its says this:


FPDF error: Undefined font: B


Tnks in advance.

[phalek]

Please go to Console -> Settings -> NMID and hit save at the bottom. The retry.

If that doesn't work, download the mPDF engine from here and extract the contect to the ReportEninge directory. Then go to the NMID settings and change the ReportEngine to mPDF and retry.

[juliop]

Phalek,

I did what you told me to do " Please go to Console -> Settings -> NMID and hit save at the bottom. The retry. "

And now its working ok !!!!

Thanks!! This tool is perfect.

I Hope this helps someone else.

[phalek]

Btw. If the PDF is corrupt, please try opening the PDF file using notepad. In most of the cases, there's an error message within that file so it becomes a plain text file ( with a .pdf ending ).