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

Run-time modification of users_refresh_time and users_refresh_interval are not immediately taken into use

    XMLWordPrintable

Details

    Description

      Taken into use once user accounts are updated.

      Steps to reproduce:

      maxctrl alter maxscale users_refresh_interval=60s && 
      maxctrl show maxscale | grep users_refresh_interval && 
      sleep 90 && 
      maxctrl show maxscale | grep users_refresh_interval && 
      mariadb -h127.0.0.1 -P4100 -uroot -pWrongPass

      Maxscale logs:

      2025-08-07 12:40:50   info   : Accept authentication from 'admin', using password. Request: /v1/maxscale
      2025-08-07 12:40:50   info   : Accept authentication from 'admin', using password. Request: /v1/maxscale
      2025-08-07 12:42:20   info   : Accept authentication from 'admin', using password. Request: /v1/maxscale
      2025-08-07 12:42:20   info   : (1) [MariaDBProtocol] Connection attributes: _os=Linux _client_name=libmariadb _pid=5841 _client_version=3.1.25 _platform=aarch64 program_name=mysql _server_host=127.0.0.1
      2025-08-07 12:42:20   info   : (1) Found matching user 'root'@'localhost' for client 'root'@'::ffff:127.0.0.1' with sufficient privileges.
      2025-08-07 12:42:20   warning: (1) [MariaDBProtocol] Authentication failed for user 'root'@[::ffff:127.0.0.1] to service 'Async-RW-Service'. Originating listener: 'Async-RW-Listener'. MariaDB error: 'Access denied for user 'root'@'::ffff:127.0.0.1' (using password: YES)'.
      2025-08-07 12:42:20   info   : (1) Stopped Async-RW-Service client session [1]
      2025-08-07 12:42:20   info   : Read 9 user@host entries from 'node1' for service 'Async-RW-Service'. The data was identical to existing user data.
      2025-08-07 12:43:20   info   : Read 9 user@host entries from 'node1' for service 'Async-RW-Service'. The data was identical to existing user data.
      2025-08-07 12:44:20   info   : Read 9 user@host entries from 'node1' for service 'Async-RW-Service'. The data was identical to existing user data.
      

      Expectations:

      1. Setting the `_time` and `_interval` will immediately take affect
      2. Not requiring a bad login to kick start the process

      Attachments

        Activity

          People

            markus makela markus makela
            esa.korhonen Esa Korhonen
            Votes:
            0 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.