- sonarqube 8.x版本安装可以参照:
https://blog.csdn.net/qq_35550345/article/details/102860422 - postgresql数据库备份和恢复可以参照:
https://blog.csdn.net/qq_35550345/article/details/103588970 - mysql数据库备份和恢复可以参照:
https://blog.csdn.net/qq_35550345/article/details/103588917
1、准备工作
ln -s sonarqube-8.2.0.32929 sonar-server
/etc/systemd/system/sonarqube.service
[Unit]
Description=SonarQube Server
After=network-online.target
[Service]
Type=forking
ExecStart=/data/apps/sonarqube/sonar-server/bin/linux-x86-64/sonar.sh start
ExecStop=/data/apps/sonarqube/sonar-server/bin/linux-x86-64/sonar.sh stop
LimitNOFILE=131072
LimitNPROC=8192
User=sonar
Group=sonar
Restart=on-failure
[Install]
WantedBy=multi-user.target
2、升级
cd /data/apps/sonarqube
wget https://binaries.sonarsource.com/Distribution/sonarqube/sonarqube-8.9.2.46101.zip
unzip sonarqube-8.9.2.46101.zip
cp sonarqube-8.9.2.46101/conf/sonar.properties sonarqube-8.9.2.46101/conf/sonar.properties.bak
cp sonarqube-8.9.2.46101/conf/wrapper.conf sonarqube-8.9.2.46101/conf/wrapper.conf.bak
cp sonar-server/conf/sonar.properties sonarqube-8.9.2.46101/conf/sonar.properties
cp sonar-server/conf/wrapper.conf sonarqube-8.9.2.46101/conf/wrapper.conf
sudo systemctl stop sonarqube
sudo -u postgres pg_rman backup -b full -Z -B /data/database/psql_back/psqldb
pg_rman show -B /data/database/psql_back/psqldb
rm -rf sonar-server
ln -s sonarqube-8.9.2.46101 sonar-server
sudo systemctl start sonarqube
1) 访问网址 http://172.16.212.11:9000/setup
2)点击upgrade升级数据库,升级成功会自动跳转到登录页面
3)使用管理员账户和默认密码(admin/admin)登录,会提示修改密码
1)页面从原来的中文变成了英文
cd /data/apps/sonarqube/sonar-server/extensions/downloads
wget https://github.com/xuhuisheng/sonar-l10n-zh/releases/download/sonar-l10n-zh-plugin-8.9/sonar-l10n-zh-plugin-8.9.jar
sudo systemctl restart sonarqube
2)阿里代码规范丢失
cp sonarqube-8.2.0.32929/extensions/plugins/sonar-pmd-plugin-3.2.0-SNAPSHOT.jar sonar-server/extensions/downloads/
sudo systemctl restart sonarqube
3、回滚
sudo systemctl stop sonarqube
sudo systemctl stop postgresql-11
pg_rman show -B /data/database/psql_back/psqldb
sudo -u postgres pg_rman restore -B /data/database/psql_back/psqldb -D /var/lib/pgsql/11/data/ --recovery-target-time "开始时间" --hard-copy
sudo systemctl start postgresql-11
sudo -u postgres psql
select pg_wal_replay_resume();
rm -rf /data/apps/sonarqube/sonar-server
cd /data/apps/sonarqube/
ln -s sonarqube-8.2.0.32929 sonar-server
systemctl start sonarqube