dépôts
/
lhc
/
ateliers.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Modifications : etc/fstab.m4
[lhc/ateliers.git]
/
etc
/
sv
/
sympa
/
local.sh
diff --git
a/etc/sv/sympa/local.sh
b/etc/sv/sympa/local.sh
index
06f436a
..
81ba013
100644
(file)
--- a/
etc/sv/sympa/local.sh
+++ b/
etc/sv/sympa/local.sh
@@
-4,9
+4,8
@@
home=/home/sympa
"$tool"/local/runit-sv-start postgres
while ! sudo -u postgres psql </dev/null
do sleep 1; done
"$tool"/local/runit-sv-start postgres
while ! sudo -u postgres psql </dev/null
do sleep 1; done
-~postgres/bin/createuser "$sv"
-sudo -u postgres psql template1 -a -f - <<-EOF
- \set ON_ERROR_STOP on
+"$tool"/local/postgresql-user-create "$sv"
+sudo -u postgres psql template1 -a -f - --set ON_ERROR_STOP=1 <<-EOF
-- NOTE: pour /usr/share/sympa/lib/Upgrade.pm
-- appelant DBI->tables
GRANT USAGE ON SCHEMA pg_catalog TO $sv;
-- NOTE: pour /usr/share/sympa/lib/Upgrade.pm
-- appelant DBI->tables
GRANT USAGE ON SCHEMA pg_catalog TO $sv;
@@
-138,7
+137,7
@@
sudo install -m 600 -o root -g root /dev/stdin \
dbc_authmethod_user='ident'
dbc_basepath=''
dbc_dbadmin='postgres'
dbc_authmethod_user='ident'
dbc_basepath=''
dbc_dbadmin='postgres'
- dbc_dbname='
sympa
'
+ dbc_dbname='
$sv
'
dbc_dbpass=''
dbc_dbport=''
dbc_dbserver='/run/postgresql'
dbc_dbpass=''
dbc_dbport=''
dbc_dbserver='/run/postgresql'
@@
-151,9
+150,14
@@
sudo install -m 600 -o root -g root /dev/stdin \
EOF
! sudo etckeeper unclean ||
EOF
! sudo etckeeper unclean ||
-sudo etckeeper commit -m "ru
le_runit_
configure $sv"
+sudo etckeeper commit -m "ru
nit-
configure $sv"
"$tool"/local/apt-get-install --no-install-recommends sympa
# NOTE: évite d'installer apache2 ..
"$tool"/local/insserv-remove sympa
"$tool"/local/apt-get-install --no-install-recommends sympa
# NOTE: évite d'installer apache2 ..
"$tool"/local/insserv-remove sympa
+
+sudo -u postgres psql template1 -a -f - --set ON_ERROR_STOP=1 <<-EOF
+ REVOKE ALL ON DATABASE $sv FROM public;
+ GRANT ALL PRIVILEGES ON DATABASE $sv TO $sv;
+ EOF