he1ix' blog

e.g. for testing purposes before touching valuable data…

1. set the DB names

   ORIG_DB="orig_db_name" NEW_DB="new_db_name"



2. create a dump (make sure to use a user having access rights to the db)

   TSTAMP=$(date +%F_%H-%M) FILE_ORIG="${ORIG_DB}_${TSTAMP}.sql" pg_dump -f ${FILE_ORIG} --blobs --create ${ORIG_DB}



3. adjust the DB name in the dump and check everything went ok (the diff should be just in CREATE, ALTER and \connect statements)

   FILE_NEW="${NEW_DB}_based-on_${ORIG_DB}_${TSTAMP}.sql" sed "s/${ORIG_DB}/${NEW_DB}/g" ${FILE_ORIG} > ${FILE_NEW} vimdiff ${FILE_ORIG} ${FILE_NEW}



4. adjust permissions for the new db (add the new DB name to the desired user(s)) and reload the postgres config

   sudo vim /etc/postgresql/8.4/main/pg_hba.conf sudo /etc/init.d/postgresql-8.4 reload



5. load the new DB’s SQL-code into postgres

   psql -f ${FILE_NEW}



6. to set identical permissions on the new DB, create a full dump using pg_dumpall, check the GRANT commands in the dump and apply them to the new DB as well…
   

This posting describes the steps required to build the Funambol add-on for Mozilla Thunderbird 3 on Ubuntu 10.10 (Maverick Meerkat). It is mostly based on Bas’ Blog entry .

Part I: the prerequisites

1. define the buildroot

   BASE="${HOME}/buildenvs/mozbuild.maverick_amd64"

2. install required packages

   sudo aptitude install mercurial autoconf2.13 colormake libcurl4-gnutls-dev libtool git-svn

3. I had problems using a freshly debootstrapped ubuntu maverick (10.10) chroot that was missing the “staff“ group, so if it’s missing, add it via “vigr“…
4. install build-dependencies

   sudo apt-get build-dep thunderbird

http://www.secudb.de/~seuffert/mozilla/

UPDATE:

http://releases.mozilla.org/pub/mozilla.org/calendar/lightning/releases/1.0b1/contrib/linux-x86_64/

…still has some problems using the CalDAV interface, see the communigate mailing list, while it works great with the latest DAViCal.

Lightning/Thunderbird also has issues with self-signed SSL-certificates, see Mozilla Bug #523555.

Ever got messages like this in your Apache logfiles, wondering why setting properties via a client on your (otherwise working) WebDAV is failing?

Could not open the property database.  [500, #205]
(2)No such file or directory: Could not open property database.  [500, #1]
(2)No such file or directory: Attempted to set/remove a property without a valid, open, read/write property database.  [500, #202]

Well, simply add a directory called “.DAV“ (note the leading dot!) to your WebDAV base-directory, that is writeable to the webserver. That’s where the corresponding information will be stored by Apache. Note that this is “somehow” mentioned by the mod_dav documentation at webdav.org, but not by Apache’s documentation itself. Yes, that’s bad and pretty annoying.

finally, CalDAV evolves to a pretty common standard. sun microsystems is about to contribute a client for symbian: blog.symbian.org.

(just a link-collection by now…)

Funambol 7

OpenSync

Funambol Mozilla Plugin

Thunderbird/Lightning mit dem Handy synchronisieren