starred/authelia-admin

Fork 0

mirror of https://github.com/asalimonov/authelia-admin.git synced 2026-04-25 14:45:56 +03:00

[GH-ISSUE #20] Error: SQLITE_CANTOPEN: unable to open database file #88

New issue

Closed

opened 2026-02-27 12:33:02 +03:00 by kerem · 4 comments

kerem commented

2026-02-27 12:33:02 +03:00

Owner

Originally created by @mamema on GitHub (Sep 10, 2025).
Original GitHub issue: https://github.com/asalimonov/authelia-admin/issues/20

Dockerfile:

docker run -p 9093:9093
-v /mnt/docker/authelia/config:/config
-v /mnt/docker/authelia/dbv4:/data
ghcr.io/asalimonov/authelia-admin:latest

Error:

Digest: sha256:be9de29df2307fb1a6872b4a52db82d30f541ad6abcd179b6fb76d3b610068bb
Status: Downloaded newer image for ghcr.io/asalimonov/authelia-admin:latest
Listening on http://0.0.0.0:9093
Error opening database: [Error: SQLITE_CANTOPEN: unable to open database file] {
errno: 14,
code: 'SQLITE_CANTOPEN'
}
Health check failed: [Error: SQLITE_CANTOPEN: unable to open database file] {
errno: 14,
code: 'SQLITE_CANTOPEN'
}

the db file is in the provided path:

ls /mnt/docker/authelia/dbv4
db.sqlite3

Originally created by @mamema on GitHub (Sep 10, 2025). Original GitHub issue: https://github.com/asalimonov/authelia-admin/issues/20 Dockerfile: docker run -p 9093:9093 \ -v /mnt/docker/authelia/config:/config \ -v /mnt/docker/authelia/dbv4:/data \ ghcr.io/asalimonov/authelia-admin:latest Error: Digest: sha256:be9de29df2307fb1a6872b4a52db82d30f541ad6abcd179b6fb76d3b610068bb Status: Downloaded newer image for ghcr.io/asalimonov/authelia-admin:latest Listening on http://0.0.0.0:9093 Error opening database: [Error: SQLITE_CANTOPEN: unable to open database file] { errno: 14, code: 'SQLITE_CANTOPEN' } Health check failed: [Error: SQLITE_CANTOPEN: unable to open database file] { errno: 14, code: 'SQLITE_CANTOPEN' } the db file is in the provided path: ls /mnt/docker/authelia/dbv4 db.sqlite3

kerem closed this issue

2026-02-27 12:33:03 +03:00

kerem commented

2026-03-15 02:23:32 +03:00

Author

Owner

@asalimonov commented on GitHub (Sep 11, 2025):

@mamema , looks like anthelia-admin docker container doesn't access rights. Does authelia and authalia-admin processes have the same UID and GID (user and group)?

@asalimonov commented on GitHub (Sep 11, 2025): @mamema , looks like anthelia-admin docker container doesn't access rights. Does authelia and authalia-admin processes have the same UID and GID (user and group)?

kerem commented

2026-03-15 02:23:37 +03:00

Author

Owner

@mamema commented on GitHub (Sep 11, 2025):

authelia ist set to:
- PUID=1001
- PGID=1001

authelia admin seems to also use 1001

/app $ id
uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup)
/app $

@mamema commented on GitHub (Sep 11, 2025): authelia ist set to: - PUID=1001 - PGID=1001 authelia admin seems to also use 1001 /app $ id uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup) /app $

kerem commented

2026-03-15 02:23:42 +03:00

Author

Owner

@asalimonov commented on GitHub (Sep 11, 2025):

authelia ist set to: - PUID=1001 - PGID=1001

authelia admin seems to also use 1001

/app id uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup) /app

Please check access rights on file system with ls -ln /mnt/docker/authelia/dbv4 there should be files with 1001:1001 numeric uid and gid.
You can also check access from container to DB file with docker exec -t authelia-admin head -c 6 /data/db.sqlite3, it should print the first 6 bytes of the file with "SQLite" word.

@asalimonov commented on GitHub (Sep 11, 2025): > authelia ist set to: - PUID=1001 - PGID=1001 > > authelia admin seems to also use 1001 > > /app $ id uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup) /app $ Please check access rights on file system with `ls -ln /mnt/docker/authelia/dbv4` there should be files with `1001:1001` numeric uid and gid. You can also check access from container to DB file with `docker exec -t authelia-admin head -c 6 /data/db.sqlite3`, it should print the first 6 bytes of the file with "SQLite" word.

kerem commented

2026-03-15 02:23:47 +03:00

Author

Owner

@mamema commented on GitHub (Sep 12, 2025):

this this from within authelia container:

/var/lib/authelia # ls -la
total 1284
drwxrwsr-x 2 1001 1001 4096 Sep 11 08:28 .
drwxr-xr-x 1 root root 4096 Sep 11 09:36 ..
-rwxrwxrwx 1 1001 1001 1306624 Sep 11 08:28 db.sqlite3

this is from host:
-rwxrwxrwx 1 1001 1001 1306624 11. Sep 08:28 db.sqlite3

this is from within authelia admin:

/data $ ls -la
total 1284
drwxrwsr-x 2 nodejs nodejs 4096 Sep 11 06:28 .
drwxr-xr-x 1 root root 4096 Sep 11 11:11 ..
-rwxrwxrwx 1 nodejs nodejs 1306624 Sep 11 06:28 db.sqlite3
/data $ id
uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup)
/data $

and :

/data $ head -c 6 /data/db.sqlite3
SQLite/data

reveals nothing

@mamema commented on GitHub (Sep 12, 2025): this this from within authelia container: /var/lib/authelia # ls -la total 1284 drwxrwsr-x 2 1001 1001 4096 Sep 11 08:28 . drwxr-xr-x 1 root root 4096 Sep 11 09:36 .. -rwxrwxrwx 1 1001 1001 1306624 Sep 11 08:28 db.sqlite3 this is from host: -rwxrwxrwx 1 1001 1001 1306624 11. Sep 08:28 db.sqlite3 this is from within authelia admin: /data $ ls -la total 1284 drwxrwsr-x 2 nodejs nodejs 4096 Sep 11 06:28 . drwxr-xr-x 1 root root 4096 Sep 11 11:11 .. -rwxrwxrwx 1 nodejs nodejs 1306624 Sep 11 06:28 db.sqlite3 /data $ id uid=1001(nodejs) gid=65533(nogroup) groups=65533(nogroup) /data $ and : /data $ head -c 6 /data/db.sqlite3 SQLite/data reveals nothing

No labels

enhancement

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/authelia-admin#88

No description provided.

Rows
Columns