Bug #7395
closed
After a fresh install on Centos, the Rudder server web interface does not work
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
Updated by Vincent MEMBRÉ about 9 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
Updated by Vincent MEMBRÉ about 9 years ago
Here a page listing all path about psql path
https://wiki.postgresql.org/wiki/YUM_Installation
Updated by Nicolas CHARLES about 9 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)
Updated by Vincent MEMBRÉ about 9 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';
Updated by Vincent MEMBRÉ about 9 years ago
- Target version changed from 2.11.17 to 2.10.20
Updated by Vincent MEMBRÉ about 9 years ago
- Status changed from New to In progress
- Assignee changed from Benoît PECCATTE to Vincent MEMBRÉ
Updated by Vincent MEMBRÉ about 9 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
Updated by Vincent MEMBRÉ about 9 years ago
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
Applied in changeset rudder-packages|0103e21abc9b849667a886723085e4725a4b57d2.
Updated by Benoît PECCATTE about 9 years ago
Applied in changeset rudder-packages|995cc454ca0d3aed1062150d825ec7851a7542bb.
Updated by Vincent MEMBRÉ almost 9 years ago
- Status changed from Pending release to Released
Updated by Nicolas CHARLES almost 6 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