EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Posted: 2020-08-06 05:03 AM . Last Modified: 2020-08-06 05:25 AM
Hi Team!
I'm experiencing issue working with ETL export database.
I successfully create internal export ETL database via web-interface and it works (I can see that in etl.log).
But I was unable to connect to database with pgAdmin tool:
I've found that port 5432 was closed and open it on firewall.
Now I have another error:
There were no entries in pg_hba.conf file related to new databese:
I add 'allow all' entry to pg_hba.conf file:
host all all all trust
and set parameter to listen all addresses in postgresql.conf file:
listen_addresses = '*'
But with no luck. I still receive error about connection rejection by pg_hba.
Can anyone advice how to configure new version to allow external connections? Is there something specific?
And why didn't ITA make all the settings when create export database?
Posted: 2020-08-06 06:34 AM . Last Modified: 2020-08-06 06:37 AM
Hi Valentin,
I could reproduce it with pgAdmin, but adding the host IP in the allowed list permits the connection:
this worked for me without further problem!
Kind regards,
Jef
Posted: 2020-08-06 05:44 AM
Hello Valentin
Did you set an allowed list in the ETL definition in the web client? If not, then remote access is not allowed.
Regards
Greg Sterling
Posted: 2020-08-06 06:00 AM
Hi Greg!
Did you mean this one?
I set it to 0.0.0.0, because usually it means allow all addresses.
Posted: 2020-08-06 06:34 AM . Last Modified: 2020-08-06 06:37 AM
Hi Valentin,
I could reproduce it with pgAdmin, but adding the host IP in the allowed list permits the connection:
this worked for me without further problem!
Kind regards,
Jef
Posted: 2020-08-06 06:53 AM
Great!
It works for me either, thank you!
But nothing changes in pg_hba.conf and it is very interested...
So, now we need to add all addresses we want to connect from. Of course it is more secure,but less convenient for me 🙂
Posted: 2020-08-06 07:10 AM
Hi Valentin,
Sounds great, that it worked for you as well.
I could reproduce similar experience (as you) using pgAdmin but not with DbVisualizer. So basically we may add a specific IP to the allowed list when/if needed.
Kind regards,
Jef
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.