SquidGuard is a URL redirector used to use blacklists with the proxysoftware Squid. There are two big advantages to squidguard: it is fast and it is free.
Revision of Database Purging from Thu, 10/15/2015 - 09:40
Revisions allow you to track differences between multiple versions of your content, and revert back to older versions.
Performance Tuning
- Edit
/etc/my.cnf
and add aquery_cache
:query_cache_size = 8M
- Make sure you're using InnoDB for the MySQL tables
http://dspamwiki.expass.de/Performance_Tuning
http://sourceforge.net/apps/mediawiki/dspam/index.php?title=Installation
Nightly Maintenance Script
mkdir /var/dspam/sql
cp /extra/src/dspam-3.10.2/src/tools.mysql_drv/purge-4.1.sql /var/dspam/sql/
Test the script out:
/usr/local/mysql/bin/mysql -u simscan -p \
dspamdb < /var/dspam/sql/purge-4.1.sql
Create a cron task to run it nightly:
cd /etc/cron.d
echo "0 0 * * * root /usr/local/mysql/bin/mysql -u simscan -p<password> dspamdb < /var/dspam/sql/purge-4.1.sql" > dspam
touch /etc/crontab
Purging a user
Script to delete dspam users
- Log in to post comments