need help with spamd->mysql config required_hits problem please

[Daryn <da...@steelsword.org.uk>]

hey there

first time mailing to the list, so apologies for any gaffs i make. I've
searched the archive at GMANE for my problem but I can't find much associated
with it.

problem:

I've got Postfix 2.2 (using virtual mailboxes through mysql), spamassassin 3
(getting it's required_hits and whitelists from the mysql db), clamd, and
latest version of mysql all trying to work together.

my particular problem is that, right now, I have these lines in postfix/master.cf:

smtp      inet  n       -       y       -       -       smtpd -o
content_filter=spamassassin

spamassassin  unix  -       n       n       -       -       pipe  user=filter
argv=/usr/bin/spamc -f -e /usr/sbin/sendmail -oi -f ${sender} ${recipient}


This WOULD be fine for what I need except for the fact that I want each user
to have control over his/her required hits factor (through php-sa/mysql).

As shown, spam runs as filter and thus checks the sql database using the
"filter" user:
Jan 14 21:11:55 krynn spamd[2497]: spamd: processing message
<20...@domain.blah.com> for filter:41031

So with each mail going through spamassassin as the user "filter" then it does
not read each user's required hits in mysql, just the user "filter"'s.

IF I comment out the spamassassin sections above in master.cf and use the
mailbox_command in main.cf to pipe it through a site-wide /etc/procmailrc,
THEN it works (more or less).

I'm looking at this page: http://www.akadia.com/services/postfix_spamassassin.html
and wondering if i can cobble a bash script together that will filter out the
email address from the To: line and use THAT as the user spamc runs as so
that, when it goes to the spamd daemon, it contacts the mysql database and
checks the required hits for THAT user's email address rather then filter.

Does it have anything to do with the -Q flag on spamd's command line?

Solution: ?? :)

Confusing as heck isnt it?

any ideas please? ANY ideas would be helpful right now but I dont really want
to install mailscanner or amavis if it can be avoided please.

Thanks very much for any help/pointers etc.

Steve