NAGIOSQL LOGIN FAILED!

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

[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

[sandeepatil]

After credentials update, reconfigure working fine.

Please explain why this issue occur.

[scottwilkerson]

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.

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

[scottwilkerson]

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

[sandeepatil]

Did as per instruction, but issue is not resolve.

We are facing sane from yesterday.

[scottwilkerson]

Did as per instruction, but issue is not resolve.

We are facing sane from yesterday.

Do they show as being scheduled?

[sandeepatil]

Please find attachment

[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