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

crowdsec
1

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 │

2

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
3

Hi Smu44,

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

4

i have same issue .Thankyou