Dashboard database migration - Revision history

Olibouban at 19:38, 15 June 2022

2022-06-15T19:38:52Z

← Older revision		Revision as of 19:38, 15 June 2022
Line 17:		Line 17:

	3. Returning to the jenkins user, modify sonar.properties of Dashboard server 7.8.3		3. Returning to the jenkins user, modify sonar.properties of Dashboard server 7.8.3
	cp lingoport/dashboard-server-7.8.3/conf/sonar.properties lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql		cp lingoport/dashboard-server-7.8.3/conf/sonar.properties lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql
	vi lingoport/dashboard-server-7.8.3/conf/sonar.properties		vi lingoport/dashboard-server-7.8.3/conf/sonar.properties
	* Then modify the sonar.properties file as		* Then modify the sonar.properties file as

	sonar.jdbc.username=lingodashuser		sonar.jdbc.username=lingodashuser
	sonar.jdbc.password=password can be found on dashboard-server-9.4.1/conf/sonar.properties		sonar.jdbc.password=password can be found on dashboard-server-9.4.1/conf/sonar.properties
	sonar.jdbc.url=jdbc:postgresql://localhost/lingodash		sonar.jdbc.url=jdbc:postgresql://localhost/lingodash
	sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError		sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError

	* Also comment out any duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.		* Also comment out any duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.

Olibouban at 19:37, 15 June 2022

2022-06-15T19:37:45Z

← Older revision		Revision as of 19:37, 15 June 2022
Line 38:		Line 38:

	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop
	rm ./lingoport/dashboard-server-7.8.3/data/es6		rm -rf ./lingoport/dashboard-server-7.8.3/data/es6

Rdaly at 21:01, 10 June 2022

2022-06-10T21:01:30Z

← Older revision		Revision as of 21:01, 10 June 2022
Line 89:		Line 89:

	* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
			* The projects should all be listed under the Projects tab and look correct.

	* If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder		* If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder

Rdaly at 20:58, 10 June 2022

2022-06-10T20:58:14Z

← Older revision		Revision as of 20:58, 10 June 2022
Line 1:		Line 1:
	Here are the migration steps. Before starting, note that there are two users:		Here are the migration steps. Before starting, note that there are two users:
	*'''jenkins''' with a home directory /var/lib/jenkins and most of the Lingoport programs are in the /var/lib/jenkins/lingoport folder.		*'''jenkins''' with a home directory /var/lib/jenkins and most of the Lingoport programs are in the /var/lib/jenkins/lingoport folder.
	*'''centos''' or '''ec2-user''' or another name - this is the user that has sudo permission on the system.		*'''centos''' or '''ec2-user''' or another name - this is the user that has sudo permission on the system.
			* Several times in this migration, the Dashboard will be started. This may take several minutes for the URL to come up and may give errors while initializing. To troubleshoot, verify that the Dashboard is running from the command line using the status option:
			/var/lib/jenkins/lingoport/<path to Dashboard server>/bin/linux-x86-64/sonar.sh status

	1.As the jenkins user, stop Dashboard Server 9.4.1		1.As the jenkins user, stop Dashboard Server 9.4.1

Rdaly at 20:54, 10 June 2022

2022-06-10T20:54:07Z

← Older revision		Revision as of 20:54, 10 June 2022
Line 15:		Line 15:

	3. Returning to the jenkins user, modify sonar.properties of Dashboard server 7.8.3		3. Returning to the jenkins user, modify sonar.properties of Dashboard server 7.8.3
	lingoport/dashboard-server-7.8.3/conf/sonar.properties		cp lingoport/dashboard-server-7.8.3/conf/sonar.properties lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql
	* Make a copy of current mysql version sonar.properties ~~file and name it sonar.propertiesmysql~~		vi lingoport/dashboard-server-7.8.3/conf/sonar.properties
	* Then modify the sonar.properties file as		* Then modify the sonar.properties file as

