Page 1 of 2

NAGIOSQL LOGIN FAILED!

Posted: Thu Jul 19, 2018 8:26 am
by sandeepatil
Hi Team,

Please find the out put of reconfigure_nagios.sh script,

URL: https://localhost:8443/nagiosxi/include ... nents/ccm/
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies https://localhost:8443/nagiosxi/include ... nents/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&backend=1&username=nagiosxi&password=Mo0EO8gmvERX' -O nagiosql.login--2018-07-19 09:22:00-- https://localhost:8443/nagiosxi/include ... nents/ccm/
Resolving localhost (localhost)... 127.0.0.1, ::1
Connecting to localhost (localhost)|127.0.0.1|:8443... connected.
WARNING: cannot verify localhost's certificate, issued by ‘/C=US/O=DigiCert Inc/CN=DigiCert SHA2 Secure Server CA’:
Unable to locally verify the issuer's authority.
WARNING: no certificate subject alternative name matches
requested host name ‘localhost’.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘nagiosql.login’

[ <=> ] 18,602 --.-K/s in 0.02s

2018-07-19 09:22:01 (1.06 MB/s) - ‘nagiosql.login’ saved [18602]

NAGIOSQL LOGIN FAILED!
FYI,

#cat /usr/local/nagiosxi/html/config.inc.php | grep "use_https"
$cfg['use_https'] = true; // determines whether cron jobs and other scripts will force the use of HTTPS instead of HTTP

#cat /usr/local/nagiosxi/html/config.inc.php | grep "port_number"
$cfg['port_number'] = 8443;

Re: NAGIOSQL LOGIN FAILED!

Posted: Thu Jul 19, 2018 8:38 am
by scottwilkerson
Lets go to Admin -> Security Credentials
don't change anything
Click "Update Credentials"

Try again

If you still get a failure, please send the following file

Code: Select all

/usr/local/nagiosxi/scripts/nagiosql.login

Re: NAGIOSQL LOGIN FAILED!

Posted: Thu Jul 19, 2018 9:07 am
by sandeepatil
After credentials update, reconfigure working fine.

Please explain why this issue occur.

Re: NAGIOSQL LOGIN FAILED!

Posted: Thu Jul 19, 2018 9:14 am
by scottwilkerson
sandeepatil wrote:After credentials update, reconfigure working fine.

Please explain why this issue occur.
It is rare, but occasionally the password that is used by the backed system can get changed (usually by someone modifying the password for the special nagiosxi user in the CCM) which makes it out of sync with the password that the Apply Configuration process uses.

Glad this resolved the issue.

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 9:27 am
by sandeepatil
Thanks for sharing information.

After reconfiguration issue resolved, new issue arrived.

More than 500 services showing in pending state from yesterday.

FYI, checked with retention.dat file deletion.

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 9:36 am
by scottwilkerson
sandeepatil wrote:Thanks for sharing information.

After reconfiguration issue resolved, new issue arrived.

More than 500 services showing in pending state from yesterday.

FYI, checked with retention.dat file deletion.
Lets run the following

Code: Select all

service nagios stop
killall -9 nagios
service nagios start
Then, allow a few minutes to catch up

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 10:57 am
by sandeepatil
Did as per instruction, but issue is not resolve.

We are facing sane from yesterday.

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 11:25 am
by scottwilkerson
sandeepatil wrote:Did as per instruction, but issue is not resolve.

We are facing sane from yesterday.
Do they show as being scheduled?

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 11:37 am
by sandeepatil
Please find attachment

Re: NAGIOSQL LOGIN FAILED!

Posted: Fri Jul 20, 2018 12:00 pm
by scottwilkerson
These are passive checks, and if you deleted the retention.dat like you said you did, they will not show results until they receive updates from the servers sending the results