Percona PAM doesn't support spaces for groups
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
|
Medium
|
Sergei Glushchenko | |||
5.6 |
Fix Released
|
Medium
|
Sergei Glushchenko | |||
5.7 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
Let's say "tuser" is part of group "mysql ro" in LDAP
create user ''@'' identified with auth_pam as 'mysqld,"mysql ro"=readuser';
grant proxy on readuser@localhost to ''@'';
grant select on *.* to readuser@localhost;
flush privileges;
Result:
mysql> select user(), current_user(), @@proxy_user;
+------
| user() | current_user() | @@proxy_user |
+------
| tuser@localhost | @ | NULL |
+------
1 row in set (0.00 sec)
It should be that current_user() and @@proxy_user should have values readuser@localhost and ''@'' respectively.
If this is a bug, please also include fix to support special characters like backslashes too for groups so we can support groups in ActiveDirectory. Eg. "DOMAIN\
Changed in percona-pam-for-mysql: | |
status: | New → Incomplete |
summary: |
- Percona PAM doesn't support spaces for supplementary groups + Percona PAM doesn't support spaces for groups |
Changed in percona-server: | |
status: | New → Confirmed |
no longer affects: | percona-pam-for-mysql |
Updates:
The group name supports hyphen(eg. my-group) but for authentication it requires that it be case sensitive which is the same for providing the user too.
Unfortunately, for testing spaces in group, it requires Samba/Active Directory because these infra supports spaces in groups.