Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-783

Could not connect to HostAddress{host='10.x.x.x', port=3306, type='master'}. PAM authentication request multiple passwords, but 'password2' is not set

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5.2, 2.6.0, 2.6.2
    • Fix Version/s: 2.7.0
    • Component/s: authentication
    • Labels:
      None
    • Environment:
      MariaDB-server-10.3.21-1.el7.centos.x86_64
      mariadb-java-client-2.5.2.jar until mariadb-java-client-2.6.0.jar

      Description

      Reconnect to a PAM_LDAP account in mysqld will cause below error:
      java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: Could not connect to HostAddress

      {host='10.x.x.x', port=3306, type='master'}

      . PAM authentication request multiple passwords, but 'password2' is not set

      First connect is okay, and queries can run, etc.
      If a reconnect fails, things will work if restart the DB client used so that DB client connects to mysqld first time again after restart.

      The JDBC driver has been tested using multiple DB client apps (ie: Squirrel SQL, SQL Workbench/J) & effect is the same.

      JDBC drivers that can reproduce this problem are of below versions:
      mariadb-java-client-2.5.2.jar
      until
      mariadb-java-client-2.6.0.jar

      Drivers of below version are okay (initial connect & multiple subsequent reconnects are all ok):
      mariadb-java-client-2.4.3.jar
      mariadb-java-client-2.4.4.jar
      mariadb-java-client-2.5.0.jar
      mariadb-java-client-2.5.1.jar

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              diego dupin Diego Dupin
              Reporter:
              khchan Chan Kar Heng
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration