|
From: Gerd W. <ger...@t-...> - 2022-11-13 01:02:45
|
In case you know a bit of Java you may try to reproduce your error with the attached test class. If this works you should contact your DB-Admin. Gerd Am 09.10.22 um 13:25 schrieb Martin Röth via Squirrel-sql-users: > Hi, > > I am trying to connect to a mysql database from squirrel. > > I installed squirrel sql client version 4.4.0 on a Windows 11 PC. > > The mysql database (Maria DB 10) is running on a synology NAS System. > > I retrieved the mysql-connector-java-8.0.30.jar and copied it into > squirrel lib folder . > > Alias was set up with URL jdbc:mysql://DS220Plus:3306/clubman – instead > of hostname DS220Plus I also tried localhost and the exact IP address of > my Synology. > > The rights for accessing the database (clubman) are setup within mysql > for the user account (that I used for connecting) as well as for the > host with all privileges. > > I also tried with firewall deactivated. > > Database is up and running and I am able to connect via phpMyAdmin. > > But when I am trying to connect via squirrel I always get the message > > „Unexpected Error occurred attempting to open an SQL connection. > > class java.net.ConnectException: Connection refused: connect“ > > Here is the stack trace: > > java.net.ConnectException: Connection refused: connect > > at java.base/java.net.PlainSocketImpl.waitForConnect(Native > Method) > > at > java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107) > > at > java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399) > > at > java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242) > > at > java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224) > > at > java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) > > at java.base/java.net.Socket.connect(Socket.java:591) > > at > com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153) > > at > com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) > > at com.mysql.cj.NativeSession.connect(NativeSession.java:120) > > at > com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948) > > at > com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818) > > at > com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) > > at > com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) > > at > com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) > > 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) > > at java.base/java.lang.Thread.run(Thread.java:834) > > Maybe I did something wrong? Maybe the wrong driver? > > Thanks for help. > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
