Fixing DAViCal and PostgreSQL on Ubuntu 11.10 (Oneric Ocelot)

DAViCal is a great server for calendar sharing. It is an implementation of the CalDAV protocol which is designed for storing calendaring resources (in iCalendar format) on a remote shared server. I have used it for sharing with my wife and I at home with our iPads, iCal on OS X and iPhones to allow us to have a shareed schedule for the house and our events. There are now other options like Google Calendar and iCloud, but I still like to run my own stuff and control my own data. DAViCal was running fine for me over the last year or so, but it stopped ater I did my recent upgrade to Ubuntu 11.10 server for mergy.org. I deleted it all and did a reset from scratch on the calendar setups.

After spending some time this weekend getting this fixed again, I found some simple fixes that aren’t out there yet in the docs. My problems were related to the PostgreSQL version bump to 9.1. Hope this is helpful if you are seeing issues with this as I have.

The installation page for DAViCal is pretty close, but now with PostgreSQL 9.1, things have changed a bit.


1. Slight Adjustments to the Database Setup

You can install DAViCal via the

$ su apt-get install davical

but the files in /usr/share/davical/dba need to be modified because PostgreSQL 9.1 uses port 5433 instead of 5432 as PostgreSQL did.

From the DAViCal Installation Docs

BUT Before you attempt to run this script to do the setup

/usr/share/davical/dba/create-database.sh

/usr/share/davical/dba/update-davical-database

Change this line under  “Options variables” towards the start of the file to

my $dbport = 5433;

then you can run the create database script.

 

2. Adjust the DAViCAL Configuration in /etc/davical/

Under the DAViCal configuration area, you should change the port to 5433 as well for your setup config.

From the DAViCal Installation Docs

In the pg_connect line, change the port to 5433 to get it to work with PostgreSQL defaults.

After doing those items, I was able to get back up and running and hit the web interface for DAViCal (depending on how you setup the Apache stuff) and add users / groups / resources. Because we don’t have a lot of accounts, it wasn’t that big of a deal. DAViCal has been a great way for us to share dynamic calendars for personal events and sync OTA.

 

Leave a comment or reply