Line 24:		Line 24:
	sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError		sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError

	* Also comment out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.		* Also comment out any duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.

	4. Start Dashboard Server 7.8.3		4. Start Dashboard Server 7.8.3

Rdaly at 20:51, 10 June 2022

2022-06-10T20:51:05Z

← Older revision		Revision as of 20:51, 10 June 2022
Line 1:		Line 1:
	Here are the migration steps.		Here are the migration steps. Before starting, note that there are two users:
			*'''jenkins''' with a home directory /var/lib/jenkins and most of the Lingoport programs are in the /var/lib/jenkins/lingoport folder.
			*'''centos''' or '''ec2-user''' or another name - this is the user that has sudo permission on the system.

	1.~~Stop~~ Dashboard Server 9.4.1		1.As the jenkins user, stop Dashboard Server 9.4.1
	./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop

	2. ~~Delete~~ sonardb database		2. As the sudo user, delete sonardb database

	sudo -u postgres psql		sudo -u postgres psql (''note: this may give a permission error, but continue anyway'')
	drop database lingodash;		drop database lingodash;
	create database lingodash;		create database lingodash;
	grant all privileges on database lingodash to lingodashuser;		grant all privileges on database lingodash to lingodashuser;
			quit

	3. ~~Modify~~ sonar.properties of Dashboard server 7.8.3		3. Returning to the jenkins user, modify sonar.properties of Dashboard server 7.8.3
	lingoport/dashboard-server-7.8.3/conf/sonar.properties		lingoport/dashboard-server-7.8.3/conf/sonar.properties
	* Make a copy of current mysql version sonar.properties file and name it sonar.propertiesmysql		* Make a copy of current mysql version sonar.properties file and name it sonar.propertiesmysql
Line 21:		Line 24:
	sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError		sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError

	* Also ~~commented~~ out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.		* Also comment out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.

	4. Start Dashboard Server 7.8.3		4. Start Dashboard Server 7.8.3
Line 28:		Line 31:
	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	* Go to the Dashboard url and there should be no ~~project~~ (the login has also reverted back to ‘admin/admin’)		* Go to the Dashboard url and there should be no projects (the login has also reverted back to ‘admin/admin’)

	5. Stop Dashboard Server 7.8.3		5. Stop Dashboard Server 7.8.3
Line 37:		Line 40:

	6. Run the command		6. Run the command
			cd lingoport
			cp update/mysql-migrator-1.2-SNAPSHOT.zip .
			unzip mysql-migrator-1.2-SNAPSHOT.zip
	./mysql-migrator-1.2-SNAPSHOT/bin/mysql-migrator -source /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql -target /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.properties		./mysql-migrator-1.2-SNAPSHOT/bin/mysql-migrator -source /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql -target /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.properties

	7. Start Dashboard Server 7.8.3		7. Start Dashboard Server 7.8.3

	~~./lingoport/~~dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	* The password has returned to the original password.		* The password has returned to the original password.

	* Check the ~~project~~ all ~~exists~~ then stop the server		* Check that the projects all exist then stop the server

	~~./lingoport/~~dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop		dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop

	8. Install SonarQube 7.9 Community Edition		8. Install SonarQube 7.9 Community Edition
			cp update/sonarqube-7.9.6.zip .
	cp ~~./lingoport/~~dashboard-server-7.8.3/conf/sonar.properties ~~./lingoport/~~sonarqube-7.9.6/conf/.		unzip sonarqube-7.9.6.zip
	~~./lingoport/~~sonarqube-7.9.6/bin/linux-x86-64/sonar.sh start		cp dashboard-server-7.8.3/conf/sonar.properties sonarqube-7.9.6/conf/.
			sonarqube-7.9.6/bin/linux-x86-64/sonar.sh start

	* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
	* Login to sonarqube and you can see all the project names but no other details		* Login to sonarqube and you can see all the project names but no other details
	* Stop SonarQube 7.9		* Stop SonarQube 7.9
	~~./lingoport/~~sonarqube-7.9.6/bin/linux-x86-64/sonar.sh stop		sonarqube-7.9.6/bin/linux-x86-64/sonar.sh stop

	9. Install SonarQube 8.9 Community Edition		9. Install SonarQube 8.9 Community Edition
			cp update/sonarqube-8.9.8.54436.zip .
	cp ~~lingoport/~~dashboard-server-7.8.3/conf/sonar.properties ~~./lingoport/~~sonarqube-8.9.8.54436/conf/.		unzip sonarqube-8.9.8.54436.zip
	~~./lingoport/~~sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh start		cp dashboard-server-7.8.3/conf/sonar.properties sonarqube-8.9.8.54436/conf/
			sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh start

	* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
	* Login to sonarqube and you can see all the project names but no other details		* Login to sonarqube and you can see all the project names but no other details
	* Stop SonarQube 8.9		* Stop SonarQube 8.9
	~~./lingoport/~~sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh stop		sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh stop

	10. Start Dashboard Server 9.4.1		10. Start Dashboard Server 9.4.1

	cp ~~lingoport/~~dashboard-server-7.8.3/conf/sonar.properties ~~./lingoport/~~dashboard-server-9.4.1/conf		cp dashboard-server-7.8.3/conf/sonar.properties dashboard-server-9.4.1/conf
	rm -rf ~~./lingoport/~~dashboard-server-9.4.1/data/es7		rm -rf dashboard-server-9.4.1/data/es7

	* Start SonarQube 9.4.1		* Start SonarQube 9.4.1

	~~./lingoport/~~dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start		dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start

	* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
