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

Authentication failed on binlogrouter service

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 2.5.16, 2.5.18
    • N/A
    • binlogrouter
    • None
    • CentOS Stream 8

    Description

      Have simple config

      [db_11]
      type=server
      address=172.16.13.9
      port=3306
      protocol=MariaDBBackend
       
      [db_12]
      type=server
      address=172.16.12.5
      port=3306
      protocol=MariaDBBackend
       
      [MariaDB-Monitor]
      type=monitor
      module=mariadbmon
      servers=db_11,db_12
      user=maxscale_user
      password=maxscale_pass
      monitor_interval=2s
      auto_failover=false
      auto_rejoin=false
       
      [Replication-Proxy]
      type=service
      router=binlogrouter
      cluster=MariaDB-Monitor
      select_master=true
      expire_log_duration=5h
      expire_log_minimum_files=3
      user=maxscale_user
      password=maxscale_pass
       
      [Replication-Listener]
      type=listener
      service=Replication-Proxy
      protocol=MariaDBClient
      port=3303
      

      Log:

      2022-02-01 23:21:02   notice : The systemd watchdog is Enabled. Internal timeout = 30s
      2022-02-01 23:21:02   notice : Worker message queue size: 1MiB
      2022-02-01 23:21:02   notice : Using up to 18.77GiB of memory for query classifier cache
      2022-02-01 23:21:02   notice : syslog logging is enabled.
      2022-02-01 23:21:02   notice : maxlog logging is enabled.
      2022-02-01 23:21:02   notice : Running OS: Linux@4.18.0-358.el8.x86_64, #1 SMP Mon Jan 10 13:11:20 UTC 2022, x86_64 with 40 processor cores.
      2022-02-01 23:21:02   notice : Total usable main memory: 125.14GiB.
      2022-02-01 23:21:02   notice : MariaDB MaxScale 2.5.16 started (Commit: 34282097d0d149abb22c4d272da1da47415eb775)
      2022-02-01 23:21:02   notice : MaxScale is running in process 245268
      2022-02-01 23:21:02   notice : Configuration file: /etc/maxscale.cnf
      2022-02-01 23:21:02   notice : Log directory: /var/log/maxscale
      2022-02-01 23:21:02   notice : Data directory: /var/lib/maxscale
      2022-02-01 23:21:02   notice : Module directory: /usr/lib64/maxscale
      2022-02-01 23:21:02   notice : Service cache: /var/cache/maxscale
      2022-02-01 23:21:02   notice : Working directory: /var/log/maxscale
      2022-02-01 23:21:02   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
      2022-02-01 23:21:02   notice : Query classification results are cached and reused. Memory used per thread: 480.55MiB
      2022-02-01 23:21:02   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
      2022-02-01 23:21:02   notice : MaxScale started with 40 worker threads, each with a stack size of 8388608 bytes.
      2022-02-01 23:21:02   notice : Loading /etc/maxscale.cnf.
      2022-02-01 23:21:02   notice : /etc/maxscale.cnf.d does not exist, not reading.
      2022-02-01 23:21:02   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
      2022-02-01 23:21:02   notice : Loaded module binlogrouter: V1.0.0 from /usr/lib64/maxscale/libbinlogrouter.so
      2022-02-01 23:21:02   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
      2022-02-01 23:21:02   warning: (Replication-Proxy) No (replication) master found. Retrying silently until one is found.
      2022-02-01 23:21:02   notice : (Replication-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
      2022-02-01 23:21:02   notice : Started REST API on [0.0.0.0]:8989
      2022-02-01 23:21:02   notice : 'db_12' sent version string '10.4.22-MariaDB-log'. Detected type: 'MariaDB', version: 10.4.22.
      2022-02-01 23:21:02   notice : 'db_11' sent version string '10.4.15-MariaDB-log'. Detected type: 'MariaDB', version: 10.4.15.
      2022-02-01 23:21:02   notice : Server 'db_12' charset: latin1
      2022-02-01 23:21:02   notice : Server 'db_11' charset: latin1
      2022-02-01 23:21:02   notice : Starting a total of 1 services...
      2022-02-01 23:21:02   notice : (Replication-Listener) Listening for connections at [::]:3303
      2022-02-01 23:21:02   notice : Service 'Replication-Proxy' started (1/1)
      2022-02-01 23:21:03   notice : Read 28 user@host entries from 'db_11' for service 'Replication-Proxy'.
      2022-02-01 23:21:12   error  : (Replication-Proxy) Error received during replication from '172.16.13.9:3306': Failed to fetch binlog event from master: Could not find GTID state requested by slave in any binlog files. Probably the slave state is too old and required binlog files have been purged.
      

      OK, need change GTID
      trying (172.16.116.20 - IP Maxscale server):
      mysql -umaxscale_user -pmaxscale_pass -h172.16.116.20 -P3303
      ERROR 1045 (28000): Access denied for user 'maxscale_user'@'::ffff:172.16.116.20' (using password: YES)
      From other hosts the situation is the same (Access denied)
      Check 2.5.18 version - is the same
      Reset master can't do.
      Monitor is working good.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Victor Streltsov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.