Project

General

Profile

Bug #6403

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

Added by emb3dd3d server over 3 years ago. Updated about 1 month ago.

Status:
New
Priority:
3
Assignee:
-
Category:
System integration
Target version:
Target version (plugin):
Severity:
Critical - prevents main use of Rudder | no workaround | data loss | security
User visibility:
Infrequent - complex configurations | third party integrations
Effort required:
Pull Request:
Priority:
55

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.


Related issues

Related to Rudder - Bug #6412: Technique uses /root as an hardcoded value for the home of user rootNew
Related to Rudder - Bug #6686: Error while installing rudder-reports on centos 7Rejected2015-06-01

History

#1 Updated by François ARMAND over 3 years ago

  • Subject changed from Postgresql difficulty on Centos 6 with Postgresql 9.3 from pgfoundry.org to Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org)
  • Category set to System integration
  • Assignee set to Nicolas CHARLES
  • Priority changed from N/A to 3
  • Target version changed from Ideas (not version specific) to 2.10.12

Thanks for reporting.

Nico, could you tell us a little more on that one. For now, I can sum-up the list of problems and workarounds as:
  • 1/ missing expected starting script (=> symlink provided one to /etc/init.d/postgresql)
  • 2/ missing expected authz file (=> symlink provided one to /var/lib/pgsql/data/pg_hba.conf)
  • 3/ initialisation not done (=> do it again, by hand)

Do you see other problems ?

For #3, there must be a easier way than playing things by hand, like running again post-installation script of the package. Do you know (or perhaps Matthieu ?) how to do that with rpm/deb ?

It seems that the first easy step for that one is to document what are the requirement for non standard pg installation (perhaps just the two symlinks ?), and how to get of the mud if needed.

#2 Updated by Vincent MEMBRÉ about 3 years ago

  • Target version changed from 2.10.12 to 2.10.13

#3 Updated by Nicolas CHARLES about 3 years ago

  • Assignee changed from Nicolas CHARLES to Matthieu CERDA

Paths of postgres are hardcoded in Rudder, which is a real problem (see also #6412).
The issue is if the install of postgres does not use "standart" paths, Rudder is lost, and can't properly manage database and give access

For 3/ the solution may be to rerun the rudder-init; for the first 2, i'm not sure symlink is the right solution (it is quite dirty), but rather to detect the correct paths of installation

Matthieu may know how to detet the proper path of postgres installation

#4 Updated by Vincent MEMBRÉ about 3 years ago

  • Target version changed from 2.10.13 to 2.10.14

#5 Updated by Vincent MEMBRÉ about 3 years ago

  • Target version changed from 2.10.14 to 2.10.15

#6 Updated by Matthieu CERDA about 3 years ago

Hmmmm...

The problem is, there is no standard installation path, only possible candidates on each type of OSes, that may or may not match the currently used one (eg. if the user uses home made packages storing things in /var/lib/my-postgres-9/ so it does not conflict with system packages).

For me, the problem is not that we do not cover every possible case, it is more that we do not give the possibility to do something else (we assume defaults but do not give easily the option to the user to do something else.)

For the ACL configuration, we could try to configure automatically, and just skip and output a helpful message explaining how to do it manually if we can't.

For the postgresql service name, it is an entirely other problem, as there is also no easy way to guess the name used. We can only try to detect it, that's what I did on the Rudder 3.1 init script (get all service candidates matching "postgresql", and use the last one, like "postgresql91")

#7 Updated by Alexis MOUSSET about 3 years ago

  • Related to Bug #6686: Error while installing rudder-reports on centos 7 added

#8 Updated by Vincent MEMBRÉ almost 3 years ago

  • Target version changed from 2.10.15 to 2.10.16

#9 Updated by Vincent MEMBRÉ almost 3 years ago

  • Target version changed from 2.10.16 to 2.10.17

#10 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.10.17 to 2.10.18

#11 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.10.18 to 2.10.19

#12 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.10.19 to 2.10.20

#13 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.10.20 to 277

#14 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 277 to 2.11.18

#15 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.11.18 to 2.11.19

#16 Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 2.11.19 to 2.11.20

#17 Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 2.11.20 to 2.11.21

#18 Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 2.11.21 to 2.11.22

#19 Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 2.11.22 to 2.11.23

#20 Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 2.11.23 to 2.11.24

#21 Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 2.11.24 to 308

#22 Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 308 to 3.1.14

#23 Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 3.1.14 to 3.1.15

#24 Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 3.1.15 to 3.1.16

#25 Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 3.1.16 to 3.1.17

#26 Updated by Benoît PECCATTE over 1 year ago

  • Assignee deleted (Matthieu CERDA)

#27 Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 3.1.17 to 3.1.18

#28 Updated by Vincent MEMBRÉ over 1 year ago

  • Target version changed from 3.1.18 to 3.1.19

#29 Updated by Jonathan CLARKE about 1 year ago

  • Severity set to Critical - prevents main use of Rudder | no workaround | data loss | security
  • User visibility set to Infrequent - complex configurations | third party integrations

#30 Updated by Benoît PECCATTE about 1 year ago

  • Priority set to 41

#31 Updated by Vincent MEMBRÉ about 1 year ago

  • Target version changed from 3.1.19 to 3.1.20

#32 Updated by Vincent MEMBRÉ about 1 year ago

  • Target version changed from 3.1.20 to 3.1.21

#33 Updated by Vincent MEMBRÉ about 1 year ago

  • Target version changed from 3.1.21 to 3.1.22

#34 Updated by Benoît PECCATTE 12 months ago

  • Priority changed from 41 to 54

#35 Updated by Vincent MEMBRÉ 10 months ago

  • Target version changed from 3.1.22 to 3.1.23

#36 Updated by Vincent MEMBRÉ 10 months ago

  • Target version changed from 3.1.23 to 3.1.24

#37 Updated by Vincent MEMBRÉ 8 months ago

  • Target version changed from 3.1.24 to 3.1.25

#38 Updated by Vincent MEMBRÉ 6 months ago

  • Target version changed from 3.1.25 to 387

#39 Updated by Vincent MEMBRÉ 6 months ago

  • Target version changed from 387 to 4.1.10

#40 Updated by Vincent MEMBRÉ 4 months ago

  • Target version changed from 4.1.10 to 4.1.11

#41 Updated by Vincent MEMBRÉ 2 months ago

  • Target version changed from 4.1.11 to 4.1.12
  • Priority changed from 54 to 55

#42 Updated by Vincent MEMBRÉ about 1 month ago

  • Target version changed from 4.1.12 to 4.1.13

Also available in: Atom PDF