monitoring-plugins-standard check_mysql missing

[Bernd Wahlen]

[Impact]

monitoring-plugins-standard in Hirsute is missing the check_mysql plugin, which is present in Focal and >= Impish. The plugin is used to tests connections to a MySQL server [1]. This is a regression for people updating from Focal to Hirsute.

[Test Plan]

Check that the check_mysql plugin is actually built and installed. Actual functionality can be verified manually by running the following (without mysql-server-8.0 installed):

$ /usr/lib/nagios/plugins/check_mysql
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

and the following (after installing mysql-server-8.0):

$ /usr/lib/nagios/plugins/check_mysql

Access denied for user 'ubuntu'@'localhost' (using password: NO)
$ sudo /usr/lib/nagios/plugins/check_mysql
Uptime: 26 Threads: 2 Questions: 2 Slow queries: 0 Opens: 117 Flush tables: 3 Open tables: 36 Queries per second avg: 0.076|Connections=9c;;; Open_files=2;;; Open_tables=53;;; Queries=3c;;; Questions=1c;;; Table_locks_waited=0c;;; Threads_connected=1;;; Threads_running=2;;; Uptime=26c;;;

[Where problems could occur]

I don't see concrete risks coming from building the missing plugin, as at the moment it's entirely missing. I only see the generic risk of rebuilding a package against newer libraries.

[Development Fix]

The bug only affects Hirsute.

[1] https://www.monitoring-plugins.org/doc/man/check_mysql.html

[Original Description]

check_mysql is included in 20.04 and also in 21.10
but missing in current 21.04

https://packages.ubuntu.com/focal/amd64/monitoring-plugins-standard/filelist
https://packages.ubuntu.com/hirsute/amd64/monitoring-plugins-standard/filelist
https://packages.ubuntu.com/impish/amd64/monitoring-plugins-standard/filelist

i installed impish package on on hirsute and it works for me, so what is the reason of the missing files?
wget http://de.archive.ubuntu.com/ubuntu/pool/universe/m/monitoring-plugins/monitoring-plugins-standard_2.3.1-1ubuntu2_amd64.deb
dpki -i monitoring-plugins-standard_2.3.1-1ubuntu2_amd64.deb

[Paride Legovini (paride)]

Hello Bernd and thanks for this bug report. Your are right: check_mysql is missing from Hirsute but present in Focal and Impish. The Hirsute build log [1] shows the following at the configure stage:

checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmariadbclient... no

while for the versions in Focal and Impish we have:

checking for mysql_init in -lmysqlclient... yes

Interestingly if src:monitoring-plugins is rebuilt today in an up-to-date Hirsute chroot, then mysql_init is found and check_mysql is built and installed. What changed is the version of the libmysqlclient-dev build-dep (or, better, of src:mysql-8.0). The buggy version of the package has been built against version 8.0.23-1, which interestingly never left hirsute-proposed. Hirsute at the moment ships version 8.0.26-0ubuntu0.21.04.3.

I believe we simply need a no-change rebuild to fix this.

[1] https://launchpadlibrarian.net/520824312/buildlog_ubuntu-hirsute-amd64.monitoring-plugins_2.3-1ubuntu1_BUILDING.txt.gz

[Brian Murray (brian-murray)]

Hello Bernd, or anyone else affected,

Accepted monitoring-plugins into hirsute-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/monitoring-plugins/2.3-1ubuntu1.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-hirsute to verification-done-hirsute. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-hirsute. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Paride Legovini (paride)]

Verification:

root@paride-h:~# ls -l /usr/lib/nagios/plugins/check_mysql*
-rwxr-xr-x 1 root root 35896 Oct 18 13:22 /usr/lib/nagios/plugins/check_mysql
-rwxr-xr-x 1 root root 31496 Oct 18 13:22 /usr/lib/nagios/plugins/check_mysql_query

root@paride-h:~# /usr/lib/nagios/plugins/check_mysql
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

And after installing mysql-server-8.0:

root@paride-h:~# /usr/lib/nagios/plugins/check_mysql
Uptime: 28 Threads: 2 Questions: 2 Slow queries: 0 Opens: 117 Flush tables: 3 Open tables: 36 Queries per second avg: 0.071|Connections=8c;;; Open_files=2;;; Open_tables=53;;; Queries=3c;;; Questions=1c;;; Table_locks_waited=0c;;; Threads_connected=1;;; Threads_running=2;;; Uptime=28c;;;

[Łukasz Zemczak (sil2100)]

Please remember to state the version number used for testing next time!

[Łukasz Zemczak (sil2100)]

The verification of the Stable Release Update for monitoring-plugins has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

[Launchpad Janitor (janitor)]

This bug was fixed in the package monitoring-plugins - 2.3-1ubuntu1.1

---------------
monitoring-plugins (2.3-1ubuntu1.1) hirsute; urgency=medium

  * No change rebuild against newer mysql build-deps. (LP: #1947141)

 -- Paride Legovini <email address hidden> Mon, 18 Oct 2021 15:22:12 +0200