opened
Zyqsempai
username_0
After fixing this one https://github.com/google/keytransparency/issues/1182 I am getting thi error.
```
 Could not create Env: env: failed to open database: error running statement "CREATE DATABASE trl_1549349836763157901": Error 1045: Access denied for user 'root'@'172.21.0.1' (using password: NO)
```
It's an error from trillian testdb.go and it's supper confusing for me, the first `sql.Open` request is made outside on `127.0.0.1:3306` but in next step `db.ExecContext()` makes it on `172.21.0.1`

So the question is for what purpose do we have docker-compose mysql, if tests are not interacting with it?
Even though, it should work, port is exposed, we have `MYSQL_RANDOM_ROOT_PASSWORD: "yes"`.
Integration tests are not working with docker-compose mysql
issue
created
gdbelvin
username_1
I got these errors too and it wasn't clear to me what the root case was. 
It was able to fix it by starting the `db` container first like so:
```sh
docker-compose down # stop all existing containers
docker-compose up -d db # start just the db container and make sure it comes online ok.
docker-compose up # start everything else
```

In the process of investigating, I also realized we were handling SSL keys the wrong way which I fixed in #11191

@username_0 could you verify whether these changes fix this issue?
comment
created
gdbelvin
username_1
On further investigation, I can confirm that this is an issue. The integration tests, do expect the root mysql user to have an empty password which the `MYSQL_RANDOM_ROOT_PASSWORD: yes` obviously breaks.  This is something I'll discuss with the team.
comment
created
gdbelvin
username_1
Fixed by #1198
comment
closed
gdbelvin
username_1
issue