Asterisk. Incorrect time in CDR

[avberk]

Although the date and time is correct on my wl500gp, the time in the Call Detail Records (CDR) is always 2 hours behind.

My setup:
Zyxel 2602H router(with analog phone connected)->Wl500gp(asterisk server)->voipbuster.com
asterisk 1.4

What i tried:
-It doesn't matter if i dial from the console or from the phone.
-tried installing 'tz' timezone utilities and make symbolic link.
-ran asterisk in verbose mode. I only see correct date/time here..

I don't understand what's going on. Google was not my friend


Who has a clue?
Anyone seen this problem before?

[newbiefan]

Not sure about......
but I suggest to have a closer look for function STRPTIME() .
http://www.asteriskdocs.org/

[avberk]

Thanks Newbiefan! I did see this command. i'll have another look at it.

I am starting to believe it might have to with a missing hardware clock on the wl500gp, but i haven't convinced myself

Could this be??

[thejew]

Although the date and time is correct on my wl500gp, the time in the Call Detail Records (CDR) is always 2 hours behind.

I have exactly the same problem since i am running asterisk. Tried myself like crazy to solve it but never made it.
Whats weired is that everywhere in the internet people claim that asterisk is looking at the unix system time. But for my experience that cant be even if i change my system time the difference of 2 hours in the asterisk is allways the same.
I would integrate this in my Asterisk tutorial (german part of this board) if anyone finds a solution.

BTW. I think in the wintertime its just a 1 hour difference.

[avberk]

Seems that if you persist on finding a solution you will find one

Hereby the steps you need to take:

-Open /opt/etc/asterisk/cdr.conf and change 'usegmtime'
to 'no'. e.g.:
[csv]
usegmtime=no ; log date/time in GMT. Default is "no"
loguniqueid=no ; log uniqueid. Default is "no"
loguserfield=no ; log user field. Default is "no"

-ipkg update
-ipkg install tz

-Goto the /opt/share/zoneinfo folder and find
your timezone location. Copy this location to the
folder /etc/localtime. e.g.:
cp /opt/share/zoneinfo/Europe/Amsterdam /etc/localtime

-Open '/usr/local/.files' and add this line:
/etc/localtime

-To make the change permanent, save it to flash:
flashfs save && flashfs commit && flashfs enable

-Restart Asterisk.


See also this link for some background info:
http://www.nslu2-linux.org/wiki/Unslung/TimeZoneUpdate

[thejew]

wow that did work!!!!!!!
thx avberk for sharing your solution, that abolutely made my day!
Now my asterisk server feels like its perfect.

[leetwanker]

Sorry to revive an old topic but these steps may be outdated. At least they don't seem to be valid in my case.

I installed my zoneinfo package. Copied my zone to /etc/localtime.

I'm running into a problem opening /usr/local/.files

The file doesn't exist and I've been unsuccessful in creating it. I could maybe figure this out for myself but I've no clue what /usr/local/.files is supposed to do.

And the next step: I don't have flashfs. Something I need to install or is there a different way to make this permanent?

Thanks

EDIT: [SOLVED] I added the following line to my /jffs/scripts/services-start script. I did it before the wait for unslung to start so the localtime file would be there before asterisk starts.

#!/bin/sh

cp /opt/share/zoneinfo/US/Eastern /etc/localtime

sleep 10
/opt/etc/init.d/rc.unslung start

I guess that's easier than the /usr/local/.files and flashfs save && commit && reboot stuffs. Anyway, I'm happy.

Seems that if you persist on finding a solution you will find one

Hereby the steps you need to take:

-Open /opt/etc/asterisk/cdr.conf and change 'usegmtime'
to 'no'. e.g.:
[csv]
usegmtime=no ; log date/time in GMT. Default is "no"
loguniqueid=no ; log uniqueid. Default is "no"
loguserfield=no ; log user field. Default is "no"

-ipkg update
-ipkg install tz

-Goto the /opt/share/zoneinfo folder and find
your timezone location. Copy this location to the
folder /etc/localtime. e.g.:
cp /opt/share/zoneinfo/Europe/Amsterdam /etc/localtime

-Open '/usr/local/.files' and add this line:
/etc/localtime

-To make the change permanent, save it to flash:
flashfs save && flashfs commit && flashfs enable

-Restart Asterisk.


See also this link for some background info:
http://www.nslu2-linux.org/wiki/Unslung/TimeZoneUpdate