Line 83:		Line 90:
	* If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder		* If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder
	** Start SonarQube 9.4.1		** Start SonarQube 9.4.1
	~~./lingoport/~~dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start		dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start
	** Delete the es7 folder		** Delete the es7 folder
	rm -rf ./lingoport/dashboard-server-9.4.1/data/es7		rm -rf ./lingoport/dashboard-server-9.4.1/data/es7

Olibouban at 20:22, 10 June 2022

2022-06-10T20:22:26Z

← Older revision		Revision as of 20:22, 10 June 2022
Line 2:		Line 2:

	1.Stop Dashboard Server 9.4.1		1.Stop Dashboard Server 9.4.1
	./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop

	2. Delete sonardb database		2. Delete sonardb database

	sudo -u postgres psql		sudo -u postgres psql
	drop database lingodash;		drop database lingodash;
	create database lingodash;		create database lingodash;
	grant all privileges on database lingodash to lingodashuser;		grant all privileges on database lingodash to lingodashuser;

	3. Modify sonar.properties of Dashboard server 7.8.3		3. Modify sonar.properties of Dashboard server 7.8.3
	lingoport/dashboard-server-7.8.3/conf/sonar.properties		lingoport/dashboard-server-7.8.3/conf/sonar.properties
	Make a copy of current mysql version sonar.properties file and name it sonar.propertiesmysql		* Make a copy of current mysql version sonar.properties file and name it sonar.propertiesmysql
			* Then modify the sonar.properties file as

	~~Then modify the~~ sonar.properties ~~file as~~		sonar.jdbc.username=lingodashuser
			sonar.jdbc.password=password can be found on dashboard-server-9.4.1/conf/sonar.properties
			sonar.jdbc.url=jdbc:postgresql://localhost/lingodash
			sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError

	~~sonar.jdbc.username=lingodashuser~~		* Also commented out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.
	~~sonar.jdbc.password=password can be found on dashboard-server-9.4.1/conf/sonar.properties~~
	~~sonar.jdbc.url=jdbc:postgresql://localhost/lingodash~~
	~~sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError~~

	Also commented out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.

	4. Start Dashboard Server 7.8.3		4. Start Dashboard Server 7.8.3
Line 29:		Line 28:
	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)		* Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)

	5. Stop Dashboard Server 7.8.3		5. Stop Dashboard Server 7.8.3
