Docker Community Forums

Share and learn in the Docker community.

Beginners question about MariaDB, phpipam and docker compose

  • Issue type: Unable to login to MariaDB

  • OS Version/: Linux phpipam 4.19.0-14-amd64 #1 SMP Debian 4.19.171-2 (2021-01-30) x86_64 GNU/Linux

  • App version: v1.4 Stable
    Docker version
    Client: Docker Engine - Community
    Version: 20.10.3
    API version: 1.41
    Go version: go1.13.15
    Git commit: 48d30b5
    Built: Fri Jan 29 14:33:25 2021
    OS/Arch: linux/amd64
    Context: default
    Experimental: true

I try to use: docker-compose.yml for " Docker Standalone" (www container + cron container + db container) from: Docker Hub

After starting continers and choosing automatic installation of DB i always got:

Could not connect to database! SQLSTATE[HY000] [1045] Access denied for user ‘phpipam’@‘172.27.0.3’ (using password: YES)

I’ve replaced passwords as requested .
Docker is in latest version and running on latest version of Debian 10.

Can you share the compose file?

Here it is:

# WARNING: Replace the example passwords with secure secrets.
# WARNING: 'my_secret_phpipam_pass' and 'my_secret_mysql_root_pass'

version: '3'

services:
  phpipam-web:
    image: phpipam/phpipam-www:latest
    ports:
      - "80:80"
    environment:
      - TZ=Europe/Warsaw
      - IPAM_DATABASE_HOST=phpipam-mariadb
      - IPAM_DATABASE_PASS=phpipam
      - IPAM_DATABASE_WEBHOST=%
    restart: unless-stopped
    volumes:
      - phpipam-logo:/phpipam/css/images/logo
    depends_on:
      - phpipam-mariadb

  phpipam-cron:
    image: phpipam/phpipam-cron:latest
    environment:
      - TZ=Europe/Warsaw
      - IPAM_DATABASE_HOST=phpipam-mariadb
      - IPAM_DATABASE_PASS=phpipam
      - SCAN_INTERVAL=1h
    restart: unless-stopped
    depends_on:
      - phpipam-mariadb

  phpipam-mariadb:
    image: mariadb:latest
    environment:
      - MYSQL_ROOT_PASSWORD=phpipam
    restart: unless-stopped
    volumes:
      - phpipam-db-data:/var/lib/mysql

volumes:
  phpipam-db-data:
  phpipam-logo:

And docker containers:
sudo docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
57871dee2c20 phpipam/phpipam-cron:latest “/sbin/tini – /bin/…” 10 hours ago Up 10 hours 80/tcp phpipam_phpipam-cron_1
a6c218095284 phpipam/phpipam-www:latest “/sbin/tini – /bin/…” 10 hours ago Up 10 hours 0.0.0.0:80->80/tcp phpipam_phpipam-web_1
435c4dad94bc mariadb:latest “docker-entrypoint.s…” 10 hours ago Up 10 hours 3306/tcp phpipam_phpipam-mariadb_1

After deleting all docker volumes created by those containers and recreating containers instalation went fine.