Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

docker部署,mysql监控,后台会报查询mysql出错。 #32

Closed
weyoung3350 opened this issue Jan 29, 2021 · 2 comments
Closed

docker部署,mysql监控,后台会报查询mysql出错。 #32

weyoung3350 opened this issue Jan 29, 2021 · 2 comments
Labels
bug Something isn't working

Comments

@weyoung3350
Copy link

weyoung3350 commented Jan 29, 2021

从后台执行日志看,应该是执行查询时没有传递mysql的密码引起的。
我反复确认过多次,数据源肯定是定义了用户名和密码。我查看data_source表,proterties字段中保存了正确的用户名密码。
并且在新增告警时,页面中的“测试”按钮执行是能正确返回结果的。

"2021-01-30T00:34:39.210+08:00" "WARN" "com.autohome.frostmourne.monitor.service.core.execute.GenerateShortLinkService" "55" "-" "-" "error when generate short link. response: {""returncode"":0,""message"":""ok"",""result"":""""}" "com.autohome.frostmourne.monitor.service.core.execute.GenerateShortLinkService" "generate" "-" "-" "tech" "frostmourne" "frostmourne.monitor" "-" "394" "Thread-264" "-" "172.18.0.4" "-" "-" "-" "-" "-"
"2021-01-30T00:34:47.230+08:00" "ERROR" "com.alibaba.druid.pool.DruidDataSource" "53" "java.sql.SQLException" "Access denied for user 'xxxxxx'@'10.10.5.220' (using password: YES)" "create connection error, url: jdbc:mysql://10.10.5.27:3306/xxxxxxx" "com.alibaba.druid.support.logging.Log4j2Impl" "error" "-" "-" "tech" "frostmourne" "frostmourne.monitor" "-" "226" "Druid-ConnectionPool-Create-1187914410" "-" "172.18.0.4" "-" "-" "-" "-" "java.sql.SQLException: Access denied for user 'xxxxxx'@'10.10.5.220' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1888)

@LittleShrimp1987 LittleShrimp1987 added the bug Something isn't working label Jan 30, 2021
@LittleShrimp1987
Copy link
Collaborator

最新版本已经修复,镜像还没有更新

@LittleShrimp1987
Copy link
Collaborator

镜像已经更新

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants