SquidGuard Blacklist Update



  • Hi,

    I've got squidGuard Proxy Filter running and I regularly download the blacklist.

    How do I check to see if the blacklist database has been updated?

    I cant seem to find the menu where this information would be…

    Thanks in advance.



  • Select: Services -> Proxy Filter: Click 'Log' tab then 'Filter Log'

    Look for dB update in the filter log, or just do a manual update if you are concerned.

    Could look at the logs manually.



  • Select: Services -> Proxy Filter: Click 'Log' tab then 'Filter Log'

    Thanks for the reply.

    I’ve check this location but it doesn’t show the updated db. What directory are the logs stored in so I can manually check them?

    I have a cron job that runs an auto update every day at 23:59.
    I followed the guide posted on this thread (http://forum.pfsense.org/index.php/topic,35479.0.html) to create my Blacklist auto update cron task.
    My blacklist source is: http://www.shallalist.de/Downloads/shallalist.tar.gz

    Every time I click on Services -> Proxy Filter -> General Settings and press the ‘Apply’ button it then updates the db and is also reflected in the filter log…

    If I manually click on 'download' to update this then shows in the filter Log…

    am i doing something wrong in the cron job..?

    ???



  • Try this.

    The squidGuard package create a update script in tmp directory.

    $cat /tmp/squidGuard_blacklist_update.sh

    #!/usr/local/bin/php -f
        $incl = "/usr/local/pkg/squidguard_configurator.inc";
        if (file_exists($incl)) {
            require_once($incl);
            sg_reconfigure_blacklist( "http://www.shallalist.de/Downloads/shallalist.tar.gz", "" );
        }
        exit;
    ?>
    

    Copy this file to other directory .

    eg. /usr/local/bin

    And schedule this in cron.

    :)



  • Hi ccesario,

    /usr/local/bin is where I had placed the squidGuard_blacklist_update.sh file originally.

    I've checked the script in that location and it is identical to the script shown in your post.
    I've uploaded an image of my cron setup for you to see. Can you confirm for me if i've set up the cron job correctly? :-[

    [IMG]http://i43.tinypic.com/24gsraq.jpg

    Thanks  ;D



  • @Noobie:

    Can you confirm for me if i've set up the cron job correctly? :-[
    [/quote]

    The cron is configured to run everyday at 15:30, but you have to check if you gave exec permissions to this script

    chmod +x /usr/local/bin/squidGuard_blacklist_update.sh
    


  • ;D ;D ;D - it's worked!

    I didn't know that permissions needed to be granted.. Lesson learned. ::)

    Thanks marcelloc & pfSense Forum users for all your help!!


Log in to reply