Project

General

Profile

Actions
Copy link

Bug #12423

closed

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

Added by Sean McBride over 3 years ago. Updated over 2 years ago.

Status:
Resolved
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 over 3 years 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
 #3

Updated by Viktor Gurov over 3 years ago

  • Status changed from New to Feedback

Merged

Actions
Copy link
 #4

Updated by Sean McBride over 3 years ago

So is this in pfBlockerNG-devel 3.1.0 or not yet released?

Actions
Copy link
 #5

Updated by Jordan G over 2 years ago

current version is 3.1.0_4 so it should be included - I have not hit this on that release, please update if you're still encountering the issue

Actions
Copy link
 #6

Updated by Danilo Zrenjanin over 2 years ago

  • Status changed from Feedback to Resolved

Yes, it's included in the 3.1.0_4 version.

/usr/local/www/widgets/widgets: cat -n pfblockerng.widget.php | grep 609
   609                        $stats[$key][$type] = "<span title='*** SQLite database 'pfb_py_dnsbl.sqlite' is missing, Force Reload DNSBL to recover! ***'>Unknown</span>";

It now specifies the missing database.

I am marking this ticket resolved.

Actions
Copy link

Also available in: Atom PDF