MySQL Enterprise Firewall : Unable to register Firewall Allowlist (Doc ID 2671231.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

If you disable the following parameters, even you already registered any allowlist, MySQL Enterprise Firewall does not recognized it and all query will be blocked by MySQL Enterprise Firewall.

performance_schema_max_thread_classes
performance_schema_max_thread_instances

With the above options disabled, refer to the MYSQL_FIREALL_WHITELIST table after registering to allowlist, nothing is registered and the following results are returned.

mysql> SELECT RULE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST WHERE USERHOST = '<username>@<hostname>';
+------------+
| RULE |
+------------+
| 0x00 |
+------------+
1 row in set (0.00 sec)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.