Project

General

Profile

Actions

User story #8901

closed

Beautify pg_hba.conf

Added by Florian Heigl over 7 years ago. Updated almost 5 years ago.

Status:
Released
Priority:
4
Category:
Packaging
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

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 1 (0 open1 closed)

Bug #14848: Parent ticket broke postgresql identification ReleasedNicolas CHARLESActions

Related issues 1 (0 open1 closed)

Related to Rudder - User story #14780: Beautify pg_hba.conf ReleasedBenoît PECCATTEActions
Actions #1

Updated by François ARMAND over 7 years ago

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

Updated by François ARMAND over 7 years ago

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

Updated by Alexis Mousset over 7 years ago

  • Target version changed from 321 to 4.0.1
Actions #4

Updated by Vincent MEMBRÉ over 7 years ago

  • Target version changed from 4.0.1 to 4.0.2
Actions #5

Updated by Vincent MEMBRÉ over 7 years ago

  • Target version changed from 4.0.2 to 4.0.3
Actions #6

Updated by Vincent MEMBRÉ about 7 years ago

  • Target version changed from 4.0.3 to 4.0.4
Actions #7

Updated by Benoît PECCATTE about 7 years ago

  • Tracker changed from Bug to User story
Actions #8

Updated by Vincent MEMBRÉ about 7 years ago

  • Target version changed from 4.0.4 to 4.0.5
Actions #9

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.0.5 to 4.0.6
Actions #10

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.0.6 to 4.0.7
Actions #11

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.0.7 to 357
Actions #12

Updated by Alexis Mousset almost 7 years ago

  • Target version changed from 357 to 4.1.6
Actions #13

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.6 to 4.1.7
Actions #14

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.7 to 4.1.8
Actions #15

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.8 to 4.1.9
Actions #16

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.9 to 4.1.10
Actions #17

Updated by Alexis Mousset about 6 years ago

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

Updated by Nicolas CHARLES almost 5 years 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}

Actions #19

Updated by Nicolas CHARLES almost 5 years ago

  • Status changed from New to In progress
Actions #20

Updated by Nicolas CHARLES almost 5 years 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
Actions #21

Updated by Rudder Quality Assistant almost 5 years ago

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

Updated by Nicolas CHARLES almost 5 years ago

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

Updated by Nicolas CHARLES almost 5 years ago

putting this at the bottom of file blocks login to postgrsql

psql: FATAL: Ident authentication failed for user "rudder

Actions #24

Updated by Vincent MEMBRÉ almost 5 years ago

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

Updated by Vincent MEMBRÉ almost 5 years ago

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

Actions #26

Updated by Vincent MEMBRÉ almost 5 years ago

Actions #27

Updated by Vincent MEMBRÉ almost 5 years ago

  • Status changed from Pending release to Released
Actions

Also available in: Atom PDF