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 to make it work with crowdsec. But for MySQL and PostgreSQL , you have to create the database and the user.

Please refer to ent. supported database. At the time of writting :

MySQL 5.6.35, 5.7.26 and 8
MariaDB 10.2 and latest
PostgreSQL 10, 11 and 12
SQLite
Gremlin

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.