Page 1 of 1

NAGIOSQL LOGIN FAILED!

Posted: Thu Sep 03, 2015 2:15 pm
by crnelson
Scenario
Attempted to upgrade to newest NagiosXI

Host Details
Linux Distribution and version?
CentOS release 5.11 (Final)

32 or 64bit?
32bit

VMware Image or Manual Install of XI?
VMware Image

Special configurations?
Yes, using SSL with self-signed certificate

Error

Code: Select all

[root@hostname nagiosxi]# ./upgrade 
Checking required prereqs... 
Please wait... 

OLD VERSION: 416
Saving old crontab to /tmp/nagios.crontab.orig.10...
Removing XI cron jobs...
Saving old crontab to /tmp/root.crontab.orig.10...
Removing XI cron jobs...
Archive:  sourceguardian/ixed4.lin.x86-32.zip
  inflating: /usr/lib/php/modules/ixed.5.1.lin  
Sourceguardian extension found for PHP version 5.1
Sourceguardian extension already in php.ini
Copying over new XI directory...
Building latest perms binary...
Updating NagiosQL...
NAGIOSQL-POST
Patching NDOUtils...
NDOUtils already patched at level 103
Updating sequences...
Nagios XI Postgres Database Sequence Information

OLD VALUES
--------------
xi_commands_command_id_seq = 19788
xi_events_event_id_seq = 8469587
xi_meta_meta_id_seq = 8470087
xi_options_option_id_seq = 197
xi_sysstat_sysstat_id_seq = 99
xi_usermeta_usermeta_id_seq = 4150
xi_users_user_id_seq = 124

NEW VALUES
--------------
xi_commands_command_id_seq = 19788
xi_events_event_id_seq = 8469587
xi_meta_meta_id_seq = 8470087
xi_options_option_id_seq = 197
xi_sysstat_sysstat_id_seq = 99
xi_usermeta_usermeta_id_seq = 4150
xi_users_user_id_seq = 124

Installing new PNP templates...
Updating init script...
Enabling large install tweaks...
Fixing config file permissions...
Fixing htpasswd permissions...
Checking group memberships...
Installing new XI templates...
URL: https://localhost/nagiosxi/includes/components/ccm/
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies https://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&username=nagiosxi&password=tlqgdq' -O nagiosql.login--2015-08-27 11:33:15--  https://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:443... connected.
WARNING: cannot verify localhost's certificate, issued by ... :
  Self-signed certificate encountered.
WARNING: certificate common name `host.domain.org' doesn't match requested host name `localhost'.
HTTP request sent, awaiting response... 200 OK
Length: 0 [text/html]
Saving to: `nagiosql.login'

    [ <=>                                                                                                                                             ] 0           --.-K/s   in 0s      

2015-08-27 11:33:15 (0.00 B/s) - `nagiosql.login' saved [0/0]

NAGIOSQL LOGIN FAILED!
Things that have been ruled out:
  • Proxy: no proxy configuration
  • SSL: --no-check-certificate argument in place at failpoint
  • SSL: disabled SSL with same result (200 OK)

Re: NAGIOSQL LOGIN FAILED!

Posted: Thu Sep 03, 2015 2:22 pm
by ssax
Go to Admin > System Config > Reset Security Credentials
- Don't change anything, just click the Update Credentials button.

Now run these commands and post the full output if there are any errors:

Code: Select all

cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh
If there are no errors, please try to upgrade again.

Re: NAGIOSQL LOGIN FAILED!

Posted: Tue Oct 13, 2015 11:20 am
by crnelson
Finally had the chance to try this again following your advice. Scenarios attempted:
  • Create snapshot
  • Reset security creds (Admin > Reset Security Credentials)
  • Rerun upgrade, same failure
  • Revert to snapshot
  • Reset security creds
  • cd /usr/local/nagiosxi/scripts
  • ./reconfigure_nagios.sh
  • Rerun upgrade, same failure
There are no errors, just warnings, as shown below. I've removed many lines of host names, services, and contact warning messages, but left one of each as examples.

Code: Select all

URL: https://localhost/nagiosql/index.php
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies https://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=PASSWORD' -O nagiosql.loginLOGIN SUCCESSFUL!
IMPORTING CONFIG FILES...URL: https://localhost/nagiosql/admin/import.php
Array
(
)
RESETTING PERMS
SETUID ROOT OK
URL: https://localhost/nagiosql/index.php
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies https://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=tlqgdq' -O nagiosql.loginLOGIN SUCCESSFUL!
URL: https://localhost/nagiosql/admin/verify.php
CMDLINE:
/usr/bin/wget --load-cookies=nagiosql.cookies https://localhost/nagiosql/admin/verify.php --no-check-certificate --post-data 'writeMonitoring=Go' -O nagiosql.export.monitoring
WRITE CONFIGS SUCCESSFUL!
CMDLINE:
/usr/bin/wget --load-cookies=nagiosql.cookies https://localhost/nagiosql/admin/verify.php --no-check-certificate --post-data 'writeAdditional=Go' -O nagiosql.export.additional
OUTPUT: 
Nagios Core 3.5.0
Copyright (c) 2009-2011 Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 03-15-2013
License: GPL

