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

ALTER TABLE statements not working with masking filter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.9
    • Fix Version/s: 6.2.0
    • Component/s: masking
    • Labels:
      None
    • Environment:
      CentOS 7.8.2003, MariaDB10.2.x Backends

      Description

      Not sure if it is 100% a bug.

      When applying a masking filter that for example should mask out passwords on specific database.tables.column I am not able to run any ALTER TABLE queries. These queries are blocked with

      The statement could not be fully parsed and will hence be rejected (masking filter).
      

      even when I log in as one of the users listed as exempted

      My filter rule

      {
              "rules": [
                      {
                              "replace": {
                                      "column": "passwd",
                                      "table": "sometable",
                                      "database": "somedatabase"
                              },
                              "with": {
                                      "value":"*",
                                      "fill":"*"
                              },
                              "exempted": ["user1@%","user2@%"]
                      }
              ]
      }
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            rbuchinger Robert Buchinger
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.