I’m in the process of moving SQ from container instance to azure App service. Setting up SQ was simple; however, I can’t connect to sql server. Somehow the properties setup of version one below gets comment back out when I restart the spp service. At the top of the sonar.properties file it states the following:
Property values can:
- be overridden by environment variables. The name of the corresponding environment variable is the
upper-cased name of the property where all the dot (‘.’) and dash (‘-’) characters are replaced by
underscores (‘_’). For example, to override ‘sonar.web.systemPasscode’ use ‘SONAR_WEB_SYSTEMPASSCODE’. - be encrypted. See Security
version one:
sonar.jdbc.password
sonar.jdbc.url
sonar.jdbc.username
version two:
SONAR_JDBC_PASSWORD
SONAR_JDBC_URL
SONAR_JDBC_USERNAME
I have tried both versions and it fails to connect to the database. I found some topics on this in the community but neither provide a solid solution