Page 1 of 2
SLA PDF Reports not Generating Properly
Posted: Sun Jun 30, 2019 7:33 pm
by MediaworksNZ
Hi,
I have NagiosXi Installed and working.
The issue i'm having is when SLA reports are generated into a PDF and emailed, the PDF is 1KB in size.
This is for all users.
Can you advise what logs can be monitored to try a find out what is causing this?
I can see that wkhtmltox.x86_64 is installed and marked in red.
Thank you for your help.
Craig
Re: SLA PDF Reports not Generating Properly
Posted: Mon Jul 01, 2019 2:09 pm
by benjaminsmith
Hi Craig,
Can you PM or attach the failed report to the post. Next, tail the Apache log file and then download a PDF of the SLA report your are generating. Open up a terminal on the Nagios server and run the following command:
generate the report and upload the output.
Lastly, please PM your system profile for us to review. Thanks.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket.
Re: SLA PDF Reports not Generating Properly
Posted: Tue Jul 02, 2019 11:24 pm
by MediaworksNZ
Hi Benjamin,
I have messaged you with the details.
Thanks
Re: SLA PDF Reports not Generating Properly
Posted: Wed Jul 03, 2019 1:54 pm
by benjaminsmith
Hi Craig,
Thanks for sending those files over. You getting a session timed out message in the report, so while the report is generating, the data is not being populated.
Please follow the instructions on the link below to optimize the PHP settings on your server, and then test the SLA report again.
Nagios XI - Optimizing The PHP Settings File
Re: SLA PDF Reports not Generating Properly
Posted: Wed Jul 03, 2019 8:32 pm
by MediaworksNZ
Hi Benjamin,
Right, I am using the Modern Dark Theme.
The Theme is not showing errors on the screen when the text itself is black.
I happened to highlight the blank page and I saw the below text being selected.
Code: Select all
Failed to create PDF
Verify that your Nagios XI server can connect to the URL:
http://localhost/nagiosxi/reports/sla.php?host=&showdetail=0&export=1&reportperiod=last24hours&startdate=&enddate=&service=&hostgroup=&servicegroup=&slalevel=99.99&advanced=0&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringdowntime=yes&includesoftstates=no&assumedhoststate=3&assumedservicestate=6&timeperiod=&token=dc95657242d47af31a9704a24c9f91a3882b3925&locale=en_US&records=100000&mode=getreport&hideoptions=1&old_browser_compat=1
Not sure why it is trying to resolve to the localhost name instead of the FQDN.
The Program URL in the System settings are correct and not pointing to localhost.
Re: SLA PDF Reports not Generating Properly
Posted: Mon Jul 08, 2019 2:40 pm
by lmiltchev
What you are describing is a bug that was fixed a long time ago - in Nagios XI 5.5.5 (task_id=13619). I am not sure why it's not working on your system. I haven't been able to recreate the issue in-house. Can you run the following command and show the output?
Code: Select all
ls -la /usr/local/nagiosxi/html/reports/sla.php
Not sure why it is trying to resolve to the localhost name instead of the FQDN.
The Program URL in the System settings are correct and not pointing to localhost.
Can you go to Admin > System Settings and show a screenshot of the page?
Re: SLA PDF Reports not Generating Properly
Posted: Wed Jul 10, 2019 10:05 pm
by MediaworksNZ
Hi.
Please find details below as requested.
[root@twnagios3 ~]# ls -la /usr/local/nagiosxi/html/reports/sla.php
-rw-r--r--. 1 nagios nagios 623833 Jun 18 16:59 /usr/local/nagiosxi/html/reports/sla.php
Here is the screen capture
Annotation (5).png
Re: SLA PDF Reports not Generating Properly
Posted: Thu Jul 11, 2019 11:08 am
by lmiltchev
Check to see if you have "localhost" in /etc/hosts:
Also, I can see that you are using https in the Program URL. Is SSL set up in config.inc.php as well?
Code: Select all
grep use_https /usr/local/nagiosxi/html/config.inc.php
Re: SLA PDF Reports not Generating Properly
Posted: Mon Jul 15, 2019 4:34 pm
by MediaworksNZ
Hi,
Please find details of hosts file:
Code: Select all
IPofServer localhost localhost.localdomain localhost4 localhost4.localdomain4 twnagios3 twnagios3.domain.forest
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 twnagios3 twnagios3.domain.forest
Output of config.inc.php
Code: Select all
grep use_https /usr/local/nagiosxi/html/config.inc.php
$cfg['use_https'] = true; // determines whether cron jobs and other scripts will force the use of HTTPS instead of HTTP
Re: SLA PDF Reports not Generating Properly
Posted: Mon Jul 15, 2019 4:40 pm
by MediaworksNZ
Also, when I use wget on the server:
When I try to download the report when using the GUI:
Code: Select all
Failed to create PDF
Verify that your Nagios XI server can connect to the URL:
https://localhost/nagiosxi/reports/sla.php?host=&showdetail=0&export=1&reportperiod=last24hours&startdate=&enddate=&service=&hostgroup=&servicegroup=&slalevel=99.99&advanced=0&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringdowntime=yes&includesoftstates=no&assumedhoststate=3&assumedservicestate=6&timeperiod=&token=38f1eec73d3954fd21bb1d5cfbd51b4d67229c78&locale=en_US&records=100000&mode=getreport&hideoptions=1&old_browser_compat=1
When submitting the URL via cli:
Code: Select all
wget https://localhost/nagiosxi/reports/sla.php?host=&showdetail=0&export=1&reportperiod=last24hours&startdate=&enddate=&service=&hostgroup=&servicegroup=&slalevel=99.99&advanced=0&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringdowntime=yes&includesoftstates=no&assumedhoststate=3&assumedservicestate=6&timeperiod=&token=38f1eec73d3954fd21bb1d5cfbd51b4d67229c78&locale=en_US&records=100000&mode=getreport&hideoptions=1&old_browser_compat=1
[1] 76376
[2] 76377
[3] 76378
[4] 76379
[5] 76380
[6] 76381
[7] 76382
[8] 76383
[9] 76384
[10] 76385
[11] 76386
[12] 76387
[13] 76388
[14] 76389
[15] 76390
[16] 76391
[17] 76392
[18] 76393
[19] 76394
[20] 76395
[21] 76396
[22] 76397
[23] 76398
[2] Done showdetail=0
[3] Done export=1
[4] Done reportperiod=last24hours
[6] Done enddate=
[8] Done hostgroup=
[9] Done servicegroup=
[10] Done slalevel=99.99
[12] Done assumeinitialstates=yes
[13] Done assumestateretention=yes
[14] Done assumestatesduringdowntime=yes
[16] Done assumedhoststate=3
[17] Done assumedservicestate=6
[18] Done timeperiod=
[19] Done token=38f1eec73d3954fd21bb1d5cfbd51b4d67229c78
[21] Done records=100000
[root@twnagios3 ~]# --2019-07-16 09:35:24-- https://localhost/nagiosxi/reports/sla.php?host=
Resolving localhost (localhost)... ::1, IPofSERVER
Connecting to localhost (localhost)|::1|:443... connected.
ERROR: cannot verify localhost's certificate, issued by ‘/DC=**/DC=**/CN=**-CA’: (** = commented out)
Unable to locally verify the issuer's authority.
ERROR: no certificate subject alternative name matches
requested host name ‘localhost’.
To connect to localhost insecurely, use `--no-check-certificate'.
Then I submit the same command and instruct to ignore certificate error
It seems to get further but creates a file called: 27b Jul 16 09:42 sla.php?host=
Code: Select all
wget --no-check-certificate https://localhost/nagiosxi/reports/sla.php?host=&showdetail=0&export=1&reportperiod=last24hours&startdate=&enddate=&service=&hostgroup=&servicegroup=&slalevel=99.99&advanced=0&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringdowntime=yes&includesoftstates=no&assumedhoststate=3&assumedservicestate=6&timeperiod=&token=38f1eec73d3954fd21bb1d5cfbd51b4d67229c78&locale=en_US&records=100000&mode=getreport&hideoptions=1&old_browser_compat=1
[1] 82782
[2] 82783
[3] 82784
[4] 82785
[5] 82786
[6] 82787
[7] 82788
[8] 82789
[9] 82790
[10] 82791
[11] 82792
[12] 82793
[13] 82794
[14] 82795
[15] 82796
[16] 82797
[17] 82798
[18] 82799
[19] 82800
[20] 82801
[21] 82802
[22] 82803
[23] 82804
[2] Done showdetail=0
[3] Done export=1
[4] Done reportperiod=last24hours
[5] Done startdate=
[6] Done enddate=
[7] Done service=
[8] Done hostgroup=
[9] Done servicegroup=
[10] Done slalevel=99.99
[11] Done advanced=0
[12] Done assumeinitialstates=yes
[13] Done assumestateretention=yes
[14] Done assumestatesduringdowntime=yes
[15] Done includesoftstates=no
[16] Done assumedhoststate=3
[17] Done assumedservicestate=6
[18] Done timeperiod=
[19] Done token=38f1eec73d3954fd21bb1d5cfbd51b4d67229c78
[20] Done locale=en_US
[21] Done records=100000
[22]- Done mode=getreport
[root@twnagios3 ~]# --2019-07-16 09:42:17-- https://localhost/nagiosxi/reports/sla.php?host=
Resolving localhost (localhost)... ::1, 10.21.250.94
Connecting to localhost (localhost)|::1|:443... connected.
WARNING: cannot verify localhost's certificate, issued by ‘/DC=forest/DC=domain/CN=MediaWorks-CA’:
Unable to locally verify the issuer's authority.
WARNING: no certificate subject alternative name matches
requested host name ‘localhost’.
HTTP request sent, awaiting response... 200 OK
Length: 27 [text/html]
Saving to: ‘sla.php?host=’
100%[===================================================================================================================================================================================================>] 27 --.-K/s in 0s
2019-07-16 09:42:17 (667 KB/s) - ‘sla.php?host=’ saved [27/27]
[1]- Done wget --no-check-certificate https://localhost/nagiosxi/reports/sla.php?host=
[23]+ Done hideoptions=1
Tail of Error Log:
Code: Select all
tail -f /var/log/httpd/*error_log
==> /var/log/httpd/error_log <==
HTTP request sent, awaiting response... wkhtmltoimage: cannot connect to X server
200 OK
Length: 828 [text/html]
Saving to: '/usr/local/nagiosxi/tmp/scheduledreport-username-ClMKnEmClT5W-1563225669-SLA.jpg'
0K 100% 17.9M=0s
2019-07-16 09:21:10 (17.9 MB/s) - '/usr/local/nagiosxi/tmp/scheduledreport-username-ClMKnEmClT5W-1563225669-SLA.jpg' saved [828/828]
The switch --no-outline, is not support using unpatched qt, and will be ignored.The switch --footer-spacing, is not support using unpatched qt, and will be ignored.The switch --footer-font-size, is not support using unpatched qt, and will be ignored.The switch --footer-right, is not support using unpatched qt, and will be ignored.The switch --footer-left, is not support using unpatched qt, and will be ignored.wkhtmltopdf: cannot connect to X server
==> /var/log/httpd/ssl_error_log <==
--2019-07-16 09:52:19-- https://twnagios3.domain.forest/nagiosxi//reports/sla.php?host=&showdetail=0&export=0&reportperiod=last24hours&startdate=&enddate=&host=&service=&hostgroup=&servicegroup=&slalevel=95&advanced=0&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringdowntime=yes&includesoftstates=no&assumedhoststate=3&assumedservicestate=6&timeperiod=&locale=en_US&mode=pdf&token=9c509cb9d174e739f0a4a6ea2cd1baebe95453bb
Resolving twnagios3.domain.forest (twnagios3.domain.forest)... ::1, 10.21.250.94
Connecting to twnagios3.domain.forest (twnagios3.domain.forest)|::1|:443... connected.
WARNING: cannot verify twnagios3.domain.forest's certificate, issued by '/DC=forest/DC=domain/CN=MediaWorks-CA':
Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... The switch --no-outline, is not support using unpatched qt, and will be ignored.The switch --footer-spacing, is not support using unpatched qt, and will be ignored.The switch --footer-font-size, is not support using unpatched qt, and will be ignored.The switch --footer-right, is not support using unpatched qt, and will be ignored.The switch --footer-left, is not support using unpatched qt, and will be ignored.wkhtmltopdf: cannot connect to X server
200 OK
Length: 825 [text/html]
Saving to: '/usr/local/nagiosxi/tmp/scheduledreport-craigconnoll-hTpFtKCBF93L-1563227539-SLA.pdf'
0K 100% 6.59M=0s
2019-07-16 09:52:20 (6.59 MB/s) - '/usr/local/nagiosxi/tmp/scheduledreport-craigconnoll-hTpFtKCBF93L-1563227539-SLA.pdf' saved [825/825]