[MDEV-14838] PAM authentication requires mysql user to be in the shadow group Created: 2018-01-01 Updated: 2018-02-02 Resolved: 2018-02-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Affects Version/s: | 10.1.30 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Marc BALLAT | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Debian Jessie container running on Proxmox v4 kernel 4.4.98-2-pve. |
||
| Issue Links: |
|
||||||||
| Description |
|
I need to add mysql user to the shadow group in order to get PAM authentication to work. I tried with 10.1.30 (that comes with the Debian release I installed). I also installed 10.2.11 from the MariaDB repository without luck. I still need to add mysql to the shadow group to get PAM authentication to work. Is there a safer way to proceed ? Many thanks. Marc |
| Comments |
| Comment by Elena Stepanova [ 2018-01-01 ] |
|
Here is a note from PAM plugin documentation:
It doesn't talk about MariaDB server / plugin versions, but about the version of PAM itself. Did you try to upgrade it? |
| Comment by Marc BALLAT [ 2018-01-01 ] |
|
Hi Elena, I downloaded the source code for PAM 1.3.0, did configure, make and make install but I still get : |
| Comment by Marc BALLAT [ 2018-01-02 ] |
|
I found a more detailed guide explaining how to compile PAM here. I am confused about the PAM version number as downloaded from www.linux-pam.org and the version of the library (libpam.so.0.83.1). Would you have more information on the version number of libpam that is considered recent enough to be able to use PAM without addind mysql to shadow ? Thanks in advance. Marc |
| Comment by Sergei Golubchik [ 2018-01-02 ] |
|
There are two issues here. In old PAM versions, one needed to be root to read the password from /etc/shadow. Still unix_chkpwd verifies that you're root or you're checking the password for yourself (that is for $UID), it does not allow arbitrary password checks (to prevent password brute forcing, presumably). And MariaDB is still subject to this limitation. |
| Comment by Elena Stepanova [ 2018-02-02 ] |
|
According to the comment above, it should be tracked further in the scope of |