Page 2 of 3
Re: Nagios throwing DB errors on apache
Posted: Wed Mar 05, 2014 2:38 pm
by slansing
Are you noticing any hindered performance on the front end? Are certain pages/components/functions broken or not working properly? Nothing out of the ordinary compared to mine at the initial look... when this error is dumped to the error log, what page/function are you trying to view/use?
Re: Nagios throwing DB errors on apache
Posted: Mon Mar 10, 2014 12:05 pm
by johndoe
Sure, reports don-t work, page just hangs and i cant access any more pages... only by cleaning up my session
Re: Nagios throwing DB errors on apache
Posted: Mon Mar 10, 2014 4:34 pm
by lmiltchev
Go to Admin->System Profile->Download Profile->save the "profile.zip" file and PM it to any of us on the Nagios Tech Support Team.
Re: Nagios throwing DB errors on apache
Posted: Tue Mar 11, 2014 7:36 am
by johndoe
sent as requested
Re: Nagios throwing DB errors on apache
Posted: Tue Mar 11, 2014 9:04 am
by lmiltchev
We got the profile.zip. Give us some time to review the configs and logs. Thanks!
Re: Nagios throwing DB errors on apache
Posted: Fri Mar 14, 2014 8:10 am
by johndoe
Guys, just a note here, yesterday when configuring something else i noticed the https certificate was expired! Could this be the case? We use self signed certificates and after i changed it to our new one i get this:
Code: Select all
WGET From URL: https://localhost/nagiosql/index.php
Running:
/usr/bin/wget https://localhost/nagiosql/index.php
--2014-03-14 13:06:09-- https://localhost/nagiosql/index.php
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:443... connected.
ERROR: cannot verify localhost's certificate, issued by "/C=XXXXXXXXXX":
Unable to locally verify the issuer's authority.
ERROR: certificate common name "monitoring" doesn't match requested host name "localhost".
To connect to localhost insecurely, use '--no-check-certificate'.
Sounds like a vague possibility but can it be related? If not, how do i get nagios to ignore this, a.k.a where do i add the '--no-check-certificate' part ?
Re: Nagios throwing DB errors on apache
Posted: Fri Mar 14, 2014 2:22 pm
by abrist
You most likely need to create an alias in /etc/hosts:
What does yours look like?
Re: Nagios throwing DB errors on apache
Posted: Mon Mar 17, 2014 8:47 am
by johndoe
abrist wrote:You most likely need to create an alias in /etc/hosts:
What does yours look like?
Thanks but Unfortunately solving this will only complain about a self signed certificate (which is true since it is one).
I believe this doesn-t affect anything on nagios other than the lousy browser message we connect to it so will leave that one for now.
Let-s go back to the DB errors issue itself.
Re: Nagios throwing DB errors on apache
Posted: Mon Mar 17, 2014 2:08 pm
by scottwilkerson
Can you run the following
and make sure it reads
Also, I believe the vew version of PHP you have has strict standards on by default, you may need to run the following
Code: Select all
sed -i 's/&NewADOConnection/NewADOConnection/g' /usr/local/nagiosxi/html/includes/db.inc.php
Re: Nagios throwing DB errors on apache
Posted: Tue Mar 18, 2014 7:34 am
by johndoe
Thanks scott,
While that seems to clean up the initial error, a few more came up which seem to be related:
Note that i had the ixed.5.3.lin and not ixed.5.4.lin
Error 1:
Code: Select all
[Tue Mar 18 12:30:04 2014] [error] [client XXXXX] PHP Strict Standards: Only variables should be assigned by reference in /usr/local/nagiosxi/html/includes/configwizards/ssh-expect/ssh-expect.inc.php on line 488, referer: https://XXXXX/nagiosxi/config/
This one relates to a client that is only opened on a dashboard
Code: Select all
[Tue Mar 18 12:30:14 2014] [error] [client XXXXX] PHP Notice: Undefined variable: dashletmode in /usr/local/nagiosxi/html/includes/components/xicore/dashlets-perfdata.inc.php on line 173
Error 3 : When going into Reports the session doesnt allow for any more pages to be opened until the nagios session is restarted.