{"action":"opened","issue":{"url":"https://api.github.com/repos/audit4j/audit4j-core/issues/77","repository_url":"https://api.github.com/repos/audit4j/audit4j-core","labels_url":"https://api.github.com/repos/audit4j/audit4j-core/issues/77/labels{/name}","comments_url":"https://api.github.com/repos/audit4j/audit4j-core/issues/77/comments","events_url":"https://api.github.com/repos/audit4j/audit4j-core/issues/77/events","html_url":"https://github.com/audit4j/audit4j-core/issues/77","id":334559555,"node_id":"MDU6SXNzdWUzMzQ1NTk1NTU=","number":77,"title":"Timestamp format for database auditing","user":{"login":"johno1985","id":1640705,"node_id":"MDQ6VXNlcjE2NDA3MDU=","avatar_url":"https://avatars2.githubusercontent.com/u/1640705?v=4","gravatar_id":"","url":"https://api.github.com/users/johno1985","html_url":"https://github.com/johno1985","followers_url":"https://api.github.com/users/johno1985/followers","following_url":"https://api.github.com/users/johno1985/following{/other_user}","gists_url":"https://api.github.com/users/johno1985/gists{/gist_id}","starred_url":"https://api.github.com/users/johno1985/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johno1985/subscriptions","organizations_url":"https://api.github.com/users/johno1985/orgs","repos_url":"https://api.github.com/users/johno1985/repos","events_url":"https://api.github.com/users/johno1985/events{/privacy}","received_events_url":"https://api.github.com/users/johno1985/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-21T16:04:39Z","updated_at":"2018-06-21T16:04:39Z","closed_at":null,"author_association":"NONE","body":"I am trying to store the audit timestamp with the UTC timezone included in the database. I am using the following config\r\n\r\n`!Configuration\r\nhandlers:\r\n- !org.audit4j.handler.db.DatabaseAuditHandler\r\n    embedded: false\r\n    db_driver: com.mysql.cj.jdbc.Driver\r\n    db_url: jdbc:mysql://localhost:3306/launchbi_audit_local?serverTimezone=UTC\r\n    db_user: launchbi\r\n    db_password: QWdF94@.7\r\nlayout: \r\n  !org.audit4j.core.layout.SimpleLayout\r\n    dateFormat: MM/dd/yyyy HH:mm:ss zzz`\r\n\r\nBut this has no effect, the timestamp is stored without the timezone"}}
{"actor":{"display_login":"johno1985"}}