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

Whitelisting of functions using dbfwfilter.

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • dbfwfilter
    • None
    • 2017-37

    Description

      It is possible to bypass the masking performed by the masking filter by using a function.

      E.g.

      > select a from tbl;
      +-------+
      | a     |
      +-------+
      | XXXXX |
      +-------+
      > select concat(a) from tbl;
      +-----------+
      | concat(a) |
      +-----------+
      | hello     |
      +-----------+
      

      This can be prevented using the firewall filter, but that requires you to explicitly specify each and every function, which is quite unpractical.

      With the firewall filter, it should be possible to easily

      • block all functions, and
      • whitelist specific functions.

      Attachments

        Activity

          People

            markus makela markus makela
            johan.wikman Johan Wikman
            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.