sonarqube用Oracle,kubernetes实践之三十： SonarQube和SonarQube Runner

小鱼儿 2022-10-21 01:14 205阅读 0赞

\# 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 embeddedH2database is used bydefault.It is recommended for tests but not for

\# production use.Supported databases are MySQL,Oracle,PostgreSQL and Microsoft SQLServer.

\# - Changes to database connectionURL (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=root

sonar.jdbc.password=password

\#----- Embedded Database(default)

\#H2embedded database server listening port,defaults to 9092

\#sonar.embeddedDatabase.port=9092

\#----- MySQL 5.6 or greater

\# Only InnoDB storage engine is supported(not myISAM).

\# Only the bundled driver is supported.It can not be changed.

sonar.jdbc.url=jdbc:mysql://112.74.53.213: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 thethinclient 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

\#----- PostgreSQL 8.x or greater

\# If you don't use the schema named "public", please refer to

\#sonar.jdbc.url=jdbc:postgresql://localhost/sonar

\#----- Microsoft SQLServer 2014/2016 and SQL Azure

\# A database named sonar must exist and its collation must be case-sensitive (CS) and accent-sensitive (AS)

\# Use the following connection string if you want to use integrated security with Microsoft Sql Server

\# Do not set sonar.jdbc.username or sonar.jdbc.password property if you are using Integrated Security

\# For Integrated Security to work, you have to download the Microsoft SQL JDBC driver package from

\# and copy sqljdbc\_auth.dll to your path. You have to copy the 32 bit or 64 bit version of the dll

\# depending upon the architecture of your server machine.

\#sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar;integratedSecurity=true

\# Use the following connection string if you want to use SQL Auth while connecting to MS Sql Server.

\# Set the sonar.jdbc.username and sonar.jdbc.password appropriately.

\#sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar

\#----- Connection pool settings

\# The maximum number of active connections that can be allocated

\# at the same time, or negative for no limit.

\# The recommended value is 1.2 \* max sizes of HTTP pools. For example if HTTP ports are

\# enabled with default sizes (50, see property sonar.web.http.maxThreads)

\# then sonar.jdbc.maxActive should be 1.2 \* 50 = 60.

\#sonar.jdbc.maxActive=60

\# The maximum number of connections that can remain idle in the

\# pool, without extra ones being released, or negative for no limit.

\#sonar.jdbc.maxIdle=5

\# The minimum number of connections that can remain idle in the pool,

\# without extra ones being created, or zero to create none.

\#sonar.jdbc.minIdle=2

\# The maximum number of milliseconds that the pool will wait (when there

\# are no available connections) for a connection to be returned before

\# throwing an exception, or <= 0 to wait indefinitely.

\#sonar.jdbc.maxWait=5000

\#sonar.jdbc.minEvictableIdleTimeMillis=600000

\#sonar.jdbc.timeBetweenEvictionRunsMillis=30000

\#--------------------------------------------------------------------------------------------------

\# WEB SERVER

\# Web server is executed in a dedicated Java process. By default heap size is 512Mb.

\# Use the following property to customize JVM options.

\# Recommendations:

\# The HotSpot Server VM is recommended. The property -server should be added if server mode

\# is not enabled by default on your environment:

\# Startup can be long if entropy source is short of entropy. Adding

\# -Djava.security.egd=file:/dev/./urandom is an option to resolve the problem.

\# See

sonar.web.javaOpts=-Xmx512m -Xms512m -XX:+HeapDumpOnOutOfMemoryError

\# Same as previous property, but allows to not repeat all other settings like -Xmx

\#sonar.web.javaAdditionalOpts=

\# Binding IP address. For servers with more than one IP address, this property specifies which

\# address will be used for listening on the specified ports.

\# By default, ports will be used on all IP addresses associated with the server.

sonar.web.host=0.0.0.0

\# Web context. When set, it must start with forward slash (for example /sonarqube).

\# The default value is root context (empty value).

\#sonar.web.context=

