MySQL Bugs: #81647: Server post-install script "mysql-systemd-start" needs missing "mysqladmin"

Bug #81647	Server post-install script "mysql-systemd-start" needs missing "mysqladmin"
Submitted:	30 May 2016 20:58	Modified:	16 Jun 2016 16:20
Reporter:	Nicolas Cuissard	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.6.30	OS:	Debian (jessie)
Assigned to:		CPU Architecture:	Any
Tags:	Debian, mysqladmin, PACKAGE

Description:
On Debian Jessie, the "mysql-community-server" packages runs the "/usr/share/mysql/mysql-systemd-start post" script after the installation.

This script has a pinger() function that uses the "mysqladmin" tool.

"mysqladmin" is part of the mysql-community-client package and it is missing if not explicitly installed, therefore the pinger() function enters in an infinite loop.

How to repeat:
Install mysql-community-server on a fresh Debian Jessie installation that has systemd. The installation hangs during "/usr/share/mysql/mysql-systemd-start post".

Suggested fix:
Make the mysql-community-server package dependent of mysql-community-client and make sure mysqladmin exists before running "/usr/share/mysql/mysql-systemd-start post".

Thanks for the report. This problem is that the server has a weak dependency on the client (recommended, not required), which of course doesn't make sense when the server script actually use the client.

Needs to be changed from Recommends: to Depends: on mysql-client.

Posted by developer:
 
Noted in 5.7.14 changelog.

Several issues for Debian/Ubuntu packages were fixed:

The mysql-systemd-start script in the mysql-community-server package
depended on mysqladmin for the ping command. Packages including this
script now are made dependent on the mysql-community-client package.

The systemd service still used mysqld_safe. It now uses mysqld
--initialize.

Entering a blank root password during the installation process caused
installation to hang.

MySQL upgrades failed to create a missing data directory.

In addition, CMake-generated packaging for Debian/Ubuntu packages was
refactored for improved maintainability.