Page 1 of 1
NAGIOSQL LOGIN FAILED!
Posted: Mon Nov 27, 2017 4:11 pm
by 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!
Re: NAGIOSQL LOGIN FAILED!
Posted: Mon Nov 27, 2017 5:59 pm
by markmerchant
Could this be caused by a certificate error?I had the SAs add a cert recently.
Re: NAGIOSQL LOGIN FAILED!
Posted: Mon Nov 27, 2017 7:35 pm
by 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.
Re: NAGIOSQL LOGIN FAILED!
Posted: Tue Nov 28, 2017 10:33 am
by 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
Re: NAGIOSQL LOGIN FAILED!
Posted: Thu Nov 30, 2017 4:25 pm
by 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.
Re: NAGIOSQL LOGIN FAILED!
Posted: Thu Nov 30, 2017 4:37 pm
by kyang
Sounds good, we can leave this thread open in case you have any more questions.