Coolify attaches a root-owned volume/bind at /pb_data; the non-root pb user couldn't write it, so SQLite failed with "unable to open database file (14)". Drop the pb user and run as root. Verified against a root-owned bind mount locally: server starts clean, migrations apply, data.db persists to the mount. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
36 lines
1.3 KiB
Docker
36 lines
1.3 KiB
Docker
# myanime-backend — PocketBase, version-pinned from the official release.
|
|
#
|
|
# We download the official static binary from GitHub releases (rather than a
|
|
# third-party image) so the deploy is reproducible and easy to audit.
|
|
FROM alpine:3.20 AS fetch
|
|
|
|
# Bump this to upgrade PocketBase. Keep it in sync with the README.
|
|
ARG PB_VERSION=0.39.6
|
|
ARG TARGETARCH=amd64
|
|
|
|
RUN apk add --no-cache ca-certificates unzip wget \
|
|
&& wget -q "https://github.com/pocketbase/pocketbase/releases/download/v${PB_VERSION}/pocketbase_${PB_VERSION}_linux_${TARGETARCH}.zip" -O /tmp/pb.zip \
|
|
&& unzip /tmp/pb.zip -d /pb \
|
|
&& rm /tmp/pb.zip
|
|
|
|
FROM alpine:3.20
|
|
|
|
RUN apk add --no-cache ca-certificates
|
|
|
|
COPY --from=fetch /pb/pocketbase /usr/local/bin/pocketbase
|
|
|
|
# Schema-as-code: migrations are baked in and auto-applied on serve.
|
|
COPY pb_migrations /pb_migrations
|
|
|
|
# Persist DB, uploaded files, and any admin-created migrations here. Runs as root
|
|
# so it can always write the volume Coolify attaches — Coolify's persistent mount
|
|
# is root-owned, and a non-root user hitting it fails with SQLite "unable to open
|
|
# database file (14)".
|
|
RUN mkdir -p /pb_data
|
|
VOLUME ["/pb_data"]
|
|
|
|
EXPOSE 8090
|
|
|
|
# Coolify terminates TLS at Traefik; PocketBase listens plain on 8090 behind it.
|
|
ENTRYPOINT ["pocketbase"]
|
|
CMD ["serve", "--http=0.0.0.0:8090", "--dir=/pb_data", "--migrationsDir=/pb_migrations"]
|