Host graphs per hostgroup as a monthly report

[DennisPR]

Hi,

The host graphs feature gives you a nice overview of all the performance data that was captured by Nagios XI.
I was just wondering if it's possible to make a report of all the host graphs in a certain hostgroup.
It would be even nicer if I could get it in a mail as a monthly report.

Regards
Dennis

[slansing]

You could add the graphs individually to a dashboard, and then use the "schedule page button" on the top right hand portion of the main menu bar to schedule that entire dashboard as a report. Would that work for you?

[DennisPR]

Adding the grapsh to a scheduled dashboard would do the trick however it seems to have some issues if the generated report contains more than 1 page.

I have added about 13 graphs in total to the dashboard and it should be printed on 4 pages at +/- 4 graphs per page
I can open the dashboard in my browser without any problem but if I print it something goes wrong.

• If I print from Internet Exlorer the browser crashes => Internet Explorer has stopped working : A problem caused the program to stop working correctly. Winsows will close the program....
• If I print from Firefox it always prints 2 pages. The 1st page is perfect but on the second page it show all the graphs on top of each other. It seems that there is a 1 page limit ?
  This is how the 2nd page looks like.
  Report.PNG
• If I schedule the report to send a PDF by mail it works fine if the PDF is only 1 page. I don't receive anything at all if I add more that 7 graphs split over 2 pages
  How can I troubleshoot not getting the report ? Which log files can I check ?

[lmiltchev]

What is the version of Nagios XI that you are currently using? Run the following commands and show us the output:

Code: Select all

/usr/bin/wkhtmltopdf --version
/usr/bin/wkhtmltoimage --version

When you view the report under "Schedule Reports" (by clicking on the "View" action button) does it look correct? How did you lay out the dashlets on the dashboard (2 columns, 3 columns, etc.)?

Do you have any errors in the apache error log, when you try to email the report by clicking on "Send Now"?

Code: Select all

tail -50 /var/log/httpd/error_log

[DennisPR]

I am using Nagios XI 2014 R2.6

Code: Select all

[root@ap-dco67-mon log]# /usr/bin/wkhtmltopdf --version
wkhtmltopdf 0.12.1-c22928d (with patched qt)
[root@ap-dco67-mon log]# /usr/bin/wkhtmltoimage --version
wkhtmltoimage 0.12.1-c22928d (with patched qt)

As long as I view the dashboard/report in a browser everything works fine. It's only the generated PDF files that don't seem to work if it's more than 1 page.

Code: Select all

[root@ap-dco67-mon ~]# tail -50 /var/log/httpd/error_log
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[Fri Feb 20 09:20:55 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?cmd=modify&type=host&id=1225&page=1&returnUrl=index.php%3Fcmd%3Dview%26type%3Dhost%26page%3D1
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[Fri Feb 20 09:20:57 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?type=host&page=1
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[Fri Feb 20 09:21:22 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?cmd=modify&type=host&id=1226&page=1&returnUrl=index.php%3Fcmd%3Dview%26type%3Dhost%26page%3D1
[Fri Feb 20 09:21:25 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 176, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?type=host&page=1
[Fri Feb 20 09:21:25 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?type=host&page=1
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[Fri Feb 20 09:22:45 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?cmd=modify&type=host&id=1224&page=1&returnUrl=index.php%3Fcmd%3Dview%26type%3Dhost%26page%3D1
[Fri Feb 20 09:23:43 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 176, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?type=host&page=1
[Fri Feb 20 09:23:43 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php?type=host&page=1
[Fri Feb 20 09:23:53 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 176, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
[Fri Feb 20 09:23:53 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
[Fri Feb 20 09:24:01 2015] [error] [client 10.70.0.59] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 10747902 bytes) in /usr/local/nagiosxi/html/includes/utils-reports.inc.php on line 475, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/reports/
[Fri Feb 20 09:24:07 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 176, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
[Fri Feb 20 09:24:07 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
[Fri Feb 20 09:24:33 2015] [error] [client 10.70.2.76] PHP Notice:  Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 389, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/dashboards/dashboard.php?id=c5m5dk8t
[Fri Feb 20 09:25:20 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 176, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
[Fri Feb 20 09:25:20 2015] [error] [client 10.70.0.93] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 196, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/includes/components/ccm/index.php
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
PHP Warning:  Module 'PDO' already loaded in Unknown on line 0
PHP Warning:  Module 'pdo_mysql' already loaded in Unknown on line 0
[Fri Feb 20 09:30:16 2015] [error] [client 10.70.2.76] PHP Notice:  Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 389, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/dashboards/dashboard.php?id=c5m5dk8t
[Fri Feb 20 09:36:05 2015] [error] [client 10.70.2.76] PHP Notice:  Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 389, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/dashboards/dashboard.php?id=c5m5dk8t
[Fri Feb 20 09:41:58 2015] [error] [client 10.70.2.76] PHP Notice:  Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 389, referer: http://ap-dco67-mon.bel.centric.lan/nagiosxi/dashboards/dashboard.php?id=c5m5dk8t

[jomann]

I just did this with a test dashboard and scheduled a one time report to send to my email and my PDF had all 4 graphs over 2 pages. I'm curious where are your graphs located on the dashboard? Are they all 1 after another or are they side-by-side? Also, how were you sending the PDF? As a one time send or were you scheduling it just a few minutes out?

[DennisPR]

I can't upload a PDF document to this forum. Can I mail it to the a support email address pls ?

[tmcdonald]

You can email [email protected] to open an email ticket, otherwise PM the file to myself and I will make sure the team can see it.

[abrist]

Issue is resolved. Unlocked at the request of OP so that they can update the thread with resolution.

[DennisPR]

Problem solved after fixing some settings in the PHP.ini

Code: Select all

Set max_execution_time = 30  to 90
max_input_time = 60 to 120
memory_limit = 128M to 256M

And changing the max mail size on our SMTP server from 2MB to 10MB
Thx Nagios team for the great support !