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

[phalek]

CereusReporting v1.81 is compatible with 0.8.8a

[phalek]

Version 1.83 has been released which fixes some smaller bugs with the availability function.

This version has been fully tested with the latest ioncube loaders, PHP 5.3 and Cacti 0.8.8a.

Grab it here: http://redmine.nmid-plugins.de/projects ... epdf/files

[phalek]

Stay tuned ...

CereusReporting_v2.00.png (4 KiB) Viewed 4783 times

[MI1]

Hi,
I am a bit confused with all thoose versions and names, please advice. Just tool responsibility for Cacti 0.8.7g with NmidCreatePDF v1.75.26 installed. When I hit nmidPDF button on top panel i can see following text:

Code: Select all

CereusReporting - User Reports
Archiving is not supported for this Edition. Your edition is :EXPRESS

This means I do have old NmidPDF or CereusReporting version?
Also when I navigate to Console / NMID i see there tabs - Manage reports, Backup/restore and Debug info. There are some reports under Manage reports tab but not sure if that automatic email reports or user needs to log and save it.
Debug info:

Code: Select all

CereusReporting Debug Page
--------------------------------------------------------------------------------
Dir: /var/www/cacti/plugins/nmidCreatePDF 
Main Dir:  /var/www/cacti/ 
PHP_SELF:  /cacti/plugins/nmidCreatePDF/nmidCreatePDF_debug.php 
Cacti URL:  /cacti/ 
PIA Version:  2.9 
Edition:  EXPRESS 
License Expiry:  never 
Licensed Server:  TRUE 
Operating System:  Linux XXXXXX #1 SMP Sat Feb 20 00:15:53 UTC 2010 i686 
--------------------------------------------------------------------------------
Plugin Settings: 
PHP Path /usr/bin/php 
PHP Version PHP 5.2.0-8+etch16 (cli) (built: Nov 24 2009 11:14:47) Copyright (c) 1997-2006 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2006 Zend Technologies with the ionCube PHP Loader v4.0.9, Copyright (c) 2002-2011, by ionCube Ltd.  
PDF Engine mPDF 
Plugin Version 1.75.26 
--------------------------------------------------------------------------------
Licensed Modules: 
Availability module disabled 
Report Scheduling module disabled 
Zenoss module disabled 
DSStats module disabled 
MultiReports module disabled 
Archiving module disabled 
Templating module disabled 
--------------------------------------------------------------------------------
File/Directory Settings: 
tmp directory /var/www/cacti/plugins/nmidCreatePDF/tmp 
tmp directory exists yes 
tmp directory writeable yes 
--------------------------------------------------------------------------------
Loaded PHP Modules: 
mbstring enabled 
gd enabled 
SourceGuardian disabled 
IonCube Loader enabled 
zip enabled 
soap enabled 
--------------------------------------------------------------------------------
Optional PHP Modules: 
curl disabled 
ChartDirector PHP API disabled 
--------------------------------------------------------------------------------
Installed CereusReporting Extenstions: 
File parallelGraphRetriever exists  ( /var/www/cacti/plugins/nmidCreatePDF/parallelGraphRetriever ) 
File getSmokePingPath does not exists  ( /var/www/cacti/plugins/nmidCreatePDF/getSmokePingPath ) 
--------------------------------------------------------------------------------
Plugin Tables
Table Name Status 
plugin_nmidCreatePDF_Reports_scheduler exists 
plugin_nmidCreatePDF_Reports exists 
plugin_nmidCreatePDF_Archives exists 
plugin_nmidCreatePDF_UserGroups exists 
plugin_nmidCreatePDF_UserGroupList exists 
plugin_nmidCreatePDF_UserReportList exists 
plugin_nmidCreatePDF_UserGroupReports exists 
plugin_nmidCreatePDF_GraphReports exists 
plugin_nmidCreatePDF_MultiGraphReports exists 
plugin_nmidCreatePDF_DSStatsReports exists 
plugin_nmidCreatePDF_ZenossReports exists 
plugin_nmidCreatePDF_Reports_Types exists 
plugin_nmidCreatePDF_Availability_Table exists 
plugin_nmidCreatePDF_Availability_Change_Table exists 
plugin_nmidCreatePDF_Availability_SLATimeFrame_Table exists 
plugin_nmidCreatePDF_Availability_SLATimeFrameItems_Table exists 
plugin_nmidCreatePDF_Availability_Change_Type exists 
--------------------------------------------------------------------------------
Plugin Hooks
Hook Name Status 
api_device_save does not exist 
tree_after registered 
draw_navigation_text registered 
poller_bottom registered 
top_header_tabs registered 
top_graph_header_tabs registered 
console_after registered 
page_buttons registered 

Not sure if this plugins is needed anymore since it fills log with errors like this:

Code: Select all

