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
My spamd is running with the following options:
SPAMDOPTIONS="--daemonize --local --nouser-config --sql-config
--create-prefs --username=vpopmail --vpopmail
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: 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
http://home.terraworld.net | 888-332-1616