Project

General

Profile

Actions

Bug #6403

closed

Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org)

Added by emb3dd3d server about 9 years ago. Updated over 4 years ago.

Status:
Released
Priority:
3
Category:
System integration
Target version:
Severity:
Critical - prevents main use of Rudder | no workaround | data loss | security
UX impact:
User visibility:
Infrequent - complex configurations | third party integrations
Effort required:
Priority:
61
Name check:
Fix check:
Regression:

Description

Just fyi...

I was attempting to install rudder-reports to Centos 6x with Postgresql 9.3 from the pgdg repository http://svn.pgrpms.org/browser/rpm/redhat/9.3/pgdg-yum/CTOS-6/pgdg-93-centos.repo . I was met with the issue of not finding the /var/lib/pgsql/data/pg_hba.conf file or /etc/init.d/postgresql. After scratching my head a little I created a symlink from /var/lib/pgsql/9.3/data/pg_hba.conf to the expected path in order to complete the installation as well as a symlink from /etc/init.d/postgresql-9.3 to /etc/init.d/postgresql. I also had to manually configure my pg_hba.conf to change to md5 for local and localhost, create user db rudder with owner rudder and run the schema import from /opt/rudder/etc/postgresql/reportsSchema.sql . I am sure there will be some more issues going forward, just wanted to let someone be aware if they run across this same thing to look for this. Thanks with help from ncharles on irc for assisting with this.


Subtasks 2 (0 open2 closed)

Bug #14742: System technique don't support PostgreSQL from other source than the distributionReleasedBenoît PECCATTEActions
Bug #14846: Error message in logs during install on postgresql detection ReleasedNicolas CHARLESActions

Related issues 8 (0 open8 closed)

Related to Rudder - Bug #6412: Technique uses /root as an hardcoded value for the home of user rootReleasedAlexis MoussetActions
Related to Rudder - Bug #6686: Error while installing rudder-reports on centos 7RejectedMatthieu CERDA2015-06-01Actions
Related to Rudder - Bug #7395: After a fresh install on Centos, the Rudder server web interface does not workReleasedBenoît PECCATTE2015-11-13Actions
Related to Rudder - Bug #6546: rudder-reports package should use the correct PostgreSQL serviceReleasedBenoît PECCATTE2015-04-29Actions
Related to Rudder - Bug #14296: System technique try to edit pg_hba file only on SUSE, but packaging takes care of this partReleasedAlexis MoussetActions
Related to Rudder - Bug #14827: Error when upgrading to Rudder 5.0.10 using centos7 with custom postgresqlReleasedNicolas CHARLESActions
Related to Rudder - Bug #14744: Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org)ReleasedBenoît PECCATTEActions
Has duplicate Rudder - Bug #14106: Use postgresql-setup initdb in postgresql setupRejectedNicolas CHARLESActions
Actions

Also available in: Atom PDF