The below docker compose file works but I am now needing to move it to anther server where port 3306 is being used by a MYSQL container.
version: "2"
services:
bookstack:
image: lscr.io/linuxserver/bookstack
container_name: bookstack-recipes
environment:
- PUID=1000
- PGID=1000
- APP_URL=https://mysite.com
- DB_HOST=bookstack-recipes_db
- DB_PORT=3306
- DB_USER=user
- DB_PASS=dbpwd
- DB_DATABASE=recipesapp
volumes:
- ./recipes_app_data:/config
ports:
- 6877:80
restart: unless-stopped
depends_on:
- bookstack_db
bookstack_db:
image: lscr.io/linuxserver/mariadb
container_name: bookstack_db
environment:
- PUID=1000
- PGID=1000
- MYSQL_ROOT_PASSWORD=rootpwd
- TZ=Pacific/Auckland
- MYSQL_DATABASE=recipesapp
- MYSQL_USER=user
- MYSQL_PASSWORD=dbpwd
volumes:
- ./recipes_db_data:/config
restart: unless-stopped
I tried the below but with no success.
version: "2"
services:
bookstack:
image: lscr.io/linuxserver/bookstack
container_name: bookstack-recipes
environment:
- PUID=1000
- PGID=1000
- APP_URL=https://mysite.com
- DB_HOST=bookstack-recipes_db
- DB_PORT=3307
- DB_USER=user
- DB_PASS=dbpwd
- DB_DATABASE=recipesapp
volumes:
- ./recipes_app_data:/config
ports:
- 6877:80
restart: unless-stopped
depends_on:
- bookstack_db
bookstack_db:
image: lscr.io/linuxserver/mariadb
container_name: bookstack_db
environment:
- PUID=1000
- PGID=1000
- MYSQL_ROOT_PASSWORD=rootpwd
- TZ=Pacific/Auckland
- MYSQL_DATABASE=recipesapp
- MYSQL_USER=user
- MYSQL_PASSWORD=dbpwd
volumes:
- ./recipes_db_data:/config
ports:
- 3307:3306
restart: unless-stopped
No matter what I try, mariadb listens on 3306. I also tried setting MYSQL_TCP_PORT=3307