SLA Report - PDF Error...Couldn't open PDF

[op-team]

Hi Guys,

We have the following error when trying to open the sla report pdf received from Nagios

pdf_error.JPG

We don't experience this issue with any other available reports (Availability, Capacity Planning, ... are ok).
From the Nagios web interface, we don't have any issue when running the sla report. The calculation of the SLA completes successfully

no error in /var/log/httpd/ssl_error.log but we get some errors in error_log

[root@nagios: /var/log/httpd]# tail -f error_log
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored
...
Read error (Connection timed out) in headers.==========> ] 90%
Retrying.

--2020-01-10 14:40:26-- (try: 2) https://nagios-01.vcloud.lu/nagiosxi//r ... 22b59c190a
Connecting to nagios-01.vcloud.lu|172.16.213.20|:443... connected.
WARNING: cannot verify nagios-01.vcloud.lu's certificate, issued by "/DC=LU/DC=VCLOUD/CN=VCLOUD-INFRA-CA-CA":
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... 200 OK
Length: 27 [text/html]
Saving to: "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578662725-SLA.pdf"

0K 100% 1.33M=0s

2020-01-10 14:40:26 (1.33 MB/s) - "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578662725-SLA.pdf" saved [27/27]

my php.ini looks like:
[root@nagios-01: /etc]# egrep "max_input_time|max_execution_time|memory_limit" php.ini
max_execution_time = 90
max_input_time = 90
memory_limit = 512M

My system settings:

system-settings.JPG

Thanks in advance for your help

[op-team]

Any ideas please?

wkhtmltopdf version installed on my NagiosXI:

[root@nagios-01: ~]# wkhtmltopdf -V
wkhtmltopdf 0.12.1.3 (with patched qt)
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltox
wkhtmltox.x86_64 1:0.12.1.3-1~centos6 @/wkhtmltox-0.12.1.3.el6.x86_64
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltopdf
[root@nagios-01: ~]#

Thanks in advance for your support

[tgriep]

The PHP settings you posted, double the values of them and restart Apache.
What settings are you using to run the report?

Run the report again. If you still cannot open it, try to open it up with a text editor to see if you can find any errors and then post it here.

e.g.

Code: Select all

cat /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578662725-SLA.pdf

[op-team]

Hi,

As suggested, i have double values in php.ini

[root@nagios-01: /var/log/httpd]# egrep "max_execution_time|max_input_time|memory_limit" /etc/php.ini | grep -v ";"
max_execution_time = 180
max_input_time = 180
memory_limit = 1024M

My report settings:

sla_report.JPG

I ran the SLA report one more time but still can open the pdf file

[root@nagios-01: /var/log/httpd]# tail -f error_log
--2020-01-14 10:13:18-- https://nagios-01.vcloud.lu/nagiosxi//r ... 9a02246025
Resolving nagios-01.vcloud.lu... 172.16.213.20
Connecting to nagios-01.vcloud.lu|172.16.213.20|:443... connected.
WARNING: cannot verify nagios-01.vcloud.lu's certificate, issued by "/DC=LU/DC=VCLOUD/CN=VCLOUD-INFRA-CA-CA":
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... Loading pages (1/6)
Warning: SSL error ignored
...
Warning: SSL error ignored
Read error (Connection timed out) in headers.==========> ] 90%
Retrying.

--2020-01-14 10:28:19-- (try: 2) https://nagios-01.vcloud.lu/nagiosxi//r ... 9a02246025
Connecting to nagios-01.vcloud.lu|172.16.213.20|:443... connected.
WARNING: cannot verify nagios-01.vcloud.lu's certificate, issued by "/DC=LU/DC=VCLOUD/CN=VCLOUD-INFRA-CA-CA":
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... 200 OK
Length: 27 [text/html]
Saving to: "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578993198-SLA.pdf"

0K 100% 1.37M=0s

2020-01-14 10:28:19 (1.37 MB/s) - "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578993198-SLA.pdf" saved [27/27]

Warning: SSL error ignored
Warning: SSL error ignored
Warning: SSL error ignored

It was also impossible to have a look to the file "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578993198-SLA.pdf" as it doesnt exist.

[root@nagios-01: /var/log/httpd]# cat /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578993198-SLA.pdf
cat: /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-uLv7KeggkCCl-1578993198-SLA.pdf: No such file or directory

[tgriep]

What version of Nagios XI is the server running?

Can you post the following files here so we can check them?

Code: Select all

/etc/httpd/conf/httpd.conf
/etc/httpd/conf.d/ssl.conf
/etc/httpd/conf.d/nagiosxi.conf
/etc/hosts

Run this as root and post the version number.

Code: Select all

wkhtmltopdf -V

If you select the Period for the last 24 hours, does the PDF file get created?

[tobias.clement]

I'am running a Nagios XI 5.6.8 on a Cent0s 6.10

/etc/httpd/conf/httpd.conf

httpd.conf

/etc/httpd/conf.d/ssl.conf

ssl.conf

/etc/httpd/conf.d/nagiosxi.conf

