[Serusers] Mysql CDR time different

[Andres]

Paul Hazlett wrote:

>Hi All.
>
>So just to be clear, the timestamp column is the MySQL server local
>time. Whereas the time column is what exactly??? UTC, GMT, etc??
>  
>
By default I think the time column is GMT, but that was pretty much 
useless to us.  This also depends on how you configured your servers 
TIMEZONE.  If you did not set any timezone then you would not have this 
problem.

>Regards,
>Paul
>
>On 8/11/05, Andres <andres at telesip.net> wrote:
>  
>
>>TCCHAN wrote:
>>
>>    
>>
>>>Hi All,
>>>
>>>I have acc module to generate cdr for calls.
>>>
>>>I noticed that all the calls are timed 4 hour different than what is
>>>shown on the real time clock.
>>>
>>>
>>>Can anyone help?
>>>
>>>
>>>Thanks for any help available.
>>>
>>>
>>>
>>>      
>>>
>>Change acc_mod.c so that it uses your local time  (change the below
>>variable from 0 to 1):
>>
>>int db_localtime = 1;
>>
>>    
>>
>>>Regards,
>>>
>>>TC Chan
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>
>>>
>>>      
>>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>    
>>
>
>
>  
>