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

ALTER TABLE statements not working with masking filter

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.4.9
    • 6.2.0
    • masking
    • None
    • 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

            markus makela markus makela
            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.