Page 1 of 2

PDF Report issue

Posted: Wed Sep 17, 2014 4:59 am
by jespir
We are having an issue with the PDF-reporting. Scheduled reports come up empty via email and if we click the PDF icon in any of the reports, the interface becomes unresponsive and must be restarted with service httpd restart.

HTTP-logs do not show anything that exiting (errors and such). Sometimes we can see the report appearing in nagiosxi/tmp/scheduledreport-xxx.pdf. Yet we never see these reports in browser.

Version NagiosXI 2014r1.4

Re: PDF Report issue

Posted: Wed Sep 17, 2014 4:33 pm
by slansing
Is the report that is coming in via email "pdf" completely blank? Is it 0 bytes in size? Also, would it be possible for you to go through the rebuild process for wkhtmltopdf?:

http://support.nagios.com/forum/viewtop ... 16&t=11175

There were some issues early on in the 2014 release that should have been resolved by now, your system may have one of those latent bugs.

Re: PDF Report issue

Posted: Thu Sep 18, 2014 12:55 am
by jespir
The PDF inside email is completely empty. There is nothing when examined via text editor. I did the rebuild as per the other thread.
This did not help.

I have now tested running different reports for several times and did not see any output at /usr/local/nagiosxi/tmp/. However there are some files that have been successfully created as valid PDF-files.

Re: PDF Report issue

Posted: Thu Sep 18, 2014 3:32 pm
by abrist
What specific reports cause the issue? i suspect that the problematic ones require access to the db, specifically large tables or crashed tables that are causing a timeout. Lets check the table sizes and the mysqld logs:

Code: Select all

grep crashed /var/log/mysqld.log

Code: Select all

 ls -lahS /var/lib/mysql/nagios | head -15

Re: PDF Report issue

Posted: Fri Sep 19, 2014 3:27 am
by jespir
Well there are no specific reports that cause the issue. It seems that at random some reports are able to create PDF in the /usr/local/nagiosxi/tmp/ directory. Yet it never shows these PDF's to the user. I just found out these by accessing the directory via shell. The successful PDF's have been hostgroup summaries, host summaries etc.

Code: Select all

grep crashed /var/log/mysqld.log
There is no crashed strings found in mysqld.log

Code: Select all

ls -lahS /var/lib/mysql/nagios | head -15
[root@nwmonitor-01 ~]# ls -lahS /var/lib/mysql/nagios | head -15
total 6.7M
-rw-rw----. 1 mysql mysql 1.4M Sep 19 11:21 nagios_logentries.MYD
-rw-rw----. 1 mysql mysql 1.3M Sep 19 11:20 nagios_notifications.MYD
-rw-rw----. 1 mysql mysql 1.1M Sep 19 11:21 nagios_logentries.MYI
-rw-rw----. 1 mysql mysql 395K Sep 19 11:20 nagios_notifications.MYI
-rw-rw----. 1 mysql mysql 257K Sep 19 11:21 nagios_statehistory.MYD
-rw-rw----. 1 mysql mysql 220K Sep 19 11:20 nagios_contactnotifications.MYI
-rw-rw----. 1 mysql mysql 153K Sep 19 11:20 nagios_contactnotificationmethods.MYI
-rw-rw----. 1 mysql mysql 144K Sep 19 11:20 nagios_contactnotificationmethods.MYD
-rw-rw----. 1 mysql mysql 128K Sep 19 11:17 nagios_contactnotifications.MYD
-rw-rw----. 1 mysql mysql 85K Sep 19 11:21 nagios_servicestatus.MYD
-rw-rw----. 1 mysql mysql 77K Sep 19 11:21 nagios_servicestatus.MYI
-rw-rw----. 1 mysql mysql 69K Sep 19 11:21 nagios_statehistory.MYI
-rw-rw----. 1 mysql mysql 60K Sep 19 11:20 nagios_objects.MYI
-rw-rw----. 1 mysql mysql 57K Sep 19 11:21 nagios_hoststatus.MYI

Re: PDF Report issue

Posted: Fri Sep 19, 2014 1:52 pm
by lmiltchev
Do you have a valid "Program URL" and/or "External URL" defined under the "System Settings" page (Admin->Manage System Config)?
Run the following command and show us the output:

Code: Select all

cat /etc/hosts

Re: PDF Report issue

Posted: Mon Sep 22, 2014 3:30 am
by jespir
Program URL is valid http://172.20.120.20/nagiosxi/. No external URL has been specified.

[nagios@nwmonitor-01 temp]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

172.20.120.20 nwmonitor-01

Re: PDF Report issue

Posted: Mon Sep 22, 2014 4:05 pm
by lmiltchev
Can you also run the following commands and show us the output?

Code: Select all

which wkhtmltopdf
wkhtmltopdf -V

Re: PDF Report issue

Posted: Tue Sep 23, 2014 12:04 am
by jespir
[nagios@nwmonitor-01 ~]# which wkhtmltopdf
/usr/bin/wkhtmltopdf

[nagios@nwmonitor-01 ~]$ wkhtmltopdf -V
wkhtmltopdf 0.12.1-c22928d (with patched qt)

Re: PDF Report issue

Posted: Tue Sep 23, 2014 1:43 pm
by lmiltchev
It would be easier to troubleshoot the issue if you could open an email support ticket by emailing us at [email protected]. I am not sure if you are a customer though. You posted on the "General Support" forum, but many of our customers do. Let me know if you can open a email ticket. We will probably end up scheduling a remote session to further troubleshoot the issue.
BTW, did you purchase Enterprise or you are using the trial?