Problem with the mysql database while starting Mautic with docker-compose.yml

[UtenteWeb]

Problem with the mysql database while starting Mautic with docker-compose.yml

[nickwild-999]

Yes to be clear this process should work:

1. find CONTAINER ID of percona server with docker ps
2. find IP address of container with docker inspect CONTAINER ID | grep IPAddress
3. change MAUTIC_DB_HOST in script to
   MAUTIC_DB_HOST=IPAddress:3306

[luizeof]

You need to setup the database

The compose.yml is inly a example

[sriram18981]

Hi, I am having the same issue. I tried with the plain docker version as the example version (not with docker-compose), and ended up with the same issue as this.
Could you please elaborate on what needs to be setup as the database? is the MySQL DB up and running and linked to the mautic docker is not sufficient?

Any help on this would be greatly appreciated.

[bohuspollak]

Use following setup with correct MAUTIC_DB_HOST=172.17.0.2 for your environment.
Find IP using this way:
docker ps

note CONTAINER_ID

docker inspect CONTAINER_ID | grep IP
--- docker-compose.yml --
mautic:
image: mautic/mautic:latest
links:
- mauticdb:mysql
ports:
- 8081:81
volumes:
- mautic_data:/var/www/html
environment:
- MAUTIC_DB_HOST=172.17.0.2
- MYSQL_PORT_3306_TCP=3306
- MAUTIC_DB_USER=root
- MAUTIC_DB_PASSWORD=mysecret
- MAUTIC_DB_NAME=mautic

mauticdb:
image: mysql:5.6
ports:
- 3306:3306
environment:
- MYSQL_ROOT_PASSWORD=mysecret
-- end of file --- docker-compose.yml--

[toman]

I had the same issue but finally got this docker-compose.yml file to work. https://gitlab.com/snippets/1894892 . I guess there must be a difference between how the Percona and MySQL images are built because MySQL logs showed a login failure.

[eltonjosesouza]

I had the same issue but finally got this docker-compose.yml file to work. https://gitlab.com/snippets/1894892 . I guess there must be a difference between how the Percona and MySQL images are built because MySQL logs showed a login failure.

not work for me :´(

[weisisheng]

Really at a loss. This doesn't work for me at all. Once I look up the IP, say '172.17.0.2' then set the host for it while adding the port ":3306", I get the error "Access denied for user 'root'@'172.17.0.4' (using password: Y". It's as if the system can't find the db whatsoever. TIA for any tips & tricks. I've been considering hard coding the IP for the dbase container?

[chendelin1982]

It must MAUTIC_DB_USER=root, then it running ok