Created attachment 965839[details]
remote ovirt-engine-dwh setup
Description of problem:
After upgrade to rhevm3.5 from rhevm3.4 setup (engine+dwh+reports), I can't set up new remote dwh to connect to existing dwh database with:
[ ERROR ] Cannot connect to DWH database: Cannot connect to database: could not connect to server: Connection refused Is the server running on host "10.34.61.71" and accepting TCP/IP connections on port 5432?
Host is accepting any connections.
Version-Release number of selected component (if applicable):
3.5
How reproducible:
always
Steps to Reproduce:
1. setup rhevm3.4 (engine+dwh+reports)
2. upgrade to rhevm3.5
3. try to setup new remote dwh and connect to existing dwh db
Actual results:
error
Expected results:
successful connection
Additional info:
How did you try to connect to the db?
Is it a remote db and you gave its credentials?
Did you backup and restore in the new host?
Is it on the engine host?
It's db on engine, I gave the setup, on dwh machine side, its credentials.
Comment 3Yedidyah Bar David
2014-12-08 14:22:07 UTC
This happens because postgresql is not configured to accept connections from remote hosts. In 3.4 this was the behavior. In 3.5 it was changed, but only for new setups. So setups upgraded from 3.4 need to do that manually:
Edit the file /var/lib/pgsql/data/postgresql.conf
Find there the line containing 'listen_addresses' and change it to be:
listen_addresses = '*'
If there is no such line there, or only a commented one, add a new such line.
Restart postgresql with:
service postgresql restart
This should be enough.
I think we should add the above to the article explaining how to migrate dwh to another host and not fix the code to do that on upgrade.
Created attachment 965839 [details] remote ovirt-engine-dwh setup Description of problem: After upgrade to rhevm3.5 from rhevm3.4 setup (engine+dwh+reports), I can't set up new remote dwh to connect to existing dwh database with: [ ERROR ] Cannot connect to DWH database: Cannot connect to database: could not connect to server: Connection refused Is the server running on host "10.34.61.71" and accepting TCP/IP connections on port 5432? Host is accepting any connections. Version-Release number of selected component (if applicable): 3.5 How reproducible: always Steps to Reproduce: 1. setup rhevm3.4 (engine+dwh+reports) 2. upgrade to rhevm3.5 3. try to setup new remote dwh and connect to existing dwh db Actual results: error Expected results: successful connection Additional info: