NAGIOSQL LOGIN FAILED!

[markmerchant]

I am unable to save a config.Something may be wrong with my database. How do I recover? Thx.

I'm trying to do a reconfigure, but am getting this:

Code: Select all

sudo ../../nagiosxi/scripts/reconfigure_nagios.sh
...
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘nagiosql.login’

    [ <=>                                   ] 26,696      --.-K/s   in 0.009s

2017-11-27 15:52:08 (2.83 MB/s) - ‘nagiosql.login’ saved [26696]

NAGIOSQL LOGIN FAILED!

[markmerchant]

Could this be caused by a certificate error?I had the SAs add a cert recently.

[markmerchant]

I have compared the file mentioned ( nagiosql.login ) to my Dev box. The file
on the Dev box contains a webpage and the one on the problem server contains
the login screen

Can someone point me in the right direction? Thx.

[kyang]

Are you able to restore back to a time when XI was working before with a recent snapshot?

Did this happen when you added a cert? SSL?

Otherwise, could you send us some logs?

Code: Select all

tail /var/log/messages -n 100 > /tmp/messages_log.txt
tail /var/log/httpd/error_log -n 100 > /tmp/httpd_log.txt
tail /var/log/httpd/ssl_error_log -n 100 > /tmp/httpds_log.txt
tail /var/log/mysqld.log -n 100 > /tmp/mysqld_log.txt

[markmerchant]

I have reverted to a simpler /etc/http/conf.d/nagios.conf file. It is working again.

The issue appears to have been caused by adding virtual host rewrites to the
apache config which somehow broke http://localhost style connections to the DB.

Received several 302 errors when running
/usr/bin/php -q $BASEDIR/nagiosql_login.php

Will try again when I have more time.

[kyang]

Sounds good, we can leave this thread open in case you have any more questions.