Wednesday, March 20, 2013

Installation of davical on debian 6.0 squeeze

First i install the packages with aptitude:
aptitude install apache2 php5 postgresql davical davical-doc

For using you need Apache, PHP 5 and PostgresSQL . These are part of the official Debian repositories.

The next step is to create the configuration file:

The file is created with this values, it is used from apache as alias file, so
that the path to the davical files is found: (File is without encryption)

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_value include_path /usr/share/awl/inc

Restarting Apache.
/etc/init.d/apache restart

Now we do the database configuration. This configuration is for apache and database is
on the same server. This file is created with the chmod 644.

I put this lines into the config.php file:

$c->default_locale = de_DE.UTF-8;
$c->pg_connect[] = 'dbname=davical user=davical_app';

Next step is to create two database users. For this we change to the user "postgres" with the su command and create the accounts:

su postgres
createuser davical_app
createuser davical_dba

The question for superuser, roles and databases we answer with no.

Now we edit this file:

And add this two lines:

local davical davical_dba trust
local davical davical_app trust

Now we must restart the postgresql database:
/etc/init.d/postgresql restart

The davical package come with a shell script, that creates the database. We start it as postgres user  again:
su postgres

Important: After finnishing the script the admin password is shown, you must note it !!

Now we can access to the installation with a webbrowser:

Note for installing thunderbird lightning:

The address for the caldav account looks like this:


Tuesday, March 12, 2013

Safer internet for children

A good project for safer internet:
It is simple used as proxy, so it works on debian too.
Proxy: Port: 3128
After this children only get pages shown,
that were visited from the project before and are clean.
The project works together with the children search engine fragfinn:

My account

I want to remember to my account: