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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.5.2, 2.6.0, 2.6.2
    • 2.7.0
    • authentication
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.