[MDEV-26344] MariaDB server Access denied for AD user Created: 2021-08-12  Updated: 2021-09-12  Resolved: 2021-09-12

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.5.11
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: MOHAMMAD SAMSAD HUSSAIN Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback


 Description   

Hi,

I am trying to access the MariaDB server for both local and AD users. Successful in accessing local user, but failed with an AD user. Configuration carried out below for MariaDB access for the AD user.

Please help to fix this error.

MariaDB Version : 10.5.11

>> Error from AD User>>>>
mysql -u hssn_ms -p
Enter password:
ERROR 1045 (28000): Access denied for user 'hssn_ms'@'localhost' (using password: NO)

<<<< USER Table Detail>>>>>

MariaDB [mysql]> select Host, User, Password, plugin from user where User = 'hssn_ms';
 
+---------------------+---------+----------+--------+
 
| Host                | User    | Password | plugin |
 
+---------------------+---------+----------+--------+
 
| db104.xyzz.xyz | hssn_ms |          | pam    |
 
| %                   | hssn_ms |          | pam    |
 
| localhost           | hssn_ms |          | pam    |
 
+---------------------+---------+----------+--------+
 
3 rows in set (0.001 sec)

<<< pam Configuration for MariaDB >>>

$ cat /etc/pam.d/maraidb
 
auth required pam_unix.so audit
 
auth required pam_user_map.so debug
 
account required pam_unix.so audit

Thanks,
Shamshad

 Comments   
Comment by Sergei Golubchik [ 2021-08-14 ]

You only have pam_unix.so in your pam config. Why would it check AD?

Generated at Thu Feb 08 09:44:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.