# Install SonarQube in Docker

## Steps:

### 1. Updater linux kernal varaiable

vim /etc/sysctl.conf

## add to file
vm.max_map_count=262144
fs.file-max=65536

> [reference](https://hub.docker.com/_/sonarqube)

### 2. Create Container with admin account

CREATE DATABASE sonarqube WITH OWNER={username} LC_COLLATE='en_US.utf8' LC_CTYPE='en_US.utf8' ENCODING='UTF8';

**Example:**

CREATE DATABASE sonarqube WITH OWNER=yuze LC_COLLATE='en_US.utf8' LC_CTYPE='en_US.utf8' ENCODING='UTF8';

> [Login into Postgresql Reference.](https://hackmd.io/_udiuAL9QNmdsa3deVHAVA#3-Executed-in-docker-and-login-into-PostgreSQL)

### 3. Create Docker Container

docker run --name sonarqube \
           -d \
           -p 9000:9000 \
           -e sonar.jdbc.username={username} \
           -e sonar.jdbc.password={userpassword} \
           -e sonar.jdbc.url=jdbc:postgresql://{sql host url}/sonarqube \
           -v sonarqube_conf:/opt/sonarqube/conf \
           -v sonarqube_extensions:/opt/sonarqube/extensions \
           -v sonarqube_logs:/opt/sonarqube/logs \
           -v sonarqube_data:/opt/sonarqube/data \
           --restart=always \
           sonarqube

**Example:**

docker run --name sonarqube \
           -d \
           -p 9000:9000 \
           -e sonar.jdbc.username=yuze \
           -e sonar.jdbc.password=123456 \
           -e sonar.jdbc.url=jdbc:postgresql://192.168.233.134:5432/sonarqube \
           -v sonarqube_conf:/opt/sonarqube/conf \
           -v sonarqube_extensions:/opt/sonarqube/extensions \
           -v sonarqube_logs:/opt/sonarqube/logs \
           -v sonarqube_data:/opt/sonarqube/data \
           --restart=always \
           sonarqube

###### tags: `Docker` `CI/CD`