X-Git-Url: https://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=blobdiff_plain;f=etc%2Fsv%2Fsympa%2Flocal.sh;h=ae7c1dc7297037f2519c577d48478d3e8eb2b114;hp=06f436aa7223bc88cef9267c095ac2fd7021bed2;hb=f5e12fec2c7ef8d743e2d3e32c3bbe37b40c7a73;hpb=6647e7fb851e2dbe5a5c7ec60358f7371bf17183

diff --git a/etc/sv/sympa/local.sh b/etc/sv/sympa/local.sh
index 06f436a..ae7c1dc 100644
--- a/etc/sv/sympa/local.sh
+++ b/etc/sv/sympa/local.sh
@@ -4,7 +4,7 @@ home=/home/sympa
 "$tool"/local/runit-sv-start     postgres
 while ! sudo -u postgres psql </dev/null
 do sleep 1; done
-~postgres/bin/createuser "$sv"
+"$tool"/local/postgresql-user-create "$sv"
 sudo -u postgres psql template1 -a -f - <<-EOF
 	\set ON_ERROR_STOP on
 	-- NOTE: pour /usr/share/sympa/lib/Upgrade.pm
@@ -157,3 +157,9 @@ sudo etckeeper commit -m "rule_runit_configure $sv"
  # NOTE: évite d'installer apache2 ..
 
 "$tool"/local/insserv-remove sympa
+
+sudo -u postgres psql template1 -a -f - <<-EOF
+	\set ON_ERROR_STOP on
+	REVOKE ALL ON DATABASE $sv FROM public;
+	GRANT ALL PRIVILEGES ON DATABASE $sv TO $sv;
+	EOF