Comments (11)
SwallowGG
commented on April 27, 2024
多少版本？另外能够截个图，看下日志，发我一下。帮助里有打开日志。
from ali-dbhub.
yunzhao824
commented on April 27, 2024
报错截图：
版本不知道在哪看，从下图这个位置下载的：
这里是日志
from ali-dbhub.
SwallowGG
commented on April 27, 2024
是不是没有传密码啊，看报错
from ali-dbhub.
hunny-sketch
commented on April 27, 2024
我也遇到，日志这样（用其他SQL工具能正常连接）：
2023-05-18 10:13:13.520 [http-nio-127.0.0.1-10824-exec-7] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed begin:com.alibaba.dbhub.server.web.api.controller.config.ConfigControllergetChatGptSystemConfig ,param:[]
2023-05-18 10:13:13.535 [http-nio-127.0.0.1-10824-exec-7] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.config.ConfigControllergetChatGptSystemConfig, result:{"data":{},"success":true}, cost:15
2023-05-18 10:13:21.754 [http-nio-127.0.0.1-10824-exec-1] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed begin:com.alibaba.dbhub.server.web.api.controller.config.ConfigControllergetChatGptSystemConfig ,param:[]
2023-05-18 10:13:21.759 [http-nio-127.0.0.1-10824-exec-1] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.config.ConfigControllergetChatGptSystemConfig, result:{"data":{},"success":true}, cost:6
2023-05-18 10:13:26.563 [Druid-ConnectionPool-Create-1064028521] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:mysql://rm-****.rds.***.com:3306/****, errorCode 0, state 08S01
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
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 com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1700)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1792)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2877)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
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)
... 6 common frames omitted
Caused by: java.net.ConnectException: Connection timed out: no further information
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
... 9 common frames omitted
2023-05-18 10:13:26.564 [Druid-ConnectionPool-Create-1064028521] INFO c.a.d.pool.DruidAbstractDataSource - {dataSource-1} failContinuous is true
from ali-dbhub.
SwallowGG
commented on April 27, 2024
看一下是不是配置参数少了，或者网络通吗？
from ali-dbhub.
SwallowGG
commented on April 27, 2024
方便加钉钉或者微信，详细看一下呢？1 8 0 4 2 0 0 0 7 0 9
from ali-dbhub.
SwallowGG
commented on April 27, 2024
可以参考： url: jdbc:mysql://127.0.0.1:3306/xx?useUnicode=true&characterEncoding=utf8&useSSL=false
增加参数useUnicode=true&characterEncoding=utf8&useSSL=false
from ali-dbhub.
yunzhao824
commented on April 27, 2024
刚安装完成的时候没报错的，密码肯定是对的，因为刚开始的时候，能够把这个连接下的所有数据库都展示出来，从我做了一个操作后就一直报错了，就是我查了一个很大的表，没有给条件和限制数量的参数，报了内存溢出了，然后就一直报错了，所有跟数据库的交互操作都会报错
from ali-dbhub.
yunzhao824
commented on April 27, 2024
可以参考： url: jdbc:mysql://127.0.0.1:3306/xx?useUnicode=true&characterEncoding=utf8&useSSL=false
增加参数useUnicode=true&characterEncoding=utf8&useSSL=false
不用加这个，卸载重装后不报错了，请参考我上面关于问题出现的操作过程的描述，你们应该是能够找到一些优化的点的。
from ali-dbhub.
SwallowGG
commented on April 27, 2024
明白了，知道原因了，我再去优化下。
from ali-dbhub.
SwallowGG
commented on April 27, 2024
1.0.5已修复
from ali-dbhub.
Related Issues (20)
- Bug: MySQL查询结果中，有long类型的字段，会丢失最后三位的值 HOT 3
- 优化: 建议可以导出查询结果到Excel HOT 1
- 建议: ssh连接方式 HOT 1
- 优化: ui卡顿，从左侧表列中无法快捷搜索表名 HOT 1
- 建议: mysql表筛选功能，视图表不展示，自然语言根据数据库类型直接转换对应的语法，可视化表结构编辑功能，redis按照文件夹格式展示 HOT 1
- 建议: 6月底的那个颠覆性更新预计什么时候发布呢？ HOT 2
- Bug: 查询不同表的相同字段时出现Bug HOT 1
- 建议: HOT 1
- Bug: COMMON_SYSTEM_ERROR HOT 1
- Bug: HOT 3
- Bug: HOT 4
- Bug: HOT 2
- 建议: mycat连接是否不能支持 HOT 1
- 请删除，已转移至https://github.com/chat2db/Chat2DB
- 建议: 表格字段较多时候，向右拖动滚动条的时候会卡顿 HOT 1
- 建议: 能够选中行数据然后进行SQL插入语句、REPLACE INTO语句、DELETE语句、UPDATE语句的生成 HOT 1
- 建议: sokect5 HOT 1
- 建议: 这玩意原来还需要调openai的接口才能正常使用啊 HOT 2
- 建议: MySQL connection setting add jumper server settings HOT 1
- 建议: 密码加密
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ali-dbhub.