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

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

     [ https://issues.apache.org/jira/browse/IMPALA-9402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laszlo Gaal resolved IMPALA-9402.
---------------------------------
    Fix Version/s: Impala 3.4.0
       Resolution: Fixed

> 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
>            Assignee: Laszlo Gaal
>            Priority: Critical
>             Fix For: Impala 3.4.0
>
>
> {{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)