Post Upgrade DB Connection Time Issue.

[hoegh]

Hi All,

We have recently upgraded Nagios XI from 5.2.9 to 5.4.11
After a week we are receiving Connection time alert for DB servers.
We have checked from DB end also,no issue was found.
We have troubleshooted from our side but didn't found any solution
Kindly, suggest what can be done?


Thanks and Regards,
Mayur Jilla

[dwhitfield]

What's the output of mysql --version? I'm wondering if you upgraded your mysql (or mariadb) when you upgraded XI. MariaDB 10.2+ are known to need some config changes. However, I'd expect things to completely stop working, not have intermittent connection issues.

Do you have a backup of the old server you can install on a test server? If so, can you grab a profile from it. I'd like to see a profile from the upgraded server as well. ou can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

You can also generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh

That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

If you get an error that PROFILE BUILD FAILED, please see https://support.nagios.com/kb/article.p ... ategory=44

UPDATE: profile received and shared with techs

[hoegh]

Hi ,

The mysql version is :
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1.

I have PM you the system profile.

Thanks & Regards,
Neha Singh.

[dwhitfield]

Please attach or PM your /etc/my.cnf.

Also, please run through the following commands in order:
# service nagios stop
# service ndo2db stop
# service mysqld stop
# service crond stop
# service httpd stop
# killall -9 nagios
# killall -9 ndo2db
# rm -f /usr/local/nagios/var/rw/nagios.cmd
# rm -f /usr/local/nagios/var/nagios.lock
# rm -f /usr/local/nagios/var/ndo.sock
# rm -f /usr/local/nagios/var/ndo2db.lock
# rm -f /usr/local/nagiosxi/var/reconfigure_nagios.lock
# for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
# service mysqld start
# service ndo2db start
# service nagios start
# service httpd start
# service crond start

[hoegh]

Hi,

We have executed the above commands ,and now we are not getting any alerts.
We will monitor for couple of days ,then we will update you.

Thanks & Regards,
Neha Singh.

[dwhitfield]

Fantastic. If you continue to have issues, please attach or PM your /etc/my.cnf