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

Unable to connect to maxscale when dbusers reloads

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.17
    • Fix Version/s: 2.2.2
    • Component/s: Authenticator
    • Labels:
      None
    • Environment:
      Centos 6.9

      Description

      Hi there! I have some issue with maxscale when dbusers reloads. Maxscale reloads users 2 times at day: 00:10:01 and 12:10:01 o'clock. And everytime when it's done, users can't connect to mysql through maxscale. Logs and config below.

      2018-10-27 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.36]:38594, authentication failed.
      2018-10-27 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.22]:35068, authentication failed.
      2018-10-27 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.37]:59714, authentication failed.
      2018-10-27 00:10:01   notice : [MySQLAuth] [ss_splitter] Loaded 75 MySQL users for listener ss_listener.
      2018-10-27 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'maxscale_pinger'@[192.168.50.34]:47056, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.52]:43856, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.110]:36224, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.48]:35656, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local_mnt_n'@[192.168.1.32]:47066, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.30]:43196, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.109]:52420, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'k_local'@[192.168.1.27]:46920, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'k_local'@[192.168.1.27]:46924, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.38]:51986, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local_mnt_n'@[192.168.1.32]:47074, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.51]:46032, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local_mnt_n'@[192.168.1.32]:47076, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.58]:33358, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local_mnt_n'@[192.168.1.32]:47078, authentication failed.
      2018-10-27 12:10:02   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.52]:43874, authentication failed. (subsequent similar messages suppressed for 10000 milliseconds)
      2018-10-27 12:10:02   notice : [MySQLAuth] [ss_splitter] Loaded 75 MySQL users for listener ss_listener.
      2018-10-28 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.50]:54272, authentication failed.
      2018-10-28 00:10:01   warning: [MySQLAuth] ss_splitter: login attempt for user 'ss_local'@[192.168.1.23]:41204, authentication failed.
      
      

      #
      [maxscale]
      threads=auto
      maxlog=1
      syslog=0
       
      # filters
      [Hint]
      type=filter
      module=hintfilter
       
      # servers
      [ss_1]
      type=server
      address=mysql-11.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_2]
      type=server
      address=mysql-22.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_3]
      type=server
      address=mysql-3.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_4]
      type=server
      address=mysql-4.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_5]
      type=server
      address=mysql-1.local
      port=3306
      protocol=MySQLBackend
      s_weight=10
       
      [ss_6]
      type=server
      address=mysql-2.local
      port=3306
      protocol=MySQLBackend
      s_weight=10
       
      # listeners
      [ss_listener]
      type=listener
      service=ss_splitter
      protocol=MySQLClient
      address=192.168.1.2
      port=3306
       
      # monitors
      [ss_monitor]
      type=monitor
      module=mysqlmon
      servers=ss_1,ss_2,ss_3,ss_4,ss_5,ss_6
      user=maxscale
       
      passwd=YEJ3LKJDFKHAFA
      events=master_down
      failcount=3
      backend_connect_timeout=10
      backend_write_timeout=10
      backend_read_timeout=10
      monitor_interval=15000
      detect_stale_master=true
      detect_stale_slave=true
       
      # read/write splitters
      [ss_splitter]
      type=service
      router=readwritesplit
      servers=ss_1,ss_2,ss_3,ss_4,ss_5,ss_6
      user=maxscale
      passwd=YEJ3LKJDFKHAFA
      max_slave_connections=1
      filters=Hint
      disable_sescmd_history=true
      slave_selection_criteria=LEAST_GLOBAL_CONNECTIONS
      weightby=s_weight
       
      # admin section
      [MaxAdmin_Service]
      type=service
      router=cli
       
      [MaxAdmin_Listener]
      type=listener
      service=MaxAdmin_Service
      protocol=maxscaled
      address=127.0.0.1
      port=6603
      
      

        Attachments

          Activity

            People

            • Assignee:
              markus makela markus makela
              Reporter:
              iglov Igor V. Lovalev
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: