Page 1 of 1

Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 8:42 am
by marcf
Hi,

i upgraded nagios from 5.4 to 5.6.10
Everything's seems fine except for news added server, service. They are added on the config file on the server. On the UI, i don't found them except on CCM.

I checked the mysql nagios_hosts table and saw that i missed the last host added.

Any idea what can be blocking the update ?

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 1:54 pm
by tgriep
If you look at the config on the Core Config Manager, are the objects activated?

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 2:53 pm
by marcf
yes, they were created from configuration wizard. Everything was ok except that i don't see it on the active summary.

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 3:32 pm
by mbellerue
Just to clarify, you're trying to add a new host to Nagios, and the host and its services are failing to show up? Or is it new services on an existing host?

If it's the latter, can you give me a screenshot of Configure -> Core Config Manager -> Services, showing one host with services that show up and services that do not show up?

Otherwise if it's the former, could you PM me a system profile? You can get it from Admin -> System Profile -> Download Profile. I will also need the name of a host and/or service that does show up, and a host and/or service that does not show up.

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 4:02 pm
by marcf
while trying to download profile i got the following error
PROFILE BUILD FAILED
Array
(
)
CODE: 1

I added a new server with services and yes i didn't saw them on the active summary.
I checked the command launch while using the ui interface to apply settings.
The following script is launched which is the normal way. For some reason from the ui, it's like nothing happened.
cd /usr/local/nagiosxi/scripts && ./reconfigure_nagios.sh

I tried to launch it with unix nagios account on the server and now i see my server and services on the ui.

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 4:36 pm
by mbellerue
That sounds like it might be a permissions issue. Can you show me the output of these commands,

Code: Select all

