配置mysql数据库
#下载mysql,解压
[root@localhost local]# mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql
[root@localhost local]# groupadd mysql
[root@localhost local]# useradd -r -g mysql mysql
[root@localhost local]# chown -R mysql.mysql /usr/local/mysql
#创建账户可能缺少文件,复制过去
[root@localhost local]# mkdir /home/mysql
[root@localhost local]# cp /etc/skel/.bash* /home/mysql/
#初始化,最后生成那个是临时密码
[root@localhost mysql]# mkdir data
[root@localhost mysql]# /usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
#编辑配置文件
[root@localhost mysql]# vim /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 取消密码验证
skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# skip-grant-tables
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#mysql加入服务,设置开机启动
[root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# chkconfig mysql on
[root@localhost mysql]# service mysql start
#配置环境变量
export PATH=$PATH:/usr/local/mysql/bin
#开放端口
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
#新建数据库
#注意,分号结尾才算一段语句,本人亲自踩过的坑
[root@localhost mysql]# mysql -u root -p
mysql> CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> CREATE USER 'sonar'@'localhost' IDENTIFIED BY 'sonar';
mysql> CREATE USER 'sonar'@'%' IDENTIFIED BY 'sonar';
mysql> GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'localhost';
mysql> GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'%';
mysql> FLUSH PRIVILEGES;
mysql> quit;
4、配置sonarqube
#调整系统参数
sysctl -w vm.max_map_count=262144
sysctl -w fs.file-max=65536
ulimit -u 4096 sonarqube
ulimit -n 65536 sonarqube
firewall-cmd --add-port=9000/tcp --permanent
firewall-cmd --reload
修改环境变量
export SONAR_HOME=/usr/sonar/sonarqube
#修稿sonarqube配置文件
[root@localhost local]# vim sonarqube/conf/sonar.properties
数据库的账号密码,刚才创建的
sonar.jdbc.username=sonar
sonar.jdbc.password=sonar
#连接数据库
sonar.jdbc.url=jdbc:mysql://192.168.246.134:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
#驱动程序类名,其实可以不写的
sonar.jdbc.driverClassName=org.gjt.mm.mysql.Driver
sonar.sorceEncoding=UTF-8
sonar.login=admin
sonar.password=admin
#开启端口
sonar.web.host=0.0.0.0
sonar.web.port=9000
创建账号并授权
[root@localhost local]#useradd sonar
[root@localhost local]#passwd -d sonar
[root@localhost local]# chown -R sonar.sonar sonarqube
[root@localhost local]# chmod 777 -R sonarqube
[root@localhost local]# vim /etc/sudoers
#添加
sonar ALL=(ALL) ALL
#配置sonarqube启动参数
[root@localhost local]# vim sonarqube/elasticsearch/config/elasticsearch.yml
#端口
network.host:192.168.246.134
http.port:9200
[root@localhost local]# vim sonarqube/elasticsearch/config/jvm.options
#改成-Xms1g
#切换成sonar账号 启动elasticsearch
[sonar@localhost elasticsearch]$ ./bin/elasticsearch -d
#netstat -nultp 可以查看9200.9300端口即为成功
#启动sonarqube
[sonar@localhost sonarqube]$ ./bin/linux-x86-64/sonar.sh start
登录网页界面
192.168.246.134:9000
默认账号admin
默认密码admin
网页汉化
应用市场的汉化插件版本过高,不能自动安装,需要手动安装
当前sonarqube为7.6版本,因此需要下载1.26的汉化插件
https://github.com/xuhuisheng/sonar-l10n-zh/releases?page=2
放在sonarqube\extensions\plugins
重启即可
IP变动之后,修改配置文件中的地址,查看进程,沙雕9200端口进程
netstat -alnp|grep 9200
kill -9 进程号
PS:涉及IP地址的请自行替换
本篇为参考部分文章后自己实践总结修改后得出,原本部分步骤实际操作不成功
参考文章: