Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.11
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