10/10/2012 12:12:00 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:" INSERT INTO `plugin_nmidCreatePDF_Availability_Table` ( `deviceId`, `typeId`,`timeStamp`, `total_polls`, `failed_polls`, `orig_total_polls`, `orig_failed_polls`,`isLastEntry` ) VALUES ( '1363', 'i','1349871120','345','3','345','3','1' ) '  
10/10/2012 12:12:00 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:" INSERT INTO `plugin_nmidCreatePDF_Availability_Table` ( `deviceId`, `typeId`,`timeStamp`, `total_polls`, `failed_polls`, `orig_total_polls`, `orig_failed_polls`,`isLastEntry` ) VALUES ( '1364', 'i','1349871120','338','0','338','0','1' ) '  

So I would be thankful for any advice what should be the next to step to fix this or choose if i can remove the plugin safely.

Thx

[phalek]

Hi,

Check if the user you are currently logged in with does have the realm permission "NMID - View Archived Reports" set. If yes, then uncheck it and click on the tab again.

[MI1]

Thx for reply, user has the realm permissions, after uncheck and save, I am now able to see under NmidPDF tab {saying about unsupported archieving is no longer there}. Any hint about db errors? Btw your book is great!

[phalek]

Grab that SQL statement mentioned and try executing it using the mysql client on your cacti database. It should return some better error message.

I guess the availability was/is set in the settings and it still tries to put the data into the DB.

