Rudder

An error occurs during rudder-server-root upgradewhen you upgrade between two 2.11 versions:

It occurs during the check of postgresql of rudder, and only in non distributed mode.

INFO: Checking PostgreSQL service status............PostgreSQL service verification failed after 10 tries. Aborting the migration.
Please restart the Rudder service, and start the migration script again:
# /etc/init.d/rudder-server-root restart
# /opt/rudder/bin/rudder-upgrade
dpkg: error processing rudder-webapp (--configure):
 subprocess installed post-installation script returned error exit status 1

command ran by upgrade process is:

psql -q -h server.rudder.local -p 5432 -U rudder -t -d rudder -c 'select count(ruleid) from rules'

This does not work because postgresql is configured to listen on localhost only on rudder server

We get that hostname because we get the hostname of the sql server from '/var/rudder/cfengine-community/inputs/rudder-server-roles.conf'

rudder-db:server.rudder.local

previously we lookedrudder-db:server.rudder.local for that value in /opt/rudder/etc/rudder-web.properties (which contain localhost).

My guess is that we should look if rudder-reports is installed on the local machine to define that variable and lese look to server-roles