Remote database connection using VPN

[ALa1614]

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!!!

[prg]

Hello @Ali Laghr​ ,

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

Regards,

Vaishnavi

[Anonymous]

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

[ALa1614]

hello @Vaishnavi Khandelwal​ 

this is the error message

the VPN is already running

regards

[ALa1614]

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

regards

[Anonymous]

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

[ALa1614]

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

[ALa1614]

i am running version 4.28 of pgAdmin 4

[NCooperDevelux]

Thanks a lot, i have the same problem.

Best Regards, Nick Cooper, Develux