Project

General

Profile

Bug #10704

PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6

Added by Raphael GAUTHIER 5 months ago. Updated 4 months ago.

Status:
Released
Priority:
N/A
Category:
Packaging
Target version:
Target version (plugin):
Severity:
Major - prevents use of part of Rudder | no simple workaround
User visibility:
Getting started - demo | first install | level 1 Techniques
Effort required:
Priority:
54

Description

reinstall rudder-reports and execute rudder agent run fixed it.

Associated revisions

Revision d43c1885
Added by Benoît PECCATTE 4 months ago

Fixes #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6

History

#1 Updated by François ARMAND 4 months ago

  • Severity set to Major - prevents use of part of Rudder | no simple workaround
  • User visibility set to Getting started - demo | first install | level 1 Techniques
  • Priority changed from 0 to 54

Please, whould you mind giving logs or any other relevant information that would allow us to reproduce the problem?

#2 Updated by Alexis MOUSSET 4 months ago

I could not reproduce it in a nightly install.

The issue was that during the rudder-reports postinst script could not connect to postgreSQL.

#3 Updated by Nicolas CHARLES 4 months ago

I could reproduce it on Centos 6 32 bits:

==> centos6_server: Running rpm_check_debug
==> centos6_server: Running Transaction Test
==> centos6_server: Transaction Test Succeeded
==> centos6_server: Running Transaction
  Installing : 1398866025:ncf-1.1.0.201705170243-1.EL.6.noarch             1/44
==> centos6_server:  
  Installing : 1398866025:rudder-techniques-4.1.2.rc1.git201705170216-1    2/44
==> centos6_server:  
  Installing : mailcap-2.1.31-2.el6.noarch                                 3/44
==> centos6_server:  
  Installing : jpackage-utils-1.7.5-3.16.el6.noarch                        4/44
==> centos6_server:  
  Installing : tzdata-java-2017b-1.el6.noarch                              5/44
==> centos6_server:  
  Updating   : nspr-4.13.1-1.el6.i686                                      6/44
==> centos6_server:  
  Updating   : nss-util-3.28.4-1.el6_9.i686                                7/44
==> centos6_server:  
  Installing : apr-1.3.9-5.el6_2.i686                                      8/44
==> centos6_server:  
  Installing : apr-util-1.3.9-3.el6_0.1.i686                               9/44
==> centos6_server:  
  Installing : httpd-tools-2.2.15-59.el6.centos.i686                      10/44
==> centos6_server:  
  Updating   : nss-3.28.4-1.el6_9.i686                                    11/44
==> centos6_server:  
  Updating   : nss-sysinit-3.28.4-1.el6_9.i686                            12/44
==> centos6_server:  
  Updating   : nss-tools-3.28.4-1.el6_9.i686                              13/44
==> centos6_server:  
  Installing : 1:dmidecode-2.12-7.el6.i686                                14/44
==> centos6_server:  
  Installing : 1398866025:rudder-agent-4.1.2.rc1.git201705170216-1.EL.6   15/44
==> centos6_server:  
==> centos6_server: ok: Rudder agent is now disabled.
==> centos6_server: INFO: Ensuring correct permissions on the keys directory... Done.
==> centos6_server: INFO: Creating keys for CFEngine agent... Done.
==> centos6_server: ok: Rudder agent has been enabled but not started, wait for next cron run.
==> centos6_server: ********************************************************************************
==> centos6_server: rudder-agent has been installed (not started). This host can be a Rudder node.
==> centos6_server: To get started, configure your Rudder server's hostname and launch the agent:
==> centos6_server: # echo 'rudder.server' > /var/rudder/cfengine-community/policy_server.dat
==> centos6_server: # rudder agent start
==> centos6_server: This node will then appear in the Rudder web interface under 'Accept new nodes'.
==> centos6_server: ********************************************************************************
  Installing : xz-4.999.9-0.5.beta.20091007git.el6.i686                   16/44
==> centos6_server:  
  Installing : libjpeg-turbo-1.2.1-3.el6_5.i686                           17/44
==> centos6_server:  
  Installing : freetype-2.3.11-17.el6.i686                                18/44
==> centos6_server:  
  Installing : 1:java-1.8.0-openjdk-headless-1.8.0.131-0.b11.el6_9.i686   19/44
==> centos6_server:  
  Installing : 1398866025:rudder-jetty-4.1.2.rc1.git201705170216-1.EL.6   20/44
==> centos6_server:  
  Installing : libtool-ltdl-2.2.6-15.5.el6.i686                           21/44
==> centos6_server:  
  Installing : 1398866025:rudder-inventory-ldap-4.1.2.rc1.git2017051702   22/44
