[OGo-Users] Time issues with OGo
Adam Tauno Williams
users@opengroupware.org
Mon, 16 Apr 2007 07:26:48 -0400
> >> 1) Should I keep Postgresql database in GMT?
> > Not sure what you mean by that.
> Postgresql seems to have a setting for client timezone. I'm not sure how
> this affects OGo, if at all:
> /etc/postgresql/7.4/postgresql:
The important bit is to have TimeZoneName = GMT in your Defaults.
> I was hoping somebody had an idea of that. But OGo is a client, so I
> guess it's possible that this affects OGo. Then again, if OGo stores
> timezone info along with events in the database, it shouldn't matter.
> >> 2) Does OGo add it's own DST on top of (Linux) system's own DST? So if
> >> automatic DST is activated in both Linux _and_ OGo, will the OGo clock
> >> be off 1 hour half of the year?
> > Both, OGo and Linux use UTC internally. How Linux adjusts your hardware
> > clock doesn't affect any programs.
> > But yes, OGo (more exactly libFoundation) has own timezone processing
> > code. Since Linux works in UTC, it will never get applied twice.
> Ok, so OGo does not use local time (UTF + GMT offset [+ DST]) as the
> basis of it's time calculations, but Linux system clock, which is in
> UTC. At least according to time howto Linux should never modify the
> hardware clock (Real-time clock a.k.a. CMOS clock), unless explicitly
> told to (with hwclock, for example).
The hardware clock has no effect on anything; it is read once by the OS
when booting and ignored after that.
> > As mentioned it can't be 2). It could be various things, at least three
> > timezone implementations are part of the process (Nokia, then Java, then
> > libFoundation).
> > You should file a bug report including all the necessary information (eg
> > dumps of the vCard which is exchanged).
> > BTW: vCards have no begintime. You probably refer to iCalendar.
> Yes, my mistake. I meant iCal. I'll try these tests on a clean system -
> current tests have been done _mostly_ on systems which have some history
> behind them. It could be Funambol messing something up, unless it's OGo
> due to some weird settings. If the problem persists, I'll file a bugreport.
You can set Funambol to log everything, wherein you should be able to
see the data exchanged.