Website: http://www.nagios.org
Reading configuration data...
   Read main config file okay...
Processing object config directory '/usr/local/nagios/etc/static'...
Processing object config file '/usr/local/nagios/etc/static/xiobjects.cfg'...
Processing object config file '/usr/local/nagios/etc/static/xitemplates.cfg'...
Processing object config file '/usr/local/nagios/etc/static/xitest.cfg'...
Processing object config file '/usr/local/nagios/etc/contacttemplates.cfg'...
Processing object config file '/usr/local/nagios/etc/contactgroups.cfg'...
Processing object config file '/usr/local/nagios/etc/contacts.cfg'...
Processing object config file '/usr/local/nagios/etc/timeperiods.cfg'...
Processing object config file '/usr/local/nagios/etc/commands.cfg'...
Processing object config file '/usr/local/nagios/etc/hostgroups.cfg'...
Processing object config file '/usr/local/nagios/etc/servicegroups.cfg'...
Processing object config file '/usr/local/nagios/etc/hosttemplates.cfg'...
Processing object config file '/usr/local/nagios/etc/servicetemplates.cfg'...
Processing object config file '/usr/local/nagios/etc/servicedependencies.cfg'...
Processing object config file '/usr/local/nagios/etc/serviceescalations.cfg'...
Processing object config file '/usr/local/nagios/etc/hostdependencies.cfg'...
Processing object config file '/usr/local/nagios/etc/hostescalations.cfg'...
Processing object config file '/usr/local/nagios/etc/hostextinfo.cfg'...
Processing object config file '/usr/local/nagios/etc/serviceextinfo.cfg'...
Processing object config directory '/usr/local/nagios/etc/hosts'...
...<INSERT MORE WARNINGS>
Warning: Duplicate definition found for service 'Drive_I: Disk Usage' on host 'hostname' (config file '/usr/local/nagios/etc/services/MSSQL_I_Drive_Critical.cfg', starting on line 14)
   Read object config files okay...

Running pre-flight check on configuration data...

Checking services...
...<INSERT MORE WARNINGS>
Warning: Service 'Memory Usage' on host 'host' has no default contacts or contactgroups defined!
	Checked 3980 services.
Checking hosts...
Warning: Host '192.0.0.25' has no default contacts or contactgroups defined!
...<INSERT MORE WARNINGS>
	Checked 471 hosts.
Checking host groups...
	Checked 114 host groups.
Checking service groups...
	Checked 6 service groups.
Checking contacts...
Warning: Contact 'CAAdmins' has no host notification time period defined!
...<INSERT MORE WARNINGS>
	Checked 223 contacts.
Checking contact groups...
	Checked 60 contact groups.
Checking service escalations...
	Checked 0 service escalations.
Checking service dependencies...
	Checked 0 service dependencies.
Checking host escalations...
	Checked 0 host escalations.
Checking host dependencies...
	Checked 0 host dependencies.
Checking commands...
	Checked 159 commands.
Checking time periods...
	Checked 84 time periods.
Checking for circular paths between hosts...
Checking for circular host and service dependencies...
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 110
Total Errors:   0

Things look okay - No serious problems were detected during the pre-flight check
RET: 0
Running configuration check...done.
Stopping nagios: No lock file found in /usr/local/nagios/var/nagios.lock
Starting nagios: done.

Re: NAGIOSQL LOGIN FAILED!

Posted: Tue Oct 13, 2015 4:37 pm
by ssax
What is the output of this command:

Code: Select all

chage -l nagios
Also, make it fail again and then PM me (may contain sensitive info) your /usr/local/nagiosxi/scripts/nagiosql.login file.

Thanks

Re: NAGIOSQL LOGIN FAILED!

Posted: Wed Oct 14, 2015 1:02 pm
by crnelson

Code: Select all

# chage -l nagios
Last password change					: Jan 11, 2010
Password expires					: never
Password inactive					: never
Account expires						: never
Minimum number of days between password change		: 0
Maximum number of days between password change		: 99999
Number of days of warning before password expires	: 7

Re: NAGIOSQL LOGIN FAILED!

Posted: Wed Oct 14, 2015 4:41 pm
by tgriep
You want to try the manual upgrade process and see if that works for you?
https://assets.nagios.com/downloads/nag ... nstall.pdf

Re: NAGIOSQL LOGIN FAILED!

Posted: Wed Oct 14, 2015 6:38 pm
by Box293
@tgriep from his first post I believe it shows him performing the manual upgrade from the CLI.

Run these commands

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
Send us these files:

Code: Select all

/tmp/messages_log.txt
/tmp/httpd_log.txt
/tmp/httpds_log.txt
/tmp/mysqld_log.txt