Hello, I live in the EST time zone, and I can’t figure this one out. When I do “date” from the shell, I get: Wed Feb 2 19:41:25 EST 2011 - which is accurate… when I go into Time Groups in FreePBX it says the exact same thing (Server time: 19:41:25), in /etc/timezone, I have: US/Eastern, and /etc/localtime is pointed to /usr/share/zoneinfo/US/Eastern/. However, my CDR records in MySQL are all UTC! Before you tell me the config is wrong in cdr.conf, please check out the following:
cdr.conf:
[general]
; Define whether or not to use CDR logging. Setting this to “no” will override
; any loading of backend CDR modules. Default is “yes”.
enable=yes
usegmtime=no
[csv]
usegmtime=no; log date/time in GMT. Default is "no"
loguniqueid=yes ; log uniqueid. Default is "no"
loguserfield=yes ; log user field. Default is “no”
[mysql]
usegmttime=no
cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = MYPASSWORD
user = asterisk
userfield=1
usegmtime=no
;port=3306
;sock=/tmp/mysql.sock
Am I missing something??!
Oh, right, if I look at the asteriskcdrdb database, time is written as GMT.
Thank you in advance for your time.
Bill B.