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.
Database Maintenance
Primary tabs
Credits
Various bits of code, scripts, and procedures were put together with information from John Simpson's qmail.jms1.net website. It's an excellent resource on managing and setting up a Qmail server.
Performance Tuning
- Edit
/etc/my.cnfand 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
Copy the SQL purge script from the source directory:
mkdir /var/dspam/sql
cp /extra/src/dspam-3.10.2/src/tools.mysql_drv/purge-4.1.sql \
/var/dspam/sql/mysql_purge-4.1.sqlCopy the maintenance script:
cp /extra/src/dspam-3.10.2/contrib/dspam_maintenance/dspam_maintenance.sh \
/usr/local/bin/dspam_maintenanceEdit the script with some default options:
DSPAM_CONFIGDIR="/usr/local/etc"
DSPAM_HOMEDIR="/var/dspam"
DSPAM_PURGE_SCRIPT_DIR="/var/dspam/sql"
DSPAM_BIN_DIR="/usr/local/bin"
MYSQL_BIN_DIR="/usr/local/mysql/bin"Test the script out:
/usr/local/bin/dspam_maintenance --verboseCreate a cron task to run it nightly:
cd /etc/cron.d
echo "0 0 * * * root /usr/local/bin/dspam_maintenance >/dev/null 2>&1" > dspam
touch /etc/crontabPurging a user
Script to delete dspam users
- Log in to post comments