Re: spamass-milter + MySQL users prefs + sendmail + cyrus

[Dan Nelson]

In the last episode (Aug 04), Glogger Steven said:
> first: my goal
> --------------
> i have a cyrus based on mysql auth - this works great.
> sendmail looks up the correct keys in the virtuser table and sends them
> to cyrus.
> i want to use the same username in the mysql database for storing the
> sql prefs for spamassassin.
> sendmail is correct installed (also with milter).
[snip snip] 
> then i compiled and installed the new sendmail.cf file...
> 
> ... and added in /etc/rc.conf this:
> spamass_milter_enable="YES"
> spamass_milter_socket="/var/run/spamass-milter.sock"
> spamass_milter_flags="-x -f -p ${spamass_milter_socket}"
> (for debugging reasons i added a "-d rcpt")
> 
> ok, what i find interesting are following lines:
> Aug  4 15:51:59 temp spamass-milter[46309]: sendmail output: 
> <address@hidden>>... deliverable: mailer cyrusv2, user steven
> Aug  4 15:51:59 temp spamass-milter[46309]: user: steven
> Aug  4 15:51:59 temp spamass-milter[46309]: remembering steven for spamc
> Aug  4 15:51:59 temp spamd[41691]: processing message <address@hidden> for 
> root:0.
> 
> and now the big question:
> why does he takes 'root' instead of 'steven'?
> did i missed anything?

You need to add the '-u' flag to the spamass-milter arguments:

spamass_milter_flags="-x -f -p ${spamass_milter_socket} -u steven"

The username in the -u option will be used only if there are more than
one local recpient in the message.

The log line "remembering steven for spamc" is a little misleading;
it's remembering the username, but won't actually send it to spamc
unless -u is used.

-- 
        Dan Nelson
        address@hidden