ITA 9.1.0 ETL database connection issue (platform configuration bug?)

[Valentin_Kozlov]

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?

[gsterling]

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

[Valentin_Kozlov]

Hi Greg!

Did you mean this one?

I set it to 0.0.0.0, because usually it means allow all addresses.

[Jef · Accepted solution]

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

[Valentin_Kozlov]

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 🙂

[Jef]

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