概述

SonarQube是管理代碼質(zhì)量一個(gè)開放平臺(tái),可以快速的定位代碼中潛在的或者明顯的錯(cuò)誤。

環(huán)境準(zhǔn)備

• mysql5.7.24: https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24.tar.gz
• boost: https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz (mysql5.7依賴此版本)
• SonarQube: https://binaries.sonarsource.com/Distribution/sonarqube/sonarqube-6.7.6.zip

mysql源碼編譯安裝

1. 解壓源碼包
[root@localhost ~]# tar -xvf mysql-5.7.24.tar
注： .tar.gz后綴的需要用參數(shù)-zxvf

2. 安裝依賴庫(kù)
[root@localhost ~]# yum -y install make cmake gcc gcc-c++ bison bison-devel ncurses ncurses-devel autoconf automake
[root@localhost ~]# useradd mysql
[root@localhost ~]# mkdir /home/mysql
[root@localhost ~]# cd /home/mysql/
[root@localhost mysql]# mkdir data logs temp
[root@localhost mysql]# chown -R mysql:mysql data logs temp

3. 安裝boost
[root@localhost ~]# mkdir /usr/local/boost
[root@localhost ~]# cd /usr/local/boost/
把下載的boost_1_59_0.tar.gz放于此目錄

4.執(zhí)行安裝命令
進(jìn)入mysql源碼目錄
[root@localhost boost]# cd ~/mysql-5.7.24
執(zhí)行以下命令

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/home/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DWITH_BOOST=/usr/local/boost

等待完成后，繼續(xù)執(zhí)行編譯
[root@localhost mysql-5.7.24]# make

執(zhí)行安裝
[root@localhost mysql-5.7.24]# make install

切換到/usr/local目錄
[root@localhost mysql-5.7.24]# cd /usr/local/

修改mysql的所屬用戶
[root@localhost local]# chown -R mysql:mysql mysql/

配置環(huán)境變量
[root@localhost local]# vi /etc/profile
把mysql加入path

export PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$JAVA_HOME/bin:$MAVEN_HOME/bin:$PATH

使環(huán)境變量生效
[root@localhost local]# source /etc/profile

執(zhí)行初始化mysql命令
[root@localhost local]# mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data

初始化mysql

可以看到最后有產(chǎn)生的密碼F;))m2Ou*2%e

刪除mysql默認(rèn)的配置文件
[root@localhost local]# cd /etc/
[root@localhost etc]# rm -f my.cnf

復(fù)制mysql的服務(wù)腳本
[root@localhost etc]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

啟動(dòng)mysql服務(wù)
[root@localhost etc]# service mysql start

設(shè)置開機(jī)啟動(dòng)
[root@localhost etc]# chkconfig mysql on

登錄mysql
[root@localhost etc]# mysql -u root -p
Enter password:(前面生成的密碼)

修改密碼
mysql> SET PASSWORD = PASSWORD('qwe123');
Query OK, 0 rows affected, 1 warning (0.01 sec)

修改密碼從不過(guò)期
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.00 sec)

刷新權(quán)限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

退出mysql
mysql> exit;
Bye

重新登錄mysql
[root@localhost etc]# mysql -u root -p
Enter password:qwe123

修改root賬戶可以遠(yuǎn)程登錄
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'qwe123' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)

再次刷新權(quán)限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

退出mysql
mysql> exit;
Bye

開放防火墻端口3306
[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost ~]# sudo systemctl reload firewalld

連接信息

連接成功

SonarQube安裝

安裝解壓工具unzip(已安裝的忽略此步驟)
[root@localhost ~]# yum -y install unzip

解壓
[root@localhost ~]# unzip sonarqube-6.7.6.zip

移動(dòng)到/usr/local/目錄下
[root@localhost ~]# mv sonarqube-6.7.6 /usr/local/

登錄mysql
[root@localhost ~]# mysql -u root -p
Enter password:

創(chuàng)建數(shù)據(jù)庫(kù)
mysql> CREATE DATABASE sonar DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.05 sec)

mysql> use sonar;
Database changed
mysql> exit;
Bye

進(jìn)入sonar的配置文件目錄
[root@localhost ~]# cd /usr/local/sonarqube-6.7.6/
[root@localhost sonarqube-6.7.6]# cd conf/

修改配置
[root@localhost conf]# vi sonar.properties

sonar.jdbc.username=root
sonar.jdbc.password=qwe123
sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
sonar.web.host=0.0.0.0

開放防火墻端口9000
[root@localhost ~]# firewall-cmd --zone=public --add-port=9000/tcp --permanent
[root@localhost ~]# sudo systemctl reload firewalld

添加sonar用戶，且把sonar目錄的用戶修改為sonar
[root@localhost conf]# useradd sonar
[root@localhost conf]# cd ../..
[root@localhost local]# chown -R sonar:sonar sonarqube-6.7.6/

使用sonar用戶啟動(dòng)程序
[root@localhost local]# su sonar
[sonar@localhost local]$ cd sonarqube-6.7.6/bin/
[sonar@localhost bin]$ cd linux-x86-64/
[sonar@localhost linux-x86-64]$ ./sonar.sh start

SonarQube使用

SonarQube

默認(rèn)的登錄賬戶和密碼
admin / admin

token

其中，復(fù)制這一段內(nèi)容

mvn sonar:sonar \
  -Dsonar.host.url=http://192.168.1.177:9000 \
  -Dsonar.login=d21685d0f6cdfcbcb78b0f3edf46ca0c3ba7d3a3

進(jìn)入我們的本地maven項(xiàng)目
kongxiangxis-MacBook-Pro:~ kongxiangxi$ cd /Users/kongxiangxi/git/castle-microservices-platform
kongxiangxis-MacBook-Pro:castle-microservices-platform kongxiangxi$ mvn sonar:sonar \
> -Dsonar.host.url=http://192.168.1.177:9000 \
> -Dsonar.login=d21685d0f6cdfcbcb78b0f3edf46ca0c3ba7d3a3

SonarQube

進(jìn)入項(xiàng)目

查看分析

分析詳情