Couldn't get it working initially... working in the end

[bouwew]

I was trying to follow this method: https://deepwiki.com/edv/docker-spotweb/2.1-quick-start-with-docker-compose on a Debian 13 VM in Proxmox.

The VM was set up as described here https://community-scripts.github.io/ProxmoxVE/scripts?id=debian-13-vm
and here community-scripts/ProxmoxVE#836 using:

• Expand VM Disk using parted (/dev/sda1)
• Add Guest Agent
• Install Docker
• Added 2025-02-25 - Debian Cloud Networking

But in the end it didn't work, some strange error in mysql.

After many tries I ended making it work with this docker-compose.yml content:

name: spotweb-postgres

services:
  spotweb:
    image: erikdevries/spotweb
    environment:
      TZ: Europe/Amsterdam
      DB_ENGINE: pdo_pgsql
      DB_HOST: 172.18.0.2
      DB_PORT: 5432
      DB_NAME: spotweb
      DB_USER: spotweb
      DB_PASS: spotweb
      CRON_INTERVAL: '*/1 * * * *'
    ports:
      - '8085:80'
    depends_on:
      - postgres

  postgres:
    image: 'postgres'
    environment:
      POSTGRES_USER: spotweb
      POSTGRES_PASSWORD: spotweb
      POSTGRES_DB: spotweb
    volumes:
      - postgres-data:/var/lib/postgresql

volumes:
  postgres-data:

Hope someone can benefit from this 🙂

[edv]

Thanks for the info. However, it should never be needed to use internal docker ip addresses, you should be able to just use "postgres" as the DB_HOST (as it uses the internal docker dns). If that does not work it might be a dns problem in your set-up. So I would advice for new users to always use the provided examples first.