Project

General

Profile

Actions
Copy link

Bug #12423

open

Dashboard shows "SQLite database missing, Force Reload DNSBL to recover!"

Added by Sean McBride about 2 months ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
pfBlockerNG
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Plus Target Version:
Affected Version:
Affected Plus Version:
Affected Architecture:

Description

See screenshot. The message tells to 'force reload' which I did, yet the error persists.

There's one post on the forum:

https://forum.netgate.com/topic/163039/sqlite-database-missing-force-reload-dnsbl-to-recover/8?_=1633303395995

but I see no tickets here, so am filing this.

It would be nice if the error message said which database is missing. I see several sqlite files present in /var/unbound/:

rw-r--r- 1 root unbound 0 Oct 3 18:45 pfb_dnsbl.conf
rw-r--r- 1 root unbound 4579 Apr 22 17:18 pfb_dnsbl.doh.conf
rw-r--r- 1 root unbound 2460 Apr 14 18:26 pfb_dnsbl_lighty.conf
rw-r--r- 1 unbound unbound 8192 Oct 3 17:30 pfb_py_dnsbl.sqlite
rwxr-xr-x 1 root wheel 1687428 Sep 10 12:59 pfb_py_hsts.txt
-rw-r--r- 1 unbound unbound 12288 Oct 3 17:30 pfb_py_resolver.sqlite
-rwxr-xr-x 1 root wheel 66726 Sep 10 12:59 pfb_unbound.py
-rwxr-xr-x 1 root wheel 7058 Sep 10 12:59 pfb_unbound_include.inc

Files

Screen Shot 2021-10-03 at 17.36.57.png (67.7 KB) Screen Shot 2021-10-03 at 17.36.57.png Sean McBride, 10/03/2021 06:49 PM
Actions
Copy link
 #2

Updated by Sean McBride about 2 months ago

Viktor, thanks for improving the error message. Two comments:
1. putting the full path might be even better. I assume it's /var/unbound/pfb_py_dnsbl.sqlite?
2. If that is the file, it does exist on my system already:

[21.05.1-RELEASE][admin@pfsense.example.com]/root: file /var/unbound/pfb_py_dnsbl.sqlite
/var/unbound/pfb_py_dnsbl.sqlite: SQLite 3.x database, last written using SQLite version 3035005
Actions
Copy link

Also available in: Atom PDF