Warning "sqlite without WAL...." and cannot update community blocklist

Hi Team Crowdsec,

I upgraded version from 1.3.8 β†’ 1.4.2. I restart crowdsec and see warning. How can i fix it ?
I new user so i cant attach image to topic :smiling_face_with_tear:

crowdsec[89142]: time=β€œ2022-11-24T23:39:04+07:00” level=warning msg=β€œYou are using sqlite without WAL, this can have a…warning.”
Nov 24 23:39:04 : time=β€œ2022-11-24T23:39:04+07:00” level=warning msg=β€œDeprecation warning: the pid_dir config can be sa…required”
Nov 24 23:39:05 time=β€œ2022-11-24T23:39:05+07:00” level=warning msg=β€œYou are using sqlite without WAL, this can have a…warning.”
Nov 24 23:39:05 time=β€œ2022-11-24T23:39:05+07:00” level=warning msg=β€œDeprecation warning: the pid_dir config can be sa…required”

Crowdsec log
time=β€œ25-11-2022 01:39:26” level=info msg=β€œStarting community-blocklist update”
time=β€œ25-11-2022 01:39:35” level=info msg=β€œcapi/community-blocklist : 0 explicit deletions”
time=β€œ25-11-2022 01:39:35” level=warning msg=β€œsqlite is not using WAL mode, LAPI might become unresponsive when inserting the community blocklist”
time=β€œ25-11-2022 01:39:36” level=info msg=β€œcrowdsecurity/community-blocklist : added 18890 entries, deleted 0 entries (alert:6)”
time=β€œ25-11-2022 01:43:54” level=info msg=β€œcapi metrics: metrics sent successfully”

Alerts dont see update community blocklist

ID β”‚ value β”‚ reason β”‚ country β”‚ as β”‚ decisions β”‚ created_at β”‚
β”œβ”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”Όβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 5 β”‚ Ip:185.234.75.159 β”‚ crowdsecurity/http-open-proxy β”‚ US β”‚ 7489 HostUS β”‚ ban:1 β”‚ 2022-11-24 17:44:42.761322964 +0000 UTC β”‚
β”‚ 4 β”‚ Ip:103.131.71.127 β”‚ crowdsecurity/http-bad-user-agent β”‚ VN β”‚ 45899 VNPT Corp β”‚ ban:1 β”‚ 2022-11-24 16:49:39.709134511 +0000 UTC β”‚
β”‚ 3 β”‚ Ip:103.131.71.147 β”‚ crowdsecurity/http-bad-user-agent β”‚ VN β”‚ 45899 VNPT Corp β”‚ ban:1 β”‚ 2022-11-24 16:49:30.1803368 +0000 UTC β”‚
β”‚ 2 β”‚ Ip:103.131.71.145 β”‚ crowdsecurity/http-bad-user-agent β”‚ VN β”‚ 45899 VNPT Corp β”‚ ban:1 β”‚ 2022-11-24 16:49:26.169507244 +0000 UTC β”‚
β”‚ 1 β”‚ Ip:103.131.71.160 β”‚ crowdsecurity/http-bad-user-agent β”‚ VN β”‚ 45899 VNPT Corp β”‚ ban:1 β”‚ 2022-11-24 16:49:22.158959268 +0000 UTC β”‚

Hi,

About WAL: you can insert the following line in /etc/crowdsec/config.yaml, section db_config:

use_wal: true

Then restart Crowdsec using systemctl restart crowdsec.

1 Like

Hi Smu44,

Thanks so much. With your guide, my problem’s gone :laughing: