System freeze when updating SquidGuard blacklist



  • Everything was working fine from 2015. However, since last Feb 2019, I can not seem to load shallalist (not sure about the other lists). I think download completes successfully but when configuring, the system is stuck/froze (I do not have the system error with me and I can not seem to locate it in the logs as it was immediately covered by other logs--I think).

    What I have seen in the log window (blacklist tab) is something like:

    Begin blacklist update
    Start download.
    Download archive http://www_shallalist_de/Downloads/shallalist_tar_gz
    Download complete
    Unpack archive
    Scan blacklist categories.
    Start rebuild DB.
    Completed 60%
    

    That is when system freezes--at 60%. I've tried it several times through several restarts and even changed the HD.

    Blacklist still missing as per Filter GUI log (this is after the restart as system froze):

    11.04.2019 09:28:33	[squid_reconfigure] Add new redirector options to Squid config.
    11.04.2019 09:28:33	[squid_reconfigure] Remove old redirector options from Squid config.
    11.04.2019 09:28:33	[sg_redirector_base_url] Select redirector base url (http://10.10.2.1:80/sgerror.php?url=403%20Error%21%20Check%20squidGuard%20configuration%20data.%20%28sg_create_config%3A%20%5B2%5D%29.&a=%a&n=%n&i=%i&s=%s&t=%t&u=%u)
    11.04.2019 09:28:33	[sg_create_simple_config] Begin with dbhome='/var/db/squidGuard'.
    11.04.2019 09:28:33	[sg_create_config] Error Terminated.
    01.01.1970 08:00:00	error: destination name 'blk_BL_webtv' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_webradio' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_webphone' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_weapons' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_warez' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_violence' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_urlshortener' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_updatesites' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_tracker' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_spyware' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_socialnet' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_shopping' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_sex_lingerie' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_sex_education' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_searchengines' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_ringtones' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_remotecontrol' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_redirector' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_recreation_humor' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_radiotv' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_porn' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_podcasts' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_music' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_movies' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_models' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_jobsearch' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_imagehosting' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_hobby_pets' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_hobby_games-online' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_hobby_games-misc' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_hacking' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_gamble' not found
    11.04.2019 09:28:33	[sg_reconfigure] Save squidGuard config to '/usr/local/etc/squidGuard/squidGuard.conf'. 'default' error: destination name 'blk_BL_fortunetelling' not found
    11.04.2019 09:28:33	[squidguard_rebuild_db] Start rebuild DB.
    11.04.2019 09:28:33	[sg_redirector_base_url] Select redirector base url (http://10.10.2.1:80/sgerror.php?url=403%20Error%21%20Check%20squidGuard%20configuration%20data.%20%28sg_create_config%3A%20%5B2%5D%29.&a=%a&n=%n&i=%i&s=%s&t=%t&u=%u)
    11.04.2019 09:28:33	[sg_create_simple_config] Begin with dbhome='/var/db/squidGuard'.
    11.04.2019 09:28:33	[sg_create_config] Error Terminated.
    01.01.1970 08:00:00	error: destination name 'blk_BL_webtv' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_webradio' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_webphone' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_weapons' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_warez' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_violence' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_urlshortener' not found
    01.01.1970 08:00:00	error: destination name 'blk_BL_updatesites' not found
    

    Note that the date and time stamp 01.01.1970 08:00:00.

    In the directory /var/db/squidGuard, the shallalist is nowhere to be found. However, the target categories I added manually are still there and is currently being used by squidguard.

    [2.1.3-RELEASE][admin@pfsense.mydomain.local]/root(11): ls /var/db/squidGuard/
    blk_allow       blk_extensions  blk_proxies     gamesandmobiles personalnsocial
    blk_cartoons    blk_pornsites   blk_sites       multimedia      virtualcurrency
    [2.1.3-RELEASE][admin@pfsense.mydomain.local]/root(12): ls -lh /var/db/squidGuard/
    total 20
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_allow
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_cartoons
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_extensions
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_pornsites
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_proxies
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 blk_sites
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 gamesandmobiles
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 multimedia
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 personalnsocial
    drwxr-xr-x  2 proxy  proxy   512B Feb 12 22:02 virtualcurrency
    

    As you might notice, I'm still in 2.1.3-RELEASE. I'm using a legacy hardware (pentium dualcore with 2GB RAM) waiting to be refreshed. Last 2015 or 2016, when I decided to upgrade to 2.1.5, error hit me and required me to reinstall. So I just reverted to 2.1.3.

    Thank you in advance to anyone who may be able to help.

    ~Buruguduy



  • Shallalist URL is http://www_shallalist_de/Downloads/shallalist_tar_gz. Can not seem to post above as post being flagged as SPAM



  • Nobody likes trying to troubleshoot an issue on an ancient version of pfSense from yesteryear. You should have worked to get that error you saw in 2.1.5 fixed and stayed current. Now that the x86 images are gone, it's too late.

    Maybe your disk is low on space? Have you tried removing squidguard, cleaning up the filesystem and then reinstalling it?



  • Thanks @KOM,

    I know. Plenty of disk space. This is on new disk but config was from a backup. So yes, squidguard has been reinstalled.

    Now working on upgrading hardware.


Log in to reply