\# TCP port for incoming HTTP connections. Default value is 9000.

sonar.web.port=9000

\# The maximum number of connections that the server will accept and process at any given time.

\# When this number has been reached, the server will not accept any more connections until

\# the number of connections falls below this value. The operating system may still accept connections

\# based on the sonar.web.connections.acceptCount property. The default value is 50.

\#sonar.web.http.maxThreads=50

\# The minimum number of threads always kept running. The default value is 5.

\#sonar.web.http.minThreads=5

\# The maximum queue length for incoming connection requests when all possible request processing

\# threads are in use. Any requests received when the queue is full will be refused.

\# The default value is 25.

\#sonar.web.http.acceptCount=25

\# By default users are logged out and sessions closed when server is restarted.

\# If you prefer keeping user sessions open, a secret should be defined. Value is

\# HS256 key encoded with base64. It must be unique for each installation of SonarQube.

\# Example of command-line:

\# echo -n "type\_what\_you\_want" | openssl dgst -sha256 -hmac "key" -binary | base64

\#sonar.auth.jwtBase64Hs256Secret=

\# The inactivity timeout duration of user sessions, in minutes. After the configured

\# period of time, the user is logged out.

\# The default value is set to 3 days (4320 minutes)

\# and cannot be greater than 3 months. Value must be strictly positive.

\#sonar.web.sessionTimeoutInMinutes=4320

\# A passcode can be defined to access some web services from monitoring

\# tools without having to use the credentials of a system administrator.

\# Check the Web API documentation to know which web services are supporting this authentication mode.

\# The passcode should be provided in HTTP requests with the header "X-Sonar-Passcode".

\# By default feature is disabled.

\#sonar.web.systemPasscode=

\#--------------------------------------------------------------------------------------------------

\# SSO AUTHENTICATION

\# Enable authentication using HTTP headers

\#sonar.web.sso.enable=false

\# Name of the header to get the user login.

\# Only alphanumeric, '.' and '@' characters are allowed

\#sonar.web.sso.loginHeader=X-Forwarded-Login

\# Name of the header to get the user name

\#sonar.web.sso.nameHeader=X-Forwarded-Name

\# Name of the header to get the user email (optional)

\#sonar.web.sso.emailHeader=X-Forwarded-Email

\# Name of the header to get the list of user groups, separated by comma (optional).

\# If the sonar.sso.groupsHeader is set, the user will belong to those groups if groups exist in SonarQube.

\# If none of the provided groups exists in SonarQube, the user will only belong to the default group.

\# Note that the default group will always be set.

\#sonar.web.sso.groupsHeader=X-Forwarded-Groups

\# Interval used to know when to refresh name, email and groups.

\# During this interval, if for instance the name of the user is changed in the header, it will only be updated after X minutes.

\#sonar.web.sso.refreshIntervalInMinutes=5

\#--------------------------------------------------------------------------------------------------

\# COMPUTE ENGINE

\# The Compute Engine is responsible for processing background tasks.

\# Compute Engine is executed in a dedicated Java process. Default heap size is 512Mb.

\# Use the following property to customize JVM options.

\# Recommendations:

\# The HotSpot Server VM is recommended. The property -server should be added if server mode

\# is not enabled by default on your environment:

\#sonar.ce.javaOpts=-Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError

\# Same as previous property, but allows to not repeat all other settings like -Xmx

\#sonar.ce.javaAdditionalOpts=

\#--------------------------------------------------------------------------------------------------

\# ELASTICSEARCH

\# Elasticsearch is used to facilitate fast and accurate information retrieval.

\# It is executed in a dedicated Java process. Default heap size is 512Mb.

\# --------------------------------------------------

\# Word of caution for Linux users on 64bits systems

\# --------------------------------------------------

\# Please ensure Virtual Memory on your system is correctly configured for Elasticsearch to run properly

\# (see for details).

\# When SonarQube runs standalone, a warning such as the following may appear in logs/es.log:

