[Spacewalk-list] rhn-search fails connection to PostgreSQL POST 2.1 upgrade

[Michael Mraka]

Jeremy Davis wrote:
% Hello List,
% 
% I have a Spacewalk 2.1 installation that was just upgraded from 2.0 that
% rhn-search fails to start after the upgrade. I get the following error in
% the logs. Any ideas as to what could be the issue? rhn-search is running on
% the same server as tomcat and taskomatic and everything seems to be working
% fine with those services connecting to our external PostgreSQL database.
% This is a clean install of 2.0 that was upgraded to 2.1. Everything was
% working before the upgrade. No errors were seen during the upgarde process
% everything went really well. Maybe a little too well as it was really fast!
% :)
% 
% INFO   | jvm 1    | 2014/03/07 14:39:34 | WARNING:
% com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 5ff54855 --
% Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
% acquire a needed new resource, we failed to succeed more than the maximum
% number of allowed acquisition attempts (30). Last acquisition attempt
% exception:
% INFO   | jvm 1    | 2014/03/07 14:39:34 |
% org.postgresql.util.PSQLException: Connection refused. Check that the
% hostname and port are correct and that the postmaster is accepting TCP/IP
% connections.

Hello Jeremy,

Rhn-search can't connect to postgresql. Is database running? Are the
connect information and user credentials correct? Can you connect to
database manually? Any selinux errors?


Regars,

--
Michael Mráka
Satellite Engineering, Red Hat