Yedidyah Bar David has uploaded a new change for review.

Change subject: packaging: setup: Update postgresql.conf listen_address
......................................................................

packaging: setup: Update postgresql.conf listen_address

Allow connecting to the database from remote.

Listen on '*' (all local addresses) by default, env overridable.

Change-Id: I9e2111271732f395878621b23b9ca3689814a084
Bug-Url: https://bugzilla.redhat.com/1080997
Bug-Url: https://bugzilla.redhat.com/1080998
Signed-off-by: Yedidyah Bar David <d...@redhat.com>
---
M packaging/setup/ovirt_engine_setup/constants.py
M packaging/setup/ovirt_engine_setup/postgres.py
M 
packaging/setup/plugins/ovirt-engine-setup/ovirt-engine-common/provisioning/postgres.py
3 files changed, 22 insertions(+), 5 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/85/27285/1

diff --git a/packaging/setup/ovirt_engine_setup/constants.py 
b/packaging/setup/ovirt_engine_setup/constants.py
index 508dfe6..804d87f 100644
--- a/packaging/setup/ovirt_engine_setup/constants.py
+++ b/packaging/setup/ovirt_engine_setup/constants.py
@@ -497,6 +497,7 @@
 
     DEFAULT_POSTGRES_PROVISIONING_SERVICE = 'postgresql'
     DEFAULT_POSTGRES_PROVISIONING_MAX_CONN = 150
+    DEFAULT_POSTGRES_PROVISIONING_LISTEN_ADDRESS = '*'
 
 
 @util.export
@@ -992,6 +993,7 @@
     POSTGRES_PG_VERSION = 'OVESETUP_PROVISIONING/postgresPgVersion'
     POSTGRES_SERVICE = 'OVESETUP_PROVISIONING/postgresService'
     POSTGRES_MAX_CONN = 'OVESETUP_PROVISIONING/postgresMaxConn'
+    POSTGRES_LISTEN_ADDRESS = 'OVESETUP_PROVISIONING/postgresListenAddress'
 
 
 @util.export
diff --git a/packaging/setup/ovirt_engine_setup/postgres.py 
b/packaging/setup/ovirt_engine_setup/postgres.py
index 7add279..f80452a 100644
--- a/packaging/setup/ovirt_engine_setup/postgres.py
+++ b/packaging/setup/ovirt_engine_setup/postgres.py
@@ -259,10 +259,11 @@
                     ),
                 )
 
-    def _updateMaxConnections(
+    def _updatePostgresConf(
         self,
         transaction,
         maxconn,
+        listenaddr,
     ):
         with open(
             self.environment[
@@ -275,9 +276,15 @@
         for l in content:
             m = self._RE_KEY_VALUE.match(l)
             if (
-                m is not None and
-                m.group('key') == 'max_connections' and
-                int(m.group('value')) >= int(maxconn)
+                m is not None and (
+                    (
+                        m.group('key') == 'max_connections' and
+                        int(m.group('value')) >= int(maxconn)
+                    ) or (
+                        m.group('key') == 'listen_addresses' and
+                        int(m.group('value')) != listen_addresses
+                    )
+                )
             ):
                 needUpdate = False
                 break
@@ -287,6 +294,7 @@
                 content=content,
                 params={
                     'max_connections': maxconn,
+                    'listen_addresses': listen_addresses,
                 },
             )
 
@@ -532,11 +540,14 @@
 
         self.logger.info(_('Configuring PostgreSQL'))
         with transaction.Transaction() as localtransaction:
-            self._updateMaxConnections(
+            self._updatePostgresConf(
                 transaction=localtransaction,
                 maxconn=self.environment[
                     osetupcons.ProvisioningEnv.POSTGRES_MAX_CONN
                 ],
+                listenaddr=self.environment[
+                    osetupcons.ProvisioningEnv.POSTGRES_LISTEN_ADDRESS
+                ],
             )
             self._addPgHbaDatabaseAccess(
                 transaction=localtransaction,
diff --git 
a/packaging/setup/plugins/ovirt-engine-setup/ovirt-engine-common/provisioning/postgres.py
 
b/packaging/setup/plugins/ovirt-engine-setup/ovirt-engine-common/provisioning/postgres.py
index 8804c1a..b2cd35e 100644
--- 
a/packaging/setup/plugins/ovirt-engine-setup/ovirt-engine-common/provisioning/postgres.py
+++ 
b/packaging/setup/plugins/ovirt-engine-setup/ovirt-engine-common/provisioning/postgres.py
@@ -61,6 +61,10 @@
             osetupcons.ProvisioningEnv.POSTGRES_MAX_CONN,
             osetupcons.Defaults.DEFAULT_POSTGRES_PROVISIONING_MAX_CONN
         )
+        self.environment.setdefault(
+            osetupcons.ProvisioningEnv.POSTGRES_LISTEN_ADDRESS,
+            osetupcons.Defaults.DEFAULT_POSTGRES_PROVISIONING_LISTEN_ADDRESS
+        )
 
 
 # vim: expandtab tabstop=4 shiftwidth=4


-- 
To view, visit http://gerrit.ovirt.org/27285
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9e2111271732f395878621b23b9ca3689814a084
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Yedidyah Bar David <d...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to