On Wed, 2004-08-18 at 14:37, Nicholas Harring wrote: > Nick Bright wrote: > > >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). > > > > > > > I use: > preline /usr/bin/spamc -s 10000000 -u [EMAIL PROTECTED]
Ok, I added your -u [EMAIL PROTECTED] to my spamc line, and I get the following log entries when sending a message: Aug 18 14:35:09 node0 spamd[32486]: processing message <[EMAIL PROTECTED]> for [EMAIL PROTECTED]:0. Aug 18 14:35:09 node0 spamd[32486]: identified spam (1001.0/5.0) for [EMAIL PROTECTED]:0 in 0.1 seconds, 2678 bytes. So it appears to be getting the address properly (yay!), however, it didn't create a prefs entry in the database. If it's as simple as "it doesn't make it automatically, and just uses the default if it's not there" is fine, I just don't know and couldn't really tell from the documentation. My table is set up as such: +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | username | varchar(100) | | MUL | | | | preference | varchar(30) | | | | | | value | varchar(100) | | | | | | prefid | int(11) | | PRI | NULL | auto_increment | +------------+--------------+------+-----+---------+----------------+ Does that cause a problem? It's the table description I got from the documentation at http://old.spamassassin.org/full/2.6x/dist/sql/README, but I had to remove the word "default" because it wouldn't create the table with that on there. Maybe that's the problem? Perhaps at this point, I need to take my question to the spamassassin list? Thanks for your time. > Works like a charm for me. > Hope that helps, > Nick Harring > Webley Systems -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
