[asterisk-bugs] [JIRA] (ASTERISK-24494) UTC in MySQL

[Matt Jordan (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-24494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=223290#comment-223290 ] 

Matt Jordan commented on ASTERISK-24494:
----------------------------------------

We require a complete debug log to help triage the issue. This document will provide instructions on how to collect debugging logs from an Asterisk machine for the purpose of helping bug marshals troubleshoot an issue: https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information

Please also attach you cdr_mysql.conf.

Note that {{cdr_mysql}} is an extended support module. Response times on issues may reflect that.

> UTC in MySQL 
> -------------
>
>                 Key: ASTERISK-24494
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24494
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/cdr_mysql
>    Affects Versions: 11.7.0
>         Environment: Ubuntu 12.04.5 LTS
>            Reporter: Vitaliy Gerdt
>
> I want to use UTC timezone for the dates in a queries to MySQL database, so I tried to set  timezone = UTC or usegmtime = yes in the config, but it'd still use localtime timezone. I tried to enable logging to CVS instead of MySQL and when usegmtime is set to yes it writes dates to CVS in UTC timezone, unlike with MySQL. When usegmtime is disabled it updates CVS with dates in localtime timezone, just as expected. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)