#建庫
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
