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

Client restrict authentication plugin to a limited set of authentication plugin and doesn't permit requested plugin ('caching_sha2_password')

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.3
    • Fix Version/s: 3.0.4
    • Component/s: configuration
    • Labels:
      None
    • Environment:
      Rocky Linux 8

      Description

      Hello, we have updated our connectorJ to 3.0.3 and we face this issue when we try to access to our web application:

      java.sql.SQLException: Client restrict authentication plugin to a limited set of authentication plugin and doesn't permit requested plugin ('caching_sha2_password'). Current list is `restrictedAuth=mysql_native_password,client_ed25519,auth_gssapi_client`
              at org.mariadb.jdbc.plugin.authentication.AuthenticationPluginLoader.get(AuthenticationPluginLoader.java:41)
              at org.mariadb.jdbc.client.impl.ConnectionHelper.authenticationHandler(ConnectionHelper.java:286)
              at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:188)
              at org.mariadb.jdbc.Driver.connect(Driver.java:64)
              at org.mariadb.jdbc.Driver.connect(Driver.java:83)
              at org.mariadb.jdbc.Driver.connect(Driver.java:27)
              at java.sql.DriverManager.getConnection(DriverManager.java:664)
              at java.sql.DriverManager.getConnection(DriverManager.java:270)
              at it.loway.tpf.SQL.openConnection(SQL.java:62)
              at it.loway.tpf.transaction.servlets.LowayTransactionController.processClassicSynchronizedRequest(LowayTransactionController.java:492)
              at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:367)
              at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:262)
              at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:84)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
              at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1650)
              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
              at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
              at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:750)
      -- End Inner Exception --
      

      The strangeness is that if we are going to initialize the database, it works. Is there anything we can do to help debug the issue?

      Database version:

      ~ # rpm -qa | grep mysql
      mysql-common-8.0.26-1.module+el8.4.0+652+6de068a7.x86_64
      mysql-8.0.26-1.module+el8.4.0+652+6de068a7.x86_64
      mysql-server-8.0.26-1.module+el8.4.0+652+6de068a7.x86_64
      mysql-errmsg-8.0.26-1.module+el8.4.0+652+6de068a7.x86_64
      

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            agostino Agostino
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.