Unable get it to run on an Ubuntu docker installation

[DarthHeizenberg]

Trying to run it in docker with compose. The web portal shows the home page fine, but clicking login/signup results in an 500 Internal Error. Would greatly appreciate any help with this! Thanks!

DB server console logs show:

2025-06-02 00:46:29.061 UTC [55] ERROR:  relation "django_site" does not exist at character 78
2025-06-02 00:46:29.061 UTC [55] STATEMENT:  SELECT "django_site"."id", "django_site"."domain", "django_site"."name" FROM "django_site" WHERE "django_site"."id" = 1 LIMIT 21
2025-06-02 00:46:31.449 UTC [27] LOG:  checkpoint starting: time
2025-06-02 00:46:31.470 UTC [27] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.003 s, total=0.021 s; sync files=2, longest=0.002 s, average=0.002 s; distance=0 kB, estimate=0 kB
2025-06-02 00:46:39.840 UTC [57] ERROR:  relation "socialaccount_socialapp" does not exist at character 303
2025-06-02 00:46:39.840 UTC [57] STATEMENT:  SELECT "socialaccount_socialapp"."id", "socialaccount_socialapp"."provider", "socialaccount_socialapp"."provider_id", "socialaccount_socialapp"."name", "socialaccount_socialapp"."client_id", "socialaccount_socialapp"."secret", "socialaccount_socialapp"."key", "socialaccount_socialapp"."settings" FROM "socialaccount_socialapp" INNER JOIN "socialaccount_socialapp_sites" ON ("socialaccount_socialapp"."id" = "socialaccount_socialapp_sites"."socialapp_id") WHERE "socialaccount_socialapp_sites"."site_id" = 1
2025-06-02 00:55:53.668 UTC [95] ERROR:  relation "socialaccount_socialapp" does not exist at character 303
2025-06-02 00:55:53.668 UTC [95] STATEMENT:  SELECT "socialaccount_socialapp"."id", "socialaccount_socialapp"."provider", "socialaccount_socialapp"."provider_id", "socialaccount_socialapp"."name", "socialaccount_socialapp"."client_id", "socialaccount_socialapp"."secret", "socialaccount_socialapp"."key", "socialaccount_socialapp"."settings" FROM "socialaccount_socialapp" INNER JOIN "socialaccount_socialapp_sites" ON ("socialaccount_socialapp"."id" = "socialaccount_socialapp_sites"."socialapp_id") WHERE "socialaccount_socialapp_sites"."site_id" = 1

