Nagios Support Forum

==> /var/log/httpd/error_log <==
[Wed Jun 05 10:29:47 2019] [error] [client 172.27.114.52] PHP Notice: Call made to exac_sql_query() when DB handler does not exist\n#0 exec_sql_query(nagiosxi, SELECT * FROM xi_options WHERE name='wc_display', ) called at [/usr/local/nagiosxi/html/includes/utils.inc.php:1033]\n#1 get_option(wc_display, 0) called at [/usr/local/nagiosxi/html/includes/components/capacityplanning/includes/capacityreport.js.php:187]\n in /usr/local/nagiosxi/html/includes/db.inc.php on line 511, referer: http://10.161.176.67/nagiosxi/includes/ ... anning.php
[Wed Jun 05 10:30:11 2019] [error] [client 172.27.114.52] PHP Notice: Call made to exac_sql_query() when DB handler does not exist\n#0 exec_sql_query(nagiosxi, SELECT * FROM xi_options WHERE name='wc_display', ) called at [/usr/local/nagiosxi/html/includes/utils.inc.php:1033]\n#1 get_option(wc_display, 0) called at [/usr/local/nagiosxi/html/includes/components/capacityplanning/includes/capacityreport.js.php:187]\n in /usr/local/nagiosxi/html/includes/db.inc.php on line 511, referer: http://10.161.176.67/nagiosxi/includes/ ... s&manual=1
Loading pages (1/6)
[Wed Jun 05 10:30:46 2019] [error] [client 127.0.0.1] PHP Notice: Call made to exac_sql_query() when DB handler does not exist\n#0 exec_sql_query(nagiosxi, SELECT * FROM xi_options WHERE name='wc_display', ) called at [/usr/local/nagiosxi/html/includes/utils.inc.php:1033]\n#1 get_option(wc_display, 0) called at [/usr/local/nagiosxi/html/includes/components/capacityplanning/includes/capacityreport.js.php:187]\n in /usr/local/nagiosxi/html/includes/db.inc.php on line 511, referer: http://localhost/nagiosxi/includes/comp ... r_compat=1
=================================================> ] 88%
==> /var/log/httpd/ssl_error_log <==
[Wed Jun 05 10:37:53 2019] [error] [client 10.161.156.25] File does not exist: /usr/local/nagiosxi/html/includes/js/jquery/jquery-1.11.2.min.js, referer: https://monitor.noviscorp.cl/

==> /var/log/httpd/error_log <==
[Wed Jun 05 10:38:05 2019] [error] [client 172.27.200.29] File does not exist: /usr/local/nagiosxi/html/includes/js/jquery/jquery-1.11.2.min.js, referer: http://nagios.servicio.novis.com/

novisnagios wrote:When generating individual reports of the servers these are generated without problems, but when generating a report of some hostgroup or several servers in only one, the PDF conversion ends with errors. There is some solution.

scottwilkerson wrote:

novisnagios wrote:When generating individual reports of the servers these are generated without problems, but when generating a report of some hostgroup or several servers in only one, the PDF conversion ends with errors. There is some solution.

It is possible that you are hitting a limit with the php max_execution_time if you are hitting the limit when trying to run a report over a whole hostgroup because it takes quite some time to create the capacity planning report in general, but with the PDF report there isn't a page limit so it could be creating TONS of graphs, and this will take a lot of time

scottwilkerson wrote:Does it load in the page but not in the PDF report, or not in the page either?

Can you run the following

Code: Select all

tail -f /var/log/httpd/error_log

then try to send the report and send back all the output from the outputted logging

Also, 5.6.3 came out this morning that I know is supposed to fix one of the notices you were getting in your logs before.

npolovenko wrote:@novisnagios, What's the output of:

Code: Select all

rpm -qa | grep wkhtmltox

npolovenko wrote:Also, please run the following commands:

Code: Select all

touch /usr/local/nagiosxi/var/wkhtmltox.log
chmod 777 /usr/local/nagiosxi/var/wkhtmltox.log

npolovenko wrote:Then tail the wkhtmltox.log and leave the command running:

Code: Select all

tail -f /usr/local/nagiosxi/var/wkhtmltox.log

npolovenko wrote:Open the web interface and generate a PDF report for a host group or multiple hosts. When you see an error in the GUI, take a look at the tail command and copy-paste all errors that it produced.