Database connection error on Docker startup for new dev install

[SandyS1]

Steps required to reproduce the problem

1. Check out latest from master
2. Copy docker-compose.yml.dist to docker-compose.yml
3. Change line 10 to - "CFP_ENV=development"
4. Change DB password on config/development.yml.dist and config/production.yml.dist to root
5. Issue docker-compose up -d
6. Issue docker-compose -f docker-compose.yml exec app composer run setup-env

Expected Result

• Install dependencies via composer and load initial database

Actual Result

• Get
  `In AbstractMySQLDriver.php line 93:

  An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused

In PDOConnection.php line 31:

SQLSTATE[HY000] [2002] Connection refused

In PDOConnection.php line 27:

SQLSTATE[HY000] [2002] Connection refused`

I'm doing this on a new Mac with MacOS Catalina 10.15.3 with Docker version 19.03.5, build 633a0ea and docker-compose version 1.25.4, build 8d51620a

[chartjes]

I have never touched the Docker stuff (it was contributed by someone else) so it might take me a while to figure it out.

…

On Wed, Feb 12, 2020, at 10:24 PM, SandyS1 wrote: Steps required to reproduce the problem 1. Check out latest from master 2. Copy `docker-compose.yml.dist` to `docker-compose.yml` 3. Change line 10 to ` - "CFP_ENV=development"` 4. Change DB password on `config/development.yml.dist` and `config/production.yml.dist` to `root` 5. Issue `docker-compose up -d` 6. Issue `docker-compose -f docker-compose.yml exec app composer run setup-env` Expected Result * Install dependencies via composer and load initial database Actual Result * Get `In AbstractMySQLDriver.php line 93: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused In PDOConnection.php line 31: SQLSTATE[HY000] [2002] Connection refused In PDOConnection.php line 27: SQLSTATE[HY000] [2002] Connection refused` I'm doing this on a new Mac with MacOS Catalina 10.15.3 with Docker version 19.03.5, build 633a0ea and docker-compose version 1.25.4, build 8d51620a — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1244?email_source=notifications&email_token=AAAG5INMDADPWOEMWZCH7QLRCS4NDA5CNFSM4KUJD3XKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4INEJANQ>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAG5INXEBMHEKNSKLO6MJ3RCS4NDANCNFSM4KUJD3XA>.

[chartjes]

I followed the instructions in the README file and was able to:

• successfully build the docker container
• successfully execute the 'docker-compose' command as instructed

I now have a working version of the application in a docker container.

[chartjes]

Never mind, I spoke too soon. I am seeing the same error. Will dig in and fix

[toofff]

@chartjes Why did you delete the docker-compose.yml.dist file from the project in this commit knowing that the documentation still refers to it?

ping @BoutValentin

[chartjes]

Sorry about that, it was part of a cleanup I did not finish. I have re-added that file

[toofff]

Thanks!

[toofff]

@chartjes Would it be interesting for you to redo the docker for your project?
Because I am seeing some design errors on the use of docker and docker-compose in your project.

[chartjes]

@toofff I would definitely take a look at any changes like that. The docker stuff was a 3rd party contribution so I didn't delve into it too deeply

[toofff]

@chartjes Thank you to you and I understand it perfectly and I also prefer that you look in detail ;)
We will be working on this task in the coming weeks with @BoutValentin.
We will open a Pull Request probably the first half of October.