mysql-systemd fails with PAM auth and proxies

Bug #1558312 reported by Nathan Stone
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Fix Released
Undecided
Tomislav Plavcic
5.6
Fix Released
Undecided
Tomislav Plavcic
5.7
Invalid
Undecided
Tomislav Plavcic

Bug Description

https://github.com/percona/percona-server/commit/136b0a03f4c814800b2dbc4e534b94b4ec2fd0c3

This changes causes mysql-systemd to fail on startup when using pam_auth_compat and proxy users because when UNKNOWN_MYSQL_USER doesn't match a local user, the pam plugin attempts to authenticate against the ''@'' user. pam_auth_compat requires the cleartext password plugin to be enabled, but the absence of environment variables and the "--no-defaults" option lead to a plugin error being returned instead of "access denied".

Tags: pam pkg
tags: added: pkg
Changed in percona-server:
assignee: nobody → Tomislav Plavcic (tplavcic)
tags: added: pam
Revision history for this message
Nathan Stone (nastone) wrote :

I just discovered a work around. If you create a user ''@'localhost' using auth_pam or native authentication, it doesn't need to use the cleartext authentication plugin and returns "access denied" as the startup script expects.

Revision history for this message
Tomislav Plavcic (tplavcic) wrote :

We will revert adding the UNKNOWN_MYSQL_USER and "--no-defaults" for the next releases. The socket option that was added in the linked change is needed for custom socket locations.

Revision history for this message
Tomislav Plavcic (tplavcic) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3396

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.