From: Tony Mack <tmack@paris.CS.Princeton.EDU>
Date: Tue, 21 Feb 2012 21:42:16 +0000 (-0500)
Subject: Only manage access rules for MyPLC databses (planetlab5 and drupal). Ignore access... 
X-Git-Tag: plcapi-5.0-37~6
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=269c65e50075def8b3f1b3d7a06b1f7dff77b483

Only manage access rules for MyPLC databses (planetlab5 and drupal). Ignore access rules for other database instances
---

diff --git a/plc.d/postgresql b/plc.d/postgresql
index 2e87033..3b77e53 100755
--- a/plc.d/postgresql
+++ b/plc.d/postgresql
@@ -92,8 +92,8 @@ case "$1" in
 	echo "timezone='UTC'" >> $postgresql_conf
 
 	######## /var/lib/pgsql/data/pg_hba.conf
-	# Disable access to all DBs from all hosts
-	sed -i -e '/^\(host\|local\)/d' $pghba_conf
+    # Disable access to MyPLC and drupal DBs from all hosts
+    sed -i -e '/^\(host\|local\)\s\($PLC_DB_NAME\|drupal\)/d' $pghba_conf
 
 	# Enable passwordless localhost access
 	echo "local all all trust" >>$pghba_conf