1 sudo adduser www-
"$site"-tls www-
"$site"
2 sudo adduser php5_
"$site" www-
"$site"
3 sudo adduser php5_
"$site" postgres-data
4 sudo adduser php5_
"$site" log-php5-
"$site"
6 hint
="run before: remote/runit-configure nginx -- $site"
7 assert
"sudo test -f /etc/agendav/config.php" hint
8 sudo chgrp php5_
$site /etc
/agendav
/config.php
10 sudo sv start postgres
11 while ! sudo
-u postgres psql
</dev
/null
14 "$tool"/local
/postgresql-user-create
"$site"
15 "$tool"/local
/postgresql-database-create
"$site"
16 sudo
-u postgres psql
-AqtX "$site" <<-EOF
18 GRANT USAGE ON SCHEMA pg_catalog TO $site;
21 eval home
="~www-$site"
22 if test ! shared
= "$(sudo -u postgres psql -AqtX "$site" <<-EOF
24 FROM pg_catalog.pg_class c
25 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
27 AND c.relname = 'shared'
28 AND n.nspname = 'public';
32 sudo
-u php5_
"$site" psql
-f - -U "$site" "$site" <<-EOF
34 $(sudo cat "$home"/sql/pgsql.schema.sql)
38 sudo
install -d -m 750 -o root
-g php5_
"$site" \
40 sudo
find "$tool"/etc
/agendav
-type f \
41 -not -name config.php \
42 -exec install -m 640 -o root
-g php5_
"$site" \