https://issues.rudder.io/https://issues.rudder.io/themes/rudder7/favicon/favicon.ico?17096450182017-05-15T12:42:42ZIssue TrackerRudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=762692017-05-15T12:42:42ZFrançois ARMANDfrancois.armand@rudder.io
<ul><li><strong>Severity</strong> set to <i>Major - prevents use of part of Rudder | no simple workaround</i></li><li><strong>User visibility</strong> set to <i>Getting started - demo | first install | level 1 Techniques</i></li><li><strong>Priority</strong> changed from <i>0</i> to <i>54</i></li></ul><p>Please, whould you mind giving logs or any other relevant information that would allow us to reproduce the problem?</p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=762732017-05-15T12:48:08ZAlexis Moussetalexis.mousset@rudder.io
<ul></ul><p>I could not reproduce it in a nightly install.</p>
<p>The issue was that during the rudder-reports postinst script could not connect to postgreSQL.</p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=762942017-05-17T09:02:58ZNicolas CHARLESnicolas.charles@rudder.io
<ul></ul><p>I could reproduce it on Centos 6 32 bits: <br /><pre>
==> 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:
</pre></p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=762952017-05-17T09:12:04ZNicolas CHARLESnicolas.charles@rudder.io
<ul></ul><p>Service is not correctly started:<br /><pre>
root@server:/home/vagrant# service postgresql status
postmaster dead but pid file exists
</pre></p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=762972017-05-17T09:23:15ZNicolas CHARLESnicolas.charles@rudder.io
<ul></ul><p>/var/log/messages contains:<br /><pre>
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
</pre><br />/var/lib/pgsql/data/pg_log/postgresql-Wed.log contains<br /><pre>
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"
</pre></p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=763052017-05-17T12:03:24ZBenoît PECCATTEbenoit.peccatte@rudder.io
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>In progress</i></li><li><strong>Assignee</strong> set to <i>Benoît PECCATTE</i></li></ul> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=763062017-05-17T12:09:39ZBenoît PECCATTEbenoit.peccatte@rudder.io
<ul><li><strong>Status</strong> changed from <i>In progress</i> to <i>Pending technical review</i></li><li><strong>Assignee</strong> changed from <i>Benoît PECCATTE</i> to <i>Alexis Mousset</i></li><li><strong>Pull Request</strong> set to <i>https://github.com/Normation/rudder-packages/pull/1347</i></li></ul><p>PR <a class="external" href="https://github.com/Normation/rudder-packages/pull/1347">https://github.com/Normation/rudder-packages/pull/1347</a></p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=763132017-05-17T15:46:18ZBenoît PECCATTEbenoit.peccatte@rudder.io
<ul><li><strong>Status</strong> changed from <i>Pending technical review</i> to <i>Pending release</i></li></ul><p>Applied in changeset <a class="changeset" title="Fixes #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6" href="https://issues.rudder.io/projects/rudder/repository/rudder-packages/revisions/d43c18854bf7a8ca8079c56b353b8f4a1a64a696">rudder-packages|d43c18854bf7a8ca8079c56b353b8f4a1a64a696</a>.</p> Rudder - Bug #10704: PostgreSQL could not connect to server when installing Rudder 4.1 nightlies on Centos6https://issues.rudder.io/issues/10704?journal_id=767962017-05-22T13:51:25ZVincent MEMBRÉvme@rudder.io
<ul><li><strong>Status</strong> changed from <i>Pending release</i> to <i>Released</i></li></ul><p>This bug has been fixed in Rudder 4.1.2 which was released today.</p>
<ul>
<li>4.1.2: <a href="http://www.rudder-project.org/pipermail/rudder-announce/2017-May/thread.html000230.html" class="external">Announce</a> <a href="http://www.rudder-project.org/changelog-4.1" class="external">Changelog</a></li>
<li>Download: <a class="external" href="https://www.rudder-project.org/site/get-rudder/downloads/">https://www.rudder-project.org/site/get-rudder/downloads/</a></li>
</ul>