Can not connect to database sonarqube with mysql in docker

Question

I try to install sonarqube with mysql in docker.

1. Mysql

```

$ docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root --name mysql mysql
$ docker exec -it mysql bash
# mysql -uroot -proot
mysql> CREATE DATABASE sonar CHARACTER SET utf8;
mysql> CREATE USER 'sonar'@'localhost' IDENTIFIED BY 'sonar' PASSWORD EXPIRE NEVER;
mysql> GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'localhost';
mysql> FLUSH PRIVILEGES;

```

2. SonarQube

```

$ docker run -d --name SonarQube --link mysql:mysql -p 9000:9000 -p 9092:9092 \
-e SONARQUBE_JDBC_USERNAME=sonar \
-e SONARQUBE_JDBC_PASSWORD=sonar \
-e "SONARQUBE_JDBC_URL=jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true" \
  sonarqube

```

Here is my error log. Give me a solution. Thankyou

2018.08.10 12:53:37 ERROR web[][o.s.s.p.Platform] Web server startup failed java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.'). at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:108) at org.sonar.db.DefaultDatabase.start(DefaultDatabase.java:75) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ...

Answer 1

Change host in JDBC URL environment variable to below i.e replace localhost with mysql -

-e SONARQUBE_JDBC_URL=jdbc:mysql://mysql:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true"

Reason being you created a link to container mysql with DNS name mysql which means it will put a host entry for mysql container IP in sonarqube container. You can verify it by doing a docker exec & cat /etc/hosts in sonarqube container. That's how linking works w.r.t docker in the background.

PS - Localhost means the container itself & not the mysql container.

Update

Your second issue is, you are granting privileges for @'localhost' which means access from sonarqube container will be denied, you can change it to @'%' to allow from anywhere.

Ref - MySQL root access from all hosts
Allow all remote connections, MySQL