Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    New pfblockerNG install Database Sanity check Failed

    Scheduled Pinned Locked Moved pfBlockerNG
    9 Posts 4 Posters 175 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      madmaxpr
      last edited by

      I just did a clean install of pfBlockerNG and on update or reload I see this in the log:

      Database Sanity check [  FAILED  ] ** These two counts should match! **
      ------------
      Masterfile Count    [ 16932 ]
      Deny folder Count   [ 16931 ]
      
      Duplication sanity check (Pass=No IPs reported)
      

      No idea on this, its working but I have no idea what it means and google is no help so stuck with that message, but otherwise is working fine.

      S 1 Reply Last reply Reply Quote 0
      • S
        SteveITS Galactic Empire @madmaxpr
        last edited by

        @madmaxpr what version of pfSense and pfBlocker?

        Pre-2.7.2/23.09: Only install packages for your version, or risk breaking it. Select your branch in System/Update/Update Settings.
        When upgrading, allow 10-15 minutes to restart, or more depending on packages and device speed.
        Upvote 👍 helpful posts!

        M 1 Reply Last reply Reply Quote 0
        • M
          madmaxpr @SteveITS
          last edited by

          @SteveITS

          2.8.0-RC (amd64)
          built on Fri May 16 16:21:00 BST 2025
          FreeBSD 15.0-CURRENT
          
          The system is on the latest version.
          Version information updated at Sat May 24 17:17:34 BST 2025
          
          pfBlockerNG		net 	3.2.8
          
          1 Reply Last reply Reply Quote 0
          • M
            madmaxpr
            last edited by

            Still seeing this on the newest 2.8 release, just updated today.

            1 Reply Last reply Reply Quote 0
            • tinfoilmattT
              tinfoilmatt
              last edited by

              Try performing the process outlined under Firewall / pfBlockerNG / General / Keep Settings:

              Note: To clear all downloaded lists, uncheck these two checkboxes and 'Save'. Re-check both boxes and run a 'Force Update|Reload'

              M 1 Reply Last reply Reply Quote 0
              • M
                marchand.guy @tinfoilmatt
                last edited by

                @tinfoilmatt I don't see "2 settings" just one.

                M tinfoilmattT 2 Replies Last reply Reply Quote 0
                • M
                  marchand.guy @marchand.guy
                  last edited by

                  @marchand-guy And no, it did not fix the error.

                  1 Reply Last reply Reply Quote 0
                  • tinfoilmattT
                    tinfoilmatt @marchand.guy
                    last edited by

                    @marchand-guy said in New pfblockerNG install Database Sanity check Failed:

                    @tinfoilmatt I don't see "2 settings" just one.

                    Firewall / pfBlockerNG / General / pfBlockerNG "Enable" checkbox

                    and

                    Firewall / pfBlockerNG / General / Keep Settings "Enable" checkbox

                    Uncheck both checkboxes (to disable each), click "Save", re-check both checkboxes (to re-enable each), click "Save" again—and finally run Force Update | Reload All.

                    You might consider starting a new thead unless you have the same exact issue as OP (i.e., a failed "Database Sanity check").

                    M 1 Reply Last reply Reply Quote 0
                    • M
                      marchand.guy @tinfoilmatt
                      last edited by

                      @tinfoilmatt Same exact problem. Thank you.

                      1 Reply Last reply Reply Quote 0
                      • First post
                        Last post
                      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.