[SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)

crowdsec
1

Hello.

I installed the dashboard and the installation was successful. However, I get this message: “[SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)” when I try to view the data.

2023-08-19_15-27
2023-08-19_15-271917×928 41.8 KB

CrowdSec Version
2023/08/19 15:33:16 version: v1.5.2-debian-pragmatic-4fbc3402fba932c8bd34b671527dcf7909d264c0
2023/08/19 15:33:16 Codename: alphaga
2023/08/19 15:33:16 BuildDate: 2023-05-26_16:11:23
2023/08/19 15:33:16 GoVersion: 1.20.1
2023/08/19 15:33:16 Platform: linux
2023/08/19 15:33:16 Constraint_parser: >= 1.0, <= 2.0
2023/08/19 15:33:16 Constraint_scenario: >= 1.0, < 3.0
2023/08/19 15:33:16 Constraint_api: v1
2023/08/19 15:33:16 Constraint_acquis: >= 1.0, < 2.0

Metabase version: 0.41.5

2

2023-08-19_15-35
2023-08-19_15-351228×777 69.6 KB

3

We dont offer support directly with metabase since its a metabase issue. However, my advice would be follow the error message, exec into the container and check the path:

  • is the database mounted?
  • what are permissions on database? should be 0640
    .rw-r-----
  • check the permissions outside the container /var/lib/crowdsec/data/crowdsec.db
    • Is it owned by root?
    • Is the group CrowdSec?
4

I don’t use the metabase directly. I installed it using the “cscli dashboard setup” command. And yes, there was an error with the database file, I fixed it in the way you suggested. However, the “[SQLITE_CANTOPEN] Unable to open the database file (unable to open database file)” error did not go away.

5

I don’t use the metabase directly. I installed it using the “cscli dashboard setup” command.

I understand, but we dont offer support to metabase we offer a command to automatically prop up a container with everything mounted inside.

However, I will attempt to help with 0 knowledge. Have you tried stopping and starting the container since the database issue were rectified?

6

Change /var/lib/crowdsec/data if needed.

sudo chown 2000:1000 /var/lib/crowdsec/data -R

Notes

uid=2000(metabase) gid=1001(metabase) groups=1001(metabase),1001(metabase)
7

This worked for me. Specifically, I am using both Crowdsec & Metabase in docker containers. So Crowdsec runs as root while Metabase runs as user metabase (UID = 1000).

I had a shared static volume with the Crowdsec database. Since Crowdsec is running as roote, Metabase couldn’t access the DB files.

The directory with the crowdsec database was ./crowdsec-db (relative to the docker compose yml file) so sudo chown 2000:1000 ./crowdsec-db -R from that same directory allowed both Crowdsec & Metabase access to the files.

So dropping out to the