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

dbfwfilter on_queries clause appears to be ignored

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.1.0
    • 1.1.0
    • dbfwfilter
    • 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

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