\# "max virtual memory areas vm.max\_map\_count \[65530\] is too low, increase to at least \[262144\]"

\# When SonarQube runs as a cluster, however, Elasticsearch will refuse to start.

\# JVM options of Elasticsearch process

\#sonar.search.javaOpts=-Xms512m \\

\# -Xmx512m \\

\# -XX:+HeapDumpOnOutOfMemoryError

\# Same as previous property, but allows to not repeat all other settings like -Xmx

\#sonar.search.javaAdditionalOpts=

\# Elasticsearch port. Default is 9001. Use 0 to get a free port.

\# As a security precaution, should be blocked by a firewall and not exposed to the Internet.

\#sonar.search.port=9001

\# Elasticsearch host. The search server will bind this address and the search client will connect to it.

\# Default is loopback address.

\# As a security precaution, should NOT be set to a publicly available address.

\#sonar.search.host=

\#--------------------------------------------------------------------------------------------------

\# UPDATE CENTER

\# Update Center requires an internet connection to request

\# It is enabled by default.

\#sonar.updatecenter.activate=true

\# HTTP proxy (default none)

\#http.proxyHost=

\#http.proxyPort=

\# HTTPS proxy (defaults are values of http.proxyHost and http.proxyPort)

\#https.proxyHost=

\#https.proxyPort=

\# NT domain name if NTLM proxy is used

\#http.auth.ntlm.domain=

\# SOCKS proxy (default none)

\#socksProxyHost=

\#socksProxyPort=

\# Proxy authentication (used for HTTP, HTTPS and SOCKS proxies)

\#http.proxyUser=

\#http.proxyPassword=

\#--------------------------------------------------------------------------------------------------

\# LOGGING

\# SonarQube produces logs in 4 logs files located in the same directory (see property sonar.path.logs below),

\# one per process:

\# Main process (aka. App) logs in sonar.log

\# Web Server (aka. Web) logs in web.log

\# Compute Engine (aka. CE) logs in ce.log

\# Elasticsearch (aka. ES) logs in es.log

\# All 4 files follow the same rolling policy (see sonar.log.rollingPolicy and sonar.log.maxFiles) but it applies

\# individually (eg. if sonar.log.maxFiles=4, there can be at most 4 of each files, ie. 16 files in total).

\# All 4 files have logs in the same format:

\# 1 2 3 4 5 6

\# |-----------------| |---| |-|--------------------||------------------------------| |------------------------------------------------------------------------------------------------------------------------------|

\# 1: timestamp. Format is YYYY.MM.DD HH:MM:SS

\# YYYY: year on 4 digits

\# MM: month on 2 digits

\# DD: day on 2 digits

\# HH: hour of day on 2 digits in 24 hours format

\# MM: minutes on 2 digits

\# SS: seconds on 2 digits

\# 2: log level.

\# Possible values (in order of descending criticality): ERROR, WARN, INFO, DEBUG and TRACE

\# 3: process identifier. Possible values: app (main), web (Web Server), ce (Compute Engine) and es (Elasticsearch)

\# 4: SQ thread identifier. Can be empty.

\# In the Web Server, if present, it will be the HTTP request ID.

\# In the Compute Engine, if present, it will be the task ID.

\# 5: logger name. Usually a class canonical name.

\# Package names are truncated to keep the whole field to 20 characters max

\# 6: log payload. Content of this field does not follow any specific format, can vary in length and include line returns.

\# Some logs, however, will follow the convention to provide data in payload in the format " | key=value"

\# Especially, log of profiled pieces of code will end with " | time=XXXXms".

\# Global level of logs (applies to all 4 processes).

\# Supported values are INFO (default), DEBUG and TRACE

\#sonar.log.level=INFO

\# Level of logs of each process can be controlled individually with their respective properties.

\# When specified, they overwrite the level defined at global level.

\# Supported values are INFO, DEBUG and TRACE

\#sonar.log.level.app=INFO

\#sonar.log.level.web=INFO

\#sonar.log.level.ce=INFO

