Page 1 of 1
Closing Mysql sessions from monitoring Nagios
Posted: Wed Jul 17, 2019 9:52 am
by evisus
Hi all!!. I would like to know how Nagios manages the closing of sessions to Mysql from the plugins. Our DBA calls us for many open sessions that originate from our Nagios server and that has been causing problems
Thank you
Re: Closing Mysql sessions from monitoring Nagios
Posted: Wed Jul 17, 2019 11:57 am
by benjaminsmith
Hello
@evisus,
You may have an issue with corrupted database tables. Log into the server as root and run the following command to check and repair the database.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
If the issue persists, please send us your system profile for us to review.
Thanks.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
Re: Closing Mysql sessions from monitoring Nagios
Posted: Fri Jul 19, 2019 1:49 pm
by evisus
Hello @benjaminsmith.
I think I've explained myself wrong, I'm sorry.
Nagios is monitoring a MySQL database on a remote server. According to the DBA, nagios is leaving sessions open to MySQL and that is causing problems.
My question is whether the plugin used in the Nagios XI Wizard closes sessions to MySQL when finished running the plugins
Thank you!
Re: Closing Mysql sessions from monitoring Nagios
Posted: Fri Jul 19, 2019 3:33 pm
by benjaminsmith
Hi
@evisus,
What do you have your check interval set at for those services?
Also, the plugin used by the wizard is
check_mysql_health,. The latest version is 2.2.2, and you may want to upgrade as it's possible you maybe hitting a bug.
To check the version:
Code: Select all
cd /usr/local/nagios/libexec
./check_mysql_health -V
Upgrade instructions are found in the readme file of the plugin archive.
Re: Closing Mysql sessions from monitoring Nagios
Posted: Fri Jul 26, 2019 3:05 pm
by evisus
Thank you.
The interval is 5 minutes.
We are going to update the plugins.
I will be reporting results
Re: Closing Mysql sessions from monitoring Nagios
Posted: Fri Jul 26, 2019 4:02 pm
by benjaminsmith
We are going to update the plugins.
I will be reporting results
Sounds good. We'll wait for your reply.