[asterisk-bugs] [JIRA] (ASTERISK-24494) Setting timezone option in cdr_mysql to UTC has no effect

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-24494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-24494:
------------------------------------

    Status: Waiting for Feedback  (was: Triage)

Hmm. I don't know what is going on. cdr_mysql has been deprecated a while and this issue will be closed unless we have a large amount of people report the same issue and a patch is submitted.

At least now, with your debug posted here, an interested party could look into it.

The path forward is for you to test with the module that is core supported - *cdr_adaptive_odbc*. If the issue still occurs with cdr_adaptive_odbc then you can open up a new issue for that module.

Thanks,




> Setting timezone option in cdr_mysql to UTC has no effect
> ---------------------------------------------------------
>
>                 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
>            Assignee: Vitaliy Gerdt
>         Attachments: asterisk_full_log, cdr_csv_log, cdr_mysql.conf, mylog, mylog, mylog2, system_info
>
>
> 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)