Failure in systemd while using auth_pam_compat

There is a piece of code in init.d script that checks if mysql is operational.
/etc/init.d/mysql
128 if ! $(mysqladmin --no-defaults --socket="$socket" --user=UNKNOWN_MYSQL_USER ping &>/dev/null) ;then
129 ping_alive=0
130 fi
It’s working fine for a check, but if you use auth_pam_compat plugin, trying to authenticate with UNKNOWN_MYSQL_USER will give non-zero return code, and, thus will fail systemd unit. The reason for that is in client parameters. --enable-cleartext-plugin option should be provided on cli. But, IMO, this behaviour should be reflected in init script.

1 Like

Hello Alex, thanks for spotting this. May I ask you to open a bug at jira.percona.com so dev can look into this?

1 Like

Sure, [PS-8043] Failure in systemd while using auth_pam_compat - Percona JIRA

1 Like

thank you for the report!

1 Like