Re: UK BST Time Settings

> I have checked that the PC + Outlook that I'm using is set to UK London 
> time and DST. Indeed it is. If I change the timezone or DST setting in 
> Outlook then the time setting on the PC also changes. I can make the 
> appointments appear at the correct times by unticking the DST setting, 
> but that makes the PC clock wrong.

Are you talking about appointments created earlier or just now?  Because
if an erroneous timezone calculation occurred in the past the error
would persist.

>  From Outlook I created a test appointment at 10AM. Using ODBC/Access to 
> look into the OGo database, the entry in date_x is also at 10:00. Using 
> psql I see this:-
> OGo=# select date_id,start_date,title FROM date_x where title='Test';
>  date_id |       start_date       | title
> ---------+------------------------+-------
>   119440 | 2009-04-02 10:00:00+01 | Test
> (1 row)
> OGo=#

This can be very deceiving;  PostgreSQL can compensate for a clients
time zone as well.  For example:

In psql utility:
SELECT start_date FROM date_x WHERE date_id = 18850;
2003-12-03 20:30:00+00

In DbVisualizer:
SELECT start_date FROM date_x WHERE date_id = 18850;
2003-12-03 15:30:00.0

15:30 is the date I would see in a client, this is "correct" for
timezone.  But 20:30 is what is actually stored in the database.  If
your going to inspect date/time values in the OGo database from a fat
client you need to make sure you specify to see the values in GMT like:

SELECT start_date AT TIME ZONE 'GMT' FROM date_x WHERE date_id = 18850;

> I don't fully understand the significance of the '+01' at the end of the 
> date data.

It denotes a time zone adjustment :)

> In the OGo web display the same appointment appears at 09:00. So this 
> test entry I created with Outlook/Zidelook does not appear to be 
> adjusted into UTC before entry in the database.
> Using wireshark I attempted to capture the traffic between the PC & the 
> server, to see what the time data was 'on the wire'. Unfortunately I'm 
> using a VPN to the remote server and the capture is of the encrypted VPN 
> traffic. :-(

You can log the stream directly from ZideStore to it's log file.  This
is the best way to inspect the exchange between the client and the
server.  This is documented in the Debugging chapter of WMOGAG
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>,  it
should work for ZideLook in the same manner as ZideStore.

> Superficially, it would appear that DST is not getting applied somewhere 
> between the database and the Outlook display. Is it possible that a 
> correction is being applied on the server and then removed by Outlook? 
> If so there is a possibility of a simple fix.
> I tried to export the appointment from Outlook to a csv file, to see 
> what data Outlook thought it had, but unfortunately I get a MAPI error 
> and the export fails.
> I'd appreciate any suggestions and if you have any tests I can try I'd 
> be more than willing to get a fix to this.

-- 
OpenGroupware developer: [email protected]
<http://whitemiceconsulting.blogspot.com/>
OpenGroupare & Cyrus IMAPd documenation @
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users