Nagios Support Forum

Hi Everybody !!!

We are upgrading the Nagios XI release 2014R2.6 to 2014R2.7, but when we execute the script, we have the next error message: "NAGIOSQL LOGIN FAILED!"

Can you help me please !!!!!


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

OLD VERSION: 416
no crontab for nagios
Saving old crontab to /tmp/root.crontab.orig.12...
Removing XI cron jobs...
Archive: sourceguardian/ixed4.lin.x86-64.zip
inflating: /usr/lib64/php/modules/ixed.5.4.lin
Sourceguardian extension found for PHP version 5.4
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 = 14374
xi_events_event_id_seq = 385316
xi_meta_meta_id_seq = 385385
xi_options_option_id_seq = 166
xi_sysstat_sysstat_id_seq = 101
xi_usermeta_usermeta_id_seq = 1178
xi_users_user_id_seq = 67

NEW VALUES
--------------
xi_commands_command_id_seq = 14374
xi_events_event_id_seq = 385316
xi_meta_meta_id_seq = 385385
xi_options_option_id_seq = 166
xi_sysstat_sysstat_id_seq = 101
xi_usermeta_usermeta_id_seq = 1178
xi_users_user_id_seq = 67

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: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE
/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&username=nagiosxi&password=9hg5go' -O nagiosql.login--2015-09-11 20:37:20-- http://localhost/nagiosxi/includes/components/ccm/
Connecting to 150.100.210.40:8080... connected.
Proxy request sent, awaiting response... 301 Moved Permanently
Location: http://150.250.130.205 [following]
--2015-09-11 20:37:20-- http://150.250.130.205/
Connecting to 150.100.210.40:8080... connected.
Proxy request sent, awaiting response... 200 OK
Length: 2999 (2.9K) [text/html]
Saving to: ‘nagiosql.login’

100%[=============================================================================================================>] 2,999 --.-K/s in 0s

2015-09-11 20:37:20 (193 MB/s) - ‘nagiosql.login’ saved [2999/2999]

NAGIOSQL LOGIN FAILED!

Below is the like to our FAQ for instructions on how to setup your system to bypass the proxy settings on your Nagios system.
https://support.nagios.com/wiki/index.p ... n_Problems
Let us know if you need any more help.

Thanks !!!!

The message reported was resolved, restarting the Nagios XI server, but i have some questions:

a) Our system profile is :

System:
Nagios XI Version : 2014R2.7
lvmmxpmongin01 3.10.0-123.20.1.el7.x86_64 x86_64
Red Hat Enterprise Linux Server release 7.0 (Maipo)
Gnome is not installed
Apache Information

PHP Version: 5.4.16
Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36
Server Name:
Server Address:
Server Port: 80
Date/Time

PHP Timezone: America/Monterrey
PHP Time: Mon, 14 Sep 2015 08:41:38 -0500
System Time: Mon, 14 Sep 2015 08:41:38 -0500
Nagios XI Data

License ends in: OQPNOP

nagios (pid 15160) is running...
NPCD running (pid 1473).
ndo2db (pid 1572) is running...
CPU Load 15: 2.57
Total Hosts: 156
Total Services: 3634
Function 'get_base_uri' returns: http:///nagiosxi/
Function 'get_base_url' returns: http:///nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: http:///nagiosxi/includes/components/profile/profile.php
Function 'get_backend_url(internal_call=true)' returns: http://localhost/nagiosxi/backend/


Question: Is still used on Red Hat Enterprise Linux Server release 7.0 (Maipo), the service " mysqld" ?


b) What are the databases that are used in Nagios XI Version : 2014R2.7 ( Red Hat Enterprise Linux Server release 7.0 (Maipo) ) and which is the purpose of each one ?


c) We review all the enviroment after the reported issue, and we see that all is working normally, what "log" or "config file" we have to review to certified that all is ok?


Thanks for your help !!!!

Happy monday !!!!!

I see that you have an email ticket open with us about this, so I will be closing this thread and we will continue via email.

Please only open issues either in the forum or in a ticket, not both.