topic Remote database connection using VPN in Talend Studio

Remote database connection using VPN

ALa1614 — Sat, 16 Nov 2024 00:32:16 GMT

i want to load my output table in a postgresql database that exist in a linux server, i am using a vpn to access to the database.

i am getting error in the connection! i can't connect

can anyone help with this!!!

Re: Remote database connection using VPN

prg — Wed, 24 Feb 2021 15:48:10 GMT

Hello @Ali Laghr ,

Could you please share the exact error logs/ screenshot with us?

Regards,

Vaishnavi

Re: Remote database connection using VPN

Anonymous — Wed, 24 Feb 2021 15:55:03 GMT

Hello , VPN is happening on sysem side, can you connect your operating system to the VPN and run the job again ?

Re: Remote database connection using VPN

ALa1614 — Wed, 24 Feb 2021 16:09:49 GMT

hello @Vaishnavi Khandelwal

this is the error message

the VPN is already running

regards

Re: Remote database connection using VPN

ALa1614 — Wed, 24 Feb 2021 16:10:37 GMT

The VPN is already running, i tried but still getting the same error as shown in the screen

regards

Re: Remote database connection using VPN

Anonymous — Wed, 24 Feb 2021 16:15:15 GMT

can youclick on the details and show the output by copy paste ? Which release of postgresql is installed ?

Re: Remote database connection using VPN

ALa1614 — Thu, 25 Feb 2021 08:22:22 GMT

Echec de la connexion Vous devez modifier les paramètres de la base de données.

java.lang.RuntimeException: org.postgresql.util.PSQLException: La tentative de connexion a échoué.

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.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: La tentative de connexion a échoué.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:292)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)

at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:211)

at org.postgresql.Driver.makeConnection(Driver.java:458)

at org.postgresql.Driver.connect(Driver.java:260)

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:199)

... 9 more

Caused by: java.net.SocketTimeoutException: connect timed out

at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.postgresql.core.PGStream.<init>(PGStream.java:75)

at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)

... 15 more

Re: Remote database connection using VPN

ALa1614 — Thu, 25 Feb 2021 13:26:24 GMT

i am running version 4.28 of pgAdmin 4

Re: Remote database connection using VPN

NCooperDevelux — Sun, 28 Feb 2021 20:04:34 GMT

Thanks a lot, i have the same problem.

Best Regards, Nick Cooper, Develux