Last Comment Bug 1009894 - Update internal timezone database from version 2014b to version 2015a
: Update internal timezone database from version 2014b to version 2015a
Product: Calendar
Classification: Client Software
Component: Internal Components (show other bugs)
: Trunk
: All All
P2 normal with 9 votes (vote)
Assigned To: Geoff Lankow (:darktrojan)
Depends on:
Blocks: 1090082
  Show dependency treegraph
Reported: 2014-05-13 15:32 PDT by Martin Schröder [:mschroeder]
Modified: 2015-02-15 01:17 PST (History)
13 users (show)
See Also:
Crash Signature:
QA Whiteboard:
Iteration: ---
Points: ---

calendar-timezones-1.2015a.xpi (28.30 KB, application/x-xpinstall)
2015-02-12 19:18 PST, Geoff Lankow (:darktrojan)
no flags Details

Description User image Martin Schröder [:mschroeder] 2014-05-13 15:32:57 PDT
Comment 1 User image Philipp Kewisch [:Fallen] 2014-05-14 00:00:50 PDT
If there are no string changes, maybe we can slip this in for Lightning 3.3 ?
Comment 2 User image Martin Schröder [:mschroeder] 2014-06-07 05:21:20 PDT
Comment 3 User image Martin Schröder [:mschroeder] 2014-06-16 15:47:20 PDT
Comment 4 User image Philipp Kewisch [:Fallen] 2014-08-08 01:30:01 PDT

A lot of changes here that affect historical data. Please read carefully before blindly selecting [t]ake over as is or use [a]lias.
Comment 5 User image Martin Schröder [:mschroeder] 2014-09-11 14:07:22 PDT
Comment 6 User image Martin Schröder [:mschroeder] 2014-10-16 14:36:30 PDT
Comment 7 User image Martin Schröder [:mschroeder] 2014-10-24 12:21:10 PDT
Comment 8 User image Stefan Sitter 2014-10-28 01:21:16 PDT
When fixing this bug we need to consider to port it back to Lightning 3.3.x. Users are already complaining because of the outdated timezone information.
Comment 9 User image Dmitry Monakhov 2014-10-28 01:34:51 PDT
Is there any approximate  date of release?
Comment 10 User image Alexander T 2014-11-05 01:50:01 PST
Hello guys, any news on this update?
Comment 11 User image Kitoboy 2014-11-05 02:33:24 PST
When will the new release be issued?
Comment 12 User image Dmitry Monakhov 2014-11-05 02:45:01 PST
Fortunately local timezone data base has well known format (SQLite). So as a workaround you can adjust it yourself.
Comment 13 User image Anton Derbenev 2014-11-05 05:28:56 PST
unfortunately most of users of this are not tech specialists, so could not do that (without will and 2-3 months of acquiring knowledge and skills).

There is another workaround though, - to select another timezone; it our case (Moscow was +4, became +3), Kaliningrad works, because it was and stays UTC+3.

