/docker-sonarqube-mysql

sonarqube with mysql server as dock

Primary LanguageShellGNU General Public License v3.0GPL-3.0

Install

Make sure that your environment already installed docker and docker-compose

docker-sonarqube-mysql

sonarqube with mysql server with docker.

  • sonarqube server version 6.7

  • mysql server 5.7

create docker-compose.yml


vversion: '3'

services:
  mysql:
    image: mysql:5.7
    ports:
      - 3306:3306
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=sonarqube
    volumes:
      - $PWD/mysql-server/mysql-data:/var/lib/mysql
      - $PWD/mysql-server/mysqlconf:/etc/mysql/conf.d

  sonarqube:
    image: sopheamak/sonarqube-docker
    ports:
      - "9000:9000"
    volumes:
      - ./sonarqube-server/data/app/conf:/opt/sonarqube/conf
      - ./sonarqube-server/data/app/data:/opt/sonarqube/data
      - ./sonarqube-server/data/app/extensions:/opt/sonarqube/extensions
      - ./sonarqube-server/data/app/logs:/opt/sonarqube/logs
    environment:
      - SONARQUBE_JDBC_URL=jdbc:mysql://mysql:3306/sonarqube?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance
      - SONARQUBE_JDBC_USERNAME=root
      - SONARQUBE_JDBC_PASSWORD=root
      - DATABASE_PORT=3306
      - DATABASE_HOST=mysql
    links:
      - mysql:mysql

run docker-compose


docker-compose up

log container

ysql_1      | Version: '5.7.20'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
mysql_1      | 2017-11-14T10:06:20.220050Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 
mysql_1      | 2017-11-14T10:06:20.220071Z 0 [Note] Beginning of list of non-natively partitioned tables
mysql_1      | 2017-11-14T10:06:20.273341Z 0 [Note] End of list of non-natively partitioned tables
sonarqube_1  | J
sonarqube_1  | 5.7.20�*
....
se, or set useSSL=true and provide truststore for server certificate verification.
sonarqube_1  | 2017.11.14 10:07:50 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
sonarqube_1  | 2017.11.14 10:07:50 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
sonarqube_1  | 2017.11.14 10:07:53 INFO  ce[][o.s.c.q.PurgeCeActivities] Delete the Compute Engine tasks created before Thu May 18 10:07:53 UTC 2017
sonarqube_1  | 2017.11.14 10:07:53 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is operational
sonarqube_1  | 2017.11.14 10:07:54 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
sonarqube_1  | 2017.11.14 10:07:54 INFO  app[][o.s.a.SchedulerImpl] SonarQube is up

stop and remove all docker containers

docker-compose down

Run sonarqube server with H2 database

 - install sonaqube with docker and run it as below

docker pull sopheamak/my-docker-sonarqube
docker run -d --name my-docker-sonarqube -p 9000:9000 -p 9092:9092 sopheamak/my-docker-sonarqube console

go to browser :

http://localhost:9090