Line 82:		Line 81:
	* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button

	If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder		* If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder
			** Start SonarQube 9.4.1
	* Start SonarQube 9.4.1
	./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start
			** Delete the es7 folder
	* Delete the es7 folder
	rm -rf ./lingoport/dashboard-server-9.4.1/data/es7		rm -rf ./lingoport/dashboard-server-9.4.1/data/es7

Olibouban at 20:19, 10 June 2022

2022-06-10T20:19:40Z

← Older revision		Revision as of 20:19, 10 June 2022
Line 26:		Line 26:
	4. Start Dashboard Server 7.8.3		4. Start Dashboard Server 7.8.3

	cd		cd
	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)		Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)
Line 33:		Line 33:
	5. Stop Dashboard Server 7.8.3		5. Stop Dashboard Server 7.8.3

	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop
			rm ./lingoport/dashboard-server-7.8.3/data/es6
	~~Delete~~ lingoport/dashboard-server-7.8.3/data/es6 ~~folder~~


	6. Run the command		6. Run the command

	./mysql-migrator-1.2-SNAPSHOT/bin/mysql-migrator -source /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql -target /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.properties		./mysql-migrator-1.2-SNAPSHOT/bin/mysql-migrator -source /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql -target /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.properties

	7. Start Dashboard Server 7.8.3		7. Start Dashboard Server 7.8.3

	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	The password has returned to the original password.		* The password has returned to the original password.

	Check the project all exists then stop the server		* Check the project all exists then stop the server

	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop

	8. Install SonarQube 7.9 Community Edition		8. Install SonarQube 7.9 Community Edition

	~~Copy~~ lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/sonarqube-7.9.6/conf		cp ./lingoport/dashboard-server-7.8.3/conf/sonar.properties ./lingoport/sonarqube-7.9.6/conf/.
			./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh start
	~~Start SonarQube 7.9~~ ./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh start

	~~Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button~~

	Login to sonarqube and you can see all the project names but no other details		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
			* Login to sonarqube and you can see all the project names but no other details
	Stop SonarQube 7.9 ./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh stop		* Stop SonarQube 7.9
			./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh stop

	9. Install SonarQube 8.9 Community Edition		9. Install SonarQube 8.9 Community Edition

	~~Copy~~ lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/sonarqube-8.9.8.54436/conf		cp lingoport/dashboard-server-7.8.3/conf/sonar.properties ./lingoport/sonarqube-8.9.8.54436/conf/.
			./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh start
	~~Start SonarQube 8.9~~ ./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh start

	~~Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button~~

	~~Login to sonarqube and you can see all the project names but no other details~~

	Stop SonarQube 8.9 ./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh stop		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button
			* Login to sonarqube and you can see all the project names but no other details
			* Stop SonarQube 8.9
			./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh stop

	10. Start Dashboard Server 9.4.1		10. Start Dashboard Server 9.4.1

	~~Copy~~ lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/dashboard-server-9.4.1/conf		cp lingoport/dashboard-server-7.8.3/conf/sonar.properties ./lingoport/dashboard-server-9.4.1/conf
			rm -rf ./lingoport/dashboard-server-9.4.1/data/es7

	~~Delete~~ dashboard-server-9.4.1/~~data~~/~~es7~~		* Start SonarQube 9.4.1

			./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start

	~~Start SonarQube 9.4.1 .~~/~~lingoport~~/~~dashboard-server-9.4.1~~/~~bin/linux-x86-64/sonar.sh start~~		* Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button

	~~Browse to http:/~~/~~yourSonarQubeServerURL~~/~~setup and follow the setup instructions and click “Migrate database” button~~		If there are no projects showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder

	~~If there is no project showing, stop the server and delete~~ dashboard-server-9.4.1/~~data~~/~~es7 folder~~		* Start SonarQube 9.4.1
			./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start

	~~Start SonarQube 9.4.1~~ ./lingoport/dashboard-server-9.4.1/~~bin~~/~~linux-x86-64/sonar.sh start~~		* Delete the es7 folder
			rm -rf ./lingoport/dashboard-server-9.4.1/data/es7

