[OGo-Users] Time issues with OGo

Helge Hess users@opengroupware.org
Mon, 16 Apr 2007 11:06:34 +0200


On Apr 16, 2007, at 09:16, Samuli Sepp=E4nen wrote:
> 1) Should I keep Postgresql database in GMT?

Not sure what you mean by that.

> 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 =20
hardware clock doesn't affect any programs.

But yes, OGo (more exactly libFoundation) has own timezone processing =20=

code. Since Linux works in UTC, it will never get applied twice.

> 3) Is the only safe setting for TimeZoneName still "GMT"? Can it be
> changed to "GMT" on a running system without messing everything up?

Its the only setting which is tested and recommended. It *should* =20
only affect logging output, but who knows.

You can change it to something else, but I'm not sure whether this =20
would move the dates. Could be. (try it on a test system).


> 4) Is the problem shown below happening due to hypothesis I wrote in
> question 2 or something else entirely:
>
> So, when I try to synchronize events between Nokia and OGo by using
> Funambol + GroupDAV plugin event begin and endtimes are consistently 1
> hour off, either less or more than they ought to be:
>
> An event created in Nokia:
>
> Nokia Timezone: GMT+2 (does automatic DST)
> Real begintime: 8.00
> Real endtime: 8.05
> Vcard begintime: 5.00 (-3 hours)
> Vcard endtime: 5.05 (-3 hours)
> OGo begintime: 9.00 (+4 hours)
> OGo endtime: 9.05 (+4 hours)
>
> This looks good, except for the OGo part. Now onto the OGo event:
>
> OGo TimeZone: EET (GMT+2 with DST)
> Real begintime: 7.00
> Real endtime: 8.00
> Vcard begintime: 3.00 (-4 hours)
> Vcard endtime: 4.00 (-4 hours)
> Nokia begintime: 6.00 (+3 hours)
> Nokia endtime: 7.00 (+3 hours)
>
> Now for some reason OGo adds or decreases 4 hours from begin- and
> endtimes, instead of 3 as it should. Nokia on the other hand =20
> (correctly)
> adds or decreases three hours to the vCard as it is now GMT+2 + DST (1
> hour). All this seems like if OGo was adding it's 1 hour on top of the
> Linux system's time, even though the system has already switched to =20=

> DST
> (GMT+3).

As mentioned it can't be 2). It could be various things, at least =20
three timezone implementations are part of the process (Nokia, then =20
Java, then libFoundation).
You should file a bug report including all the necessary information =20
(eg dumps of the vCard which is exchanged).

BTW: vCards have no begintime. You probably refer to iCalendar.

Greets,
   Helge
--=20
Helge Hess
http://www.helgehess.eu/