Bug #84961 Need timezone setting for audit log.

• Submitted: 13 Feb 2017 0:23
• Modified: 13 Feb 2017 12:34
• Reporter: Meiji Kimura
• Status: Verified
• Category: MySQL Server: Security: Audit
• Severity: S4 (Feature request)
• Version: 5.6, 5.7, 8.0
• OS: Any
• CPU Architecture: Any

[13 Feb 2017 0:23] Meiji Kimura

Description:
MySQL Enterprise Audit does log with UTC only.

https://dev.mysql.com/doc/refman/5.6/en/audit-log-file.html
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file.html

"The time zone is always UTC." in <TIMESTAMP>

Need timezone setting for audit logs (e.g. JST), like mysqld's option

log_timestamps = SYSTEM

etc...

How to repeat:
N/A

Suggested fix:
Make new option for auditlog_timestamp or behave based on mysqld's option

[13 Feb 2017 12:34] MySQL Verification Team

Hello Meiji-San,

Thank you for the report and feature request!

Thanks,
Umesh

[10 Sep 2019 6:06] MySQL Verification Team

Manual URL are chantged, and same status in MySQL 8.0.

https://dev.mysql.com/doc/refman/5.6/en/audit-log-file-formats.html
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html

[9 Nov 2019 0:28] MySQL Verification Team

Add 8.0 to Version:

[15 Jun 2021 4:04] Martin Chan

Any schedule to fix the timestamp issue?

[2 Apr 2022 0:34] Remzi AKYÜZ

Any update?