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

[phalek]

Will be posted soon.

The beta version has been tested successfully, the release version has not been fully tested yet.

[phalek]

CereusReporting 1.76.32 is compatible with Cacti 0.8.7h.

[phalek]

The next upcoming version of CereusReporting will add several new features:

- Create SLA reports based on Thold thresholds
- Add SQL Reports from remote database servers
- Add support for the "Maint" plugin ( add maintenance windows for devices )

Stay tuned !

[phalek]

A first step towards the next version has been accomplished by adding support for Windows Services availability data.

Attached is a screenshot of an early version of this feature:

WinService_Availability.png (21.75 KiB) Viewed 3833 times

[phalek]

Here's an example report which includes the Windows Services Availability chart ( on the very last page ).

[phalek]

WinServices is nearly complete now.

The upcoming release will also support mutiple SLA times for a host ( e.g. Mo -> 00:00 - 03:00, 04:00-23:59, Tue-Sun -> 00:00-23:59 )

It will also be possible to create special tree items which can display Weathermaps, Thold data or Availability data. See the attached screenshots for a preview.

Thold Data:

Special_Tree_items.png (58.66 KiB) Viewed 3811 times

Weathemaps:

Special_Tree_items_weathermap.png (95.56 KiB) Viewed 3811 times

Availability Charts:

Special_Tree_items_winservices.png (67.06 KiB) Viewed 3811 times

No code replacements is needed, this feature is fully compatible with Cacti 0.8.7g/h and Pia !

[brightm]

Does any one know why i would be getting the following error:

[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 1. {main}() C:\\wamp\\www\\cacti\\settings.php:0, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 2. include() C:\\wamp\\www\\cacti\\settings.php:25, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 3. include() C:\\wamp\\www\\cacti\\include\\auth.php:25, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 4. include_once() C:\\wamp\\www\\cacti\\include\\global.php:208, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 5. api_plugin_hook() C:\\wamp\\www\\cacti\\include\\global_settings.php:1193, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 6. nmidCreatePDF_config_settings() C:\\wamp\\www\\cacti\\lib\\plugins.php:62, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:24 2011] [error] [client 10.100.100.105] PHP 7. mysql_fetch_assoc() C:\\wamp\\www\\cacti\\plugins\\nmidCreatePDF\\setup.php:941, referer: http://10.100.100.105/cacti/settings.php
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\\wamp\\www\\cacti\\plugins\\nmidCreatePDF\\setup.php on line 941, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP Stack trace:, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 1. {main}() C:\\wamp\\www\\cacti\\settings.php:0, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 2. include() C:\\wamp\\www\\cacti\\settings.php:25, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 3. include() C:\\wamp\\www\\cacti\\include\\auth.php:25, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 4. include_once() C:\\wamp\\www\\cacti\\include\\global.php:208, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 5. api_plugin_hook() C:\\wamp\\www\\cacti\\include\\global_settings.php:1193, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 6. nmidCreatePDF_config_settings() C:\\wamp\\www\\cacti\\lib\\plugins.php:62, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP 7. mysql_fetch_assoc() C:\\wamp\\www\\cacti\\plugins\\nmidCreatePDF\\setup.php:941, referer: http://10.100.100.105/cacti/settings.php?tab=nmid
[Fri Dec 09 12:36:37 2011] [error] [client 10.100.100.105] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\\wamp\\www\\cacti\\plugins\\nmidCreatePDF\\setup.php on line 941, referer: http://10.100.100.105/cacti/settings.php?tab=nmid

Any help appreciated thanks.

[phalek]

Hi

Can you first check if the following table contains any items:

plugin_nmidCreatePDF_Availability_SLATimeFrame_Table

if not, please execute the following in the mysql cli:

Code: Select all

INSERT INTO `plugin_nmidCreatePDF_Availability_SLATimeFrame_Table` (`id`,`defaultDays`,`defaultStartTime`,`defaultEndTime`,`shortDescription`,`longDescription` ) VALUES (1,'Mon,Tue,Wed,Thu,Fri,Sat,Sun','00:00','23:59','24x7','Default SLA TimeFrame');

[brightm]

I can't actually see that table at all (assuming it's in the cacti database). Will the command you gave me create the table?

Thanks

[phalek]

No, it should be installed/created when you install and enable the plugin. Trreinstalling it

[brightm]

Tried that -no go. Is there a way of manually doing it, by importing the sql db?

Thanks

[phalek]

Is your DB user able to create tables in the DB, e.g do you have other plugins installed ?

What is the "Debug Info" page saying in regard to the tables ( at the bottom of that page ).

Unfortunately, there's no SQL file for importing

[brightm]

Yes installed plugins before with no problem but maybe somethings up with the permissions now.

Sorry where's the debug info found?

Thanks

[phalek]

Once installed, it can be found in the menu.

[brightm]

Thanks as below for some reason the tables aren't being created:

CereusReporting Debug Page


--------------------------------------------------------------------------------
Dir: C:\wamp\www\cacti\plugins\nmidCreatePDF
Main Dir: C:\wamp\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: Windows NT CS-CONSOLE 5.2 build 3790 (Windows Server 2003 Enterprise Edition Service Pack 2, v.2825) i586

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

Plugin Settings:
PHP Path php
PHP Version PHP 5.2.11 (cli) (built: Sep 16 2009 19:39:46) Copyright (c) 1997-2009 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
PDF Engine FPDF
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 C:\wamp\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 disabled

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

Required Cacti Plugins:
settings installed

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

Optional PHP Modules:
curl disabled
ChartDirector PHP API disabled

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

Installed CereusReporting Extenstions:
File parallelGraphRetriever.exe exists ( C:\wamp\www\cacti\plugins\nmidCreatePDF\parallelGraphRetriever.exe )
File getSmokePingPath.exe does not exists ( C:\wamp\www\cacti\plugins\nmidCreatePDF\getSmokePingPath.exe )

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

Plugin Tables
Table Name Status
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

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

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