#建库
CREATE DATABASE sonar CHARACTER SET utf8 COLLATE utf8_general_ci;
#创建用户
CREATE USER 'sonar' IDENTIFIED BY 'password';
#授权
GRANT ALL ON sonar.* TO 'sonar'@"%" identified by "password";
GRANT ALL ON sonar.* TO 'sonar'@'localhost' IDENTIFIED BY 'password';
#刷新权限
FLUSH PRIVILEGES;
# Property values can:
# - reference an environment variable, for example sonar.jdbc.url= ${env:SONAR_JDBC_URL}
# - be encrypted. See https://redirect.sonarsource.com/doc/settings-encryption.html
#--------------------------------------------------------------------------------------------------
# DATABASE
#
# IMPORTANT:
# - The embedded H2 database is used by default. It is recommended for tests but not for
# production use. Supported databases are MySQL, Oracle, PostgreSQL and Microsoft SQLServer.
# - Changes to database connection URL (sonar.jdbc.url) can affect SonarSource licensed products.
# User credentials.
# Permissions to create tables, indices and triggers must be granted to JDBC user.
# The schema must be created first.
sonar.jdbc.username=数据库用户名sonar
sonar.jdbc.password=数据库sonar的密码
#----- Embedded Database (default)
# H2 embedded database server listening port, defaults to 9092
#sonar.embeddedDatabase.port=9092
#----- 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.
#jdbc连接串
sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
#----- Oracle 11g/12c
# The Oracle JDBC driver must be copied into the directory extensions/jdbc-driver/oracle/.
# Only the thin client is supported, and only the versions 11.2.x or 12.2.x must be used. See
# https://jira.sonarsource.com/browse/SONAR-9758 for more details.
# If you need to set the schema, please refer to http://jira.sonarsource.com/browse/SONAR-5000
#sonar.jdbc.url=jdbc:oracle:thin:@localhost:1521/XE
#-----连接池设置（可以分配的活动连接的最大数目）
#不限制可能会有负面影响。
#建议值为HTTP池的最大值的1.2倍。例如，如果HTTP端口是
#启用默认大小（50，请参阅属性sonar.web.http.maxThreads）
#那么sonar.jdbc.maxActive应该是1.2*50=60。
sonar.jdbc.maxActive=60
#数据库连接池最大空闲连接数
sonar.jdbc.maxIdle=5
#数据库最小连接数，0为不创建空闲线程
sonar.jdbc.minIdle=2
#连接池最大等待毫秒数（当前无可用连接，等至线程抛出异常）
#小于0表示无限期等待
sonar.jdbc.maxWait=5000
sonar.jdbc.minEvictableIdleTimeMillis=600000
sonar.jdbc.timeBetweenEvictionRunsMillis=30000
#Web Server网站的相关配置--------------------------------
#网站于JAVA环境运行，该项配置java启动的环境变量，内存cpu占用等，不建议修改
#sonar.web.javaOpts=-Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError
#网站bind地址，默认为0.0.0.0，建议设为内网地址
sonar.web.host=本机内网地址
#网站监听HTTP请求的TCP端口。默认9000
sonar.web.port=9000
