SquirrelMail  
Donations
News
About
Support
Screen shots
Download
Plugins
Documentation
Sponsors
Bounties













Security Notice
Phishing campain
Version 1.4.15
Security Upgrade
Plugins - Amavis-New + SQL + SpamAssassin + Quarantine
Category: Filters & Spam

This plugin lets users change a pre-defined set of SpamAssassin settings when those settings are stored in a SQL DB rather than a config file. It also allows you to use a quarantine database for questionable mail. This plugin was designed with enterprise use in mind, and differs from other plugins in that it works with amavis-new rather than SpamAssassin directly. Most of the code lives in an external class for you to reuse in your own admin tools.. and even has support for SOAP calls to perform common tasks.


Version 0.8.0
by Jared Watkins on Jul 18, 2005
[ amavisnewsql-0.8.0-1.4.tar.gz tarball (14515 d/l) Help ]
Requires: SquirrelMail 1.4x PEAR Log PEAR Net/SMTP Mysql or PgSql Recent PHP

Description: You may also get this from sourceforge:

http://sourceforge.net/projects/sm-plugins/

o Added the ability to turn the quarantine off on a per user basis.

o Fixed quarantine display to show a page header even when no messages are in the quarantine.

o Moved the code that adds a new user into the amavis database to be run from setup.php instead of amavisnewsql.php. This has the affect that new users will be added the first time they log into webmail instead of the first time they visit the plugin options page as before. An assumption had to be made in relation to the persons email address.. Now when a new user logs into webmail for the first time.. it will create an email address based on their username and the default domain from the config file. The code where this happens is in the setup.php file around line 60. You should customize this part if it does not work with your site. If they already have an email address set in the personal info section of SQM it will use that. Make sure this email address matches the 'base address' if you use multiple addresses per account. See the FAQ in the readme for an explanation.

o Reordered the process of storing quarantined messages in process_bsmtp.php. Now.. if a recipient is not in the database the message in question will not be stored. Please see the FAQ in the readme about this issue. Thanks for the tip on this to Nick Davis

o Limited the digest mailing to the top 100 lowest scoring messages

o The quarantine page now limits the number of messages per page... it uses the same value as the 'Number of Messages to Index' option on the Display Preferences page.

o cleanquarantine.php script has been updated to also remove all messages that are not owned by anyone in the users table. I know this has been a problem for some sites...

o Moved the listQuarantineMessages function from the generatedigest script into the class.

o Changed quotestring to use the php addslashes function for storing emails in the database.

o Changes to support virtual domains. If the username is passed in with an @ sign it will (for a new user) use that for the email address as well. If it does not have an @ sign it will assemble an email from the default domain set in the config file.

Older versions

Version 0.7.3
by Jared Watkins on Sep 21, 2004
[ amavisnewsql-0.7.3x-1.4.tar.gz tarball (4468 d/l) Help ]
Requires: SquirrelMail 1.4x PEAR Log PEAR Net/SMTP Mysql or PgSql Recent PHP

Description: Please download this from sourceforge: http://sourceforge.net/projects/sm-plugins/ Several bug fixes that have surfaced over the last several months. The 7.3x release updates some old db schema files in 7.3.. it would only affect new installs done with the 7.3 release.

Version 0.7.2
by Jared Watkins on Apr 14, 2004
[ amavisnewsql-0.7.2-1.4.tar.gz tarball (4460 d/l) Help ]
Requires: SquirrelMail 1.4x PEAR Log PEAR Net/SMTP Mysql or PgSql Recent PHP

Description: Several small fixes for problems that resulted from my doing development in two places. This rev fixes the following issues: DB Schema Problems, Incomplete Language Support, Missing Install Steps, Missing Subject On Quarantine Release. Props also given for recent amazon gifts.

Version 0.7.1
by Jared Watkins on Apr 1, 2004
[ amavisnewsql-0.7.1x-1.4.tar.gz tarball (2445 d/l) Help ]
Requires: SquirrelMail 1.4x PEAR Log PEAR Net/SMTP Mysql or PgSql Recent PHP

Description: For .1 I fixed a few small bugs.. including one that caused the subject line not to be in released quarantine messages. For those who get the wrong schema.. this was a problem where my newly uploaded file was not the same one you were linked to download... I have fixed this with the 'x' file release. This problem also happened on sourceforge.. depending on the mirror you use.. you would get different files... it's maddening! =]

Version 0.7.0
by Jared Watkins on Mar 20, 2004
[ amavisnewsql-0.7-1.4.tar.gz tarball (2739 d/l) Help ]
Requires: SquirrelMail 1.4x PEAR Log PEAR Net/SMTP Mysql or PgSql Recent PHP

Description: The perl files were done away with.. so now everything is working off a common php class. Changes in the class to support replicated databases. Error handling was redone. You can now whitelist everyone in your SM address book. Direct links to whitelist a sender when viewing a message. Whitelist on release option in quarantine.

If you have problems with the download or decompressing...
Internet Explorer
Right-click on the file, then select "Save Target As"
Firefox, Mozilla, Netscape
Right-click on the file, then select "Save Link As"
Opera
Right-click on the file, then select "Save Link Document As"
Lynx and Links
Press "d" on the link to download the file directly.
  • Untarring problems: Your browser might have un-gzipped it for you automatically. Try just "tar xvf" instead of "tar xvfz". Also, the plugins archive isn't gzipped (it is a tarball of .tar.gz files)
  • Macintosh users: Just hold down your mouse button to get the menu instead of right-clicking.
  • If all else fails, seek our help
© 1999-2010 by The SquirrelMail Project Team