Error Crowdsec Metabase Dashboard 2024

It has been reported that there is an Error Crowdsec Metabase Dashboard which Ubuntu users are facing. The solution is to follow this guide.

Issue: Metabase SQLITE_CANTOPEN crowdsec

I tried 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.

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

sudo apt install crowdsec
sudo apt install crowdsec-firewall-bouncer-iptables

Solution

Reason was that metabase wont start because of an error

Error is because the .db file cannot be read

It cannot be read because openjdk is not installed by default in Ubuntu

So, solution is to install openjdk

sudo apt install openjdk-21-jdk