无法访问 Sonar MySQL 数据库原因:java.sql.SQLException:用户 'sonar'@'glassfishdev.ccs.local' 的访问被拒绝(使用密码:YES)

本文介绍了无法访问 Sonar MySQL 数据库原因:java.sql.SQLException:用户 'sonar'@'glassfishdev.ccs.local' 的访问被拒绝(使用密码:YES)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试将 Sonar 添加到我的持续集成构建系统中.我使用 ANT 作为我的构建脚本，并且我使用 sonar-ant-task-1.1.jar 来生成基于我在 SVN 中的源代码的报告.

I am trying to add Sonar to my Continuous Integration build system. I am using ANT as my build script and I am using the sonar-ant-task-1.1.jar for sonar to generate the reports based on my source code in SVN.

问题当构建运行并命中 sonar ant 任务时，我得到如下异常:

Problem When the build runs and hits the sonar ant task I get the exception as follows:

Caused by: java.sql.SQLException: Access denied for user 'sonar'@'glassfishdev.ccs.local' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2312)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at org.sonar.jpa.session.DriverProxy.connect(DriverDatabaseConnector.java:160)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.sonar.jpa.session.DriverDatabaseConnector.getConnection(DriverDatabaseConnector.java:95)
at org.sonar.jpa.session.AbstractDatabaseConnector.testConnection(AbstractDatabaseConnector.java:185)
... 40 more

我做了什么

1. 安装 MySQL 数据库.

1. Install MySQL database.

2.使用sonar安装中提供的脚本创建sonar数据库、sonar用户并授予权限

2. Create the sonar database, sonar user, and grant permissions by using the script provided in the sonar installation

**CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci;    
CREATE USER 'sonar' IDENTIFIED BY 'sonar';
GRANT ALL ON sonar.* TO 'sonar'@'%' IDENTIFIED BY 'sonar';
GRANT ALL ON sonar.* TO 'sonar'@'localhost' IDENTIFIED BY 'sonar';
FLUSH PRIVILEGES;**

3. 添加了跟随到我的构建脚本

3. Added the following to my build script

4. 在 Jenkins Freestyle 构建项目中添加了以下外部变量

4. Added the following external variables in Jenkins Freestyle build project

sonar.jdbc.url=jdbc:mysql://10.120.21.12:3306/sonar?useUnicode=true&characterEncoding=utf8
    sonar.jdbc.driverClassName=com.mysql.jdbc.Driver
    sonar.jdbc.username=sonar
    sonar.jdbc.password=sonar
    sonar.host.url=http://10.120.21.12:9000/

5.我也可以通过我的sql客户端工具连接到数据库，验证数据库、用户和权限语句是否正确执行.

5. I was also available to connect to the database through my sql client tool to verify that the database, user and permissions statements were executed correctly.

但是，当 Jenkins 运行构建时，它似乎不知道如何连接到 MySQL 数据库.

However when Jenkins runs the build it does not seem to know how to connect to the MySQL database.

有什么想法吗?

无法访问 Sonar MySQL 数据库原因:java.sql.SQLException:用户 'sonar'@'glassfishdev.ccs.local' 的访问被拒绝(使用密码:YES)

问题描述

推荐答案

相关文档推荐