sonar 配置mysql 连接报错 5C

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: 远程主机强迫关闭了一个现有的连接。

3个回答

mysql 换5.7版本可以成功

sonarqube建表语句中有mysql8中的关键字,所以建表总是失败

#----- DEPRECATED 
#----- MySQL >=5.6 && <8.0
# Support of MySQL is dropped in Data Center Editions and deprecated in all other editions
# Only InnoDB storage engine is supported (not myISAM).
# Only the bundled driver is supported. It can not be changed.

配置文件里面写了说不支持8.0

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!