[Squirrel-sql-users] Squirrel SQL can't connect over VPN

[Mike B. <mb...@on...>]

Hi,
I use AWS VPN to access our remote MySQL DBs.  I use SQuirrel SQL 4.6.0 as my primary SQL IDE.

Since Nov 13, I have been unable to access any DBs remotely over the VPN.  My team discovered that AWS VPN doesn't like IP6  traffic, so I've disabled it on my Mac.  I've also set globally JAVA_TOOL_OPTIONS="-Djava.net.preferIPv4Stack=true".  These changes have allowed my local Java development servers to access the DBs over AWS VPN. My apps as well as SQuirrel SQL use the mysql jar below. However, I still can't use SQuirrel SQL; the connection times out.

Here's my environment:
MacOS 14.1.1
Java (Eclipse Adoptium) 11.0.17+8
mysql-connector-j-8.0.33.jar
MySQL 8.0.34
AWS VPN Client 3.8.0

Any thoughts on what I can set inside or outside of SQuirrel SQL?

—Mike


registerDriver: com.mysql.cj.jdbc.Driver@265c887a
SQLState(08001) vendor code(0)
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
	at net.sourceforge.squirrel_sql.fw.sql.SQLConnector.getSqlConnection(SQLConnector.java:58)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:110)
	at net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:155)
	at net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConnectionCommand.lambda$execute$0(OpenConnectionCommand.java:89)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)