Hi,
we have a list of email addresses stored in MySQL. We now would like to use this MySQL list as a global whitelist in spamassassin. For every incoming email this MySQL list should be checked before the user white/blacklist is used.
Is this possible with spamassassin? If yes, how?
Thanks
Willi
Do you have have SA set up to interface with MySQL? If not, read this first: http://www.spamassassin.org/full/2.6x/dist/sql/README
The global entries would be added (or altered) so that the username is "@GLOBAL".
insert into userpref(username,preference,value)
values ('@GLOBAL','whitelist_from','[EMAIL PROTECTED]');
Once you have this set up, if you want a PHP-based front-end, try the following: http://webuserprefs.pipegrep.net/
HTH --
Edward Shornock
------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
