DAViCal
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
- http://wiki.ubuntuusers.de/davical
- http://wiki.davical.org/w/Main_Page
- http://ubuntuguide.org/wiki/DAViCal_tips#Clarification_of_user_types_and_relationships
- http://www.davical.org/clients.php?client=iPhone
- http://wiki.davical.org/w/CardDAV/Configuration/Well-known_URLs
- http://www.rz.uni-osnabrueck.de/Dienste/Sogo/Kontakte/thunderbird.htm#Anchor1
- http://wiki.davical.org/index.php?title=Configuration/Authentication_Settings/LDAP_Examples