Project

General

Profile

Bug #7395

After a fresh install on Centos, the Rudder server web interface does not work

Added by Nicolas CHARLES over 5 years ago. Updated about 5 years ago.

Status:
Released
Priority:
N/A
Category:
Packaging
Target version:
Severity:
User visibility:
Effort required:
Priority:

Description

I install Rudder on a centos, with a postgresql 9.1
After installing, the web interface complains that it cannot connect to the database
I can't either, so tries to set password, without success

The issue what that the file /var/lib/pgsql/9.1/data/pg_hba.conf was not updated, and did not contain the line about user rudder for connexion

This happened on 3.1, but will probably happen on all version


Subtasks

Bug #7404: Merge error from #7395 - extra "if" in .spec pre scripletReleasedVincent MEMBRÉ2015-11-13Actions

Related issues

Related to Rudder - Bug #6403: Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org)ReleasedNicolas CHARLESActions
#1

Updated by Vincent MEMBRÉ over 5 years ago

The path to psql conf file should be:
/var/lib/pgsql/data/pg_hba.conf

Did it was on centos6? It should use psql 8.4, did you use an external package??

Where the conf file path is determined is here:
https://github.com/Normation/rudder-packages/blob/master/rudder-reports/SPECS/rudder-reports.spec

#2

Updated by Vincent MEMBRÉ over 5 years ago

Here a page listing all path about psql path
https://wiki.postgresql.org/wiki/YUM_Installation

#3

Updated by Nicolas CHARLES over 5 years ago

It was on Centos6, and Postgres 9.1

the path to the postgres was /var/lib/pgsql/9.1/data (but you know that, given the link you pasted)

#4

Updated by Vincent MEMBRÉ over 5 years ago

Here I found how to ask postgres where is located its conf file: http://askubuntu.com/questions/256534/how-do-i-find-the-path-to-pg-hba-conf-from-the-shell

sum up (with PGUSER set, need to try with "su postgres -c"):

psql -t -P format=unaligned -c 'show hba_file';
#5

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 2.11.17 to 2.10.20
#6

Updated by Vincent MEMBRÉ over 5 years ago

  • Status changed from New to In progress
  • Assignee changed from Benoît PECCATTE to Vincent MEMBRÉ
#7

Updated by Vincent MEMBRÉ over 5 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Vincent MEMBRÉ to Benoît PECCATTE
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/790
#8

Updated by Vincent MEMBRÉ over 5 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
#10

Updated by Vincent MEMBRÉ about 5 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.10.20, 2.11.17, 3.0.12 and 3.1.5 which were released today.

#11

Updated by Nicolas CHARLES about 2 years ago

  • Related to Bug #6403: Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org) added

Also available in: Atom PDF