Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.9
-
None
-
On the Client: Windows 7 x64, Geneious, mariadb-java-client-1.1.9.jar
On the Server: CentOS 6.6, MariaDB-server 5.5.42, using PAM authentication
Description
The java client library is unable to authenticate against a server using PAM authentication for the user. The error is:
"An error occurred while connecting this account: Client does not support authentication protocol requested by server; consider upgrading MariaDB client"
This may or not be related to CONJ-129
How to reproduce:
1. Install, enable, and configure the pam plugin:
[root]# cat >/etc/pam.d/mariadb <<EOF
auth required pam_unix.so
account required pam_unix.so
EOFMariaDB [(none)]> install plugin pam soname 'auth_pam.so';
Query OK, 0 rows affected (0.00 sec)
2. Create a database and user:
[root]# echo 'testusr:$6$ThDum2kp$Qkwr/72qEalUsqCdM.SsjbJJnnX7OCxHnMgjEhAq4rTmeXwXW0dLWxDcCkoVRS8GyNZgIHtaEReJaUK4hdNMV/:13306:13306::/home/testusr:/bin/bash' >>/etc/passwd
MariaDB [(none)]> create database `testdbpam`;
MariaDB [(none)]> grant all privileges on `testdbpam`.* to testusr@'%' identified via pam using 'mariadb';[root]# mysql -u testusr -pabcdef
3. Attempt to connect from a client application using the java-client.jar library. In our case we are getting this error with Geneious, a genome annotation tool.
Attachments
Issue Links
- relates to
-
MDEV-8690 include dialog_examples.so in mariadb-server packages (Ubuntu)
- Closed