I'm using vpopmail 5.4.5 on WhiteBox EL 3.0, and I'm trying to set up
per-user prefrences with spamassassin (spamc called from .qmail). I
don't care if it works with SQL or just puts a user_prefs file in each
users' Maildir.

My spamd is running with the following options:

SPAMDOPTIONS="--daemonize --local --nouser-config --sql-config
--create-prefs --username=vpopmail --vpopmail
--socketpath=/var/run/spamd.socket --max-children=64"

and my .qmail-default file contains:

| /usr/bin/spamc -U /var/run/spamd.socket |
/usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox

As far as I can tell, this should tell spamd to get the username from
vpopmail and query the information out of the database, creating the
prefrences if they don't exist already. When I send a test message I get
this error in my maillog:

Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value 
from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or
username = '@GLOBAL' order by username asc Table
'spamassassin.user_prefs' doesn't exist

so, it appears to me, that it isn't getting the proper username for some
reason. I also tried the same SPAMDOPTIONS without the
--username=vpopmail option, and it still came up with a username of
vpopmail (since that is the user that calls spamc, I belive).

How can I make spamc read the appropriate username and pass it to spamd,
or how can I make spamd read this from vpopmail?

I have also tried this configuration, which I thought should have
created/used a file in the users' Maildir:

SPAMDOPTIONS="--daemonize --local --create-prefs --username=vpopmail
--vpopmail --socketpath=/var/run/spamd.socket --max-children=64"

Again, I tried this one with and without the --username=vpopmail, they
both showed it being run as the vpopmail user in the log file.

I don't care if it works via a file in the maildir, or via SQL, but I
would really like to get user prefrences working, any advice that anyone
can give would be very much appreciated. Thanks.

- Nick Bright
  Terraworld, Inc | 888-332-1616

Reply via email to