[Serusers] Mysql CDR time different

List overview All Threads
Download

newer

older

[Serusers] ser_fifo

[Serusers] enum lookups and billing

TCCHAN

11 Aug 2005 11 Aug '05

11:34 a.m.

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. Regards, TC Chan

Show replies by thread

Andres

11 Aug 11 Aug

5:09 p.m.

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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

Paul Hazlett

5:58 p.m.

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?? Regards, Paul On 8/11/05, Andres <andres(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

Andres

6:14 p.m.

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(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

6855

days inactive

6855

days old

sr-users@lists.kamailio.org

Manage subscription

3 comments

3 participants

tags (0)

participants (3)

Andres
Paul Hazlett
TCCHAN