Also, I think it's bad that Lightning uses separate database permanently. All moderns OSes have tzdata or analogue (regstry values in windows:, so it would be great if Lightning would not carry its own database, but generate it from system values instead (on 1st start) and check periodically (like once per month). Then, even if db gets outdated, fix would be simple reinstall of lightning (simple for non-techy users), or removal of cache-db to get it regenerated.
Comment 14 User image Aleksandr 2014-11-07 08:28:11 PST
Any updates?
Comment 16 User image ilya.dergalin 2014-11-12 15:09:39 PST
(In reply to Dmitry Monakhov from comment #12)
> Fortunately local timezone data base has well known format (SQLite). So as a
> workaround you can adjust it yourself.
This is a valid workaround for technical and semi-technical users. To make it more easily implementable can you please provide [semi-exact] commands to update?
Comment 17 User image Dmitry Monakhov 2014-11-12 23:04:49 PST
you can find time zone database with right Moscow time Zone.

To edit time zone file manually I use (FireFox + SQLight Manager).
You should edit tz_data table.

You can simply replace distribution file by the new one and restart Thunderbird.
Bad news that  you need  repeat the procedure in the case of lightning upgrade until the bug will be fixed.
Comment 18 User image Philipp Kewisch [:Fallen] 2014-11-13 01:22:00 PST
Martin, do you think you have time to look into this?
Comment 19 User image Martin Schröder [:mschroeder] 2014-11-13 10:31:02 PST
Philipp, I prepared the timezone data for 2014i with vzic but got stuck with our make target for the timezone update because it is not automatically included in the build process (and therefore not in the objdir) and after doing it manually (generating a valid Makefile) I encountered the following situation:

ms-mbp:timezones mschroeder$ make update=/Users/mschroeder/vzic-1.3/zoneinfo-2014i
/Users/mschroeder/Repositories/comm-central/config/ No such file or directory
/Users/mschroeder/Repositories/comm-central/config/ *** /Users/mschroeder/Repositories/comm-central/calendar/timezones contains a file but this file is not declared in a JAR_MANIFESTS variable in a file.  Stop.

During the week I had no time to have a look at the problem (had it once before, but cannot remember how I solved it). I'll give it another try this weekend.
Comment 20 User image Philipp Kewisch [:Fallen] 2014-11-13 14:29:01 PST
Thanks for taking a look. Maybe we should switch the update code to a python script instead, that would make things easier in the future.
Comment 21 User image Slipeer 2014-11-24 04:37:54 PST
Is here any working instructions how to update timezones.sqlite database?
Instructions from calendar/timezones/ don't work for me.
Or can anybody provide world-wide actual timezones.sqlite database (not only Europe/Moscow)?
Comment 22 User image Merlyel 2014-11-24 05:19:30 PST
2 Slipeer
$ sqlite timezones.sqlite
update tz_data set component='BEGIN:VTIMEZONE
' where TZID like 'Asia/Yek%' ;
You need to change TZOFFSETFROM and TZOFFSETTO. And don't forget to put newline at the end or there gonna be problems. Also, backup your current timezones.sqlite.
Comment 23 User image Slipeer 2014-11-24 05:42:29 PST
(In reply to Merlyel from comment #22)
> 2 Slipeer
> $ sqlite timezones.sqlite

Thank you, this I understand.
But I have users in more than one or two time zones of Russia.
Therefore, looking for instructions on how to update the data on timezones.sqlite for all timezones.
Comment 24 User image Stefan Sitter 2015-02-05 00:21:33 PST
2015a was released:
Comment 25 User image Eugene Crosser 2015-02-05 02:55:09 PST
If calendar is a package in an OS distribution (such as in Ubuntu), it does not get updated between releases of the distribution. Consequently, users may not get the update of the timezone database for years. This is hardly acceptable.

Could it be possible to make calendar use OS-wide timezone database instead? Such system-wide database is typically updated more frequently.
Comment 26 User image Philipp Kewisch [:Fallen] 2015-02-05 06:51:20 PST
I think we have a bug open for that, and now that there has been some work on making the timezone database simpler we may be able to make some progress on it.
Comment 27 User image Stefan Sitter 2015-02-05 07:07:29 PST
I see that Bug 1129857 was opened today. But the change from this bug cannot be applied to current stable release Lightning 3.3. It should be discussed if those users have to live with wrong event information due to incorrect timezone data until release of Lightning 4.0.
Comment 28 User image Eugene Crosser 2015-02-05 07:27:58 PST
@Philipp, I cannot find the bug to which you refer in comment 26. Could you please write the number here in a comment for reference? (so we can upvote it ;)
Comment 29 User image Philipp Kewisch [:Fallen] 2015-02-05 07:42:46 PST
As we currently don't release the timezones extension, we'd have to do another release Lightning 3.3.4 to update the timezones there. As long as there are no string updates and its just a matter of dropping in a new timezones.sqlite, I can easily do this manually.

I did a quick search and I couldn't find a bug for it either, its been on my mind more than once though. Feel free to file one.
Comment 30 User image Eugene Crosser 2015-02-05 08:20:15 PST
Filed bug 1129963 "Timezone database being static part of the calendar leads to users having out of date timezone definitions"
Comment 31 User image Magnus Melin 2015-02-09 07:11:18 PST
Fixed by bug 1129857?
Comment 32 User image Philipp Kewisch [:Fallen] 2015-02-12 17:34:24 PST
Yes I'd say so.
Comment 33 User image Geoff Lankow (:darktrojan) 2015-02-12 19:18:04 PST
Created attachment 8563856 [details]

This is an SQLite version of the timezones extension for 2015a. I created it by extracting the data from the JSON version into timezones.sqlite. I've also changed the application versions and set the strictCompatibility flag, to disable the extension once the user upgrades Thunderbird.

Hopefully this is a suitable solution for those of you who need it. I'm not making promises about any further updates.

Note You need to log in before you can comment on or make changes to this bug.