DAViCal

Aus xinux.net
Zur Navigation springen Zur Suche springen

Installation

Benötigte Paktete

 apt-get install apache2 php5 postgresql davical

Apache

vi /etc/apache2/conf.d/davical.conf
## davical Vhost
## /etc/apache2/conf.d/davical.conf

# <IfModule mod_ssl.c>
Alias /davical /usr/share/davical/htdocs

<Directory /usr/share/davical/htdocs>
       Options Indexes
       DirectoryIndex index.php
       php_flag magic_quotes_gpc Off
       php_flag register_globals Off
       php_flag include_path /usr/share/awl/inc
</Directory>
# </IfModule>
/etc/init.d/apache2 restart

DAViCal Konfiguration

vi /etc/davical/config.php
<?php
  $c->default_locale = 'de_DE@euro.csd';
// $c->default_locale = 'de_DE'.'UTF-8';
// Diesen String verwenden, wenn die Datenbank auf dem gleichen Host betrieben 
// wird, wie das Webinterface.
  $c->pg_connect[] = 'dbname=davical user=davical_app';
// Wenn der Datenbankserver auf einer anderen Maschine läuft, diesen String verwenden. 
//  $c->pg_connect[] = 'dbname=davical user=davical_app' host=HOSTNAME port=5432;
?>
chmod 644 /etc/davical/config.php

PostgreSQL

Davical Benutzer anlegen:

sudo -u postgres createuser davical_app
sudo -u postgres createuser davical_dba 

Fragen nach superuser, roles und databases können alle mit "Nein" beantwortet werden

vi /etc/postgresql/*/main/pg_hba.conf

Muss ÜBER die anderen local einträge (eventuell bei csd unnötig)

local   davical     davical_dba                     trust
local   davical     davical_app                     trust

Datenbank neu starten

/etc/init.d/postgresql* restart

Für CSD im skript /usr/share/davical/dba/create-database.sh

if ! createdb --encoding UTF8 --template template0 --owner "${AWL_DBAUSER}" "${DBNAME}" ; then

ändern zu

if ! createdb --encoding LATIN9 --template template0 --owner "${AWL_DBAUSER}" "${DBNAME}" ; then

Eventuell patchen

cd /usr/share/davical/dba
sudo sed -i "s/'PlPgSQL'/'plpgsql'/" ./*sql ./patches/*sql
sudo sed -i "s/'SQL'/'sql'/" ./*sql ./patches/*sql

Datenbank mit Skript anlegen

sudo -u postgres -s /usr/share/davical/dba/create-database.sh 

Nach Skript Admin Passwort notieren

Troubleshoot

Weißer Screen

cd /usr/share/davical/inc
ln -s /usr/share/awl/inc/* . 

Problem:

/var/log/apache2/error.log

[Wed Dec 21 09:07:30 2011] [error] [client 192.168.242.1] PHP Warning:  require_once(AWLUtilities.php): failed to open stream: No such file or directory in /usr/share/davical/inc/always.php on line 54
[Wed Dec 21 09:07:30 2011] [error] [client 192.168.242.1] PHP Fatal error:  require_once(): Failed opening required 'AWLUtilities.php' (include_path='../inc:0') in /usr/share/davical/inc/always.php on line 54

Lösung:

/usr/share/davical/inc/always.php

Zeile addieren

set_include_path( '/usr/share/awl/inc'. PATH_SEPARATOR. get_include_path());

Problem:

/var/log/apache2/error.log
[Wed Dec 21 09:14:30 2011] [error] [client 192.168.242.1] PHP Warning:  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 70
[Wed Dec 21 09:14:30 2011] [error] [client 192.168.242.1] davical: ***: ERROR:Connection failed: >>0<< = >>dbname=davical user=davical_app<<

Lösung:

/etc/postgresql/8.4/main/pg_hba.conf

ÜBER anderen "local" zeilen

local   davical     davical_dba                         trust
local   davical     davical_app                         trust

Admin Password

If all is going well you should be able to browse to the admin pages and log in as 'admin' (the password is the bit after the '**' in the 'password' field of the 'usr' table so:

psql davical -c 'select username, password from usr;'

should show you a list. Note that once you change a password it won't be readable in this way - only the initial configuration leaves passwords readable like this for security reasons.

Xinux

http://naut.tmen.de/davical/caldav.php/xinux/projekte/

user: xinux
pass: suxer


Thunderbird Addon

allgemein
https://addons.mozilla.org/de/thunderbird/addon/lightning/
https://addons.mozilla.org/de/thunderbird/addon/lightning/versions/?page=1#version-1.7
  • .xpi herunter laden
  • in Thunderbird:
    -> Extras ( Tools )
    -> Addons
    -> Schraubeschlüssel
    -> Addon aus Datei Installieren


Ubuntu (ab 11.x)
apt-get install xul-ext-lightning

Kalender einrichten

File -> New -> New Calender

On the Network' auswählen Next
Location: https://<IP oder DOMAIN>/davical/caldav.php/<USER>/calendar/

Adressbuch einrichten

Ab Version 0.9.9.5

Location: https://<IP oder DOMAIN>/davical/caldav.php/<USER>/addresses/

Links