topic Re: PostgreSQL connection error in Talend Studio

PostgreSQL connection error

Anonymous — Sat, 16 Nov 2024 09:31:51 GMT

Hi All / Team,

I am getting below error while i am trying to connect to Heroku PostgreSQL. Request you to kindly help me.

Connection details:

DB Type : PostgreSQL

DB Verson : Prior to v9 or any

Host : ec2-54-75-224-100.eu-west-1.compute.amazonaws.com

Database : d47os107p1ek80

Port : 5432

Password : 40b1f6233cd25b3acef5b27185919683894692e8895fa8a7b4d7bfd5d8de6f66

Schema : salesforcennikumdevorg

Error:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.postgresql.util.PSQLException: Connection attempt timed out.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Caused by: org.postgresql.util.PSQLException: Connection attempt timed out.
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:352)
at org.postgresql.Driver.connect(Driver.java:264)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more

Thank you,

Narendra Nikum

+91 9731271416

Re: PostgreSQL connection error

Anonymous — Fri, 21 Jul 2017 10:25:05 GMT

Hello,

With your DB connection parameters, could you successfully connect to PostgreSQL DB directly by client without talend tool?

Have you already downloaded and installed required jar files in talend studio for PostgreSQL connection?

Best regards

Sabrina

Re: PostgreSQL connection error

Anonymous — Tue, 25 Jul 2017 10:36:39 GMT

Hi Sabrina,

Thank you so much for your mail, PFB new connection details. i have created new PostgreSQL DB in Heroku. Hope it helps, because using heroku i am able to connect to this PostgreSQL database.

Host: ec2-54-163-254-143.compute-1.amazonaws.com

Port : 5432

Database : d21gmbnlr6hi6s

schema : salesforce

User : npdulhqsumdyhv

Password : c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599

URI : postgres://npdulhqsumdyhv:c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599@ec2-54-163-254-143.compute-1.amazonaws.com:5432/d21gmbnlr6hi6s

Heroku CLI : heroku pgsql postgresql-curved-11352 --app nikumtestapp1

Thank you,

Narendra Nikum

9731271416

Re: PostgreSQL connection error

Anonymous — Tue, 25 Jul 2017 14:49:55 GMT

Hi Sabrina,

When i am trying in my home network i am getting below error. Kindly help me.

Host: ec2-54-163-254-143.compute-1.amazonaws.com

Port : 5432

Database : d21gmbnlr6hi6s

schema : salesforce

User : npdulhqsumdyhv

Password : c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599

URI : postgres://npdulhqsumdyhv:c0130dd662e703254a654978fb375450598973ce2af91c652836c20195c64599@ec2-54-163-254-143.compute-1.amazonaws.com:5432/d21gmbnlr6hi6s

Heroku CLI : heroku pgsql postgresql-curved-11352 --app nikumtestapp1

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "157.49.1.67", user "npdulhqsumdyhv", database "d21gmbnlr6hi6s", SSL off
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "157.49.1.67", user "npdulhqsumdyhv", database "d21gmbnlr6hi6s", SSL off
at org.postgresql.Driver$ConnectThread.getResult(Driver.java:341)
at org.postgresql.Driver.connect(Driver.java:264)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more

Thank you,

Narenndra Nikum

9731271416

Re: PostgreSQL connection error

Anonymous — Wed, 26 Jul 2017 04:53:54 GMT

Hello,

Could you please have a look at this article:https://stackoverflow.com/questions/16740095/org-postgresql-util-psqlexception-fatal-no-pg-hba-conf-entry-for-host to see if it is OK with your issue?

Best regards

Sabrina