[MXS-72] dbfwfilter on_queries clause appears to be ignored Created: 2015-03-27  Updated: 2015-04-27  Resolved: 2015-03-28

Status: Closed
Project: MariaDB MaxScale
Component/s: dbfwfilter
Affects Version/s: 1.1.0
Fix Version/s: 1.1.0

Type: Bug Priority: Blocker
Reporter: Kolbe Kegel (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
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.



 Comments   
Comment by markus makela [ 2015-03-28 ]

This was documented as on_queries even though the code was looking for a on_operations keyword. The behavior is now in line with the documentation.

Comment by Timofey Turenko [ 2015-04-27 ]

automated tests uses on_queries in several places and it works

Generated at Thu Feb 08 03:56:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.