nagiosql.loginNAGIOSQL LOGIN FAILED!

[nchan10111]

I am getting NAGIOSSQL login failed error after installing SSL and redirecting to 443 for nagios management. I have searched the forum and done all the steps mentioned from updating security to checking the ssl.conf files. No luck on resolving this. We are testing Nagios XI at this time, no support contract yet. Thank you for any help you may provide.

What version of Nagios XI are you using?
- Nagios XI 5.4.13

Linux Distribution and version?
- Cent OS 7 64bit

VMware Image or Manual Install of XI?
- OVA deployment

Are there special configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL?
-Configured SSL wildcard and Redirect to https

Output of cmdsubsys.log
------------------------------

......PROCESSING COMMAND ID 178...
PROCESS COMMAND: CMD=17, DATA=
APPLYING NAGIOSCORE CONFIG...
CMDLINE=cd /usr/local/nagiosxi/scripts && ./reconfigure_nagios.sh
URL: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE
--2018-05-31 14:35:09-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost (localhost)... 127.0.0.1
Connecting to localhost (localhost)|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://localhost/nagiosxi/includes/components/ccm/ [following]
--2018-05-31 14:35:09-- https://localhost/nagiosxi/includes/components/ccm/
Connecting to localhost (localhost)|127.0.0.1|:443... connected.
WARNING: no certificate subject alternative name matches
requested host name ‘localhost’.
HTTP request sent, awaiting response... 302 Found
Location: https://localhost/nagiosxi/login.php?re ... f&noauth=1 [following]
--2018-05-31 14:35:09-- https://localhost/nagiosxi/login.php?re ... f&noauth=1
Reusing existing connection to localhost:443.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘nagiosql.login’

0K .......... .......... ..... 1.82M=0.01s

2018-05-31 14:35:09 (1.82 MB/s) - ‘nagiosql.login’ saved [26419]

/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&backend=1&username=nagiosxi&password=9999' -O nagiosql.loginNAGIOSQL LOGIN FAILED!
OUTPUT=/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&backend=1&username=nagiosxi&password=9999' -O nagiosql.loginNAGIOSQL LOGIN FAILED!
RETURNCODE=2

[scottwilkerson]

First lets edit /usr/local/nagiosxi/html/config.inc.php
and set this to true

Code: Select all

$cfg['use_https'] = true; // determines whether cron jobs and other scripts will force the use of HTTPS instead of HTTP

If you continue to get a failed login prompt, go to Admin -> Reset Security Credentials and just click "Update Credentials" and try again

If you still have the same issue, please grab copy of the file at /usr/local/nagiosxi/scripts/nagiosql.login and post it back to this thread.

[nchan10111]

That solved it, thank you ScottWilkins. I followed the doc from the official site for implementing SSL and forgot the step mentioned above.

https://assets.nagios.com/downloads/nag ... s%20XI.pdf

[scottwilkerson]

Excellent, glad to hear it is resolved.

Locking