|
本帖最后由 edgar_mu 于 2024-8-14 10:48 编辑 GreatSQL审计日志里的timestamp值有问题，样例如图 例如： "timestamp":"2024-08-13T15:06:01Z" ， 为当前时间+Z Z已经代表UTC了，换算到东八区，就是： 2024-08-13 23:06:01 了，是不是哪里设置有问题？ time_zone配置如下： | Variable_name | Value | +-------------------------------------+--------+ | group_replication_zone_id | 0 | | group_replication_zone_id_sync_mode | ON | | system_time_zone | CST | | time_zone | +08:00 | audit配置如下： +-----------------------------+----------------------+ | Variable_name | Value | +-----------------------------+----------------------+ | audit_log_buffer_size | 1048576 | | audit_log_enabled | 1 | | audit_log_exclude_accounts | xxx@127.0.0.1 | | audit_log_exclude_commands | | | audit_log_exclude_databases | | | audit_log_file | audit.log | | audit_log_flush | OFF | | audit_log_format | JSON | | audit_log_handler | FILE | | audit_log_include_accounts | | | audit_log_include_commands | | | audit_log_include_databases | | | audit_log_max_rows | 2147483647 | | audit_log_policy | ALL | | audit_log_rotate_on_size | 0 | | audit_log_rotations | 0 | | audit_log_strategy | ASYNCHRONOUS | | audit_log_syslog_facility | LOG_USER | | audit_log_syslog_ident | percona-audit | | audit_log_syslog_priority | LOG_INFO | | audit_log_to_table | 0 | +-----------------------------+----------------------+ |
|
|
KAiTO
2024-8-13 16:31:26
| |
|
|
yejr
2024-8-13 17:07:37
| |
|
|
edgar_mu
2024-8-14 10:46:28
| |
|
|
edgar_mu
2024-8-14 10:47:03
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
