MariaDB authentication does not work when MariaDB is integrated with pam+ldap
-
Hi everyone.
I’ve setup wordpress on my page on a self hosted server with mariadb-10.3 and everything worked fine until I decided to integrate my mariadb installation with PAM (to authenticate using the user created locally on the server).
The DB username is ‘casafamilia’ and what I did was to remove the current database user and add it again but now authenticating against PAM:
MariaDB [(none)]> drop user casafamilia@localhost; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> CREATE USER 'casafamilia'@'localhost' IDENTIFIED VIA pam; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> GRANT ALL ON casafamilia.* TO casafamilia@localhost; Query OK, 0 rows affected (0.001 sec)
On the command line, the user authenticates just fine:
# mysql -u casafamilia -p casafamilia Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 60 Server version: 10.3.17-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [casafamilia]>
And I have also updated the wp-config.php with the correct password.
When enabling de debug mode, the following message appears:
Warning: mysqli_real_connect(): The server requested authentication method unknown to the client [dialog] in /var/www/casafamilia.org.br/wp-includes/wp-db.php on line 1612 Warning: mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client in /var/www/casafamilia.org.br/wp-includes/wp-db.php on line 1612 The server requested authentication method unknown to the client
My guess is that the way WordPress authenticates users, specially considering it uses hash and salts to make it more secure, makes it incompatible with MariaDB+PAM.
Any help would be much appreciated.
The page I need help with: [log in to see the link]
- The topic ‘MariaDB authentication does not work when MariaDB is integrated with pam+ldap’ is closed to new replies.