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

    New pfblockerNG install Database Sanity check Failed

    Scheduled Pinned Locked Moved pfBlockerNG
    45 Posts 15 Posters 13.7k Views 15 Watching
    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 Offline
      MidGe48 @tinfoilmatt
      last edited by

      @tinfoilmatt

      here: running pfSense 2.8.0-RELEASE and pfBlockerNG 3.2.8-dev

      Made the suggested change to line 1232.

      Still same issue showing DNSBL (unbound mode) out of sync.

      Should I revert the channge to ensure that the patch when available works correctly?

      Thanks for nay help.

      LaxarusL 1 Reply Last reply Reply Quote 0
      • LaxarusL Offline
        Laxarus @MidGe48
        last edited by Laxarus

        @MidGe48

        I had the same issue

        make the suggested change on line 1232

        then go to general
        uncheck

        • pfBlockerNG Enable
        • Keep Settings Enable
          save
          wait for it to save

        then

        check

        • pfBlockerNG Enable
        • Keep Settings Enable
          save
          wait for it to save

        then

        force reload all

        M M 2 Replies Last reply Reply Quote 0
        • M Offline
          MidGe48 @Laxarus
          last edited by

          @Laxarus

          Thank you Laxarus,

          It seems to have worked.

          1 Reply Last reply Reply Quote 0
          • M Offline
            mull0r @Laxarus
            last edited by

            @Laxarus This worked for me as well. Though I had to search the web how to edit the file (the easiest way).

            Therefore:

            Addition for anyone struggling to find where to edit files on your pfsense system.

            Go to Diagnostics --> Edit File --> insert the location of the file:

            /usr/local/pkg/pfblockerng/pfblockerng.sh
            

            Go to line number 1232 by filling it in the Go to line field.

            That line should read:

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

            replace only (leave the rest intact):

            masterfile
            

            to

            mastercat
            

            Then follow the above instructions from @Laxarus https://forum.netgate.com/post/1219635

            1 Reply Last reply Reply Quote 0
            • A anthonys referenced this topic on
            • T Offline
              tman222
              last edited by tman222

              Ran into this issue today as well running on 25.07.1 with pfblockerNG-devel 3.2.7. Followed the steps outlined in this thread to edit the pfblockerng.sh file, then deleted/force reloaded all the lists, and all was well again. Thank you everyone in this thread for your your help and great instructions.

              1 Reply Last reply Reply Quote 0
              • S Offline
                slu @BBcan177
                last edited by

                @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?

                pfSense Gold subscription

                G 1 Reply Last reply Reply Quote 0
                • G Offline
                  Gradius @slu
                  last edited by

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

                  M 1 Reply Last reply Reply Quote 0
                  • N nanda referenced this topic
                  • J jrey referenced this topic
                  • N nanda referenced this topic
                  • M Offline
                    mcury Rebel Alliance @Gradius
                    last edited by

                    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 ]
                    

                    dead on arrival, nowhere to be found.

                    1 Reply Last reply Reply Quote 0
                    • TommyMooT Offline
                      TommyMoo
                      last edited by

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

                      1 Reply Last reply Reply Quote 0
                      • TommyMooT Offline
                        TommyMoo
                        last edited by 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! 👍 👍 👍

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