概述
SonarQube是管理代碼質(zhì)量一個開放平臺,可以快速的定位代碼中潛在的或者明顯的錯誤。
環(huá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. 安裝依賴庫
[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í)行安裝命令
進入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
可以看到最后有產(chǎn)生的密碼F;))m2Ou*2%e
刪除mysql默認的配置文件
[root@localhost local]# cd /etc/
[root@localhost etc]# rm -f my.cnf
復制mysql的服務(wù)腳本
[root@localhost etc]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
啟動mysql服務(wù)
[root@localhost etc]# service mysql start
設(shè)置開機啟動
[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)
修改密碼從不過期
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賬戶可以遠程登錄
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
移動到/usr/local/目錄下
[root@localhost ~]# mv sonarqube-6.7.6 /usr/local/
登錄mysql
[root@localhost ~]# mysql -u root -p
Enter password:
創(chuàng)建數(shù)據(jù)庫
mysql> CREATE DATABASE sonar DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.05 sec)
mysql> use sonar;
Database changed
mysql> exit;
Bye
進入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用戶啟動程序
[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
默認的登錄賬戶和密碼
admin / admin
其中罪郊，復制這一段內(nèi)容
mvn sonar:sonar \
-Dsonar.host.url=http://192.168.1.177:9000 \
-Dsonar.login=d21685d0f6cdfcbcb78b0f3edf46ca0c3ba7d3a3
進入我們的本地maven項目
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
