Databases

By default, the crowdsec Local API use SQLite as backend storage. But in case you expect a lot of traffic on your local API, you should use MySQL or PostgreSQL.

For SQLite, there is nothing to do on your side in order to make it work with crowdsec. But for MySQL and PostgreSQL , you have to create the database and the user.

MySQL

Connect to your MySQL server and run the following commands:

mysql> CREATE DATABASE crowdsec;
mysql> CREATE USER 'crowdsec'@'%' IDENTIFIED BY '<password>';
mysql> GRANT ALL PRIVILEGES ON crowdsec.* TO 'crowdsec'@'%';
mysql> FLUSH PRIVILEGES;

Then edit /etc/crowdsec/config.yaml to update the db_config part.

You can now start/restart crowdsec.

PostgreSQL

Connect to your PostgreSQL server and run the following commands:

postgres=# CREATE DATABASE crowdsec;
postgres=# CREATE USER crowdsec WITH PASSWORD '<password>';
postgres=# GRANT ALL PRIVILEGES ON DATABASE crowdsec TO crowdsec;

Then edit /etc/crowdsec/config.yaml to update the db_config part.

You can now start/restart crowdsec.