Greetings, 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: 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 http://home.terraworld.net | 888-332-1616