[TOC]
### 安装mysql运行环境
#### 下载mysql:5.7 镜像
```cmd
docker pull mysql:5.7
```
#### 启动mysql:5.7 容器
数据挂载到宿主机的/data/mysql5.7-data目录下，端口为3306,
```cmd
docker run --name mysql5.7 -v /data/mysql5.7-data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
```
#### 进入容器中创建数据库与用户
1. 进入容器
```cmd
docker exec -it mysql5.7 bash
```
2. 连接数据库
```cmd
mysql -uroot -p123456
```
3. 创建数据库db_sonar
```cmd
create database db_sonar character set utf8 collate utf8_general_ci;
flush privileges;
```
4. 创建数据库用户，用户名密码都为`sonar`
```cmd
grant all privileges on db_sonar.* to 'sonar'@'%'identified by 'sonar' with grant option;
flush privileges;
```
#### 查看mysql容器ip
```cmd
root@ubuntu:/data# docker exec -it mysql5.7 bash
root@ec7039cd8020:/#
root@ec7039cd8020:/# cat /etc/hosts
127.0.0.1 localhost
::1 localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
172.17.0.2 ec7039cd8020
```
结果：
由上面命令可以查到，我的容器ip为`172.17.0.2`
### 安装SonarQube
#### 下载 sonarqube:6.7.5 镜像
```cmd
docker pull sonarqube:6.7.5
```
#### 启动sonarqube容器
* -v 挂载相关配置到 /data/sonar/ 目录下
* -e 指定数据库相关参数
```cmd
docker run -d --name sonar -p 9000:9000 -p 9092:9092 -v /data/sonar/conf:/opt/sonarqube/conf -v /data/sonar/data:/opt/sonarqube/data -v /data/sonar/logs:/opt/sonarqube/logs -v /data/sonar/extensions:/opt/sonarqube/extensions -e "SONARQUBE_JDBC_USERNAME=sonar" -e "SONARQUBE_JDBC_PASSWORD=sonar" -e "SONARQUBE_JDBC_URL=jdbc:mysql://172.17.0.2:3306/db_sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false" sonarqube:6.7.5
```
### SonarQube 实例操作
1. 访问浏览器：http://192.168.147.128:9000 ，这里`192.168.147.128`是我的宿主机ip。
2. 登录，默认账号密码都是admin,首次登录后，会有一个使用教程，如下
根据提示，创建token
3. 实例扫描一个maven工程
* step1：准备一个maven工程
maven下载地址: https://pan.baidu.com/s/1WEvNvMNggXW6s2YIfEFXLw 提取码: 9fx4
demo 下载地址：https://pan.baidu.com/s/1gkMR0sLday9RREu6o6fzBA 提取码: cv47
这里我的maven解压地址为：D:\apache-maven-3.6.0
* step2：这里以扫描maven项目为例，进入到工程根目录下，执行扫描命令为：
`
D:\apache-maven-3.6.0\bin\mvn sonar:sonar -Dsonar.host.url=http://192.168.147.128:9000 -Dsonar.login=b20387fd392e64e9e1cf14501900e3c5149acbcb
`
构建成功后，如下：
```cmd
[INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.147.128:9000/dashboard/index/com.rfchina:utils
[INFO] Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report
[INFO] More about the report processing at http://192.168.147.128:9000/api/ce/task?id=AWgw2wxiWWteYCl4dwII
[INFO] Task total time: 5.034 s
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 14.265 s
[INFO] Finished at: 2019-01-09T12:24:49+08:00
[INFO] ------------------------------------------------------------------------
```
* step3：重新访问Sonar后，会发现在项目列表中已经加入了该项目的分析报告。
### SonarQube Scanner 代码分析
#### 安装 Scanner
通过 [SonarQube Scanner](https://docs.sonarqube.org/display/SCAN/Analyzing+with+SonarQube+Scanner) 进行代码分析
1. 下载Scanner
Scanner 下载地址为：https://docs.sonarqube.org/display/SCAN/Analyzing+with+SonarQube+Scanner
（百度云盘，win64: https://pan.baidu.com/s/1aFRCi7iu1QTwgPZynlltfA 提取码: s6ra）
2. 解压，到目录E:\tools\sonar-scanner
3. 修改全局配置 E:\tools\sonar-scanner\conf\sonar-scanner.properties
```
#----- Default SonarQube server
sonar.host.url=http://192.168.147.128:9000
```
4. 将E:\tools\sonar-scanner\bin目录添加到环境变量中
5. 检查sonar-scanner 配置结果
```cmd
C:\Users\guanfuchang>sonar-scanner -h
INFO:
INFO: usage: sonar-scanner [options]
INFO:
INFO: Options:
INFO: -D,--define <arg> Define property
INFO: -h,--help Display help information
INFO: -v,--version Display version information
INFO: -X,--debug Produce execution debug output
```
#### 使用Scanner
在项目根目录下，创建配置文件`sonar-project.properties`
```cmd
# must be unique in a given SonarQube instance
sonar.projectKey=rfchina:utils
# this is the name and version displayed in the SonarQube UI. Was mandatory prior to SonarQube 6.1.
sonar.projectName=rfchina_utils
sonar.projectVersion=1.0
# Path is relative to the sonar-project.properties file. Replace "\" by "/" on Windows.
# This property is optional if sonar.modules is set.
sonar.sources=.
sonar.java.binaries=./target/classes
# Encoding of the source code. Default is default system encoding
#sonar.sourceEncoding=UTF-8
```
在项目根目录下，执行命令：
```cmd
sonar-scanner
```
执行成功后，如下
```cmd
INFO: ANALYSIS SUCCESSFUL, you can browse http://192.168.147.128:9000/dashboard/index/rfchina:utils
INFO: Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report
INFO: More about the report processing at http://192.168.147.128:9000/api/ce/task?id=AWgxHkcAWWteYCl4dwIW
INFO: Task total time: 3.285 s
INFO: ------------------------------------------------------------------------
INFO: EXECUTION SUCCESS
INFO: ------------------------------------------------------------------------
INFO: Total time: 4.854s
INFO: Final Memory: 18M/380M
INFO: ------------------------------------------------------------------------
```
访问Sonar，将会显示出该项目的分析结果