[root@nagios-01: ~]# grep -v "#" /etc/httpd/conf.d/nagiosxi.conf
<Directory "/usr/local/nagiosxi/html">
Options None
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Alias /nagiosxi "/usr/local/nagiosxi/html"

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule nagiosxi/api/v1/(.*)$ /usr/local/nagiosxi/html/api/v1/index.php?request=$1 [QSA,NC,L]
</IfModule>

/etc/hosts

[root@nagios-01: ~]# grep -v "#" /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.xx.xx.xx nagios-01.vcloud.lu nagios-01

wkhtmltopdf version installed on my NagiosXI

[root@nagios-01: ~]# wkhtmltopdf -V
wkhtmltopdf 0.12.1.3 (with patched qt)
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltox
wkhtmltox.x86_64 1:0.12.1.3-1~centos6 @/wkhtmltox-0.12.1.3.el6.x86_64
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltopdf
[root@nagios-01: ~]#

I ran the report for the last 24hours without issue

[root@nagios-01: /usr/local/nagiosxi/tmp]# tail -f /var/log/httpd/error_log
...
--2020-01-15 10:39:47-- https://nagios-01.vcloud.lu/nagiosxi//r ... 0d06de3648
Resolving nagios-01.vcloud.lu... 172.16.213.20
Connecting to nagios-01.vcloud.lu|172.16.213.20|:443... connected.
WARNING: cannot verify nagios-01.vcloud.lu's certificate, issued by "/DC=LU/DC=VCLOUD/CN=VCLOUD-INFRA-CA-CA":
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... Loading pages (1/6)
Warning: SSL error ignored
...
Warning: SSL error ignored
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Done
200 OK
Length: unspecified [application/pdf]
Saving to: "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf"

0K .......... .......... .......... .. 955K=0.03s

2020-01-15 10:40:50 (955 KB/s) - "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf" saved [32988]

I couldn't get file in CLI

[root@nagios-01: ~]# cat /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf
cat: /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf: No such file or directory

but i was able to open the report pdf received via email

report-24h.JPG

It seems like monthy sla report is being interrupted by a timeout. Please help.
Thanks

[op-team]

Hi,

I'm running NagiosXI 5.6.8 on a Cent0s 6.10

/etc/httpd/conf/httpd.conf

httpd.conf

/etc/httpd/conf.d/ssl.conf

ssl.conf

/etc/httpd/conf.d/nagiosxi.conf

[root@nagios-01: /usr/local/nagiosxi/tmp]# grep -v "#" /etc/httpd/conf.d/nagiosxi.conf
<Directory "/usr/local/nagiosxi/html">
Options None
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Alias /nagiosxi "/usr/local/nagiosxi/html"

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule nagiosxi/api/v1/(.*)$ /usr/local/nagiosxi/html/api/v1/index.php?request=$1 [QSA,NC,L]
</IfModule>

/etc/hosts

[root@nagios-01: ~]# grep -v "#" /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.xx.xx.xx nagios-01.vcloud.lu nagios-01

wkhtmltopdf version installed on my NagiosXI:

[root@nagios-01: ~]# wkhtmltopdf -V
wkhtmltopdf 0.12.1.3 (with patched qt)
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltox
wkhtmltox.x86_64 1:0.12.1.3-1~centos6 @/wkhtmltox-0.12.1.3.el6.x86_64
[root@nagios-01: ~]# yum list installed | grep -i wkhtmltopdf
[root@nagios-01: ~]#

I ran the sla report for the last 24hours without issue

[root@nagios-01: /usr/local/nagiosxi/tmp]# tail -f /var/log/httpd/error_log
...
Warning: SSL error ignored
...
--2020-01-15 10:39:47-- https://nagios-01.vcloud.lu/nagiosxi//r ... 0d06de3648
Resolving nagios-01.vcloud.lu... 172.16.213.20
Connecting to nagios-01.vcloud.lu|172.16.213.20|:443... connected.
WARNING: cannot verify nagios-01.vcloud.lu's certificate, issued by "/DC=LU/DC=VCLOUD/CN=VCLOUD-INFRA-CA-CA":
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... Loading pages (1/6)
Warning: SSL error ignored
...
Warning: SSL error ignored
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Done
200 OK
Length: unspecified [application/pdf]
Saving to: "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf"

0K .......... .......... .......... .. 955K=0.03s

2020-01-15 10:40:50 (955 KB/s) - "/usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf" saved [32988]

I couldn't get the file pdf in CLI

[root@nagios-01: ~]# cat /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf
cat: /usr/local/nagiosxi/tmp/scheduledreport-itop-nwuc-lWOlkYrgin5v-1579081187-SLA.pdf: No such file or directory

But I was able to open the report received via mail

report-24h.JPG

It seems like my monthly sla report is being interrupted by a timeout. Please help.
Thanks

[tgriep]

How long does it take for web browser to show the Couldn't open PDF after you click the button to download it?

Run the report for 30 days, wait for about 10 to 20 seconds and run this as root and post the output.

Code: Select all

top -bcn1 | head -n 20
ps -ef --cols=300

How many host and services are configured on the server and how many do you select when you run the report?
What version of XI is the server running?

Running reports is very I/O intensive and is the server is hosted in a virtual environment, can it be moved to a faster disk sub-system?