Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.0.18
-
None
-
CentOS Linux release 7.0.1406
Description
Unable to set the server_audit_file_path to any directory outside the data dir. As per the variable status we are able to set the path to a different location, outside the data dir. But the logs are not physically created. Following are the details.
#chown -R mysql.mysql /media
|
MariaDB [(none)]> SET GLOBAL server_audit_logging=OFF; |
Query OK, 0 rows affected (0.00 sec) |
MariaDB [(none)]> SET GLOBAL server_audit_file_path="/media/backups/audit/server_audit.log"; |
Query OK, 0 rows affected (0.00 sec) |
|
|
MariaDB [(none)]> SET GLOBAL server_audit_logging=ON; |
Query OK, 0 rows affected, 2 warnings (0.00 sec) |
|
|
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'server_audit_file_path%'; |
+------------------------+---------------------------------------+ |
| Variable_name | Value |
|
+------------------------+---------------------------------------+ |
| server_audit_file_path | /media/backups/audit/server_audit.log |
|
+------------------------+---------------------------------------+ |
1 row in set (0.00 sec) |
MariaDB [(none)]> set global server_audit_file_rotate_now=ON; |
Query OK, 0 rows affected (0.00 sec) |
# ll /media/backups/audit/
|
total 0
|