This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Audit Plugin whit Logrotate problem

hello, i use audit plugin whit below settings; while plugin writing logfile, logrotate changes file name and create new logfile but audit_plugins stops write logs. i checked both old and new files there is no new event. when i restart mariadb server its start again and write newly created file. as i understand this variable control force rotate "server_audit_file_rotate_now | ON" but i tried multiple times i cant solve problem can u give me any information about this issue?

+-------------------------------+---------------------------------+
| Variable_name                 | Value                           |
+-------------------------------+---------------------------------+
| server_audit_events           | CONNECT,QUERY,TABLE             |
| server_audit_excl_users       | app_usr                   |
| server_audit_file_path        | /var/log/mysql/server_audit.log |
| server_audit_file_rotate_now  | ON                              |
| server_audit_file_rotate_size | 1000000                         |
| server_audit_file_rotations   | 0                               |
| server_audit_incl_users       |                                 |
| server_audit_logging          | ON                              |
| server_audit_mode             | 0                               |
| server_audit_output_type      | file                            |
| server_audit_query_log_limit  | 1024                            |
| server_audit_syslog_facility  | LOG_USER                        |
| server_audit_syslog_ident     | mysql-server_auditing           |
| server_audit_syslog_info      |                                 |
| server_audit_syslog_priority  | LOG_INFO                        |
+-------------------------------+---------------------------------+
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.