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

[Gerd W. <ger...@t-...>]

Am 07.12.23 um 18:19 schrieb Mike Barker:
> My point was that I don’t think it is a VPN issue.  I can connect to my 
> databases over VPN  using squirrelcli, but not using squirrel UI, even 
> though both are using the same aliases.  What is the difference between 
> the squirrelcli connection and the UI connection?
> 

The error message from your first mail shows that the problem occurs at 
a  code section that both SQuirreL's CLI and UI use.

Here are things you may try:
1. If in use disable the MySQL Plugin, see menu Plugins --> summary. 
Please restart SQuirreL after you disabled it.
2. Right click your MySQL Alias choose "Alias Properties" --> tab 
"Driver Properties". Make sure "User driver properties" is unchecked.
3. In case you know some Java you may experiment with the Java code 
below to reproduce the problem. If you were able to reproduce it this 
way that should make it easier to tell if it's a SQuirreL or 
database/driver or VPN problem.


Gerd

---- Java code ----
package mysqltest;

import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;

public class MySqlTest
{
    public static void main(String[] args)
    {
       try
       {
          Driver driver = (Driver) 
(Class.forName("com.mysql.cj.jdbc.Driver").getDeclaredConstructor().newInstance());

          Properties props = new Properties();
          props.put("user", "<yourUserName>");
          props.put("password", "<yourPassword>");

          Connection con = driver.connect("<yourJdbcUrl>", props);

          System.out.println("SUCCESSFULLY CONNECTED!");
       }
       catch (Exception e)
       {
          System.out.println("FAILED TO CONNECT. ERROR MESSAGE:");
          e.printStackTrace();
       }
    }
}