==> centos6_server:  
==> centos6_server: INFO: Setting rudder-slapd as a boot service... Done
==> centos6_server: INFO: Reloading syslogd...  Done
==> centos6_server: INFO: Restarting rudder-slapd...rudder-slapd[8464]: [INFO] Using /etc/default/rudder-slapd for configuration
==> centos6_server: rudder-slapd[8469]: [OK] virtual memory limit set to unlimited
==> centos6_server: rudder-slapd[8470]: [INFO] Halting OpenLDAP...
==> centos6_server: rudder-slapd[8471]: [INFO] can't read PID file, to stop rudder-slapd try: /etc/init.d/rudder-slapd forcestop
==> centos6_server: rudder-slapd[8472]: [INFO] Halting OpenLDAP replication...
==> centos6_server: rudder-slapd[8473]: [INFO] no replica found in configuration, aborting stopping slurpd
==> centos6_server: rudder-slapd[8474]: [INFO] Launching OpenLDAP configuration test...
==> centos6_server: rudder-slapd[8476]: [OK] OpenLDAP configuration test successful
==> centos6_server: rudder-slapd[8477]: [INFO] Launching OpenLDAP replication...
==> centos6_server: rudder-slapd[8478]: [INFO] no replica found in configuration, aborting lauching slurpd
==> centos6_server: rudder-slapd[8479]: [INFO] no db_recover done
==> centos6_server: rudder-slapd[8480]: [INFO] Launching OpenLDAP...
==> centos6_server: rudder-slapd[8481]: [OK] file descriptor limit set to 1024
==> centos6_server: rudder-slapd[8488]: [INFO] Using /etc/default/rudder-slapd for configuration
==> centos6_server: rudder-slapd[8499]: [OK] OpenLDAP started on port 389 and 636
==> centos6_server: rudder-slapd[8500]: [INFO] Prefetching data for cache warmup
==> centos6_server:  Done
  Installing : 1398866025:rudder-inventory-endpoint-4.1.2.rc1.git201705   23/44
==> centos6_server:  
==> centos6_server: INFO: Launching script to check if a migration is needed
==> centos6_server: INFO: End of migration script
==> centos6_server: INFO: Restarting syslogd ... Done
  Installing : postgresql-libs-8.4.20-7.el6.i686                          24/44
==> centos6_server:  
  Installing : postgresql-8.4.20-7.el6.i686                               25/44
==> centos6_server:  
  Installing : postgresql-server-8.4.20-7.el6.i686                        26/44
==> centos6_server:  
  Installing : rsyslog-pgsql-5.8.10-10.el6_6.i686                         27/44
==> centos6_server:  
  Installing : 1398866025:rudder-reports-4.1.2.rc1.git201705170216-1.EL   28/44
==> centos6_server:  
==> centos6_server: INFO: Initializing PostgreSQL ...Initializing database: [  OK  ]
==> centos6_server:  Done
==> centos6_server: Starting postgresql service: [  OK  ]
==> centos6_server: psql: could not connect to server: No such file or directory
==> centos6_server:     Is the server running locally and accepting
==> centos6_server:     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
==> centos6_server: sed: no input files
==> centos6_server: sed: no input files
==> centos6_server: INFO: Setting PostgreSQL as a boot service... Done
==> centos6_server: INFO: Waiting for PostgreSQL to be up...............................................................
==> centos6_server: ERROR: Connection to PostgreSQL has not been established before timeout. Exiting
==> centos6_server: warning: %post(rudder-reports-1398866025:4.1.2.rc1.git201705170216-1.EL.6.noarch) scriptlet failed, exit status 1
==> centos6_server: Non-fatal POSTIN scriptlet failure in rpm package 1398866025:rudder-reports-4.1.2.rc1.git201705170216-1.EL.6.noarch
  Updating   : openldap-2.4.40-16.el6.i686                                29/44
==> centos6_server:  
  Installing : openldap-clients-2.4.40-16.el6.i686                        30/44
==> centos6_server:  
  Installing : apr-util-ldap-1.3.9-3.el6_0.1.i686                         31/44
==> centos6_server:  
  Installing : httpd-2.2.15-59.el6.centos.i686                            32/44
==> centos6_server:  
  Installing : 1:mod_ssl-2.2.15-59.el6.centos.i686                        33/44
==> centos6_server:  
  Installing : mod_wsgi-3.2-7.el6.i686                                    34/44
==> centos6_server:  
  Installing : 1398866025:rudder-server-relay-4.1.2.rc1.git201705170216   35/44
==> centos6_server: 

#4 Updated by Nicolas CHARLES 4 months ago

Service is not correctly started:

root@server:/home/vagrant# service postgresql status
postmaster dead but pid file exists

#5 Updated by Nicolas CHARLES 4 months ago

/var/log/messages contains:

May 17 08:56:30 server yum[7261]: Installed: postgresql-libs-8.4.20-7.el6.i686
May 17 08:56:32 server yum[7261]: Installed: postgresql-8.4.20-7.el6.i686
May 17 08:56:33 server yum[7261]: Installed: postgresql-server-8.4.20-7.el6.i686
May 17 08:56:34 server yum[7261]: Installed: rsyslog-pgsql-5.8.10-10.el6_6.i686
May 17 08:57:41 server yum[7261]: Installed: 1398866025:rudder-reports-4.1.2.rc1.git201705170216-1.EL.6.noarch

/var/lib/pgsql/data/pg_log/postgresql-Wed.log contains
LOG:  database system was shut down at 2017-05-17 08:56:39 UTC
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  Ident authentication failed for user "rudder" 
FATAL:  Ident authentication failed for user "rudder" 
FATAL:  Ident authentication failed for user "rudder" 

#6 Updated by Benoît PECCATTE 4 months ago

  • Status changed from New to In progress
  • Assignee set to Benoît PECCATTE

#7 Updated by Benoît PECCATTE 4 months ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Benoît PECCATTE to Alexis MOUSSET
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/1347

#8 Updated by Benoît PECCATTE 4 months ago

  • Status changed from Pending technical review to Pending release

#9 Updated by Vincent MEMBRÉ 4 months ago

  • Status changed from Pending release to Released

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

Also available in: Atom PDF