Well, It looks like I was having a dumbass attack. The table name in my database was wrong, once I fixed that, the error message went away (as it was "table doesn't exist".
It still appears to be not pulling the username correctly though, and I would like to know how to properly adjust that. It is also not creating the prefrences entry if it doesn't exist, which I belive it should. Again, any assistance is greatly appreciated. On Wed, 2004-08-18 at 14:30, Nick Bright wrote: > 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[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 http://home.terraworld.net | 888-332-1616
