sr 3.0.0版本,创建mysql jdbc catalog,创建成功,但是查询报错

或者用低版本的这个jar包试试,比如用5.7的connector

低版本的jar试过了,也不行

telnet 防火墙确认了吗

我在3台节点测试telnet,测试结果如下图:等一会儿就显示Connection closed by foreign host.,这个是通的吗?
image

这时表示端口通的,你在mysql里面执行下show global variables like '%port%'看下结果是啥

你在sr的机器用mysql客户端可以连上mysql正常查询么

image
是可以正常连接mysql的。这个只是其中一台机器(安装了mysql的),其他两台没有安装myql,但是网络都是通的

可以正常查表的数据吗

可以正常查询

用5.1.49的jar包试试mysql-connector-java-5.1.49.jar (983.3 KB)

执行 show databases from mysql_catalog_201; 时报错,报错如下:

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1064] [42000]: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:510)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:441)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:169)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:428)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:813)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3280)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:169)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4589)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLSyntaxErrorException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130)
… 12 more

之前用的5.1.48测试也是这样,查询报错

你在社区群吗,在的话,加下我

我在社区群 7 ,我在群里打了1

原因是mysql服务开启了ssl认证,mysql server关闭ssl认证之后可以正常使用jdbc catalog。当前sr在使用useSSL=false连接的时候支持的不好,这种情况下jdbc catalog还不能使用,我们后续支持下这个

1赞

useSSL=false 这个有解决方案了吗

1赞