NAGIOSQL LOGIN FAILED!
Posted: Thu Sep 03, 2015 2:15 pm
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
Things that have been ruled out:
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!- Proxy: no proxy configuration
- SSL: --no-check-certificate argument in place at failpoint
- SSL: disabled SSL with same result (200 OK)