upgrading nagiosxi with certificate issue

[amit.ahuja]

i'm upgrading nagiosxi to 5.2.2 but failed at the last part regarding certificate. Can anyone help on this?

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=-O nagiosql.login--2016-01-18 21:51:19-- https://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:443... connected.
WARNING: cannot verify localhost’s certificate, issued by “/C=--/ST=SomeState/L=SomeCity/O=SomeOrganization/OU=SomeOrganizationalUnit/CN=MA100DLVMON813/emailAddress=root@MA100DLVMON813”:
Self-signed certificate encountered.
WARNING: certificate common name “MA100DLVMON813” doesn't match requested host name “localhost”.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: “nagiosql.login”

[Box293]

Can you please upload the file:
/etc/sudoers
Also, any files in /etc/sudoers.d/

How are you trying to run the upgrade? From the Nagios GUI or are you logged in to the server in a console while trying the manual upgrade procedure?
If you ran the upgrade from the GUI, it will create a upgrade.log file located in this folder.
/usr/local/nagiosxi/tmp/upgrade.log

If you ran the upgrade from manually from the console, it will create a upgrade.log file located in this folder.
/tmp/nagiosxi/tmp/upgrade.log

Please post the upgrade file for us to look at.

[haile711]

Here is the output of the sudoers file.

Code: Select all

ALL ALL=!SUDOSUDO
#
# End NA sudoers standard template Ver 8.1NA Date 2014-07-09 * Master * Refer NA14211028 End #






root    ALL=(ALL)       ALL
nagios    ALL=(ALL)       ALL















User_Alias      NAGIOSXI=nagios
User_Alias              NAGIOSXIWEB=apache
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios status
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios checkconfig
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db status
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd status
NAGIOSXI ALL = NOPASSWD:/usr/bin/php /usr/local/nagiosxi/html/includes/components/autodiscovery/scripts/autodiscover_new.php *
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/upgrade_to_latest.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/change_timezone.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/manage_services.sh *
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/reset_config_perms.sh
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/messages
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/httpd/error_log
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/mysqld.log
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/php /usr/local/nagiosxi/html/includes/components/autodiscovery/scripts/autodiscover_new.php *
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
NAGIOSXIWEB ALL = NOPASSWD:/etc/init.d/snmptt restart
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/scripts/repair_databases.sh
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/scripts/manage_services.sh *

Code: Select all

ls -lrt /usr/local/nagiosxi/tmp/
total 0
-rw-r--r-- 1 apache nagios 0 Jan 18 10:44 http:__library.nagios.com_library_products_nagiosxi_documentation?format=feed&type=rss.xml
-rw-r--r-- 1 apache nagios 0 Jan 18 10:44 http:__labs.nagios.com_feed.xml
-rw-r--r-- 1 apache nagios 0 Jan 18 10:44 http:__api.nagios.com_feeds_xipromo_.xml

[rkennedy]

The lines I see related are here -

Code: Select all

NEW VALUES
--------------
xi_commands_command_id_seq = 380
xi_events_event_id_seq = 47839
xi_meta_meta_id_seq = 47834
xi_options_option_id_seq = 136
xi_sysstat_sysstat_id_seq = 101
xi_usermeta_usermeta_id_seq = 479
xi_users_user_id_seq = 50

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=n@gweb' -O nagiosql.loginNAGIOSQL LOGIN FAILED!

Are you using a proxy in your environment at all?

[amit.ahuja]

no proxy, it's working for our current version right now Nagios XI 2014R2.7 . Could it be password? we haven't any password for nagiosql either, been using default. Again, only see this issue when upgrading from 2014R2.7 to 5.2.2. OS on the box is Redhat 6.6

[hsmith]

Are both of your threads for the same server?

[haile711]

2 different servers and 2 different issues.

[hsmith]

Was the password for the nagiosxi MySQL user changed? That's what it's looking like.

[amit.ahuja]

we're able to get this work. thanks

[bwallace]

Thanks for that update, we'll lock this thread now and feel free to open another should you require assistance with anything else.