PDF Report issue

[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

[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.

[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.

[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

[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

[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

[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

[lmiltchev]

Can you also run the following commands and show us the output?

Code: Select all

which wkhtmltopdf
wkhtmltopdf -V

[jespir]

[nagios@nwmonitor-01 ~]# which wkhtmltopdf
/usr/bin/wkhtmltopdf

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

[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?