File kivitendo-erp-install.sh of Package kivitendo-erp

#!/bin/bash
# Copyright (c) 2007 oc2pus
# Copyright (c) 2016 - 2023 Scorpio IT, Deidesheim, Germany
# This file and all modifications and additions to the pristine
# package are under the same license as the package itself.
#
# Please submit bugfixes or comments to toni@links2linux.de
# Please submit bugfixes or comments to rpm@scorpio-it.net

# - start PostgreSQL if not running
# - add kivitendo user
# - add some functions to PostgreSQL

# start PostgreSQL if necessary
if [[ "$(systemctl is-active postgresql.service)" != active ]]; then
    echo "Starting PostgreSQL ..."
    systemctl start postgresql
fi

# create kivitendo user
#echo "Creating kivitendo user ..."
#su - postgres -c "createuser -s -d kivitendo 2> /dev/null || :"
# add function
#echo "Adding needed functions to template1 ..."
#su - postgres -c"psql template1 -f /usr/share/doc/packages/kivitendo-erp/kivitendo-erp-create-function.sql 2> /dev/null || :"

### Configure Client Authentification Configuration File 
if ! grep 'kivitendo' /var/lib/pgsql/data/pg_hba.conf ; then
echo '85c85
< local   all             all                                     peer
---
> local   all             all                                     trust
87c87
< host    all             all             127.0.0.1/32            ident
---
> host    all             all             127.0.0.1/32            trust
89c89
< host    all             all             ::1/128                 ident
---
> host    all             all             ::1/128                 trust
92,94c92,99
< local   replication     all                                     peer
< host    replication     all             127.0.0.1/32            ident
< host    replication     all             ::1/128                 ident
---
> #local   replication     all                                     peer
> #host    replication     all             127.0.0.1/32            ident
> #host    replication     all             ::1/128                 ident
> 
> # kivitendo-erp
> local   kivitendo       kivitendo                               password
> host    kivitendo       kivitendo       127.0.0.1/32            password
> host    kivitendo       kivitendo       ::1/128                 password' \
  | patch /var/lib/pgsql/data/pg_hba.conf >/dev/null
fi

### configure PostgreSQL
# CLIENT CONNECTION DEFAULTS
# set locale
echo '711c711
< lc_messages = 'C'                     # locale for system error message
---
> lc_messages = 'de_DE.UTF-8'                   # locale for system error message
713,715c713,715
< lc_monetary = 'C'                     # locale for monetary formatting
< lc_numeric = 'C'                      # locale for number formatting
< lc_time = 'C'                         # locale for time formatting
---
> lc_monetary = 'de_DE.UTF-8'                   # locale for monetary formatting
> lc_numeric = 'de_DE.UTF-8'                    # locale for number formatting
> lc_time = 'de_DE.UTF-8'                               # locale for time formatting' \
  | patch /var/lib/pgsql/data/postgresql.conf >/dev/null

# restart apache ?
#rcapache2 restart
echo ""
echo " Now, start your apache webserver and open page"
echo "  http://localhost/kivitendo-erp/admin.pl"
echo "  to configure your kivitendo-erp"