Spamassassin + SQL Mail accounts

troopern · Posted: Mon Sep 08, 2003 2:15 pm Post subject: Spamassassin + SQL Mail accounts

I have a problem with getting Spamassassin to scan my Virtual Mail accounts.
I have followed the VMAIL howto in gentoo.org/docs/
Current config is: Postfix, MySQL, mikrop, SpamAssassin.
mikrop and SpamAssassin only works on local accounts, not on virtual, anybody got an Idea on how I can solve this ?
I've searched this forum and google for a while but didn't fint anything that could help me.
_________________
//troopern
-
"It seems like once people grow up, they have no idea what's cool.-- Calvin"

NickDaFish · Posted: Tue Sep 09, 2003 5:10 pm Post subject:

Ha!
You need to do allot of work to get his working as there is no community (that I have found) software for this.
First you have to get SpamAssassin to get it's CFG from SQL. There are a number of FAQs on the spamassassin site for that.
Then you have to make a custom script. I wrote one if python, it checks the To: address against a SQL table and extracts a virtual username for that address. It then submits the mail to spamd using the user name it just aquired. It's alot of messing around with SQL and postfix filters/transports. If you need any pointers......

troopern · Posted: Mon Oct 13, 2003 11:11 am Post subject:

that would be a nice way to try and see if it works, have you got any tips on how I should build that script ? or can I have a peek at yours ?
_________________
//troopern
-
"It seems like once people grow up, they have no idea what's cool.-- Calvin"

Dr_Stein · Posted: Thu Jan 22, 2004 1:09 am Post subject:

NickDaFish · Posted: Thu Jan 22, 2004 2:04 am Post subject:

Jaxom · Tux's lil' helper Joined: 31 Jan 2003 Posts: 137

Ummm, guys....

https://forums.gentoo.org/viewtopic.php?t=89036&highlight=spamassassin+virtual+mail

Worked like a champ for me as far as filtering and whatnot, that's what I'm using and I have a server setup following the vmail guide as well.
_________________
Undisputed Heavyweight Champion. If it's undisputed, WHAT'S ALL THE FIGHTING ABOUT?!?! -- George Carlin

Dr_Stein · Posted: Thu Jan 22, 2004 6:06 am Post subject:

Yup. It's working for me as well. Just needed a $4 in the filter script - I do have a slightly different setup than mentioned in that thread, and I'll post some information on "How I did it" later.

I'm using amavis, f-prot, clam-av, anomy mailtools, and a few other things..

Dr_Stein · Posted: Thu Jan 22, 2004 7:01 pm Post subject: SOLVED!

I have a slightly different method that also works great:

http://www.pbp.net/~jnichols/filtering.html

Check it out, it might be just what you're looking for. :-)