[jira] [Created] (IMPALA-9402) bootstrap_system.sh fails to configure PostgreSQL 9 on some CentOS 7 systems

["Laszlo Gaal (Jira)" <ji...@apache.org>]

Laszlo Gaal created IMPALA-9402:
-----------------------------------

             Summary: bootstrap_system.sh fails to configure PostgreSQL 9 on some CentOS 7 systems
                 Key: IMPALA-9402
                 URL: https://issues.apache.org/jira/browse/IMPALA-9402
             Project: IMPALA
          Issue Type: Bug
            Reporter: Laszlo Gaal


{{bin/bootstrap_system.sh}} relaxes the default PostgreSQL security rules to allow password-less operations during data load. It uses {{sed}} to manipulate the contents of the {{pg_hba.conf}} file, see the lines [https://github.com/apache/impala/blob/master/bin/bootstrap_system.sh#L310]

Unfortunately the {{sed}} patterns are too much system-dependent, which caused a setup failure when a CentOS 7 test platform was set up with PostgreSQL 9.2: the expected default content of pg_hba.conf did not match the script.

This failure broke the build in the dataload phase with the symptom:
{code:java}
23:36:49 dropdb: could not connect to database template1: FATAL:  Peer authentication failed for user "hiveuser"
23:36:49 createdb: could not connect to database template1: FATAL:  Peer authentication failed for user "hiveuser" {code}
This blocks automatic deployment of an Impala build on such a platform.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)