Block Sender - A Plugin for SquirrelMail ======================================== Version: 2.02 Version Date: 16-May-2003 Author: Derek Battams <derek@battams.ca> Requires SQMAIL: >= v1.4.0 Requires procmail: >= v3.15.x The files in this directory are tools for aiding the setup of MySQL support with the Block Sender plugin. The exception is the isBlocked binary. This file is required for the plugin's operation when you choose to use MySQL support. Below is a description of the tools within this directory. create_tbl.mysql ================ This script can be used to create the required table for use with MySQL support. To use the script you must already have a MySQL database created called squirrelmail. With the squirrelmail database already created, use the script as follows: mysql -u <user> --password squirrelmail < create_tbl.mysql Where <user> is a MySQL user with sufficient authority to create a table in the squirrelmail database. This will create the table which is then ready for immediate use by the plugin. block_flat2mysql.pl =================== This script can used to convert your flatfile block lists to a MySQL script which will then load your current lists into the MySQL database. Use the script as following: block_flat2mysql.pl <path to *.block files> The path should be that which contains the current user block files. This will create a file called blocklist.mysql in the directory from where you call the perl script. With this file you can load the data into MySQL as follows: mysql -u <user> --password squirrelmail < blocklist.mysql Where <user> is a MySQL user with sufficient authority to INSERT records into the squirrelmail database. This will load the block lists for all users into the MySQL database. isBlocked ========= A C program used by the procmail recipes for plugin operation. You should not need to manually run this program.