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.
    • E
      erisan500
      last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • 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.