The backend container shows errors like this:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/local/lib/python3.10/site-packages/django/views/decorators/csrf.py", line 65, in _view_wrapper
    return view_func(request, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/django/views/generic/base.py", line 104, in view
    return self.dispatch(request, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 515, in dispatch
    response = self.handle_exception(exc)
  File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 475, in handle_exception
    self.raise_uncaught_exception(exc)
  File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 486, in raise_uncaught_exception
    raise exc
  File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 512, in dispatch
    response = handler(request, *args, **kwargs)
  File "/code/users/views.py", line 166, in get
    for provider in social_providers:
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 400, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1928, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 100, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/site-packages/django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "socialaccount_socialapp" does not exist
LINE 1: ...."key", "socialaccount_socialapp"."settings" FROM "socialacc...
                                                             ^
Internal Server Error: /auth/social-providers/
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/usr/local/lib/python3.10/site-packages/corsheaders/middleware.py", line 59, in __call__
    self.add_response_headers(request, response)
  File "/usr/local/lib/python3.10/site-packages/corsheaders/middleware.py", line 110, in add_response_headers
    and not self.origin_found_in_white_lists(origin, url)
  File "/usr/local/lib/python3.10/site-packages/corsheaders/middleware.py", line 145, in origin_found_in_white_lists
    or self._url_in_whitelist(url)
  File "/usr/local/lib/python3.10/site-packages/corsheaders/middleware.py", line 165, in _url_in_whitelist
    origins = [urlsplit(o) for o in conf.CORS_ALLOWED_ORIGINS]
  File "/usr/local/lib/python3.10/site-packages/corsheaders/middleware.py", line 165, in <listcomp>
    origins = [urlsplit(o) for o in conf.CORS_ALLOWED_ORIGINS]
  File "/usr/local/lib/python3.10/urllib/parse.py", line 523, in urlsplit
    raise ValueError("Invalid IPv6 URL")
ValueError: Invalid IPv6 URL

The front end container shows:

The origin to be set is: http://localhost:8025
Listening on http://0.0.0.0:3000
Error: Data returned from `load` while rendering /login is not serializable: Cannot stringify arbitrary non-POJOs (data)
    at get_data_json (file:///app/build/server/index.js:2921:11)
    at render_data (file:///app/build/server/index.js:2806:30)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async resolve2 (file:///app/build/server/index.js:4055:22)
    at async i18nHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:96:12)
    at async themeHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:91:10)
    at async authHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:39:14)
    at async respond (file:///app/build/server/index.js:3950:22)
    at async Array.ssr (file:///app/build/handler.js:1284:3)
SyntaxError: Unexpected token '<', "
<!doctype "... is not valid JSON
    at JSON.parse (<anonymous>)
    at parseJSONFromBytes (node:internal/deps/undici/undici:5738:19)
    at successSteps (node:internal/deps/undici/undici:5719:27)
    at fullyReadBody (node:internal/deps/undici/undici:4609:9)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async consumeBody (node:internal/deps/undici/undici:5728:7)
    at async load (file:///app/build/server/chunks/17-BdBzTcVe.js:11:26)
    at async load_server_data (file:///app/build/server/index.js:1303:18)
    at async Promise.all (index 1)
    at async render_data (file:///app/build/server/index.js:2788:19)
Error: Data returned from `load` while rendering /login is not serializable: Cannot stringify arbitrary non-POJOs (data)
    at get_data_json (file:///app/build/server/index.js:2921:11)
    at render_data (file:///app/build/server/index.js:2806:30)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async resolve2 (file:///app/build/server/index.js:4055:22)
    at async i18nHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:96:12)
    at async themeHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:91:10)
    at async authHook (file:///app/build/server/chunks/hooks.server-B9jJ9cmg.js:39:14)
    at async respond (file:///app/build/server/index.js:3950:22)
    at async Array.ssr (file:///app/build/handler.js:1284:3)

My compose file with changes I made:

1. Need it to run on ports 8025/8026 since 8015/8016 are already in use by other containerized apps I'm running
2. Changed DB password
3. Host machine can be locally resolved on my network as kidbuntu.local, including from the host itself

services:
  web:
    #build: ./frontend/
    image: ghcr.io/seanmorley15/adventurelog-frontend:latest
    container_name: adventurelog-frontend
    restart: unless-stopped
    environment:
      - PUBLIC_SERVER_URL=http://server:8000 # Should be the service name of the backend with port 8000, even if you change the port in the backend service
      - ORIGIN=http://localhost:8025
      - BODY_SIZE_LIMIT=Infinity
    ports:
      - "8025:3000"
    depends_on:
      - server

  db:
    image: postgis/postgis:15-3.3
    container_name: adventurelog-db
    restart: unless-stopped
    environment:
      POSTGRES_DB: database
      POSTGRES_USER: adventure
      POSTGRES_PASSWORD: s00perd00per
    volumes:
      - postgres_data:/var/lib/postgresql/data/

  server:
    #build: ./backend/
    image: ghcr.io/seanmorley15/adventurelog-backend:latest
    container_name: adventurelog-backend
    restart: unless-stopped
    environment:
      - PGHOST=db
      - PGDATABASE=database
      - PGUSER=adventure
      - PGPASSWORD=s00perd00per
      - SECRET_KEY=s00perd00per
      - DJANGO_ADMIN_USERNAME=admin
      - DJANGO_ADMIN_PASSWORD=admin
      - DJANGO_ADMIN_EMAIL=admin@example.com
      - PUBLIC_URL=http://kidbuntu.local:8026 # Match the outward port, used for the creation of image urls
      - CSRF_TRUSTED_ORIGINS=[http://localhost:8026,http://localhost:8025,http://kidbuntu.local:8025,http://kidbuntu.local:8026] # Comma separated list of trusted origins for CSRF
      - DEBUG=False
      - FRONTEND_URL=http://kidbuntu.local:8025 # Used for email generation. This should be the url of the frontend
    ports:
      - "8026:80"
    depends_on:
      - db
    volumes:
      - adventurelog_media:/code/media/

volumes:
  postgres_data:
  adventurelog_media:

[Danie10]

@DarthHeizenberg my setup is a bit different but I did spend a good hour or two with a similar issue. It all boiled down to me realising firstly there was not only one "frond end". So there is the web front end exposed but also the server front end, and both seemed to need domain names and be reverse proxied. That, and also the trusts needed to be specified correctly.

So I have https://adventures.gadgeteerza.co.za as my web front end and have https://adventuresimages.gadgeteerza.co.za as the server domain. I also opted for the new db version, which is working fine.

So in my case I have "both front ends" exposed to my reverse-proxy-net network with just the db only in the adventurelog network (the other two also part of this network).

This is the docker-compose that is working for me and maybe it will help you troubleshoot what is out of sync - but it is lilley either the trust settings, or visibility of seeing the other container:port correctly.

services:
  web:
    #build: ./frontend/
    image: ghcr.io/seanmorley15/adventurelog-frontend:latest
    container_name: adventurelog-frontend
    hostname: adventurelog-frontend
    restart: unless-stopped
    networks:
      - adventurelog # For backend connections
      - reverse-proxy-net # For NPM to connect to front end
    environment:
      - PUBLIC_SERVER_URL=http://server:8000 # Should be the service name of the backend with port 8000, even if you change the port in the backend service
      - ORIGIN=https://adventures.gadgeteerza.co.za
      - BODY_SIZE_LIMIT=Infinity
    labels:
      # These are all needed for Watchtower or WUD updaters only
      com.centurylinklabs.watchtower.enable: true # Watchtower updates
      wud.display.name: adventurelog-frontend
      wud.tag.include: ^\d+\.(\d+)\.(\d+)$ # watch y.z tags only
    ports:
      - "8015:3000"
    depends_on:
      - server

  db:
#    image: postgis/postgis:15-3.3
    # 17-3.5 is a recommended version for new users
    image: postgis/postgis:17-3.5
    container_name: adventurelog-db
    hostname: adventurelog-db
    restart: unless-stopped
    networks:
      - adventurelog # For backend connections
    env_file:
          - stack.env
    environment:
      POSTGRES_DB: database
      POSTGRES_USER: adventure
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    volumes:
      # I use an absolute path on left side
      - /srv/dev-disk-by-uuid-e6c3b71f-ef88-4055-a599-fb607c4baed2/data/appdata/Config/AdventureLog/postgres_data:/var/lib/postgresql/data/
    labels:
      # These are all needed for Watchtower or WUD updaters only
      com.centurylinklabs.watchtower.enable: true # Watchtower updates
      wud.display.name: adventurelog-db
      wud.tag.include: ^\d+\.(\d+)\.(\d+)$ # watch y.z tags only

  server:
    #build: ./backend/
    image: ghcr.io/seanmorley15/adventurelog-backend:latest
    container_name: adventurelog-backend
    hostname: adventurelog-backend
    restart: unless-stopped
    networks:
      - adventurelog # For backend connections
      - reverse-proxy-net # For NPM to connect to front end
    env_file:
          - stack.env
    environment:
      - PGHOST=db
      - PGDATABASE=database
      - PGUSER=adventure
      - PGPASSWORD=${POSTGRES_PASSWORD}
      - SECRET_KEY=${SECRET_KEY}
      - DJANGO_ADMIN_USERNAME=admin
      - DJANGO_ADMIN_PASSWORD=${DJANGO_ADMIN_PASSWORD}
      - DJANGO_ADMIN_EMAIL=admin@gadgeteer.co.za
      - PUBLIC_URL=https://adventuresimages.gadgeteerza.co.za # Match the outward port, used for the creation of image urls
      - CSRF_TRUSTED_ORIGINS=http://192.168.20.2:8016,http://192.168.20.2:8015,https://adventures.gadgeteerza.co.za,https://adventuresimages.gadgeteerza.co.za # Comma separated list of trusted origins for CSRF
      - DEBUG=False
      - FRONTEND_URL=https://adventures.gadgeteerza.co.za # Used for email generation. This should be the url of the frontend
      - DISABLE_REGISTRATION=True
        # OPTIONAL: Set the message to display when registration is disabled
      - DISABLE_REGISTRATION_MESSAGE='Registration is disabled for this instance of AdventureLog.'
      - EMAIL_BACKEND=email
      - EMAIL_HOST=smtp.gmail.com
      - EMAIL_USE_TLS=True
      - EMAIL_PORT=587
      - EMAIL_USE_SSL=False
      - EMAIL_HOST_USER=${EMAIL_HOST_USER}
      - EMAIL_HOST_PASSWORD=${EMAIL_HOST_PASSWORD}
      - DEFAULT_FROM_EMAIL=${EMAIL_HOST_USER}
    ports:
      - "8016:80"
    depends_on:
      - db
    volumes:
      - /srv/dev-disk-by-uuid-e6c3b71f-ef88-4055-a599-fb607c4baed2/data/appdata/Config/AdventureLog/adventurelog_media:/code/media/
    labels:
      # These are all needed for Watchtower or WUD updaters only
      com.centurylinklabs.watchtower.enable: true # Watchtower updates
      wud.display.name: adventurelog-backend
      wud.tag.include: ^\d+\.(\d+)\.(\d+)$ # watch y.z tags only

networks:
  adventurelog:
    name: adventurelog
  reverse-proxy-net:
    # Joins existing network of this name so that Nginx Proxy Manager can connect to front ends
    external: true
    # Specify name so that it does not append stack name
    name: reverse-proxy-net

[WatchTower41]

Hugely helpful - I'm stepping my configuration in changes and the networks portion of this is not really defined anywhere, little frustrating.

[Danie10]

I want to streamline mine a bit still - it was really rough. Ideally with the containers on the same network, no external ports need to be exposed. So as long as the web ad server containers are on the nginx-proxy-net network that holds true, and the others all share the adventurelog network.

[keunes]

Hi @Danie10,
I aimed for the same thing, and thanks to Claude.ai I managed to set it up. I have AdventureLog running via Docker compose but behind an Nginx instance running bare-metal. Adding the following to my

    # Proxy backend routes directly
    location ~ ^/(api|admin|static|media|auth|accounts|docs) {
        include snippets/proxy-headers.conf;
        proxy_pass http://localhost:48644;
        proxy_set_header X-Forwarded-Port $server_port;
    }

For Authelia, I've got the front-end's ORIGIN and the back-end's PUBLIC_URL and FRONTEND_URL all just set to https://adventurelog.mydomain.com.
Just wanted to share in case you're interested.

[Danie10]

Thanks @keunes I'll try that. That makes sense as only redirecting admin would break the other paths. This may also solve a similar issue I was having with Immich Public Proxy having a separate domain name.

[keunes]

Appears I ran into #634 and couldn't manage to fix it. So now I'm back to having two domains also. Still hoping it'll be possible in future to make do with a single domain for everything :-)

[DarthHeizenberg]

@Danie10, thanks again for your help! I got it to work by comparing your compose with mine. I'm not using a rev. proxy setup (all internal on the home network for now). I needed the container network defined like you have and not use square braces around the CSRF value (which is weird given that other bits of documentation around the web show that format).

[Danie10]

@Danie10 it's a pleasure. I need to try to get my head around separating it into logical pieces and hope to do a video about this project soon. I'm not sure why that second domain name is required but it did confuse me quite a bit, made worse with the reverse proxy. But glad at l;east my partial bird's nest of a docker-compose helped.