[QUESTION] Possible VPN blocking Query

[johnnymajor]

Trying to determine if possibly a port needs to be opened up via VPN because the connection "seems" to work just fine however when attempting to do a query nothing ever happens. Never fails or responds. I did add trace : true to the connection config and all I am seeing is after connecting and attempting a query.

as400@setString: Properties  (2142755619) : trace = "true".
as400@setString: Properties  (2142755619) : naming = "system".
as400: ConnectionPool com.ibm.as400.access.AS400JDBCConnectionPool@3fda8085 (1071284357) : Filling the pool with 1 connections..

I am able to connect and query a local IBM i just fine "not going through a VPN" so assuming the VPN is blocking a port but would have assumed then I would get some sort of failure from the query endpoint.

Does anyone have any thoughts? Thanks!

[crimsonhawk009]

I would compare what ports you can access on the VPN to your running services on this list. It should help narrow down to which service it is failing to connect to.

Here is the list of ports.
https://www-01.ibm.com/support/docview.wss?uid=nas8N1012436

[bergur]

Hey @johnnymajor did you ever find a solution? My name is Bergur and I work at Tryggingamidstodin. We haven't had any problems with VPN, but this is a small project and mostly used by us, so there might be some problems that we are not aware of.

[johnnymajor]

Unfortunately I did not find a solution on this one.

[agelormini]

Read this only now. When I develop with this library, I'm always connected to customer as400 with vpn. So problem must be around how your vpn works and how destination network is set up...While in vpn, you should try to access the ibm with another software like squirrel sql and see if it works.