Davical - getting started...

First attempt at getting davical/rscds running to test and try it. Distribution is Debian Etch, rscds package version 0.9.5

At a glance, Installation instructions on the Web are scattered - and all seem to be incomplete and slightly different.
See:

So, what should I really do?

I'll describe the steps I take here:
  • add apt sources.list line: "deb http://debian.mcmillan.net.nz/debian unstable awm"
  • sudo apt-key advanced --keyserver subkeys.pgp.net --recv-keys CCA377BD77494424B0DB674F8C90347F8F068012
  • apt-get install postgresql-8.1
  • su postgres /usr/share/rscds/dba/create-database.sh


could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
CREATE DATABASE
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
Supported locales updated.
CalDAV functions updated.
Database permissions updated.
could not change directory to "/root"
could not change directory to "/root"
NOTE
====
* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_dba' database user access to the 'davical' database.

* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_app' database user access to the 'davical' database.

* The password for the 'admin' user has been set to 'XXX"

Thanks for trying DAViCal! Check in /usr/share/doc/rscds/examples/ for
some configuration examples. For help, visit #davical on irc.oftc.net.
  • cd /var/www/
  • ln -s /usr/share/rscds/htdocs/ davical
  • su postgres -c "createuser --no-createdb --no-createrole general"

Here, I drop the Database, and try to run the create script again.
In psql shell:
  • DROP DATABASE davical
And again:
  • sudo su postgres -c /usr/share/rscds/dba/create-database.sh
Now, the ouptut look better, no error messages, a password for the admin user is shown.
Still, Calling http://localhost/davical URL gives me:

Warning: require_once(AWLUtilities.php) [function.require-once]: failed to open stream: No such file or directory in /usr/share/rscds/inc/always.php on line 43"

somethings wrong with the inlcusion of the AWL utilities, but the package is installed...
    • I try to add some stuff in php.ini / or in the virtualHost setting as described at http://rscds.sourceforge.net/installation.php - that helps. From the default /etc/php5/apache2/php.ini I only need to add:
      • include_path = ".:/usr/share/php:/usr/share/awl/inc"
      • default_charset = "utf-8"
      • magic_quotes_gpc=Off

Then I have connection problems - messages like

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "davical_app" in /usr/share/awl/inc/PgQuery.php on line 69

Database Error

Could not connect to PostgreSQL database


Strange database stuff, and in my opinion, non of the mix of all the Howtos got iot right!

I'm using now a localhost-conf.php like this:

pg_connect[] = 'dbname=davical user=general';
?>

And the lines I added in /etc/postgresql/8.1/main/pg_hba.conf:


local localhost davical_app trust
local localhost davical_dba trust
local davical general trust


So, I *should* have a running davical server now. The webinterface show me a nice start/login page, but the login does not work as the user "admin" and the password which was shown to me by the create-database script, and I also exactly copy and pasted it from the output of the sql query shown in some of the instructions.

I worked and fiddled on this for about 2 hours now, but here I am at a point, where I don't know where to go anymore...


As a summary, where do I see the problems with this promising software, all at the installation level:

  • At first, it's really unclear what the nbame of the program is - davical or rscds?
  • Then, which install instruction is "the right one" - having 4 to chose from, all on the official websites, doesn't make it easy
  • Are we using the "general" user or the "davical_app" or "davical_dba" ?


A minor thing: http://rscds.sourceforge.net/installation.php says, pgsql >8.1 ist a requirement, but later has some things explicitly telling about 7.4 - at least this is superflouus to write abput <8.1 stuff :)


I'll see, and report, if I wil get the thing running with the help of the author, Andrew McMillan.
Currently, I also consider trying these servers mentioned on Wikipedia as Caldav Servers:

(the others mentioned are scalix, which I don't like, and isn't free, AFAIK, and zimbra, which we have running in our company, but I did never get the calendar feature working with an external client like thunderbird or evolution - so they are out of the race,...)