projekt kivitendo

h1. Installation Ubuntu 14.04.2 LTS

* kivitendo 3.2.1
* Postgres 9.3
* Apache 2.4.7

Basierierend auf Anleitung
https://www.kivitendo.de/doc/html/ch02s02.html

h2. Ubuntu vorbereiten

> sudo su -
> apt-get install apache2 libarchive-zip-perl libclone-perl \
> libconfig-std-perl libdatetime-perl libdbd-pg-perl libdbi-perl \
> libemail-address-perl libemail-mime-perl libfcgi-perl libjson-perl \
> liblist-moreutils-perl libnet-smtp-ssl-perl libnet-sslglue-perl \
> libparams-validate-perl libpdf-api2-perl librose-db-object-perl \
> librose-db-perl librose-object-perl libsort-naturally-perl \
> libstring-shellquote-perl libtemplate-perl libtext-csv-xs-perl \
> libtext-iconv-perl liburi-perl libxml-writer-perl libyaml-perl \
> libimage-info-perl libgd-gd2-perl \
> libfile-copy-recursive-perl postgresql
> apt-get install build-essential
> cpan HTML::Restrict

h2. kivitendo per git installieren

> apt-get install git

> cd /usr/local/src/
> git clone https://github.com/kivitendo/kivitendo-erp.git
> cd kivitendo-erp/
> git checkout release-3.2.1
> ./scripts/installation_check.pl

> mkdir webdav
> chown -R www-data users spool webdav
> chown www-data templates users
> cp config/kivitendo.conf.default config/kivitendo.conf
> apt-get install vim
> vim config/kivitendo.conf
<pre>
[authentication]
admin_password = admin123

[authentication/database]
host = 127.0.0.1
port = 5432
db = kivitendo_auth
user = postgres
password =

</pre>

h2. Postgres konfigurieren


Datenbank konfigurieren, passwortloser Zugang Zugriff für lokalen Zugriff

> vim /etc/postgresql/9.3/main/pg_hba.conf
<pre>
local all postgres peer
local all all peer
host all all 127.0.0.1/32 trust
host all all ::1/128 reject
</pre>

> service postgres reload

Zugriff testen:
> psql -U postgres -h 127.0.0.1 -p 5432

h2. Apache konfigurieren
> vim /etc/apache2/sites-available/default-ssl.conf
<pre>
AddHandler fcgid-script .fpl
AliasMatch ^/kivitendo-erp/[^/]+\.pl /usr/local/src/kivitendo-erp/dispatcher.fpl
Alias /kivitendo-erp/ /usr/local/src/kivitendo-erp/
FcgidMaxRequestLen 10485760

<Directory /usr/local/src/kivitendo-erp>
AllowOverride All
Options ExecCGI Includes FollowSymlinks
Require all granted
</Directory>

<DirectoryMatch /usr/local/src/kivitendo-erp/users>
Order Deny,Allow
Deny from All
</DirectoryMatch>
</pre>

> apt-get install libapache2-mod-fcgid
> a2enmod ssl
> a2enmod fcgid
> a2ensite default-ssl
> service apache2 reload

h2. kivitendo starten

https://localhost/kivitendo-erp/

h2. Backup

@#!/bin/bash
for i in datenbankname kivitendo_auth;
do pg_dump -U postgres -h 127.0.0.1 $i > /backup/kivitendo/`date +%A`-$i.sql
done
pg_dumpall -U postgres -h 127.0.0.1 > /backup/kivitendo/`date +%A`-dumpall.sql@