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):
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
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.
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.
I can confirm it's working with workaround from comment #3
I updated the docs with the workaround.