nmidCreatePDF is now CereusReporting. It was renamed with version 1.00 ( I think . I'm working on version 2.00 right now which changes all the nmdiCreatePDF strings into CereusReporting as well so this confusion then ends. Hit some bad issues with it though so it takes longer than expected.

Yeah, not perfect but ok ( the book ).

[MI1]

I fixed that error acording to howto described here:

Code: Select all

https://urbansoftware.zendesk.com/entries/20891776-the-availability-charts-do-not-get-updated

After fix hundreds of theese shows up:

Code: Select all

10/16/2012 02:07:10 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select * from host where id="  
10/16/2012 02:07:10 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select * from host where id="  

Is this still caused by nmidPDF plugin?

[phalek]

hm, that's quite vague.

You could upgrade to 1.83 though by just extracting the files from the archive available here http://redmine.nmid-plugins.de/projects ... epdf/files

Just click on the "cereus" tab to the top to upgrade.

[phalek]

Version 2.00.53 ALPHA is available for testing.

Please download this ALPHA version from here:

http://redmine.nmid-plugins.de/attachme ... PHA.tar.gz

Download the appropriate "parallelGraphRetriever" file from here.

http://redmine.nmid-plugins.de/attachme ... -32bit.zip
http://redmine.nmid-plugins.de/attachme ... -64bit.zip
http://redmine.nmid-plugins.de/attachme ... -32bit.zip
http://redmine.nmid-plugins.de/attachme ... -64bit.zip

You can use the following license file which is valid until 31-Dec-2012:
http://redmine.nmid-plugins.de/attachme ... ec2012.zip

Please note, you cannot use your existing license file to unlock version 2.00.

Customers which had a valid support contract on 1.Aug.2012 will receive new license files when Version 2.00 has been released.


Upgrade Notes:

Extract the "CereusReporting_Corporate_v2.00.53-ALPHA.tar.gz" file to the /path/to/cacti/plugins directory.
You should then have both "nmidCreatePDF" AND "CereusReporting" within the plugins directory.

Go to Cacti -> Plugin Management and "Install" + "Enable" the "CereusReporting" Plugin.
Important: Do NOT disable or uninstall the "nmidCreatePDF" plugin !

Check that the CereusReporting Plugins is now enabled. The nmidCreatePDF plugin should now list as not installed and disabled automatically.

If you have created a cron entry for the "cron_pdf_scheduler.php" file, change it to the new path.

Check the "Debug Info" page if it lists "2.00.53" as the Plugin Version.

Bug Reporting:
Please report bugs to support@urban-software.de or directly at https://urbansoftware.zendesk.com

[phalek]

Build 2.0.0.55 ALPHA has been released fixing some migration and access issues.

Grab it here: http://redmine.nmid-plugins.de/projects ... epdf/files

If you are upgrading from 1.8x use the following steps ( on Centos ...)

Code: Select all

cd /var/www/html/cacti/plugins
wget http://redmine.nmid-plugins.de/attachments/download/363/CereusReporting_Corporate_v2.00.53-ALPHA.tar.gz
tar -xzvf CereusReporting_Corporate_v2.00.53-ALPHA.tar.gz
cd /var/www/html/cacti/plugins/CereusReporting
wget http://redmine.nmid-plugins.de/attachments/download/364/License_v2.00-ALPHA_valid_until_31Dec2012.zip
unzip License_v2.00-ALPHA_valid_until_31Dec2012.zip
wget http://redmine.nmid-plugins.de/attachments/download/355/parallelGraphRetriever-linux-32bit.zip
unzip parallelGraphRetriever-linux-32bit.zip
chmod +x parallelGraphRetriever
cd /var/www/html/cacti/plugins/CereusReporting/ReportEngines/
cp -R ../../nmidCreatePDF/ReportEngines/mpdf .
/var/www/html/cacti/plugins/CereusReporting
chown -R cacti.apache *

[killshoot]

Hi,

I just installed NmidCreatePDF 1.83.42. Everything seems ok till the point 2.5.1 Basic Configuration. If I go to seeting -> NMID, I don't have the required checkbox.

If I go to graphs page, I don't have the possibility to export the graphs to PDF. Have missed something? With the new version it is no more requiered to patch cacti tree?

My Cacti Version 0.8.8a, settings: 0.71

Nmdi debug:

Code: Select all

Dir: /usr/local/share/cacti/plugins/nmidCreatePDF 
Main Dir:  /usr/local/share/cacti/ 
PHP_SELF:  /cacti/plugins/nmidCreatePDF/nmidCreatePDF_debug.php 
Cacti URL:  /cacti/ 
PIA Version:  3.1 
Edition:  EXPRESS 
License Expiry:  never 
Licensed Server:  TRUE 
Operating System:  FreeBSD hipscacbe01.sharedtcs.net 8.2-STABLE FreeBSD 8.2-STABLE #0: Mon Mar 14 12:22:45 CET 2011 root@htmncacti01.sharedtcs.net:/usr/obj/usr/src/sys/GENERIC amd64 

--------------------------------------------------------------------------------
 
Plugin Settings: 
PHP Path  
PHP Version  
PDF Engine  
Plugin Version 1.83.42 

--------------------------------------------------------------------------------
 
Licensed Modules: 
Availability module disabled 
Report Scheduling module disabled 
Zenoss module disabled 
DSStats module disabled 
MultiReports module disabled 
Archiving module disabled 
Templating module disabled 

--------------------------------------------------------------------------------
 
File/Directory Settings: 
tmp directory /usr/local/share/cacti/plugins/nmidCreatePDF/tmp 
tmp directory exists yes 
tmp directory writeable yes 
tmp directory - can create dirs yes 

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

--------------------------------------------------------------------------------
 
Required Cacti Plugins: 
settings installed 

--------------------------------------------------------------------------------
 
Optional Cacti Plugins: 
storeLastPoll missing 

--------------------------------------------------------------------------------
 
Optional PHP Modules: 
curl disabled 
ChartDirector PHP API disabled 

--------------------------------------------------------------------------------
 
Installed CereusReporting Extenstions: 
File parallelGraphRetriever exists  ( /usr/local/share/cacti/plugins/nmidCreatePDF/parallelGraphRetriever ) 

--------------------------------------------------------------------------------

Plugin Tables
Table Name Status 
plugin_nmidCreatePDF_Reports_scheduler exists 
plugin_nmidCreatePDF_Reports exists 
plugin_nmidCreatePDF_Archives exists 
plugin_nmidCreatePDF_UserGroups exists 
plugin_nmidCreatePDF_UserGroupList exists 
plugin_nmidCreatePDF_UserReportList exists 
plugin_nmidCreatePDF_UserGroupReports exists 
plugin_nmidCreatePDF_GraphReports exists 
plugin_nmidCreatePDF_MultiGraphReports exists 
plugin_nmidCreatePDF_DSStatsReports exists 
plugin_nmidCreatePDF_ZenossReports exists 
plugin_nmidCreatePDF_Reports_Types exists 
plugin_nmidCreatePDF_Availability_Table exists 
plugin_nmidCreatePDF_Availability_Change_Table exists 
plugin_nmidCreatePDF_Availability_SLATimeFrame_Table exists 
plugin_nmidCreatePDF_Availability_SLATimeFrameItems_Table exists 
plugin_nmidCreatePDF_Availability_Change_Type exists 

--------------------------------------------------------------------------------

Plugin Hooks
Hook Name Status 
api_device_save registered 
tree_after registered 
draw_navigation_text registered 
poller_bottom registered 
top_header_tabs registered 
top_graph_header_tabs registered 
console_after registered 
page_buttons registered 

[phalek]

please set the full path to your php binary and make sure that the parallelGraphRetriever file is executable.

Also disable the SourceGuardian PHP module.

v0.8.8a does include everything, there's no manual change needed.

[killshoot]

Hi,

Thank you for your fast reply.

=> please set the full path to your php binary --> I set the same path than cacti Path settings. should be ok
=>and make sure that the parallelGraphRetriever file is executable --> -rwxr-xr-x 1 cacti www 1039572 Oct 22 20:52 parallelGraphRetriever
=> Also disable the SourceGuardian PHP module --> is now disabled, I see this in the debug page.

But I still don't see the required checkboxes into the settings-> NMID page and I still don't see the described toolbar in the Initial test section of your install guide

Many thanks for your help
Vince

[phalek]

Please check the realm permissions of your users. It may be missing,