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

Database grants with escape characters do not work (strip_db_esc)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.3
    • Fix Version/s: 2.5.6
    • Component/s: mariadbclient
    • Labels:
      None
    • Environment:
      Percona XtraDB cluster 5.7.29
    • Sprint:
      MXS-SPRINT-117

      Description

      Dear all,

      Since the migration to Maxscale 2.4 -> 2.5 (worked well in 2.4), we cannot connect to any database via mysql command:
      mysql -u test -ptest -P 3306 -h XXXX: works
      mysql -u test -ptest -P 3406 -h XXXX: doesn't works: ERROR 1044 (42000): Access denied for user 'test '@'XXXX' to database 'test'

      SELECT permissions has been added to tables_priv & columns_priv also. Not added for roles_mapping because this table doesn't exist with Percona.

      Maxscale logs (with info):

      2020-09-10 16:53:39   info   : (1) Found matching user entry 'test'@'%' for client 'test'@'XXXX' but user does not have access to database 'test'.
      2020-09-10 16:53:39   info   : Read 28 user@host entries from 'XXXX' for service 'XX-Service'. The data was identical to existing user data.
      2020-09-10 16:53:39   warning: (1) [mariadbclient] Authentication failed for user 'test'@[XXXX] to service 'XX-Service'. Originating listener: 'XX-Listener'.
      MariaDB error: 'Access denied for user 'test'@'XXXX' to database 'test''.
      2020-09-10 16:53:39   info   : Stopped XX-Service client session [1]
      

      Maxscale conf:

      [maxscale]
      threads=auto
      writeq_high_water=64Mi
      writeq_low_water=32Mi
       
      [XXXX1]
      type=server
      protocol=MariaDBBackend
      address=XXXX1
      port=3306
      priority=2
       
      [XXXX2]
      type=server
      protocol=MariaDBBackend
      address=XXXX2
      port=3306
      priority=1
       
      [MariaDB-Monitor]
      type=monitor
      module=galeramon
      servers=XXXX1,XXXX2
      user=XX
      password=XX
      monitor_interval=2000
      available_when_donor=true
      use_priority=true
       
      [dt-acc-db-Service]
      type=service
      router=readwritesplit
      servers=XXXX1,XXXX2
      user=XX
      password=XX
      connection_keepalive=10
       
      [XX-Listener]
      type=listener
      service=XX-Service
      protocol=MariaDBClient
      address=0.0.0.0
      port=3406
      

      Best regards,

        Attachments

          Activity

            People

            Assignee:
            esa.korhonen Esa Korhonen
            Reporter:
            anthosz Anthony
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration