Steve, Please see my responses below.
Thanks for your help, Robert -----Original Message----- From: Steve [mailto:[email protected]] Sent: Wednesday, July 01, 2009 11:25 PM To: [email protected] Subject: Re: [Dspam-user] Retraining Failing After Upgrade to 3.9.0-ALPHA2 Hello Robert, > I had been running DSPAM 3.8.0 for a while with the attached config (only > change for 3.9.0 was the addition of MySQLReconnect). I just upgraded to > 3.9.0-ALPHA2 and am now having problems retraining false > positives/negatives. > > I have a VB script in Outlook that parses the headers of an email and then > creates a new email with the DSPAM signature in the body of the message > and > sends it to [email protected]. In 3.8.0, this would result in the > email referenced by the signature being retrained as spam. After > upgrading > to DSPAM 3.9.0-ALPHA2, instead of retraining, the message gets learned as > an > email for [email protected]. > > My config and a verbose debug are attached. On line 170 of the debug, > DSPAM > shows it found the signature, but appears to ignore it instead of > retraining > that message. > > > DSPAM Anti-Spam Suite 3.9.0-ALPHA2 (agent/library) > > Copyright (c) 2002-2009 DSPAM Project > http://dspam.sourceforge.net. > > DSPAM may be copied only under the terms of the GNU General Public > License, > a copy of which can be found with the DSPAM distribution kit. > > Configuration parameters: '--with-storage-driver=mysql_drv' > '--with-mysql-includes=/usr/include/mysql' > '--with-mysql-libraries=/usr/lib/mysql' '--enable-virtual-users' > '--enable-preferences-extension' '--enable-daemon' > '--with-dspam-home-group=postfix' '--with-dspam-group=postfix' > '--enable-verbose-debug' > > > Thanks for any help you can provide, > I see a bunch of issues: 1) You should NOT use SBPH with MySQL driver. The only driver able to handle SBPH without issues is the hash driver. Please use something else then SBPH. I would suggest OSB. >> Done. Thanks for the advice. I looked around in the docs prior to choosing SBPH, but didn't see anything that indicated it should only be used with the hash driver. Maybe I just missed it. 2) It looks to me like you have a UID for [email protected]. The UID is 5 and therefore DSPAM will train for that user. Please delete that user in the virtual UID table. >> I tried deleting that user with the same result. I have rolled back to 3.8.0 until I can figure this out (but am willing to upgrade again to troubleshoot, as I would like to get it working on 3.9.0), and in 3.8.0, if [email protected] does not have an UID in the virtual UID table, the signature lookup fails. As soon as I add it back, retraining works properly. Here is an example of the error I got in syslog when the virtual UID for [email protected] was not present in dspam_virtual_uids: Jul 1 22:44:15 [dspam] Signature retrieval for '3,4a4c2d03153401346449753' failed Jul 1 22:44:15 [dspam] Unable to find a valid signature. Aborting. However, the signature did exist if I ran a query for it in MySQL. 3) Who is the user behind UID 207? And who is UID 5? >>UID 207 is the postfix user on the system. UID 5 in the virtual UID table was [email protected]. It is now 10 after I have added and removed it a couple of times: mysql> select * from dspam_virtual_uids; +-----+--------------------------------+ | uid | username | +-----+--------------------------------+ | 3 | [email protected] | | 9 | [email protected] | | 10 | [email protected] | +-----+--------------------------------+ 3 rows in set (0.00 sec) 4) Probably you want to set "ChangeUserOnParse" to "full". I can't say right now if that is what you want/need. I need first to know who is UID 207 and who is UID 5 before I can say that for sure. >> I tried the ChangeUserOnParse settings, but didn't see any changes. Based on the description in the sample dspam.conf, it appears that it isn't needed when using MySQLUIDInSignature. The most puzzling thing to me is that everything works fine if I roll back to 3.8.0 without making any config file or DB changes. > Robert > Steve ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
