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

dbfwfilter on_queries clause appears to be ignored

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.1.0
    • Component/s: dbfwfilter
    • Labels:
      None

      Description

      I'm not too sure what's going on here, but it seems like my on_queries clause is simply being ignored. I have on_queries delete, but the filter is blocking my select statement.

      [Database Firewall]
      type=filter
      module=dbfwfilter
      rules=/home/skysql/dbfwfilter_rules.txt

      [skysql@max1 ~]$ cat /home/skysql/dbfwfilter_rules.txt
      rule testrule deny no_where_clause on_queries delete
      users kolbe@% testuser@% match strict_all rules testrule

      [root@max1 ~]# mysql -h 192.168.30.38 -P4006 -u kolbe -ppass  -e 'select * from test.t1'
      ERROR 1141 (HY000) at line 1: Access denied for user 'kolbe'@'192.168.30.38': Required WHERE/HAVING clause is missing.

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            kolbe Kolbe Kegel (Inactive)
            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.