|
From: Leo Liebenauer-W. <lw...@we...> - 2023-12-07 08:00:14
|
I don't think that's an issue of the client (Squirrel). If you can
connect to other applications via VPN perhaps the DB-access is
restricted/blocked for those trying to connect via VPN. Might be a
security breach.
good luck
leo
Am 07.12.23 um 02:49 schrieb Mike Barker:
> 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
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
--
*Weberhofer GmbH*
information technologies *DI Leo Liebenauer-Welsch*
Software Entwicklung
Blindengasse 52/3
1080 Wien
Austria +43 (0)1 5454421 <tel:+4315454421>
www.weberhofer.at <http://www.weberhofer.at>
UID: ATU55277701, Firmenbuch: 225566s, Handelsgericht Wien
|