Lji at 17:55, 10 June 2022

2022-06-10T17:55:09Z

← Older revision		Revision as of 17:55, 10 June 2022
Line 25:		Line 25:

	4. Start Dashboard Server 7.8.3		4. Start Dashboard Server 7.8.3

	cd		cd
	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

	Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)		Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)

	5. Stop Dashboard Server 7.8.3		5. Stop Dashboard Server 7.8.3

	./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop		./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop

	Delete lingoport/dashboard-server-7.8.3/data/es6 folder		Delete lingoport/dashboard-server-7.8.3/data/es6 folder

Lji: Created page with "Here are the migration steps. 1.Stop Dashboard Server 9.4.1 ./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop 2. Delete sonardb database su..."

2022-06-10T17:54:22Z

Created page with "Here are the migration steps. 1.Stop Dashboard Server 9.4.1 ./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop 2. Delete sonardb database su..."

New page

Here are the migration steps.

1.Stop Dashboard Server 9.4.1
./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh stop

2. Delete sonardb database

sudo -u postgres psql
drop database lingodash;
create database lingodash;
grant all privileges on database lingodash to lingodashuser;

3. Modify sonar.properties of Dashboard server 7.8.3
lingoport/dashboard-server-7.8.3/conf/sonar.properties
Make a copy of current mysql version sonar.properties file and name it sonar.propertiesmysql

Then modify the sonar.properties file as

sonar.jdbc.username=lingodashuser
sonar.jdbc.password=password can be found on dashboard-server-9.4.1/conf/sonar.properties
sonar.jdbc.url=jdbc:postgresql://localhost/lingodash
sonar.search.javaOpts=-Xmx1g -Xms1g -XX:+HeapDumpOnOutOfMemoryError

Also commented out duplicate sonar.jdbc.url and sonar.search.javaOpts lines in the file.

4. Start Dashboard Server 7.8.3
cd
./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start
Go to the Dashboard url and there should be no project (the login has also reverted back to ‘admin/admin’)

5. Stop Dashboard Server 7.8.3
./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop
Delete lingoport/dashboard-server-7.8.3/data/es6 folder

6. Run the command

./mysql-migrator-1.2-SNAPSHOT/bin/mysql-migrator -source /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.propertiesmysql -target /var/lib/jenkins/lingoport/dashboard-server-7.8.3/conf/sonar.properties

7. Start Dashboard Server 7.8.3

./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh start

The password has returned to the original password.

Check the project all exists then stop the server

./lingoport/dashboard-server-7.8.3/bin/linux-x86-64/sonar.sh stop

8. Install SonarQube 7.9 Community Edition

Copy lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/sonarqube-7.9.6/conf

Start SonarQube 7.9 ./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh start

Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button

Login to sonarqube and you can see all the project names but no other details

Stop SonarQube 7.9 ./lingoport/sonarqube-7.9.6/bin/linux-x86-64/sonar.sh stop

9. Install SonarQube 8.9 Community Edition

Copy lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/sonarqube-8.9.8.54436/conf

Start SonarQube 8.9 ./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh start

Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button

Login to sonarqube and you can see all the project names but no other details

Stop SonarQube 8.9 ./lingoport/sonarqube-8.9.8.54436/bin/linux-x86-64/sonar.sh stop

10. Start Dashboard Server 9.4.1

Copy lingoport/dashboard-server-7.8.3/conf/sonar.properties to lingoport/dashboard-server-9.4.1/conf

Delete dashboard-server-9.4.1/data/es7

Start SonarQube 9.4.1 ./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start

Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions and click “Migrate database” button

If there is no project showing, stop the server and delete dashboard-server-9.4.1/data/es7 folder

Start SonarQube 9.4.1 ./lingoport/dashboard-server-9.4.1/bin/linux-x86-64/sonar.sh start