sonar 配置mysql 连接报错

Question

sonar 版本 6.7
mysql 版本 8.0
配置：sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
sonar.jdbc.username=easy
sonar.jdbc.password=nolove
错误信息：11:30:57.509 [WrapperSimpleAppMain] WARN org.sonar.application.config.JdbcSettings - JDBC URL is recommended to have the property 'useConfigs=maxPerformance'
2018.09.04 11:30:57 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory F:\service\sonarqube-6.7.4\temp
2018.09.04 11:30:57 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001
2018.09.04 11:30:57 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [F:\service\sonarqube-6.7.4\elasticsearch]: F:\service\jdk1.8\jre\bin\java -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+AlwaysPreTouch -server -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -Djdk.io.permissionsUseCanonicalPath=true -Dio.netty.noUnsafe=true -Dio.netty.noKeySetOptimization=true -Dio.netty.recycler.maxCapacityPerThread=0 -Dlog4j.shutdownHookEnabled=false -Dlog4j2.disable.jmx=true -Dlog4j.skipJansi=true -Xms512m -Xmx512m -XX:+HeapDumpOnOutOfMemoryError -Delasticsearch -Des.path.home=F:\service\sonarqube-6.7.4\elasticsearch -cp lib/* org.elasticsearch.bootstrap.Elasticsearch -Epath.conf=F:\service\sonarqube-6.7.4\temp\conf\es
2018.09.04 11:30:57 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] no modules loaded
2018.09.04 11:30:57 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2018.09.04 11:31:05 INFO app[][o.s.a.SchedulerImpl] Process[es] is up
2018.09.04 11:31:05 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='web', ipcIndex=2, logFilenamePrefix=web]] from [F:\service\sonarqube-6.7.4]: F:\service\jdk1.8\jre\bin\java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=F:\service\sonarqube-6.7.4\temp -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -cp ./lib/common/*;./lib/server/*;F:\service\sonarqube-6.7.4\lib\jdbc\mysql\mysql-connector-java-5.1.42.jar org.sonar.server.app.WebServer F:\service\sonarqube-6.7.4\temp\sq-process1179029085093446759properties
Tue Sep 04 11:31:08 AWST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [web] is stopped
2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped
2018.09.04 11:31:09 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped
2018.09.04 11:31:09 WARN app[][o.e.t.n.Netty4Transport] exception caught on transport layer [[id: 0xadc1a015, L:/127.0.0.1:53287 - R:/127.0.0.1:9001]], closing connection
java.io.IOException: 远程主机强迫关闭了一个现有的连接。

Answer 1

mysql 换5.7版本可以成功