Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3559

Access denied error from backend with MySQL 5.7

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 2.5.11
    • Fix Version/s: N/A
    • Component/s: Authenticator
    • Labels:
      None
    • Environment:
      Oracle Linux Server 7.9
      Server version: 5.7.32-35-log Percona Server
    • Sprint:
      MXS-SPRINT-133

      Description

      Invalid authentication message from backend 'db-master1'. Error code: 1045, Msg : #28000: Access denied for user 'user'@'...' (using password: NO)

      mysql> show global variables like '%default_authentication_plugin%';
      +-------------------------------+-----------------------+
      | Variable_name                 | Value                 |
      +-------------------------------+-----------------------+
      | default_authentication_plugin | mysql_native_password |
      +-------------------------------+-----------------------+
      

      # Global parameters
      [maxscale]
      threads=auto
      admin_host = 0.0.0.0
      admin_gui=true
      admin_auth=1
      admin_secure_gui=false
      log_debug=1
       
      # Server definitions
      [db-master1]
      type=server
      address=1.1.1.1
      port=3306
      protocol=MariaDBBackend
      rank=primary
       
      [db-slave1]
      type=server
      address=1.1.1.2
      port=3306
      protocol=MariaDBBackend
      rank=secondary
       
      [Service-for-cluster_service]
      user = maxscale
      password = ********
      filters = Hint
      max_slave_replication_lag=300
      disable_sescmd_history=false
      prune_sescmd_history=true
      lazy_connect= true
      type = service
      router = readwritesplit
      servers = db-master1, db-slave1
      master_accept_reads = true
       
      [MariaDB-Monitor-for-cluster_service]
      type = monitor
      module = mariadbmon
      user = maxscale
      password = ********
      monitor_interval = 5000
      failover_timeout = 10
      auto_failover = false
      detect_replication_lag = true
      handle_events = false
      servers = db-master1, db-slave1
       
      [Listener-for-cluster_service]
      address = 0.0.0.0
      type = listener
      service = Service-for-cluster_service
      protocol = MariaDBClient
      port = 3307
      authenticator_options=skip_authentication=true
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            Usachev Ivan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration