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

    SquidGuard db rebuild

    Scheduled Pinned Locked Moved pfSense Packages
    11 Posts 4 Posters 13.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.
    • D
      dvserg
      last edited by

      @erisan500:

      How do we rebuild the squidGuard database files?  ::)
      I found squidGuard_db_rebuild.sh in /tmp, but when run i get: squidGuard_db_rebuild.sh: Command not found.

      Any idea?

      You don't need use this script(this is temp file). Base rebuild for blacklist processed once after downloading (10-30 min if base big). This script generated every time, when need rebuild Blacklist base.
      User bases (destinations in GUI) not-need-rebuilding(this is impotant).
      This is a smallest part and very often changed. I not build db-files for this.
      If you want looking squidGuard command format - open an read squidGuard_db_rebuild.sh

      SquidGuardDoc EN  RU Tutorial
      Localization ru_PFSense

      1 Reply Last reply Reply Quote 0
      • E
        erisan500
        last edited by

        ok, here what i did:

        I wanted to use a more updated blacklist so i put "http://www.shallalist.de/Downloads/shallalist.tar.gz" into the blacklist field.
        Checked the blacklist checkbox and clicked upload.

        What do i have to do after this? It doesn't look like the new blacklist is active.

        EriSan500

        1 Reply Last reply Reply Quote 0
        • D
          dvserg
          last edited by

          New blacklist will downloaded, instlled and rebuilded via sh script (take some time)

          SquidGuardDoc EN  RU Tutorial
          Localization ru_PFSense

          1 Reply Last reply Reply Quote 0
          • E
            erisan500
            last edited by

            well….

            I waited more then 24 hours and the new blacklist did not get installed.

            Please let me know how to proceed from here.

            EriSan500

            1 Reply Last reply Reply Quote 0
            • D
              dvserg
              last edited by

              ok, here what i did:
              
              I wanted to use a more updated blacklist so i put "http://www.shallalist.de/Downloads/shallalist.tar.gz" into the blacklist field.
              Checked the blacklist checkbox and clicked upload.
              
              What do i have to do after this? It doesn't look like the new blacklist is active.
              

              Try this steps
              1. check enable blacklist and press Save button
              2. put URL 'http://www.shallalist.de/Downloads/shallalist.tar.gz' and press Upload
              –-
              You found wrong behaviour. I will fix this. Thanks.

              SquidGuardDoc EN  RU Tutorial
              Localization ru_PFSense

              1 Reply Last reply Reply Quote 0
              • E
                erisan500
                last edited by

                I tried that and this is what i found in the squidguard.log:

                
                2008-01-26 12:39:39 [45898] /usr/local/bin/squidGuard: can't open configfile  -C
                2008-01-26 12:39:39 [45898] going into emergency mode
                2008-01-26 12:39:39 [45898] ending emergency mode, stdin empty
                
                

                I saw that the new black lists get unpacked to /var/tmp/BL but after that nothing seems to get updated (The folders/files in /var/db/squidGuard remain the old ones)

                If i delete everything in /var/db/squidGuard and copy the unpacked folders/files again to /var/db/squidGuard will it rebuild the database files?

                Greetings,
                EriSan500

                1 Reply Last reply Reply Quote 0
                • D
                  dvserg
                  last edited by

                  ...
                  /usr/local/bin/squidGuard -c /usr/local/etc/squidGuard/squidGuard.conf -C /var/db/squidGuard/TestB/domains
                  /usr/local/bin/squidGuard -c /usr/local/etc/squidGuard/squidGuard.conf -C /var/db/squidGuard/TestB/urls
                  /usr/local/bin/squidGuard -c /usr/local/etc/squidGuard/squidGuard.conf -C /var/db/squidGuard/AIGK/domains
                  /usr/local/bin/squidGuard -c /usr/local/etc/squidGuard/squidGuard.conf -C /var/db/squidGuard/AIGK/urls
                  ...
                  chown -R -v proxy /var/db/squidGuard
                  /usr/local/sbin/squid -k reconfigure
                  

                  I found what a problem - this is a bug with unpacking procedure
                  Different Blacklist archives can including different content (with group dir/without this dir, different dir names..). I must full re-write one procedure.

                  SquidGuardDoc EN  RU Tutorial
                  Localization ru_PFSense

                  1 Reply Last reply Reply Quote 0
                  • C
                    ColdFusion
                    last edited by

                    Package working great…..however since this change the block_log report does not work. I get Block_Log report disabled on the log tab. Logging is enabled on default page also. I also deleted and re-installed package, but no luck.

                    1 Reply Last reply Reply Quote 0
                    • C
                      ciarocci
                      last edited by

                      I used the list from "http://www.shallalist.de/Downloads/shallalist.tar.gz" and it stopped SG from working and caused pfSense to put a message up saying it was restoring an old config.xml file.  Now anything I do to SG takes an eternity and the config file has to be restored again.  Me thinks something is still wrong with the way SG is handling this list.

                      Chris

                      Update: I uninstalled and re-installed SG and all seems to be working again.  I thought I had the latest version but maybe not.  The version number does not seem to be incrementing each time there is a change done to SG.

                      1 Reply Last reply Reply Quote 0
                      • D
                        dvserg
                        last edited by

                        Oldest version of config may be invalid for latest SG I move Sources elements to ACL page. Version's GUI can view on CVS tree. Package page show only port-package version (not GUI modification).

                        SquidGuardDoc EN  RU Tutorial
                        Localization ru_PFSense

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