Piwigo docker-compose

---
version: "2.1"
services:
  piwigo:
    image: lscr.io/linuxserver/piwigo
    container_name: piwigo
    hostname: piwigo
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Africa/Johannesburg
    labels:
      com.centurylinklabs.watchtower.enable: true
    volumes:
      - piwigoappdata:/config
      - piwigogallery:/gallery
    # Uncomment ports if using IP:port addressing - https://www.youtube.com/watch?v=DZRG2sezIl4
    #ports:
    #  - 8090:80
    networks:
      - mysql-net
    restart: unless-stopped

volumes:
  piwigoappdata:
    name: piwigoappdata
  piwigogallery:
    name: piwigogallery

networks:
  mysql-net:
    # Joins existing network of this name - https://www.youtube.com/watch?v=NdwB5TPXCnQ
    external: true
    # Specify name so that it does not append stack name
    name: mysql-net

This docker-compose.yaml was used to spin up a Stack in Portainer for my Piwigo hosting on a VPS server. Note though you MUST have first created an empty database before you start up Piwigo, as you need to specify the database connection details on Piwigo's first run.

If you're using a shared container database like I have, where I had called that container db, then the host name you'd type into Piwigo will just be db (no IP address or port number).  I used phpMyAdmin to create an empty database in my db shared container, and called it piwigo. Make a note too of the database username and user password that has access to the piwigo database you created, as those details must also be typed in on Piwigo's first run.