Project

General

Profile

User story #8901

Beautify pg_hba.conf

Added by Florian Heigl about 3 years ago. Updated 4 months ago.

Status:
Released
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

Bug #14848: Parent ticket broke postgresql identification ReleasedNicolas CHARLESActions

Related issues

Related to Rudder - User story #14780: Beautify pg_hba.conf ReleasedActions

Associated revisions

Revision 98170f29 (diff)
Added by Nicolas CHARLES 7 months ago

Fixes #8901: beautify pg_hba.conf

History

#1

Updated by François ARMAND about 3 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 about 3 years ago

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

Updated by Alexis MOUSSET about 3 years ago

  • Target version changed from 321 to 4.0.1
#4

Updated by Vincent MEMBRÉ almost 3 years ago

  • Target version changed from 4.0.1 to 4.0.2
#5

Updated by Vincent MEMBRÉ almost 3 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 over 2 years ago

  • Tracker changed from Bug to User story
#8

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.4 to 4.0.5
#9

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.5 to 4.0.6
#10

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.6 to 4.0.7
#11

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.0.7 to 357
#12

Updated by Alexis MOUSSET over 2 years ago

  • Target version changed from 357 to 4.1.6
#13

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 4.1.6 to 4.1.7
#14

Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 4.1.7 to 4.1.8
#15

Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 4.1.8 to 4.1.9
#16

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 4.1.9 to 4.1.10
#17

Updated by Alexis MOUSSET almost 2 years ago

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

Updated by Nicolas CHARLES 7 months 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 7 months ago

  • Status changed from New to In progress
#20

Updated by Nicolas CHARLES 7 months 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 7 months ago

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

Updated by Nicolas CHARLES 7 months ago

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

Updated by Nicolas CHARLES 6 months 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É 6 months ago

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

Updated by Vincent MEMBRÉ 6 months ago

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

#26

Updated by Vincent MEMBRÉ 4 months ago

#27

Updated by Vincent MEMBRÉ 4 months ago

  • Status changed from Pending release to Released

Also available in: Atom PDF