New pfblockerNG install Database Sanity check Failed

slu

@BBcan177 said in New pfblockerNG install Database Sanity check Failed:

From:
s1="$(grep -cv ^${ip_placeholder2}$ ${masterfile})"

To:
s1="$(grep -cv ^${ip_placeholder2}$ ${mastercat})"

Is it possible to update the pfSense package with a bug fix version?

Gradius

FYI, this bug is still present on pfSense v2.8.1-RC and pfBlockerNG-devel v3.2.8

mcury

Same issue on 25.07.1
pfBlockerNG-devel 3.2.7

Database Sanity check [  FAILED  ] ** These two counts should match! **
------------
Masterfile Count    [ 26379 ]
Deny folder Count   [ 26378 ]

TommyMoo

Thank you BIG Time! I had the same problem with pfBlocker Database mismatch message, and its now fixed...Again, Thanks!

TommyMoo

pfBlocker been updated tonight, now the Sanity Check Passes without need of patching!

Thanks to the Developer GREAT! Also other bug fixes been applied with the Update!

borgotech

HI everyone, i have the same issue:
pfBlockerNG-devel 3.2.10
Version 25.07.1-RELEASE (amd64)
built on Wed Aug 20 15:17:00 EEST 2025
FreeBSD 15.0-CURRENT

===============================================================

Database Sanity check [  FAILED  ] ** These two counts should match! **
------------
Masterfile Count    [ 60322 ]
Deny folder Count   [ 60323 ]

Duplication sanity check (Pass=No IPs reported)
------------------------
Masterfile/Deny folder uniq check
Deny folder/Masterfile uniq check

Sync check (Pass=No IPs reported)
----------

i tried to enable/diable ... uninstall/install but the error is there :(. Can anybody give me an advice. Thank you.

TommyMoo

@borgotech Hello, the bug, has been fixed with the latest update of pfBlocker. Please, check, if you have the latest version. In Menu System -> Package Manager -> see, if its the latest version (Appears then highlighted in color Orange in Packagemanager) if an Update is avaible.

If all this doesnt help, you can still patch it manually, please read above post by mull0r above here, who replies to Laxarus, he describes how to patch, in short, you have to login to your pfsense via SSH, and then:

sudo nano /usr/local/pkg/pfblockerng/pfblockerng.sh

then look for the line that contains. use ctrl w for to use nano editor search, and paste in:

s1="$(grep -cv ^${ip_placeholder2}$ ${masterfile})"

and change that line to:

s1="$(grep -cv ^${ip_placeholder2}$ ${mastercat})"

then, save it, with ctrl o, and leave nano, then just restart pfblocker, and the problem should be gone (worked for me, before last update been release a week ago approx.)

Thats it. Now, its should be fixed in the new Update of pfblocker, the Trick / Patch, is only necessary if you have a outdatet pfBlocker installed on your System.

Good Luck!

borgotech

@TommyMoo
Thank you very much for the answer, as I mentioned above I am on the latest version of PfblockerNG devel pfBlockerNG-devel 3.2.10 and the latest stable version of PfSense+ Version 25.07.1-RELEASE (amd64). The patch in your post and the previous ones do not work because the changes have already been made to the latest version.

Anyway, thanks again..

TommyMoo

@borgotech Hello, Im sorry, its doesnt help you, Im on pfsense 2.8.1 CE ... there, it works... hope someone of the Pros, can help you!

JoeNavy

@mull0r Thanks for the clear instructions to fix this issue. I am on pfsense+ 25.07.1 and pfBlockerNG 3.2.7.