\#sonar.log.level.es=INFO

\# Path to log files. Can be absolute or relative to installation directory.

\# Default is /logs

\#sonar.path.logs=logs

\# Rolling policy of log files

\# - based on time if value starts with "time:", for example by day ("time:yyyy-MM-dd")

\# or by month ("time:yyyy-MM")

\# - based on size if value starts with "size:", for example "size:10MB"

\# - disabled if value is "none". That needs logs to be managed by an external system like logrotate.

\#sonar.log.rollingPolicy=time:yyyy-MM-dd

\# Maximum number of files to keep if a rolling policy is enabled.

\# - maximum value is 20 on size rolling policy

\# - unlimited on time rolling policy. Set to zero to disable old file purging.

\#sonar.log.maxFiles=7

\# Access log is the list of all the HTTP requests received by server. If enabled, it is stored

\# in the file \{sonar.path.logs\}/access.log. This file follows the same rolling policy as other log file

\# (see sonar.log.rollingPolicy and sonar.log.maxFiles).

\#sonar.web.accessLogs.enable=true

\# Format of access log. It is ignored if sonar.web.accessLogs.enable=false. Possible values are:

\# - "common" is the Common Log Format, shortcut to: %h %l %u %user %date "%r" %s %b

\# - "combined" is another format widely recognized, shortcut to: %h %l %u \[%t\] "%r" %s %b "%i\{Referer\}" "%i\{User-Agent\}"

\# - else a custom pattern. See

\# The login of authenticated user is not implemented with "%u" but with "%reqAttribute\{LOGIN\}" (since version 6.1).

\# The value displayed for anonymous users is "-".

\# The SonarQube'sHTTP request ID can be added to the pattern with"%reqAttribute\{ID\}" (since version 6.2).

\# If SonarQube isbehind areverse proxy,then the following value allows todisplaythe correct remote IPaddress:

\#sonar.web.accessLogs.pattern=%i\{X-Forwarded-For\}%l %u\[%t\]"%r"%s%b "%i\{Referer\}" "%i\{User-Agent\}" "%reqAttribute\{ID\}"

\#Defaultvalue(which was"combined"before version 6.2)is equivalent to"combined + SQ HTTP request ID":

\#sonar.web.accessLogs.pattern=%h %l %u\[%t\]"%r"%s%b "%i\{Referer\}" "%i\{User-Agent\}" "%reqAttribute\{ID\}"

\#--------------------------------------------------------------------------------------------------

\# OTHERS

\# Delay in seconds between processing of notification queue. Defaultis 60 seconds.

\#sonar.notifications.delay=60

\# Paths to persistent data files(embedded database and search index)and temporary files.

\# Can beabsoluteorrelativeto installation directory.

\# Defaults are respectively/data and/temp

\#sonar.path.data=data

\#sonar.path.temp=temp

\# Telemetry - Share anonymous SonarQube statistics

\# By sharing anonymous SonarQube statistics,youhelpus understand how SonarQube is used so we can improve the product to work even better for you.

\# We don't collect source code or IP addresses. And we don't share the data with anyone else.

\# To see an example of the data shared:login asaglobal administrator,call the WS api/system/info and check the Statistics field.

\#sonar.telemetry.enable=true

\#--------------------------------------------------------------------------------------------------

\# DEVELOPMENT - only for developers

\# The following properties MUST NOT be used in production environments.

\# Elasticsearch HTTP connector

\#sonar.search.httpPort=-1

sonarqube用Oracle,kubernetes实践之三十： SonarQube和SonarQube Runner

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 SonarQube介绍

相关 sonarqube用Oracle,kubernetes实践之三十： SonarQube和SonarQube Runner

相关 Gradle集成sonarqube

相关 jenkins+SonarQube

相关 SonarQube学习系列2：Maven+SonarQube 最佳实践

相关 Centos 安装 SonarQube

相关 maven使用sonarqube

相关 sonarqube安装

相关 SonarQube使用介绍

相关 SonarQube_安装