Hi team,
We are testing the audit log filter component for percona 8.4.5 . I have successfully installed component but when i am trying to create this filter:
SET @exclude = ‘{ “filter”: { “log”: true, “class”: { “name”: “general”, “event”: { “name”: “query”, “action”: { “name”: [ “commit”,“insert”,“insert_select”,“purge”,“purge_before_date”, “replace_select”,“replace”,“select”,“update”,“update_multi”, “truncate”,“xa_end”,“xa_commit”,“xa_prepare”,“xa_recover”, “xa_rollback”,“xa_start”,“rollback_to_savepoint”,“rollback” ], “log”: false } } } } }’; SELECT audit_log_filter_set_filter(‘log_except_list’, @exclude); SELECT audit_log_filter_set_user(‘%’, ‘log_except_list’); SELECT audit_log_filter_flush();
i am getting error :
ERROR: Failed to check filtering rule name existence
even i tried to create minimal filter SELECT audit_log_filter_set_filter(
-> 'log_test',
-> '{"filter":{"rules":\[{"rule":{"log":true}}\]}}'
-> );
±----------------------------------------------------------------------------------------------+
| audit_log_filter_set_filter(
‘log_test’,
‘{“filter”:{“rules”:[{“rule”:{“log”:true}}]}}’
) |
±----------------------------------------------------------------------------------------------+
| ERROR: Failed to check filtering rule name existence |
±----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Can someone help if seen the similar issue .
root> SELECT TABLE_NAME, ENGINE, TABLE_ROWS
-> FROM information_schema.TABLES
-> WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME IN ('audit_log_filter','audit_log_user');
+------------------+--------+------------+
| TABLE_NAME | ENGINE | TABLE_ROWS |
+------------------+--------+------------+
| audit_log_filter | InnoDB | 0 |
| audit_log_user | InnoDB | 0 |
+------------------+--------+------------+
root> SHOW TABLES IN mysql LIKE 'audit_log%';
+------------------------------+
| Tables_in_mysql (audit_log%) |
+------------------------------+
| audit_log_filter |
| audit_log_user |
+------------------------------+
root> select * from component ;
+--------------+--------------------+------------------------------------+
| component_id | component_group_id | component_urn |
+--------------+--------------------+------------------------------------+
| 1 | 1 | file://component_validate_password |
| 3 | 3 | file://component_audit_log_filter |
+--------------+--------------------+------------------------------------+
2 rows in set (0.00 sec)