连接数据库报错jdbc:mysql://10.255.255.232:3306/yh数据库无法访问

小白与宝儿 发表于 2023-9-7 14:22
错误代码:120000019
数据集: '232mysql20230907142042-830'   执行用户: 'xjh'
异常: 超时导致创建连接 ...

从你安装bi的那台服务器通过命令行去登录
mysql -h<hostname_or_ip> -u<username> -p
看看是否正常，看起来像是网络或者数据库侧有什么限制呢

检查数据库连接，是数据源连不上了

yhdata_lyaa 发表于 2023-9-7 09:56
检查数据库连接，是数据源连不上了

我使用navicat可以连接上，用永洪就连接不上

测试连接报什么错呢

试试这段，一般都是severTimezone=UTC没有默认导致的。jdbc:mysql://10.255.255.232:3306/yh?severTimezone=UTC&useUnicode=true&zeroDataTimeBehavior=convertToNull&autoReconnect=true

shuowang2020 发表于 2023-9-7 10:20
试试这段，一般都是severTimezone=UTC没有默认导致的。jdbc:mysql://10.255.255.232:3306/yh?severTimezone ...

这个是在哪里进行设置呢？

yhdata_yzm 发表于 2023-9-7 10:08
测试连接报什么错呢

错误代码:120000019
数据集: '232mysql20230907142042-830'   执行用户: 'xjh'
异常: 超时导致创建连接失败，超时设定:30,000，URL:jdbc:mysql://10.255.255.232:3306/yh
        at g5.sv.qry.req.TestQryReq.process0(TestQryReq.java:183)
        at g5.sv.Req.process(Req.java:57)
        at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:207)
        at g5.sv.qry.QueryProc.procReq(QueryProc.java:134)
        at g5.sv.qry.QueryProc.service(QueryProc.java:62)
        at g5.sv.ServletHelper.service(ServletHelper.java:122)
        at g5.sv.PortalServlet.service(PortalServlet.java:1464)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.base/java.lang.Thread.run(Thread.java:834)