On Tue, Nov 16, 2004 at 11:35:15AM -0400, Elias Arends wrote:
>
> I have the above setup working with no problems. Incoming mail is being
> scanned and tagged properly and delivered to the mailboxes. Now I want to
> implement Per User Preferences using a MySQL database. I already have the
> database up and running with some user settings. I have also edited the
> local.cf file to query the MySQL database, which seems to be happening.
> However in the log file I see this message: "retrieving prefs for nobody
> from SQL server" and it seems spamc/spamd is not reading the user settings
> properly. How can I solve this problem? Do I need to use any additional
> software? I have included the local.cf for SA and master.cf for Postfix.
> Thanks.
>
...
> Master.cf:
> # ==========================================================================
> # service type private unpriv chroot wakeup maxproc command + args
> # (yes) (yes) (yes) (never) (100)
> # ==========================================================================
> smtp inet n - n - - smtpd -o
> content_filter=spamassassin -v
> spamassassin unix - n n - - pipe
> user=nobody argv=/usr/local/bin/spamc -f -e /usr/lib/sendmail -oi -f
> ${sender} ${recipient}
> You need to send the username using the -u param for spamc. Once you start passing in the username you should see it start fetching prefs for that user (assuming you've got spamd starting with the right options). Michael -- ApacheCon November 13-17 2004 http://www.apachecon.com/ See three SpamAssassin sessions & more Birds of a Feather Session: November 16th, 9-10pm
pgp4rUg0f4d9t.pgp
Description: PGP signature
