Re: [vchkpw] Spamassassin per user (MySQL)
You guys should take a look at Blackhole. Has Qmail-queue mode and checking based on user and domain I believe. The HOW-TO has more info on it. http://the.groovy.org/blackhole.shtml Phil Wall
Re: [vchkpw] Spamassassin per user (MySQL)
Hi, Interesting idea... but since to see if spamassassin is supposed to run you'd have to run spamassassin, maybe a little front end to check to see if the user has a required_hits set in the database and if they do, then pass the email along to spamassassin. Interesting.. I like it. I'll look into further if no one else wants to tackle it. Regards, Rick - Original Message - From: Andy BIERLAIR [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 2:42 AM Subject: [vchkpw] Spamassassin per user (MySQL) If there is no straightforward solution on that issue, is it possible to set the domain-wide spamassassin config ( /etc/mail/spamassassin/local.cf ) NOT to check spam by default and then override these settings per user from MySQL? In that case I could leave .qmail-default as it is and still having a user based filtering. Has anyone worked with that so far? I know that this is not the usual way to user Spamassassin but there might be people out there who have the same thoughts about MySQL ease as I. Thanks for giving clues. Andy
RE: [vchkpw] Spamassassin per user (MySQL)
First intersting thing would probably be the integration of .qmail files from each user into mysql and maybe even .qmail-default e.g. ~vpopmail/domain/postmaster/.qmail ~vpopmail/domain/any_user/.qmail My primary objective is getting rid of all the flat files (except the Maildir of course) Andy
RE: [vchkpw] Spamassassin per user (MySQL)
valias support in mysql will work. the current problem is that qmailadmin does not support the valias mod for vpopmail. It only likes .qmail files... If you can write a webfront end that only writes to the mysql tables you can get most of qmailadmins features - user creation/ mods (not deletes -cant remove the mail dir) Note: if you create a user in the sql table the directory is only created when that user receives its first email Ron On Sat, 2002-11-16 at 09:26, Andy BIERLAIR wrote: First intersting thing would probably be the integration of .qmail files from each user into mysql and maybe even .qmail-default e.g. ~vpopmail/domain/postmaster/.qmail ~vpopmail/domain/any_user/.qmail My primary objective is getting rid of all the flat files (except the Maildir of course) Andy ** The Firelan(tm) Virus Scanning Service has scanned this email for viruses, vandals and malicious content. http://www.firelan.net **
RE: [vchkpw] Spamassassin per user (MySQL)
I think there is a difference between .qmail .qmail-default .qmail-aliasname .qmail files are not supported in MySQL as far as I know. It's only .qmail-aliasname that is supported (for aliases and forwards) -- see valias table in mysql .qmail files are always located in a users directory. I use .qmail (user based) and .qmail-default (domain wide) to configure the way incoming emails are being checked (with or w/o spamassassin, etc...). Unfortunatley this is still being done through shell and that's what I am trying to get rid of (hopefully totally) with a pure PHP frontend. Correct me if I'm wrong with the .qmail statement Andy