newtmitch / docker-sonar-scanner

Quick sonar scanner docker image
MIT License
129 stars 88 forks source link

Deprecated property sonar.jdbc.url #24

Closed jennasalau closed 5 years ago

jennasalau commented 5 years ago

Hello, I'm getting the following warning when using your image

WARN: Property 'sonar.jdbc.url' is not supported any more. It will be ignored. There is no longer any DB connection to the SQ database.
newtmitch commented 5 years ago

I'm running the latest version of the image and I don't see that warning after running through a project containing mostly Javascript and Python. What version of the scanner image are you using, and on what type of project? Have you used this on other project with different core languages and seen the same thing?

jennasalau commented 5 years ago

Hey Ryan,

I'm executing it in the following way using docker run:

echo "Publishing Sonar Scanner with host ${SONAR_HOST_URL}"
docker run --rm -v $(pwd):/root/src newtmitch/sonar-scanner \
  sonar-scanner -Dsonar.projectBaseDir=./src -Dsonar.host.url=${SONAR_HOST_URL} -Dsonar.projectVersion=${VERSION} -Dsonar.branch.name=${BRANCH}

My SonarQube version is: Version 6.7 (build 33306)

Here are my CI/CD logs with the above mentioned warning. (Note i've hidden private information with hashes ####)

build   13-May-2019 12:45:51    INFO: Scanner configuration file: /root/sonar-scanner/conf/sonar-scanner.properties
build   13-May-2019 12:45:51    INFO: Project root configuration file: /root/src/sonar-project.properties
build   13-May-2019 12:45:51    INFO: SonarQube Scanner 3.2.0.1227
build   13-May-2019 12:45:51    INFO: Java 1.8.0_121 Oracle Corporation (64-bit)
build   13-May-2019 12:45:51    INFO: Linux 3.10.0-862.el7.x86_64 amd64
build   13-May-2019 12:45:52    INFO: User cache: /root/.sonar/cache
build   13-May-2019 12:45:53    INFO: SonarQube server 6.7.0
build   13-May-2019 12:45:53    INFO: Default locale: "en", source code encoding: "UTF-8"
build   13-May-2019 12:45:54    INFO: Publish mode
build   13-May-2019 12:45:54    INFO: Load global settings
build   13-May-2019 12:45:54    INFO: Load global settings (done) | time=124ms
build   13-May-2019 12:45:54    INFO: Server id: AWBYTHPyUINTwHLx3AJI
error   13-May-2019 12:45:54    WARN: Property 'sonar.jdbc.url' is not supported any more. It will be ignored. There is no longer any DB connection to the SQ database.
build   13-May-2019 12:45:54    INFO: User cache: /root/.sonar/cache
build   13-May-2019 12:45:54    INFO: Load plugins index
build   13-May-2019 12:45:54    INFO: Load plugins index (done) | time=74ms
build   13-May-2019 12:45:54    INFO: Download sonar-flex-plugin-2.3.jar
build   13-May-2019 12:45:54    INFO: Download sonar-ldap-plugin-2.2.0.608.jar
build   13-May-2019 12:45:54    INFO: Download sonar-csharp-plugin-6.5.0.3766.jar
build   13-May-2019 12:45:55    INFO: Download sonar-javascript-plugin-3.2.0.5506.jar
build   13-May-2019 12:45:55    INFO: Download sonar-java-plugin-4.15.0.12310.jar
build   13-May-2019 12:45:55    INFO: Download sonar-php-plugin-2.11.0.2485.jar
build   13-May-2019 12:45:55    INFO: Download sonar-python-plugin-1.8.0.1496.jar
build   13-May-2019 12:45:55    INFO: Download sonar-scm-git-plugin-1.3.0.869.jar
build   13-May-2019 12:45:56    INFO: Download sonar-scm-svn-plugin-1.6.0.860.jar
build   13-May-2019 12:45:56    INFO: Download sonar-typescript-plugin-1.1.0.1079.jar
build   13-May-2019 12:45:56    INFO: Download sonar-xml-plugin-1.4.3.1027.jar
build   13-May-2019 12:45:58    INFO: Process project properties
build   13-May-2019 12:45:58    INFO: Load project repositories
build   13-May-2019 12:45:58    INFO: Load project repositories (done) | time=186ms
build   13-May-2019 12:45:58    INFO: Load quality profiles
build   13-May-2019 12:45:58    INFO: Load quality profiles (done) | time=46ms
build   13-May-2019 12:45:58    INFO: Load active rules
build   13-May-2019 12:45:59    INFO: Load active rules (done) | time=632ms
build   13-May-2019 12:45:59    INFO: Load metrics repository
build   13-May-2019 12:45:59    INFO: Load metrics repository (done) | time=42ms
build   13-May-2019 12:45:59    INFO: Project key: ##############
build   13-May-2019 12:45:59    INFO: -------------  Scan Policy Portal SPA
build   13-May-2019 12:45:59    INFO: Load server rules
build   13-May-2019 12:45:59    INFO: Load server rules (done) | time=72ms
build   13-May-2019 12:45:59    INFO: Base dir: /root/src
build   13-May-2019 12:45:59    INFO: Working dir: /root/src/.scannerwork
build   13-May-2019 12:45:59    INFO: Source paths: src
build   13-May-2019 12:45:59    INFO: Source encoding: UTF-8, default locale: en
build   13-May-2019 12:46:00    INFO: Index files
build   13-May-2019 12:46:00    INFO: Excluded sources: 
build   13-May-2019 12:46:00    INFO:   **/node_modules/**/*
build   13-May-2019 12:46:00    INFO: 406 files indexed
build   13-May-2019 12:46:00    INFO: 0 files ignored because of inclusion/exclusion patterns
build   13-May-2019 12:46:00    INFO: Quality profile for js: Sonar way
build   13-May-2019 12:46:01    INFO: Sensor SonarJavaXmlFileSensor [java]
build   13-May-2019 12:46:01    INFO: Sensor SonarJavaXmlFileSensor [java] (done) | time=8ms
build   13-May-2019 12:46:01    INFO: Sensor Analyzer for "php.ini" files [php]
build   13-May-2019 12:46:01    INFO: Sensor Analyzer for "php.ini" files [php] (done) | time=14ms
build   13-May-2019 12:46:01    INFO: Sensor JavaScript Squid Sensor [javascript]
build   13-May-2019 12:46:02    INFO: 385 source files to be analyzed
build   13-May-2019 12:46:12    INFO: 245/385 files analyzed, current file: #########
build   13-May-2019 12:46:16    INFO: Test Coverage Sensor is started
build   13-May-2019 12:46:16    INFO: Analysing [/root/src/lcov.info]
build   13-May-2019 12:46:16    INFO: 385/385 source files have been analyzed
build   13-May-2019 12:46:16    INFO: Sensor JavaScript Squid Sensor [javascript] (done) | time=14556ms
build   13-May-2019 12:46:16    INFO: Sensor Zero Coverage Sensor
build   13-May-2019 12:46:16    INFO: Sensor Zero Coverage Sensor (done) | time=309ms
build   13-May-2019 12:46:16    INFO: Sensor CPD Block Indexer
build   13-May-2019 12:46:16    INFO: Sensor CPD Block Indexer (done) | time=0ms
build   13-May-2019 12:46:16    INFO: SCM provider for this project is: git
build   13-May-2019 12:46:16    INFO: 1 files to be analyzed
build   13-May-2019 12:46:17    INFO: 1/1 files analyzed
build   13-May-2019 12:46:17    INFO: 84 files had no CPD blocks
build   13-May-2019 12:46:17    INFO: Calculating CPD for 301 files
build   13-May-2019 12:46:17    INFO: CPD calculation finished
build   13-May-2019 12:46:18    INFO: Analysis report generated in 846ms, dir size=2 MB
build   13-May-2019 12:46:19    INFO: Analysis reports compressed in 803ms, zip size=1 MB
build   13-May-2019 12:46:19    INFO: Analysis report uploaded in 224ms
build   13-May-2019 12:46:19    INFO: ANALYSIS SUCCESSFUL, you can browse #########
build   13-May-2019 12:46:19    INFO: Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report
build   13-May-2019 12:46:19    INFO: More about the report processing at ######
build   13-May-2019 12:46:20    INFO: Task total time: 23.020 s
build   13-May-2019 12:46:20    INFO: ------------------------------------------------------------------------
build   13-May-2019 12:46:20    INFO: EXECUTION SUCCESS
build   13-May-2019 12:46:20    INFO: ------------------------------------------------------------------------
build   13-May-2019 12:46:20    INFO: Total time: 28.614s
build   13-May-2019 12:46:20    INFO: Final Memory: 22M/703M
build   13-May-2019 12:46:20    INFO: ------------------------------------------------------------------------

Note this doesn't block anything. Just thought i would mention it. I don't mind if you want to leave as is and close this issue.

newtmitch commented 5 years ago

I've been running this across all versions of Sonar Scanner and I confirmed that I haven't seen this warning at all. Running one right now and it's not showing up.

My guess is that's a) environmental and/or b) associated with the fact that you're running an older version of SonarQube, which is different than what I'm running when I'm testing (I'm testing against the latest SonarQube image, which at the time of writing is 7.7 (build 23042).

Can you test against a later version of SonarQube to see if the warning goes away when you do?

jennasalau commented 5 years ago

Hey Ryan, thanks for looking into this.

I'll put in a request for us to update our SonarQube, we should do it anyway.

newtmitch commented 5 years ago

Thanks for circling back, @jennasalau