Correction : openerp_server : permet list_db .

diff --git a/etc/postgresql/9.1/main/pg_hba.conf b/etc/postgresql/9.1/main/pg_hba.conf
index 1a57ba4..58b338a 100644 (file)
--- a/etc/postgresql/9.1/main/pg_hba.conf
+++ b/etc/postgresql/9.1/main/pg_hba.conf
@@ -3,4 +3,6 @@ local         all       postgres  peer      map=admin
 local         all       backup    peer
 local         sameuser  all       peer      map=user
 local         samerole  all       peer      map=role
+local         postgres  openerp_lhc_demo    peer
+local         template1 openerp_server_lhc  peer
 hostssl       all       postgres  samehost  cert

diff --git a/etc/sv/openerp_server_lhc/local.sh b/etc/sv/openerp_server_lhc/local.sh
index 9d953ad..ddd4d42 100644 (file)
--- a/etc/sv/openerp_server_lhc/local.sh
+++ b/etc/sv/openerp_server_lhc/local.sh
@@ -14,6 +14,13 @@ sudo -u postgres psql -AqtX "$sv" <<-EOF
        GRANT SELECT ON TABLE  pg_catalog.pg_proc       TO $sv;
        GRANT SELECT ON TABLE  pg_catalog.pg_type       TO $sv;
        EOF
+sudo -u postgres psql -AqtX template1 <<-EOF
+       \set ON_ERROR_STOP on
+       GRANT CONNECT ON DATABASE template1                TO $sv;
+       GRANT USAGE   ON SCHEMA   pg_catalog               TO $sv;
+       GRANT SELECT  ON TABLE    pg_catalog.pg_database   TO $sv;
+       GRANT SELECT  ON TABLE    pg_catalog.pg_user       TO $sv;
+       EOF
 
 "$tool"/local/adduser "$sv" \
  --disabled-login \