SqliteError: unable to open database file when using podman #1122

New Issue

MrUnknownDE · 2026-04-05T18:19:24+02:00

MrUnknownDE commented

2026-04-05 18:19:24 +02:00

Originally created by @hseliger on 8/3/2025

Hi!
I am tryying to install pangoin under linux (Alma Linux 9) using podman and podman-compose. The installer starts, creates the folder structure and all configuration files, but then hangs. I have checked the created files against the documentation and compared to "manual installation using docker compose". All seems fine (some minor additions the installer seems to make, such as enabling ipv6).
When I run podman compose up (skipping the "-d" so I see the output) I get the follwing sqlite error:

[pangolin] | 
[pangolin] | > @fosrl/pangolin@0.0.0 start:sqlite
[pangolin] | > DB_TYPE=sqlite NODE_OPTIONS=--enable-source-maps NODE_ENV=development ENVIRONMENT=prod sh -c 'node dist/migrations.mjs && node dist/server.mjs'
[pangolin] | 
[pangolin] | 
[pangolin] | /app/node_modules/better-sqlite3/lib/database.js:69
[pangolin] |            [util.cppdb]: { value: new addon.Database(filename, filenameGiven, anonymous, readonly, fileMustExist, timeout, verbose || null, buffer || null) },
[pangolin] |                                   ^
[pangolin] | SqliteError: unable to open database file
[pangolin] |     at new Database (/app/node_modules/better-sqlite3/lib/database.js:69:26)
[pangolin] |     at createDb (/app/server/db/sqlite/driver.ts:15:20)
[pangolin] |     at <anonymous> (/app/server/db/sqlite/driver.ts:19:19)
[pangolin] |     at ModuleJob.run (node:internal/modules/esm/module_job:263:25)
[pangolin] |     at async ModuleLoader.import (node:internal/modules/esm/loader:540:24)
[pangolin] |     at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:117:5) {
[pangolin] |   code: 'SQLITE_CANTOPEN'
[pangolin] | }
[pangolin] | 
[pangolin] | Node.js v20.19.4

SInce my assumption is that all commands are running inside the container environment, it should not be an issue of missing packages on the system. Permissions should not be an issue. Podman is run as root and I tried setting config/db folder permissions to world-writable (777) which did not change things.

Anything I can do to get it started? I could not find a matching existing issue, but it could of course still be that I am the problem…

Cheers,
Hendrik

*Originally created by @hseliger on 8/3/2025* Hi! I am tryying to install pangoin under linux (Alma Linux 9) using podman and podman-compose. The installer starts, creates the folder structure and all configuration files, but then hangs. I have checked the created files against the documentation and compared to "manual installation using docker compose". All seems fine (some minor additions the installer seems to make, such as enabling ipv6). When I run `podman compose up` (skipping the "-d" so I see the output) I get the follwing sqlite error: ``` [pangolin] | [pangolin] | > @fosrl/pangolin@0.0.0 start:sqlite [pangolin] | > DB_TYPE=sqlite NODE_OPTIONS=--enable-source-maps NODE_ENV=development ENVIRONMENT=prod sh -c 'node dist/migrations.mjs && node dist/server.mjs' [pangolin] | [pangolin] | [pangolin] | /app/node_modules/better-sqlite3/lib/database.js:69 [pangolin] | [util.cppdb]: { value: new addon.Database(filename, filenameGiven, anonymous, readonly, fileMustExist, timeout, verbose || null, buffer || null) }, [pangolin] | ^ [pangolin] | SqliteError: unable to open database file [pangolin] | at new Database (/app/node_modules/better-sqlite3/lib/database.js:69:26) [pangolin] | at createDb (/app/server/db/sqlite/driver.ts:15:20) [pangolin] | at <anonymous> (/app/server/db/sqlite/driver.ts:19:19) [pangolin] | at ModuleJob.run (node:internal/modules/esm/module_job:263:25) [pangolin] | at async ModuleLoader.import (node:internal/modules/esm/loader:540:24) [pangolin] | at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:117:5) { [pangolin] | code: 'SQLITE_CANTOPEN' [pangolin] | } [pangolin] | [pangolin] | Node.js v20.19.4 ``` SInce my assumption is that all commands are running inside the container environment, it should not be an issue of missing packages on the system. Permissions should not be an issue. Podman is run as root and I tried setting config/db folder permissions to world-writable (777) which did not change things. Anything I can do to get it started? I could not find a matching existing issue, but it could of course still be that I am the problem… Cheers, Hendrik

Sign in to join this conversation.

Branches Tags

main

dev

dependabot/npm_and_yarn/dev-minor-updates-b4e5d6b9c5

revert-2766-feature/systemd-install-instructions

dependabot/npm_and_yarn/prod-patch-updates-05702d39f2

dependabot/npm_and_yarn/next-16.2.1

dependabot/npm_and_yarn/recharts-3.8.1

alerting-rules

private-site-ha

dependabot/docker/docker/library/node-25-slim

ssh

delete-account

msg-delivery

org-only-idp

cicd

patch

site-targets-auto-login

No Label docker docker docker help wanted help wanted help wanted help wanted help wanted help wanted needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating needs investigating

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#1122