|
From: Mike B. <mb...@on...> - 2023-12-07 02:02:34
|
I still cannot connect to my DBs. I discovered squirrelcli and installed it in my Mac Squirrel directory. I made one change to squirrelcli.sh. It executes and brings up the jshell prompt. I’m able to connect using one of my aliases from Squirrel UI and query the DB. How is CLI connection different from the connection using the UI?
I have added "&traceProtocol=true&logXaCommands=true” to the JDBC string. It spews out a lot of information at the command line, though not shown below. None of that is logged when using the UI, at least I can’t find it.
There is something in the UI that is keeping me from connecting to the DBs.
Thanks for any help.
--Mike
/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli> squirrelcli.sh
/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli
Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
Entering JShell based mode.
Picked up JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
Picked up _JAVA_OPTIONS: -Dsquirrel.home='/Applications/SQuirreLSQL.app/Contents/Resources/Java/squirrelcli'/..
------------------------------------------------------------------
-- Welcome to the SQuirreL CLI (Command Line Interface)
-- Enter help() for information.
-- Enter /exit to leave.
------------------------------------------------------------------
| Welcome to JShell -- Version 11.0.17
| For an introduction type: /help intro
jshell> connect("sso-dev")
jshell> exec("select count(*) from user")
count(*)
--------
175383
jshell>
> On Nov 29, 2023, at 4:13 PM, Mike Barker <mb...@on...> wrote:
>
> 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
|
