Sunbird 0.9 database

[johnea]

Hello,

I've had sunbird running for several years on a machine that was intentionally not upgraded.

This machine was accidentally upgraded in late January 2012 8-(

Now sunbird will no longer run, or build, on this machine.

I have the contents of the database: .mozilla/sunbird/6jk75lcp.default/storage.sdb

I've tried renaming this to the local.sqlite file used by lightning, but lightning starts and shows no entries.

I can open the database with sqliteman and see the data, but I also see that the schema version is listed as 14, while the schema version of my new lightning install is 20.

Is there some way to convert this database or otherwise extract it for import into lightning? Maybe some kind of command line format conversion tool?

There are about 6 years of calendar data that I would _really_ like to recover.

Any help would be greatly appreciated!

johnea

[johnea]

On 2012-03-09 19:22, johnea wrote:
>
> Hello,

> Now sunbird will no longer run, or build, on this machine.

I meant to include the build error:

... lots of compiling then ...

rm -f libgfxps.so
c++ -fno-rtti -fno-exceptions -Wall -Wconversion -Wpointer-arith -Wcast-align -Woverloaded-virtual -Wsynth -Wno-ctor-dtor-privacy -Wno-non-virtual-dtor -Wno-long-long -pedantic -fshort-wchar -pthread -pipe -DNDEBUG -DTRIMMED -O -pthread -I/usr/include/gtk-2.0 -I/usr/lib/gtk-2.0/include -I/usr/include/atk-1.0 -I/usr/include/cairo -I/usr/include/gdk-pixbuf-2.0 -I/usr/include/pango-1.0 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -I/usr/include/pixman-1 -I/usr/include/freetype2 -I/usr/include/libpng15 -fPIC -shared -Wl,-z,defs -Wl,-h,libgfxps.so -o libgfxps.so nsDeviceContextPS.o nsFontMetricsPS.o nsEPSObjectPS.o nsRenderingContextPS.o nsPostScriptObj.o nsAFMObject.o nsGfxFactoryPS.o nsTempfilePS.o nsPrintJobPS.o nsPrintJobFactoryPS.o nsType1.o -lX11 -lXrender -L../../../dist/bin -L../../../dist/lib -lgfxshared_s -lgfxpsshar -lmozutil_s -lgkgfx -L../../../dist/bin -lxpcom -lxpcom_core -L../../../dist/bin -L/usr/lib -lplds4 -lplc4 -lnspr4 -lpthread -ldl ../../..
/dist/lib
/libunicharutil_s.a -lXft -lfreetype -lz -lbz2 -Wl,--version-script -Wl,../../../build/unix/gnu-ld-scripts/components-version-script -Wl,-Bsymbolic -ldl -lm
nsFontMetricsPS.o: In function `nsFontMetricsPS::~nsFontMetricsPS()':
nsFontMetricsPS.cpp:(.text+0xa7d): undefined reference to `FcCharSetDestroy'
nsFontMetricsPS.o: In function `nsXftEntry::nsXftEntry(_FcPattern*)':
nsFontMetricsPS.cpp:(.text+0x108b): undefined reference to `FcPatternGetString'
nsFontMetricsPS.cpp:(.text+0x10b8): undefined reference to `FcPatternGetString'
nsFontMetricsPS.cpp:(.text+0x10e5): undefined reference to `FcPatternGetString'
nsFontMetricsPS.cpp:(.text+0x1114): undefined reference to `FcPatternGetInteger'
nsFontMetricsPS.o: In function `nsFontPSXft::FindFont(unsigned short, nsFont const&, nsFontMetricsPS*)':
nsFontMetricsPS.cpp:(.text+0x246b): undefined reference to `FcCharSetHasChar'
nsFontMetricsPS.cpp:(.text+0x27bb): undefined reference to `FcPatternCreate'
nsFontMetricsPS.cpp:(.text+0x289e): undefined reference to `FcPatternAddInteger'
nsFontMetricsPS.cpp:(.text+0x28b9): undefined reference to `FcPatternAddInteger'
nsFontMetricsPS.cpp:(.text+0x28cb): undefined reference to `FcConfigSubstitute'
nsFontMetricsPS.cpp:(.text+0x28d3): undefined reference to `FcDefaultSubstitute'
nsFontMetricsPS.cpp:(.text+0x28f2): undefined reference to `FcFontSort'
nsFontMetricsPS.cpp:(.text+0x2930): undefined reference to `FcPatternGetBool'
nsFontMetricsPS.cpp:(.text+0x2966): undefined reference to `FcPatternGetString'
nsFontMetricsPS.cpp:(.text+0x29a5): undefined reference to `FcPatternGetString'
nsFontMetricsPS.cpp:(.text+0x29e4): undefined reference to `FcPatternGetCharSet'
nsFontMetricsPS.cpp:(.text+0x2a05): undefined reference to `FcCharSetCopy'
nsFontMetricsPS.cpp:(.text+0x2a92): undefined reference to `FcFontSetDestroy'
nsFontMetricsPS.cpp:(.text+0x2a9a): undefined reference to `FcPatternDestroy'
../../../dist/lib/libgfxshared_s.a(nsFontConfigUtils.o): In function `NS_AddLangGroup(_FcPattern*, nsIAtom*)':
nsFontConfigUtils.cpp:(.text+0x139): undefined reference to `FcPatternAddString'
nsFontConfigUtils.cpp:(.text+0x153): undefined reference to `FcPatternAddString'
../../../dist/lib/libgfxshared_s.a(nsFontConfigUtils.o): In function `NS_AddFFRE(_FcPattern*, nsCString*, int)':
nsFontConfigUtils.cpp:(.text+0x2d9): undefined reference to `FcPatternAddWeak'
nsFontConfigUtils.cpp:(.text+0x2f9): undefined reference to `FcPatternAdd'
collect2: ld returned 1 exit status
make[5]: *** [libgfxps.so] Error 1
make[5]: Leaving directory `/home/johnea/src/aur/sunbird/src/mozilla/gfx/src/ps'
make[4]: *** [libs] Error 2
make[4]: Leaving directory `/home/johnea/src/aur/sunbird/src/mozilla/gfx/src'
make[3]: *** [libs] Error 2
make[3]: Leaving directory `/home/johnea/src/aur/sunbird/src/mozilla/gfx'
make[2]: *** [tier_9] Error 2
make[2]: Leaving directory `/home/johnea/src/aur/sunbird/src/mozilla'
make[1]: *** [default] Error 2
make[1]: Leaving directory `/home/johnea/src/aur/sunbird/src/mozilla'
make: *** [build] Error 2
==> ERROR: A failure occurred in build().

[Philipp Kewisch]

So I assume its a machine where there is no official Sunbird build for?
Otherwise you can use the old Sunbird releases from here:

http://ftp.mozilla.org/pub/mozilla.org/calendar/sunbird/releases/

Lightning should be upgrading from storage.sdb to local.sqlite
automatically as long as there is no local.sqlite. So these steps may work:

In your Lightning Profile:
1. backup and then remove the calendar-data folder
2. drop in a copy of storage.sdb
3. Start Lightning

If this doesn't work I can take a closer look at the code and maybe if
its not confidential data you wouldn't trust me with, you could send me
the storage.sdb per email.

Philipp

[Stefan Sitter]

The following steps should work: Create a new dummy profile using the
Thunderbird profile manager (command line option -P). Close Thunderbird
without installing Lightning. Copy the storage.sdb from the Sunbird
profile folder into the Thunderbird profile folder. Open Thunderbird and
install Lightning. Lightning will pick up the old database and convert
it. Export the calendars as iCalendar files and import them in your main
Thunderbird profile.

Stefan

[johnea]

On 2012-03-09 23:35, Philipp Kewisch wrote:
...

> In your Lightning Profile:
> 1. backup and then remove the calendar-data folder
> 2. drop in a copy of storage.sdb
> 3. Start Lightning

This worked!

I had tried replacing calendar-data/local.sqlite with storage.sdb, but I had never tried removing the entire calendar-data directory and then placing storage.sdb directly into the profile directory.

At first I had 2 calendars named "Home". I found which one was empty, then went to it's properties and renamed it. After renaming the empty calendar I was able to delete it without affecting my existing calendar.

Thank you so much Philipp and Stefan!!!

Now I have to find a way to host this calendar online (I mean host it myself, I'm really not into google)

Thanks Again for saving me guys!!!

johnea

[Jakob Bohm]

Option 1: Install the DaviCAL on an Apache HTTPS server with PHP.
Lightning works directly with this, and so do several other clients.

Option 2: If you have an Apple OS/X server online, just import it into
their iCal server (haven't tried this one myself, but I think it is well
supported).

Option 3: Lightning can use calendars on generic HTTPS servers with
WebDAV, with some limitations (haven't tried this one myself, not sure
what the limitations are).

Option 4: Install another CalDAV server type, such as Bedework (I
haven't tried this at all).

Enjoy

Jakob
--
Jakob Bohm, CIO, Partner, WiseMo A/S. http://www.wisemo.com
Transformervej 29, 2730 Herlev, Denmark. Direct +45 31 13 16 10
This public discussion message is non-binding and may contain errors.
WiseMo - Remote Service Management for PCs, Phones and Embedded

[johnea]

On 2012-03-13 08:18, Jakob Bohm wrote:
> On 3/10/2012 4:45 PM, johnea wrote:

>> Now I have to find a way to host this calendar online (I mean host it myself, I'm really not into google)

>

> Option 1: Install the DaviCAL on an Apache HTTPS server with PHP.
> Lightning works directly with this, and so do several other clients.
>
> Option 2: If you have an Apple OS/X server online, just import it into
> their iCal server (haven't tried this one myself, but I think it is well
> supported).
>
> Option 3: Lightning can use calendars on generic HTTPS servers with
> WebDAV, with some limitations (haven't tried this one myself, not sure
> what the limitations are).
>
> Option 4: Install another CalDAV server type, such as Bedework (I
> haven't tried this at all).
>
> Enjoy
>
> Jakob

Thanks Jakob,

My web searching had also led to the conclusion that DaviCal was the leading option. That dependency on PostgreSQL is a little unfortunate. I don't currently run that database and it's a shame to install an entire database package only to support calendars 8-(

john