Percona Audit Plugin Server version:5.6.39-83.1

[varun saluja]

Hi,

Percona Audit plugin reports timestamp in UTC timezone.

Percona Version: :5.6.39-83.1

Audit Log reports:

{"audit_record":{"name":"Quit","record":"383_2018-06-14T12:02:01","timestamp":"2018-06-14T12:21:44 UTC"}}

Can you Please let me know way to change timezone in Mysql 5.6

Thanks

[Syamiera Ahmad Sobri]

https://mariadb.com/kb/en/library/time-zones/

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
Visit this group at https://groups.google.com/group/percona-discussion.
To view this discussion on the web visit https://groups.google.com/d/msgid/percona-discussion/2d38f6a1-a087-4b82-9e62-2764da5bd13b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[varun saluja]

Hi,

System timezone variables are in IST. Still audit log reports timestamp in UTC. Need to set same in IST for uniformity.

mysql> show variables like  '%time_z%';

+------------------+--------+

| Variable_name    | Value  |

+------------------+--------+

| system_time_zone | IST    |

| time_zone        | SYSTEM |

+------------------+--------+

2 rows in set (0.00 sec)

{"audit_record":{"name":"Query","record":"100724_2018-06-18T09:39:01","timestamp":"2018-06-18T10:12:34 UTC","command_class":"create_table","connection_id":"36","status":0,"sqltext":"create table audit_test(id int)","user":"] @ localhost []","host":"localhost","os_user":"","ip":"","db":""}}

PS: Mysql Error logs and other system logs are in IST timezone

Thanks

On 14 June 2018 at 19:39, Syamiera Ahmad Sobri <syam...@genusis.com> wrote:

https://mariadb.com/kb/en/library/time-zones/

On Thu, Jun 14, 2018, 10:03 PM varun saluja <salu...@gmail.com> wrote:

Hi,

Percona Audit plugin reports timestamp in UTC timezone.

Percona Version: :5.6.39-83.1

Audit Log reports:

{"audit_record":{"name":"Quit","record":"383_2018-06-14T12:02:01","timestamp":"2018-06-14T12:21:44 UTC"}}

Can you Please let me know way to change timezone in Mysql 5.6

Thanks

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to percona-discussion+unsub...@googlegroups.com.
To post to this group, send email to percona-discussion@googlegroups.com.

Visit this group at https://groups.google.com/group/percona-discussion.
To view this discussion on the web visit https://groups.google.com/d/msgid/percona-discussion/2d38f6a1-a087-4b82-9e62-2764da5bd13b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Percona Discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to percona-discussion+unsub...@googlegroups.com.
To post to this group, send email to percona-discussion@googlegroups.com.

Visit this group at https://groups.google.com/group/percona-discussion.

To view this discussion on the web visit https://groups.google.com/d/msgid/percona-discussion/CAML%3Dijq5qhzQ2NnycnqXDCevAVt-FhiK_%2BG9JwSxHTAvdTe5fA%40mail.gmail.com.