Re: Spamassassin, MySQL and Virtual Users

2004-08-31 Thread p dont think
> I've never used procmail, so I don't know. Perhaps try it on a test > setup, and see what happens? If using courier-maildrop, something like this is what most people do in their filter file: if ( $SIZE < 262144 ) { exception { xfilter "/usr/bin/spamc -u $LOGNAME" } }

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Jonathan Nichols
Wess Bechard wrote: I am using postfix+mysql+mailscanner to achieve this goal. All my accounts are virtual in mysql. I have Mailscanner sitting between two copies of postfix, handling spamassassin, blacklists, and clamAV. Mailscanner supports almost every major *nix virus scanner, and was a br

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Wess Bechard
I am using postfix+mysql+mailscanner to achieve this goal. All my accounts are virtual in mysql.  I have Mailscanner sitting between two copies of postfix, handling spamassassin, blacklists, and clamAV.  Mailscanner supports almost every major *nix virus scanner, and was a breeze to set up. M

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Nick Bright
I've never used procmail, so I don't know. Perhaps try it on a test setup, and see what happens? On Fri, 2004-08-27 at 12:59, Ziekke wrote: > Also, I am using procmail to call spamc. > # > DROPPRIVS=yes > > :0fw > | /usr/bin/spamc -f -S > # > > If I use the -u when calling spamc, should

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Ziekke
Also, I am using procmail to call spamc. # DROPPRIVS=yes :0fw | /usr/bin/spamc -f -S # If I use the -u when calling spamc, should I use the same flags that I'm using for spamd? or should I modify those at all. On Fri, 27 Aug 2004 12:50:14 -0500, Nick Bright <[EMAIL PROTECTED]> wrote: > M

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Ziekke
What if I am using Postfix as my MTA? I'll try your suggestion, but I'm not so certain it would work. However, I may be able to look in my postfix .cf files for the equivalent. Thanks for the tip! On Fri, 27 Aug 2004 12:50:14 -0500, Nick Bright <[EMAIL PROTECTED]> wrote: > My configuration is kind

Re: Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Nick Bright
My configuration is kinda like yours, I think. I use vpopmail/qmail so there are no local users. From the vpopmail mailing list I got an answer about how to pass the username over. If you are calling spamc from the .qmail file, you can use "-u [EMAIL PROTECTED]" as a spamc argument, and you'll en

Spamassassin, MySQL and Virtual Users

2004-08-27 Thread Ziekke
Hello, I'm trying to get SpamAssassin set up to locate all the user prefs from MySQL. The problem I am running into is that all my mail users are virtual users, none of them hae local accounts. Thus, setting spamd to use the userid calling spamc isn't really useful. Is there any way to get spamass