Project

General

Profile

User story #8901

Beautify pg_hba.conf

Added by Florian Heigl over 2 years ago. Updated 9 days ago.

Status:
Pending release
Priority:
4
Category:
Packaging
Target version:
Suggestion strength:
User visibility:
Effort required:
Tags:

Description

Rudder adds it's own entries to pg_hba.conf.

Unfortunately, they are not marked as managed by rudder.
Also they're at the start of the file instead of the end, where all the other auth settings are.
Looks really sloppy, like a drunk admin did it.

@[root@rudder data]# head pg_hba.conf ; echo "SNIPSNAP" ; tail pg_hba.conf
host all rudder 127.0.0.1/32 md5
host all rudder ::1/128 md5
  1. PostgreSQL Client Authentication Configuration File
  2. =================================================== #
  3. Refer to the "Client Authentication" section in the
  4. PostgreSQL documentation for a complete description
  5. of this file. A short synopsis follows. #
  6. This file controls: which hosts are allowed to connect, how clients
    SNIPSNAP
  1. TYPE DATABASE USER CIDR-ADDRESS METHOD
  1. "local" is for Unix domain socket connections only
    local all all ident
  2. IPv4 local connections:
    host all all 127.0.0.1/32 ident
  3. IPv6 local connections:
    host all all ::1/128 ident@

Subtasks

User story #14780: same as parent ticket for branch 5.1Pending releaseBenoît PECCATTEActions
Bug #14848: Parent ticket broke postgresql identification ReleasedNicolas CHARLESActions

Associated revisions

Revision 98170f29 (diff)
Added by Nicolas CHARLES 26 days ago

Fixes #8901: beautify pg_hba.conf

History

#1

Updated by François ARMAND over 2 years ago

  • Assignee set to Alexis MOUSSET
  • Priority changed from N/A to 4
  • Target version set to 4.0.0~rc2
#2

Updated by François ARMAND over 2 years ago

  • Target version changed from 4.0.0~rc2 to 321
#3

Updated by Alexis MOUSSET over 2 years ago

  • Target version changed from 321 to 4.0.1
#4

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.1 to 4.0.2
#5

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.2 to 4.0.3
#6

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.3 to 4.0.4
#7

Updated by Benoît PECCATTE about 2 years ago

  • Tracker changed from Bug to User story
#8

Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 4.0.4 to 4.0.5
#9

Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 4.0.5 to 4.0.6
#10

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 4.0.6 to 4.0.7
#11

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 4.0.7 to 357
#12

Updated by Alexis MOUSSET almost 2 years ago

  • Target version changed from 357 to 4.1.6
#13

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 4.1.6 to 4.1.7
#14

Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 4.1.7 to 4.1.8
#15

Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 4.1.8 to 4.1.9
#16

Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 4.1.9 to 4.1.10
#17

Updated by Alexis MOUSSET over 1 year ago

  • Target version changed from 4.1.10 to Ideas (not version specific)
#18

Updated by Nicolas CHARLES 27 days ago

  • Category changed from System techniques to Packaging
  • Assignee changed from Alexis MOUSSET to Nicolas CHARLES
  • Target version changed from Ideas (not version specific) to 5.0.10

we are doing a sed -i li to add the line, we should really simply do echo " " >> ${PG_HBA_FILE}

#19

Updated by Nicolas CHARLES 26 days ago

  • Status changed from New to In progress
#20

Updated by Nicolas CHARLES 26 days ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Benoît PECCATTE
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/1888
#21

Updated by Rudder Quality Assistant 26 days ago

  • Assignee changed from Benoît PECCATTE to Nicolas CHARLES
#22

Updated by Nicolas CHARLES 24 days ago

  • Status changed from Pending technical review to Pending release
#23

Updated by Nicolas CHARLES 13 days ago

putting this at the bottom of file blocks login to postgrsql

psql: FATAL: Ident authentication failed for user "rudder

#24

Updated by Vincent MEMBRÉ 9 days ago

  • Subject changed from beautify pg_hba.conf to Beautify pg_hba.conf
#25

Updated by Vincent MEMBRÉ 9 days ago

This bug has been fixed in Rudder 5.0.10 which was released today.

Also available in: Atom PDF