which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) - using soanrqube 8.4.1 version with postgres database
what are you trying to achieve - Need to to migrate sonarqube database from one server to other server.
what have you tried so far to achieve this - Gone through the sonarqube db copy tool documents in website but lack of confidence how to to achieve this.
I’m a beginner to sonarqube tool and need some guidance how to start the sonarqube migration process. We’re using sonarqube enterprise edition 8.4.1. Please guide me how to achieve this. Thanks for your help in advance!
Please someone assist on this! I have a deadline until 26/05/2021
Your version is past EOL. You should upgrade to either the latest version or the current LTS at your earliest convenience. Your upgrade path is:
8.4.1 → 8.9.8 → 9.4 (last step optional)
You may find the Upgrade Guide helpful. If you have questions about upgrading, feel free to open a new thread for that here.
Regarding your DB move, this really is external to SonarQube. I would expect that you only need to make a backup of the existing DB and restore it in the new DB. Since the SonarQube upgrade guide advises you to start by upgrading your DB, you probably want to start the whole thing with your backup & DB move.
I’m able to connect the sonarqube db which has been created locally but when i’m trying to connect remote facing the below error. Please help me to fix the below error.
C:\sonarqube>psql "sslmode=verify-full sslrootcert=BaltimoreCyberTrustRoot.crt.pem host=us6-corp-platforms-sonarqube-db-dev.postgres.database.azure.com dbname=sonaqube-devtest-db user=sonarqube@us6-corp-platforms-sonarqube-db-dev"
Password for user sonarqube@us6-corp-platforms-sonarqube-db-dev:
psql: error: connection to server at "us6-corp-platforms-sonarqube-db-dev.postgres.database.azure.com" (40.70.144.38), port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Saved in my c:drive → C:\sonarqube\BaltimoreCyberTrustRoot.crt.pem
Set the path in command prompt where cert has been saved in my local system.
Changes modified to the command accordingly: C:\sonarqube>**psql "sslmode=verify-full sslrootcert=BaltimoreCyberTrustRoot.crt.pem host=us6-corp-platforms-sonarqube-db-dev.postgres.database.azure.com dbname=sonaqube-devtest-db user=sonarqube@us6-corp-platforms-sonarqube-db-dev"**
Asked the the password: entered correctly and returned with below error.
Password for user sonarqube@us6-corp-platforms-sonarqube-db-dev:
psql: error: connection to server at "us6-corp-platforms-sonarqube-db-dev.postgres.database.azure.com" (40.70.144.38), port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.