ls -lh /usr/local/nagiosxi/scripts/
grep nagios /etc/group

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Fri Jan 31, 2020 4:47 pm
by marcf
[root@server var]# ls -lh /usr/local/nagiosxi/scripts/
total 1.1M
drwxr-xr-x 3 nagios nagios 4.0K Jan 30 19:10 automation
-r-xr-x---. 1 root nagios 7.6K Jan 30 19:10 backup_xi.sh
-r-xr-x--- 1 nagios nagios 8.0K Jan 30 19:10 ccm_delete_object.php
-r-xr-x--- 1 nagios nagios 1.1K Jan 30 19:10 ccm_export.php
-r-xr-x--- 1 nagios nagios 1.6K Jan 30 19:10 ccm_import.php
-r-xr-x--- 1 nagios nagios 3.2K Jan 30 19:10 ccm_snapshot.sh
-r-xr-x---. 1 root nagios 1.8K Jan 30 19:10 change_timezone.sh
drwxr-xr-x 2 root nagios 4.0K Jan 30 19:10 components
-rwxr-xr-x. 1 nagios nagios 2.8K Jan 30 19:10 contact_notification_handler.php
-rwxr-xr-x. 1 nagios nagios 660 Apr 29 2017 export_nagiosql.sh
-rwxr-xr-x. 1 nagios nagios 266 Jan 30 19:10 handle_nagioscore_event.php
-rwxr-xr-x. 1 nagios nagios 3.9K Jan 30 19:10 handle_nagioscore.inc.php
-rwxr-xr-x. 1 nagios nagios 267 Jan 30 19:10 handle_nagioscore_notification.php
-rwxr-xr-x. 1 nagios nagios 425 Apr 29 2017 import_nagiosql.sh
-r-xr-x---. 1 root nagios 1.3K Jan 30 19:10 import_xiconfig.php
-rwxr-xr-x 1 nagios nagios 705 Jan 30 19:10 initialize_mibs.php
-rwxr-xr-x. 1 nagios nagios 93 Apr 29 2017 kill_rrdtool.sh
-r-xr-x---. 1 root nagios 3.6K Jan 30 19:10 manage_services.sh
-r-xr-x--- 1 root nagios 3.8K Jan 30 19:10 manage_ssl_config.sh
-rwxr-xr-x. 1 nagios nagios 161 Jan 29 17:51 nagiosql.cookies
-rwxr-xr-x. 1 nagios nagios 278K Jan 30 19:10 nagiosql_defaults.sql
-rwxr-xr-x 1 nagios nagios 49K Jan 25 2018 nagiosql.delete.contact
-rwxr-xr-x. 1 nagios nagios 895 Apr 29 2017 nagiosql_delete_contact.php
-rwxr-xr-x 1 nagios nagios 52K May 9 2019 nagiosql.delete.host
-rwxr-xr-x. 1 nagios nagios 1.9K Apr 29 2017 nagiosql_delete_host.php
-rwxr-xr-x. 1 nagios nagios 497 Apr 29 2017 nagiosql_delete_object.sh
-rwxr-xr-x 1 nagios nagios 100K Sep 16 18:03 nagiosql.delete.service
-rwxr-xr-x. 1 nagios nagios 2.8K Apr 29 2017 nagiosql_delete_service.php
-rwxr-xr-x 1 nagios nagios 49K Jan 25 2018 nagiosql.delete.timeperiod
-rwxr-xr-x. 1 nagios nagios 896 Apr 29 2017 nagiosql_delete_timeperiod.php
-rwxr-xr-x. 1 nagios nagios 1.3K Apr 29 2017 nagiosql_exportall.php
-rwxr-xr-x. 1 nagios nagios 21K Jan 29 17:51 nagiosql.export.monitoring
-rwxr-xr-x. 1 nagios nagios 1.3K Apr 29 2017 nagiosql_importall.php
-rwxr-xr-x. 1 nagios nagios 216K Dec 19 14:54 nagiosql.import.monitoring
-rwxr-xr-x. 1 nagios nagios 38K Jan 29 17:51 nagiosql.login
-rwxr-xr-x. 1 nagios nagios 1.7K Apr 29 2017 nagiosql_login.php
-rwxr-xr-x. 1 nagios nagios 2.2K Apr 29 2017 nagiosql_snapshot.sh
-rwxr-xr-x. 1 nagios nagios 200 Apr 29 2017 nagiosql_trim_backups.sh
-rwxr-xr-x. 1 nagios nagios 366 Apr 29 2017 nagiosxi_dbtype.php
-rwxr-xr-x. 1 nagios nagios 506 Jan 30 19:10 nom_create_nagioscore_checkpoint_cond.sh
-rwxr-xr-x. 1 nagios nagios 986 Jan 30 19:10 nom_create_nagioscore_checkpoint.sh
-rwxr-xr-x. 1 nagios nagios 785 Jan 30 19:10 nom_create_nagioscore_errorpoint.sh
-rwxr-xr-x. 1 nagios nagios 968 Jan 30 19:10 nom_restore_nagioscore_checkpoint.sh
-rwxr-xr-x. 1 nagios nagios 947 Jan 30 19:10 nom_restore_nagioscore_checkpoint_specific.sh
-rwxr-xr-x 1 nagios nagios 4.6K Jan 30 19:10 nom_trim_checkpoints.sh
-rwxr-xr-x. 1 nagios nagios 2.9K Apr 29 2017 nom_trim_nagioscore_checkpoints.sh
-rwxr-xr-x 1 nagios nagios 7.6K Jan 30 19:10 nxti_import.php
-rwxr-xr-x 1 nagios nagios 1.4K Jan 30 19:10 nxti.php
-rwxr-xr-x. 1 nagios nagios 13K Jan 30 19:10 parse_core_eventlog.php
-rwxr-xr-x. 1 nagios nagios 6.6K Jan 30 19:10 patch_ndoutils.php
-rwxr-xr-x. 1 nagios nagios 971 Jan 30 19:10 reconfigure_nagios.sh
-rwxr-xr-x 1 nagios nagios 4.2K Jan 30 19:10 remove_historical_data.sh
-r-xr-x---. 1 root nagios 1.7K Jan 30 19:10 repair_databases.sh
-rwxr-xr-x. 1 nagios nagios 3.9K Jan 30 19:10 repairmysql.sh
-r-xr-x---. 1 root nagios 4.8K Jan 30 19:10 reset_config_perms.sh
-rwxr-xr-x. 1 nagios nagios 1.9K Jan 30 19:10 reset_nagiosadmin_password.php
-rwxr-xr-x. 1 nagios nagios 1.9K Jan 30 19:10 restart_nagios_with_export.sh
-rwxr-xr-x. 1 nagios nagios 4.0K Jan 30 19:10 restore_defaults.sh
-rwxr-xr-x. 1 nagios nagios 13K Jan 30 19:10 restore_xi.sh
-rwxr-xr-x. 1 nagios nagios 1.9K Jan 30 19:10 send_to_auditlog.php
-rwxr-xr-x. 1 nagios nagios 2.7K Apr 29 2017 uninstall_xi.sh
-rwxr-xr-x. 1 nagios nagios 1.4K Jan 30 19:10 unlock_user_account.php
-rwxr-xr-x. 1 nagios nagios 722 Jan 30 19:10 update_check.php
-r-xr-x---. 1 root nagios 2.9K Jan 30 19:10 upgrade_to_latest.sh

[root@server var]# grep nagios /etc/group
nagios:x:1000:apache,nagios,snmptt
nagcmd:x:50013:apache,nagios

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Mon Feb 03, 2020 1:40 pm
by mbellerue
That all looks correct. Let's try downloading the profile manually. To manually get a profile, ssh into the Nagios server as root and run /usr/local/nagiosxi/scripts/components/getprofile.sh 20200203
The profile is located at /usr/local/nagiosxi/var/components/profile.zip. Be aware, the path to profile.zip looks very similar to the path for the getprofile.sh script, but it is subtly different.

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Mon Feb 24, 2020 9:35 am
by marcf
Issue is resolved now. No clear resolution to tell. The server was rebooted and everything was restarted properly and seem all is back to normal.

thanks for your help.

Re: Nagios xi upgrade : sync config file mysql not done

Posted: Mon Feb 24, 2020 2:14 pm
by benjaminsmith
Hi @marcf,

Glad it's working for you now, feel free to open a new post if need further assistance.