3 replies

Issues with external Postgres DB

When I run Coder with the internal DB, it works flawlessly. As soon as I try with an external Postgres database, I get 401 errors such as "the API key is invalid" and 404 errors such as "Resource not found or you do not have access to this resource". Template creation fails with

logs: decode body: invalid character '<' looking for beginning of value

logs: decode body: invalid character '<' looking for beginning of value

version: "3.8"

networks:
  t2_external:
    external: true

services:
  coder:
    image: ghcr.io/coder/coder:latest
    
    command: chmod 666 /var/run/docker.sock

    networks:
      - t2_external

    volumes:
      - /var/run/docker.sock:/var/run/docker.sock

    environment:
      CODER_PG_CONNECTION_URL: "postgresql://coder-user:[email protected]:5432/coder?sslmode=disable"
      CODER_ADDRESS: "0.0.0.0:7080"
      CODER_ACCESS_URL: "https://coder.mydomain.com"
      CODER_OAUTH2_GITHUB_ALLOW_SIGNUPS: "true"
      CODER_OAUTH2_GITHUB_ALLOWED_ORGS: "my-org"
      CODER_OAUTH2_GITHUB_CLIENT_ID: "12345"
      CODER_OAUTH2_GITHUB_CLIENT_SECRET: "abcde"

    deploy:
      labels:
        - traefik.enable=true
        - traefik.docker.network=t2_external
        - traefik.http.routers.coder-rtr.entrypoints=https
        - traefik.http.routers.coder-rtr.rule=Host(`coder.mydomain.com`)
        - traefik.http.services.coder.loadbalancer.server.port=7080

version: "3.8"

networks:
  t2_external:
    external: true

services:
  coder:
    image: ghcr.io/coder/coder:latest
    
    command: chmod 666 /var/run/docker.sock

    networks:
      - t2_external

    volumes:
      - /var/run/docker.sock:/var/run/docker.sock

    environment:
      CODER_PG_CONNECTION_URL: "postgresql://coder-user:[email protected]:5432/coder?sslmode=disable"
      CODER_ADDRESS: "0.0.0.0:7080"
      CODER_ACCESS_URL: "https://coder.mydomain.com"
      CODER_OAUTH2_GITHUB_ALLOW_SIGNUPS: "true"
      CODER_OAUTH2_GITHUB_ALLOWED_ORGS: "my-org"
      CODER_OAUTH2_GITHUB_CLIENT_ID: "12345"
      CODER_OAUTH2_GITHUB_CLIENT_SECRET: "abcde"

    deploy:
      labels:
        - traefik.enable=true
        - traefik.docker.network=t2_external
        - traefik.http.routers.coder-rtr.entrypoints=https
        - traefik.http.routers.coder-rtr.rule=Host(`coder.mydomain.com`)
        - traefik.http.services.coder.loadbalancer.server.port=7080

The only difference between a working and non working implementation is the

CODER_PG_CONNECTION_URL

CODER_PG_CONNECTION_URL

line.

Coder.com•4y ago•

3 replies

Max

Issues with external Postgres DB

logs: decode body: invalid character '<' looking for beginning of value

logs: decode body: invalid character '<' looking for beginning of value

version: "3.8"

networks:
  t2_external:
    external: true

services:
  coder:
    image: ghcr.io/coder/coder:latest
    
    command: chmod 666 /var/run/docker.sock

    networks:
      - t2_external

    volumes:
      - /var/run/docker.sock:/var/run/docker.sock

    environment:
      CODER_PG_CONNECTION_URL: "postgresql://coder-user:[email protected]:5432/coder?sslmode=disable"
      CODER_ADDRESS: "0.0.0.0:7080"
      CODER_ACCESS_URL: "https://coder.mydomain.com"
      CODER_OAUTH2_GITHUB_ALLOW_SIGNUPS: "true"
      CODER_OAUTH2_GITHUB_ALLOWED_ORGS: "my-org"
      CODER_OAUTH2_GITHUB_CLIENT_ID: "12345"
      CODER_OAUTH2_GITHUB_CLIENT_SECRET: "abcde"

    deploy:
      labels:
        - traefik.enable=true
        - traefik.docker.network=t2_external
        - traefik.http.routers.coder-rtr.entrypoints=https
        - traefik.http.routers.coder-rtr.rule=Host(`coder.mydomain.com`)
        - traefik.http.services.coder.loadbalancer.server.port=7080

version: "3.8"

networks:
  t2_external:
    external: true

services:
  coder:
    image: ghcr.io/coder/coder:latest
    
    command: chmod 666 /var/run/docker.sock

    networks:
      - t2_external

    volumes:
      - /var/run/docker.sock:/var/run/docker.sock

    environment:
      CODER_PG_CONNECTION_URL: "postgresql://coder-user:[email protected]:5432/coder?sslmode=disable"
      CODER_ADDRESS: "0.0.0.0:7080"
      CODER_ACCESS_URL: "https://coder.mydomain.com"
      CODER_OAUTH2_GITHUB_ALLOW_SIGNUPS: "true"
      CODER_OAUTH2_GITHUB_ALLOWED_ORGS: "my-org"
      CODER_OAUTH2_GITHUB_CLIENT_ID: "12345"
      CODER_OAUTH2_GITHUB_CLIENT_SECRET: "abcde"

    deploy:
      labels:
        - traefik.enable=true
        - traefik.docker.network=t2_external
        - traefik.http.routers.coder-rtr.entrypoints=https
        - traefik.http.routers.coder-rtr.rule=Host(`coder.mydomain.com`)
        - traefik.http.services.coder.loadbalancer.server.port=7080

The only difference between a working and non working implementation is the

CODER_PG_CONNECTION_URL

CODER_PG_CONNECTION_URL

line.

Issues with external Postgres DB

Similar Threads

Issues with external Postgres DB

Similar Threads

Similar Threads

Similar Threads