MySQL Workbench 6.0.6 PAM Auth Fails
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Invalid
|
Undecided
|
Unassigned | ||
percona-pam-for-mysql |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Description:
When connecting to server with PAM authentication enabled - testing the connection works fine but trying to actually use the new connection i.e. double click from the list returns an access denied error.
Below is the log from PAM when access denied:
Aug 24 00:59:21 centos6 mysqld: pam_warn(
Aug 24 00:59:21 centos6 unix_chkpwd[12538]: password check failed for user (apc_user)
Aug 24 00:59:21 centos6 mysqld: pam_unix(
And is when I only do connection test:
Aug 24 01:00:35 centos6 mysqld: pam_warn(
Note this is tested only with Percona Server with its auth_pam_compat that is meant to be compatible with the one that comes with enterprise subscription from Oracle. So this may be Percona Server specific as well, I hope Oracle can verify if this is or not a bug with Workbench.
Percona Server 5.5.32 on Linux, WB 6.0.6 on Windows 7 x64
How to repeat:
1. Follow this procedure for the apc_user http://
2. Setup a connection on WB make sure to toggle enable cleartext authentication under Advanced tab.
Reported upstream to verify whether this is WB specific http://
Changed in percona-pam-for-mysql: | |
status: | New → Invalid |
Does it work with any older MySQL Workbench version?