Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jul 20, 2017 1:45 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 950 posts ]  Go to page Previous  1 ... 59, 60, 61, 62, 63, 64  Next
Author Message
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Mon May 23, 2016 8:03 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Version 2.90 has been released. It contains some bug fixes and code rewrites to prepare for the 3.00 version:

  • DB access Migration to PDO
  • Use Cacti integrated logging
  • Fix for scheduled reports not being send when logging set to debug
  • Preparation to separate availability module into external addon
  • Smaller plugin size

The new version can be downloaded here: https://www.urban-software.com/products ... downloads/

Updated install and setup guides will follow soon.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Last edited by phalek on Mon May 23, 2016 9:15 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Mon May 23, 2016 9:11 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
The installation guides have been corrected with the new URLs

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Mon Jun 13, 2016 12:43 pm 
Offline

Joined: Sun Jun 07, 2015 3:19 pm
Posts: 11
Using latest 2.90.1 express on CentOS 6 (with it's php 5.3) with Cacti 0.8.8h from EPEL repo.
The "Add graphs to report" button doesn't work.
I am able to generate a quick report with using the "Create PDF Report" button.
This is what happens when I press the "Add graphs to report" button in the php log:
Code:
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: dsstats_name in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 41
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: ReportId in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 42
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined index: nmid_pdfAddSubLeafs in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 45
Jun 13 19:53:19 npls4 httpd: PHP Notice:  Undefined variable: val in /usr/share/cacti/plugins/CereusReporting/addToGraphReport.php on line 49

Of course this immediately gives the following in Cacti's log:
Code:
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT reportType FROM plugin_nmidCreatePDF_Reports WHERE ReportId="
Jun 13 19:53:19 npls4 Cacti[23428]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT MAX(`order`) FROM plugin_nmidCreatePDF_GraphReports WHERE ReportId="


Another few oddities:
  • CereusReporting_messages.log is empty, regardless of the level. I do not see any permissions error (and via eye inspection it looks fine), is there a way to set its directory to /tmp (instead of under Cacti's plugins)?
  • If I enable "Add availaibility table to tree view", I get "CereusReporting/modules/availability/polling_functions.php was encoded#012with the PHP 5.5 ionCube Encoder and requires PHP 5.5 to be installed." and no graphs displayed when browsing graphs (reminder CentOS 6 with php 5.3).
  • I am able to create report by manually adding items from the console -> Manage Reports -> <report> -> Items for this report -> add. however there is a small glitch there too, on the first empty report it immediately shows a broken image under "preview" because of a "Validation error." from the query string: "graph_image.php?local_graph_id=&rra_id=0&view_type=tree&graph_start=1465835727&graph_end=1465839327"
  • This is not really a problem but just an eyesore: If I define a report with many empty fields I get multiple undefined variable notices in php:
    Quote:
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printHeader in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 208
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printFooter in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 214
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_skipHFCoverPage in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 220
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printHeader in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 278
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_printFooter in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 278
    Jun 13 20:33:10 npls4 httpd: PHP Notice: Undefined variable: s_skipHFCoverPage in /usr/share/cacti/plugins/CereusReporting/CereusReporting_addReport.php on line 279
  • I had to disable the CSRF in Cacti as the plugin didn't work with it.

Hope someone will be able to help me... :(
Thanks


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 2:32 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Hi

CereusReporting_messages.log is empty due to 2.90 using the Cacti.log for logging. The particular isssues you are seeing doesn't have any log messags though :-)

All other errors should be fixed in 2.90.02 which you can get here: https://www.urban-software.com/products ... downloads/

You can open bug reports like these on the Support Portal as well

Thanks again for reporting this issue.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 6:09 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Feature List for Version 3.0 ( Beta version to be released in July 2016 ):

Standard Edition
  • Compliance with the CSRF addon (csrf-magic )
  • Integration of the parallelGraphRetriever tool
  • On-Demand reports are created in the background. Users will be notfied when completed ( non-blocking mode )
  • Ability to add graphs/hosts using RegEXP
  • Send-via-email feature for on-demand reports

Additional Personal/Professional/Business Edition Features
  • Additional Report templates
  • Email Templates for scheduled reports
  • New report items ( e.g Pie Charts for interface utilization )

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Last edited by phalek on Tue Jun 14, 2016 9:18 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 6:17 am 
Offline

Joined: Sun Jun 07, 2015 3:19 pm
Posts: 11
phalek wrote:
Hi
All other errors should be fixed in 2.90.02 which you can get here: https://www.urban-software.com/products ... downloads/

You can open bug reports like these on the Support Portal as well

Thanks again for reporting this issue.

Thank you very much!
While at it, there was another similar issue with StoreLastPoll which gave the following errors in the log, thus disabled, perhaps it's the same/related/similar issue:
Code:
php: PHP Notice:  Undefined index:  in /usr/share/cacti/plugins/storeLastPoll/setup.php on line 27
php: PHP Warning:  Variable passed to each() is not an array or object in /usr/share/cacti/plugins/storeLastPoll/setup.php on line 28


Again, be happy to assist in any way possible, kind regards, Nitzan.
I've posted it also in the support portal.


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 7:10 am 
Offline

Joined: Sun Jun 07, 2015 3:19 pm
Posts: 11
phalek wrote:
Feature List for Version 3.0 ( Beta version to be released in July 2016 ):

Standard Edition
  • Compliance with the CSRF adding (csrf-magic )
  • Integration of the parallelGraphRetriever tool
  • On-Demand reports are created in the background. Users will be notfied when completed ( non-blocking mode )
  • Ability to add graphs/hosts using RegEXP
  • Send-via-email feature for on-demand reports

Additional Personal/Professional/Business Edition Features
  • Additional Report templates
  • Email Templates for scheduled reports
  • New report items ( e.g Pie Charts for interface utilization )


Hi, Thanks for this. I actually personally bought and read your book (even bought outside work).

My use case is a lab for testing applications on various hardware, so this is hardly your primary IT/enterprise environment, thus most of the enterprise and even the standard edition's features are not/won't be used...
But I have a very unique use case that hadn't been tackled yet: I often compare tests, meaning 'times' are meaningful sometimes for different tests.
An ability to compare tests from different times or maybe create 'aggregate' graphs of different times... I'm not sure.

Thank you for the hard work and the great book.


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 7:23 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Hm. That's a feature that can be added.

If I get it correct, you probably want to have 2 different time-frames within the same report. E.g.


Test 1 - Start 08:00 - End 08:30
<Graph of Device 1 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 1 - DataSource 1>

Test 1 - Start 08:00 - End 08:30
<Graph of Device 2 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 2 - DataSource 1>


Would this be helpful ?

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Tue Jun 14, 2016 9:31 am 
Offline

Joined: Sun Jun 07, 2015 3:19 pm
Posts: 11
phalek wrote:
Hm. That's a feature that can be added.

If I get it correct, you probably want to have 2 different time-frames within the same report. E.g.


Test 1 - Start 08:00 - End 08:30
<Graph of Device 1 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 1 - DataSource 1>

Test 1 - Start 08:00 - End 08:30
<Graph of Device 2 - DataSource 1>

Test 2 - Start 09:00 - End 09:30
<Graph of Device 2 - DataSource 1>


Would this be helpful ?


YES! Sounds exactly right! AND (though it's hardly a straight reporting issue) sometimes it's even useful to see things on the same graphs (like aggregate does but can't do between different timeframes. but that's another issue).
Edit: just to clarify: your proposal is fantastic as is.

Had a chance to check the StoreLastPoll similar issue (which still exists. BTW what is it used for?).

Your insights and responses are very appreciated.


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Wed Jun 15, 2016 12:28 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
storeLastPoll is only used for getting Windows Service Availability.

If you only want the PDF part, then it's not required at all.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Wed Jun 15, 2016 8:43 am 
Offline

Joined: Sun Jun 07, 2015 3:19 pm
Posts: 11
That's great to know.
Generally speaking I hadn't found any descent documentation about it (not how it works [like what you've just said] nor how to work with it [inc. tempting, etc.]).


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Thu Sep 08, 2016 8:50 am 
Offline

Joined: Thu Sep 08, 2016 8:48 am
Posts: 3
anyone who wants to use this on windows: make sure the path to php.exe does not contain blank spaces. if needed, replace it with PROGRA~2 or the equivalent in you path (dir /X).

This solved the issue with graph images being replaced with 'Error opening the file' images for me.


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Thu Sep 08, 2016 9:01 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Thanks nikdubois for reporting this.

I'll check if I can put some error message to that into the plugin

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Thu Sep 08, 2016 11:21 am 
Offline

Joined: Thu Sep 08, 2016 11:15 am
Posts: 1
Hi administrator`s Cereus,

hi have a license EXPRESS, but I do not meet the requirements following:
Edition: Express Edition . Requirements for SMB Edition not met: [ 1740 out of 200 used ]- Get Corporate Professional or Business Edition

this can cause me not generate reports ?

Thanks


Top
 Profile  
 
 Post subject: Re: CereusReporting - PDF/HTML Cacti Reports - v2.90 out !
PostPosted: Fri Sep 09, 2016 4:09 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2595
Location: Kressbronn, Germany
Hi

Report scheduling will not work as well as some other features.

Look here fore more details:
https://www.urban-software.com/products ... for-cacti/

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 950 posts ]  Go to page Previous  1 ... 59, 60, 61, 62, 63, 64  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group