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

    PfBlockerNG-devel 2.1.2

    Scheduled Pinned Locked Moved pfBlockerNG
    47 Posts 14 Posters 14.5k 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.
    • ForsakedF
      Forsaked
      last edited by Forsaked

      This won't work, im still out of sync.
      The log can be found here.

      pfSense: 2.4.3

      System: QOTOM-Q355G4
      CPU: Intel Core i5-5250U
      RAM: 8GB SK Hynix DDR3L-1600
      LAN: Intel I211-AT
      SSD: 256GB Lite-On

      1 Reply Last reply Reply Quote 0
      • RonpfSR
        RonpfS
        last edited by RonpfS

        This is because you have twice the Samedi_SecureMecca URL defined in your DNSBL table.

        [ Samedi_SecureMecca ]		 Downloading update [ 05/27/18 10:12:55 ] .. 200 OK.
        . . .
        [ Samedi_SecureMecca ]		 Reload [ 05/27/18 10:13:00 ] . completed ..
        . . .
          ----------------------------------------------------------------------
          Orig.    Unique     # Dups     # White    # TOP1M    Final                
          ----------------------------------------------------------------------
          25263    25263      23422      157        0          1684                 
          ----------------------------------------------------------------------
        . . .
        *** DNSBL update [ 1530059 ] [ 1528375 ] ... OUT OF SYNC ! *** [ 05/27/18 10:14:30 ]
        
        

        1530059 - 1528375 = 1684

        Header/Label have to be different.

        1 Reply Last reply Reply Quote 3
        • ForsakedF
          Forsaked
          last edited by Forsaked

          Thank you!
          I will check this, when i'm at home.

          Edit:

          You where right, somehow i managed to use the same Header/Label on 2 different lists, which caused the error.
          Now everything is fine, thank you!

          pfSense: 2.4.3

          System: QOTOM-Q355G4
          CPU: Intel Core i5-5250U
          RAM: 8GB SK Hynix DDR3L-1600
          LAN: Intel I211-AT
          SSD: 256GB Lite-On

          1 Reply Last reply Reply Quote 1
          • Q
            Quarkz
            last edited by

            I’m getting the following error on a semi-regular basis which seems to completely lock up PHP

            PHP ERROR: Type: 1, File: /usr/local/pkg/pfblockerng/pfblockerng.inc, Line: 3990, Message: Call to a member function fetchArray() on boolean

            Any ideas? Thanks for the great package

            RonpfSR 2 Replies Last reply Reply Quote 0
            • RonpfSR
              RonpfS @Quarkz
              last edited by RonpfS

              This post is deleted!
              1 Reply Last reply Reply Quote 0
              • RonpfSR
                RonpfS @Quarkz
                last edited by

                @quarkz

                Did you uninstall the 2.1.2_3 Version before install the 2.1.2 Dev version?
                Did you run a Force Reload All ?

                What is the status of the pfBlockerNG firewall filter & pfBlockerNG DNSBL service ? Restart the services.

                Did you look at the logs files ?

                Q 1 Reply Last reply Reply Quote 0
                • Q
                  Quarkz @RonpfS
                  last edited by

                  @ronpfs

                  Yes. BBCan sent me a git fix to test.

                  1 Reply Last reply Reply Quote 0
                  • ForsakedF
                    Forsaked
                    last edited by

                    Did the package name changed from "2.1.2_2" to 2.2.1"?
                    I have an update available.

                    pfSense: 2.4.3

                    System: QOTOM-Q355G4
                    CPU: Intel Core i5-5250U
                    RAM: 8GB SK Hynix DDR3L-1600
                    LAN: Intel I211-AT
                    SSD: 256GB Lite-On

                    1 Reply Last reply Reply Quote 1
                    • RonpfSR
                      RonpfS
                      last edited by

                      https://github.com/pfsense/FreeBSD-ports/pull/526

                      1 Reply Last reply Reply Quote 1
                      • ForsakedF
                        Forsaked
                        last edited by Forsaked

                        Thank you @RonpfS!

                        pfSense: 2.4.3

                        System: QOTOM-Q355G4
                        CPU: Intel Core i5-5250U
                        RAM: 8GB SK Hynix DDR3L-1600
                        LAN: Intel I211-AT
                        SSD: 256GB Lite-On

                        1 Reply Last reply Reply Quote 1
                        • RonpfSR
                          RonpfS
                          last edited by RonpfS

                          pfBlockerNG-devel 2.2.1 is now available under 2.3.5-RELEASE-p2 😀

                          1 Reply Last reply Reply Quote 2
                          • B
                            bbrendon
                            last edited by

                            Any idea when this new version is going to be a "non-devel" version?

                            B 1 Reply Last reply Reply Quote 0
                            • ?
                              A Former User
                              last edited by

                              @BBcan177 Hitting this on a pretty consistent basis:

                              Crash report begins. Anonymous machine information:

                              amd64
                              11.2-RELEASE
                              FreeBSD 11.2-RELEASE #24 5bbe95e97b4(factory-RELENG_2_4_4): Mon Jul 2 12:46:48 EDT 2018 root@buildbot3:/builder/crossbuild-master/pfSense/tmp/obj/builder/crossbuild-master/pfSense/tmp/FreeBSD-src/sys/pfSense

                              Crash report details:

                              PHP Errors:
                              [05-Jul-2018 12:59:04 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3842
                              [05-Jul-2018 13:00:48 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3845
                              [05-Jul-2018 13:00:48 America/New_York] PHP Warning: SQLite3::query(): Unable to prepare statement: 5, database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3923
                              [05-Jul-2018 13:02:33 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3842
                              [05-Jul-2018 13:04:18 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3845
                              [05-Jul-2018 13:04:18 America/New_York] PHP Warning: SQLite3::prepare(): Unable to prepare statement: 5, database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3957
                              [05-Jul-2018 13:04:18 America/New_York] PHP Fatal error: Call to a member function bindValue() on boolean in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3958
                              [05-Jul-2018 13:06:04 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3842

                              No FreeBSD crash data found.

                              ? 1 Reply Last reply Reply Quote 0
                              • ?
                                A Former User @A Former User
                                last edited by

                                @netgate-james Also this in Alerts

                                PHP ERROR: Type: 1, File: /usr/local/pkg/pfblockerng/pfblockerng.inc, Line: 3958, Message: Call to a member function bindValue() on boolean @ 2018-07-05 13:11:20

                                1 Reply Last reply Reply Quote 0
                                • BBcan177B
                                  BBcan177 Moderator
                                  last edited by BBcan177

                                  @netgate-james said in PfBlockerNG-devel 2.1.2:

                                  @netgate-james Also this in Alerts
                                  PHP ERROR: Type: 1, File: /usr/local/pkg/pfblockerng/pfblockerng.inc, Line: 3958, Message: Call to a member function bindValue() on boolean @ 2018-07-05 13:11:20

                                  I have only seen this on a few systems. So far the solution has been to change the SQLite3 PRAGMA journal_mode from "wal" to "delete". I haven't had much time to investigate the reason. Before I post a fix, I want to do some additional testing, however; you can test the following:

                                  If you can edit the file:

                                  /usr/local/pkg/pfblockerng/pfblockerng.inc
                                  

                                  and change the following line 3842
                                  https://github.com/pfsense/FreeBSD-ports/blob/devel/net/pfSense-pkg-pfBlockerNG-devel/files/usr/local/pkg/pfblockerng/pfblockerng.inc#L3842

                                  From:

                                  $db_handle->exec("PRAGMA journal_mode = wal;");
                                  

                                  To:

                                  $db_handle->exec("PRAGMA journal_mode = delete;");
                                  

                                  "Experience is something you don't get until just after you need it."

                                  Website: http://pfBlockerNG.com
                                  Twitter: @BBcan177  #pfBlockerNG
                                  Reddit: https://www.reddit.com/r/pfBlockerNG/new/

                                  ? O 2 Replies Last reply Reply Quote 0
                                  • ?
                                    A Former User @BBcan177
                                    last edited by

                                    @bbcan177 patch applied, will follow-up with results. Thank you BBcan177!!

                                    1 Reply Last reply Reply Quote 0
                                    • ?
                                      A Former User
                                      last edited by A Former User

                                      @BBcan177 been looking good since applying the change. Apparently this popped up

                                      Crash report begins. Anonymous machine information:

                                      amd64
                                      11.2-RELEASE
                                      FreeBSD 11.2-RELEASE #28 5bbe95e97b4(factory-RELENG_2_4_4): Thu Jul 5 00:38:07 EDT 2018 root@buildbot3:/builder/crossbuild-master/pfSense/tmp/obj/builder/crossbuild-master/pfSense/tmp/FreeBSD-src/sys/pfSense

                                      Crash report details:

                                      PHP Errors:
                                      [06-Jul-2018 10:41:38 America/New_York] PHP Warning: SQLite3::exec(): database is locked in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 3842

                                      No FreeBSD crash data found.

                                      No adverse behavior observed thus far.

                                      Edit: Had another two of these same crash reports generate.

                                      Edit: make that three .. still no adverse side-effects though.

                                      1 Reply Last reply Reply Quote 0
                                      • V
                                        vladimirlind
                                        last edited by

                                        Pfsense (latest dev snap) keeps crashing with this warning on "Update" webgui tab :

                                        Warning: Use of undefined constant pfb_status - assumed 'pfb_status' (this will throw an Error in a future version of PHP) in /usr/local/www/pfblockerng/pfblockerng_update.php on line 385 Warning: Use of undefined constant pfb_output - assumed 'pfb_output' (this will throw an Error in a future version of PHP) in /usr/local/www/pfblockerng/pfblockerng_update.php on line 392

                                        1 Reply Last reply Reply Quote 0
                                        • V
                                          vladimirlind
                                          last edited by

                                          Here is the crashreport I caught:

                                          Crash report begins. Anonymous machine information:

                                          arm
                                          11.2-RELEASE
                                          FreeBSD 11.2-RELEASE #2 3f33035c36f(factory-RELENG_2_4_4): Tue Jul 10 15:36:43 EDT 2018 root@buildbot3:/builder/crossbuild-master/obj/armv6/C5dYt69Q/arm.armv6/builder/crossbuild-master/pfSense/tmp/FreeBSD-src/sys/pfSense-SG-3100

                                          Crash report details:

                                          PHP Errors:
                                          [11-Jul-2018 15:33:20 Europe/Moscow] PHP Warning: Illegal string offset 'vip' in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 1128
                                          [11-Jul-2018 15:33:21 Europe/Moscow] PHP Warning: Illegal string offset 'vtype' in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 6320
                                          [11-Jul-2018 15:33:21 Europe/Moscow] PHP Warning: Illegal string offset 'key' in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 6321
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 6995
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 6995
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 6995
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 7000
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 7000
                                          [11-Jul-2018 15:33:23 Europe/Moscow] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /usr/local/pkg/pfblockerng/pfblockerng.inc on line 7000

                                          No FreeBSD crash data found.

                                          1 Reply Last reply Reply Quote 0
                                          • RonpfSR
                                            RonpfS
                                            last edited by

                                            https://forum.netgate.com/topic/132659/php-warning-illegal-string-offset-vip-in-usr-local-pkg-pfblockerng-pfblockerng-inc-on-line-1128

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