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.