Nagios throwing DB errors on apache

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

[johndoe]

Sure, reports don-t work, page just hangs and i cant access any more pages... only by cleaning up my session

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

[johndoe]

sent as requested

[lmiltchev]

We got the profile.zip. Give us some time to review the configs and logs. Thanks!

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

[abrist]

You most likely need to create an alias in /etc/hosts:

Code: Select all

127.0.0.1  localhost monitoring

What does yours look like?

Code: Select all

cat /etc/hosts

[johndoe]

You most likely need to create an alias in /etc/hosts:

Code: Select all

127.0.0.1  localhost monitoring

What does yours look like?

Code: Select all

cat /etc/hosts

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.

[scottwilkerson]

Can you run the following

Code: Select all

cat /etc/php.ini|grep ixed

and make sure it reads

Code: Select all

extension=ixed.5.4.lin

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

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

Error 2: 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.