Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84804members
354254posts

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

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.

Solved
Valentin_Kozlov
Lieutenant Lieutenant
Lieutenant
0 Likes
5
1507

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

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:

 

image.png

 

I've found that port 5432 was closed and open it on firewall.

Now I have another error:

 

image.png

 

There were no entries in pg_hba.conf file related to new databese:

 

image.png

 

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?

Tags (1)

Accepted Solutions
Jef
Captain Captain
Captain
0 Likes
2
1486

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

Hi Valentin,

 

I could reproduce it with pgAdmin, but adding the host IP in the allowed list permits the connection:

Capture-jf.JPG

this worked for me without further problem!

Kind regards,

Jef

See Answer In Context

Tags (1)
5 Replies 5
gsterling
Commander Commander
Commander
0 Likes
4
1501

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

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

Tags (1)
Valentin_Kozlov
Lieutenant Lieutenant
Lieutenant
0 Likes
3
1498

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

Hi Greg!

 

Did you mean this one?

 

image.png

 

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

Tags (1)
Jef
Captain Captain
Captain
0 Likes
2
1487

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

Hi Valentin,

 

I could reproduce it with pgAdmin, but adding the host IP in the allowed list permits the connection:

Capture-jf.JPG

this worked for me without further problem!

Kind regards,

Jef

Tags (1)
Valentin_Kozlov
Lieutenant Lieutenant
Lieutenant
0 Likes
1
1478

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

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 🙂

Tags (1)
Jef
Captain Captain
Captain
0 Likes
0
1473

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

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

Tags (1)