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

exasol router | unclear error message when missing servers

    XMLWordPrintable

Details

    Description

      Config

      [mariadb_exasolrouter]
      connection_string=DRIVER=/usr/lib64/maxscale/exasol/current/lib/libexaodbc.so;EXAHOST=34.221.172.180:8563;UID=admin_user;PWD=aBc123%%;FINGERPRINT=NOCERTCHECK
      password=aBcd123%
      preprocessor=internal:/usr/lib64/maxscale/exasol/maria_preprocessor.py
      router=exasolrouter
      type=service
      user=maxuser
      

      log message unclear

      2026-08-20T18:14:40+00:00   info   : (1) [MariaDBProtocol] Connection attributes: _os=Linux _client_name=libmariadb _pid=73972 _client_version=3.4.9 _platform=x86_64 program_name=mysql _server_host=127.0.0.1
      2026-08-20T18:14:40+00:00   info   : (1) [MariaDBProtocol] Authenticating client 'admin_user'@'127.0.0.1' using plugin 'mysql_native_password'.
      2026-08-20T18:14:40+00:00   error  : (mariadb_exasolrouter); No valid servers from which to query MariaDB user accounts found.
      2026-08-20T18:14:40+00:00   warning: (1) [MariaDBProtocol] Authentication failed for user 'admin_user'@[127.0.0.1] to service 'mariadb_exasolrouter'. Originating listener: 'exasol_listener'. MariaDB error: 'Access denied for user 'admin_user'@'127.0.0.1' (using password: YES)'.
      2026-08-20T18:14:40+00:00   info   : (1) Stopped mariadb_exasolrouter client session [1] for 'admin_user' from 127.0.0.1 at 'exasol_listener' on 'Worker-11'
      

      error

      error  : (mariadb_exasolrouter); No valid servers from which to query MariaDB user accounts found.
      

      should also indicate missing targets= in config

      fixed with

      targets=mariadb1
      

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            allen.herrera Allen Herrera
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 1d
                1d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 7h Time Not Required
                7h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.