Re: UK BST Time Settings

Ken Smith wrote:
> 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
>
As a temporary fix could someone point me to where the users time zone 
data is held in the OGo database so I can do a mass update of the user 
community to GMT+1

I've looked in the person table and can't see it there.

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