Re: UK BST Time Settings

Ken Smith wrote:
> Adam Tauno Williams wrote:
>> {snip}
>>
>>  
>>> The data in /usr/local/share/libFoundation/TimeZoneInfo/GMT has a 
>>> constant time offset (0:00) all through the year. The OGo web 
>>> interface is using this. This would work acceptably if no-one in 
>>> another time zone used the WebUI or Outlook/Zidelook or Sunbird...
>>>     
>>
>> I believe more than just the WebUI uses that;  as ZideStore, if provided
>> a timezone in an iCal, will [I believe] attempt to adjust the start/end
>> attributes accordingly.
>>
>>  
>>> There is an entry 
>>> /usr/local/share/libFoundation/TimeZoneInfo/GB-Eire which appears to 
>>> have good data in it, but 
>>> /usr/local/share/libFoundation/RegionsDictionary does not have an 
>>> entry that invokes that data.
>>> POSSIBLE SOLUTIONS
>>> (1) Correct the data in the database by subtracting an hour from the 
>>> entries for the BST part of the year. Manually set OGo webui to 
>>> GMT+1 during the BST part of the year.
>>>     
>>
>> I'd try fixing the DB, changing PostgreSQL to GMT (if it isn't already)
>> and see what happens.  Is PostgreSQL not GMT by default on Fedora?  If
>> so that deserves a red-alert-box in WMOGAG.
>>
>>  
>>> (2) Correct the data as in (1) and create a new time zone in the OGo 
>>> WebUI that follows the GMT/BST switch in the UK.
>>>     
>>
>> Why not just fix the current timezone definition?
>>
>>   {snip}
>>  
>>> Taking suggestions from 
>>> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1978, I 
>>> have added a time zone called GBT to libFoundation that invokes the 
>>> GB-Eire data and I have changed the Defaults in OGo on my test 
>>> system to use this.
>>> I notice in 
>>> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1270 what 
>>> seems to be a Default called ListTimeZones is mentioned. Can this be 
>>> used to configure the time zones that appear in the WebUI? I don't 
>>> see that parameter on my system or in WMOGAG. Is this a potential 
>>> solution that would make the timezone GBT appear as a choice in the 
>>> WebUI and allow solution (2) to be deployed or is there a better way 
>>> to do this?
>>>     
>>
>> I'll poke around and get back to you on that;  I've been meaning to
>> flesh out the TZ section of WMOGAG anyways.
>>   
> Thanks for the reply. The timezone parameter is not set in 
> postgresql.conf. According to the Postgres blurb 
> (http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html) 
> Postgres will use the systems timezone settings which are currently BST.
>
> Thanks
>
> Ken
>

I have tried a further experiment.

(1) I have corrected the content of the database, using SQL similar to 
what was given in Adam's earlier post, so that the content of the 
database is now correctly in UTC.

(2) I patched the libFoundation GMT time zone definition to use the 
GB-Eire timezone data. When I had done that, BST showed up in the OGo 
WebUI and the calendar entries were correct. But the appointments as 
viewed in Sunbird were still an hour later than in the WebUI.

(3) When I put the GMT time zone definition back to the original GMT 
data in libFoundation the times in Sunbird became correct. Changing the 
OGo WebUI to GMT+1 corrected the time data in the WebUI.

Through all this testing the Defaults timezone setting was left as GMT.

My conclusion is that zidestore and the WebUI both must use the 
libFoundation timezone data. (I assume that Zidelook operates similarly) 
What we really need to do is find a way to get the WebUI to use, for 
example, the experimental GBT timezone that I have created on my test 
system.

I suppose I could hijack one of the other timezones and give it my GBT 
data and use the hijacked timezone in the WebUI. But that is a really 
nasty kludge.

Any ideas on how to do that properly.

Thanks

Ken

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

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