Steve, Thanks for the quick response. I finally figured out what was wrong. There was a wildcard set in the groups file that was grouping all preferences together under the group name dspam. I removed that line from the group file and its recording statistics separately now for all users.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Sent: Saturday, June 21, 2008 5:46 PM To: [email protected] Subject: Re: [dspam-users] DSPAM Virtual Users Problem using Postfix & MySQL -------- Original-Nachricht -------- > Datum: Sat, 21 Jun 2008 10:06:56 -0500 > Von: "Administrator" <[EMAIL PROTECTED]> > An: [email protected] > Betreff: [dspam-users] DSPAM Virtual Users Problem using Postfix & MySQL > I have DSPAM up and running on Debian etch (installed via etch .debs) per > a > few guides I found floating around howtoforge.com and elsewhere. I'm using > DSPAM with Postfix and MySQL and have also set up the DSPAM web frontend > as > well running on Apache. > > I have an issue that must go back to my core configuration of DSPAM and > how > its handling my virtual users (I believe). Filtering is working (very well > I > might add) with only minimal training thus far and my quarantine seems to > be > working very well for all 4 of my test user accounts that I have set up.. > The > problem is, the stats don't appear to be updating properly. DSPAM only > updates stats for the user "dspam" which I'm assuming its taking from the > system user that's running dspam? An output of dspam_stats is as follows: > > [EMAIL PROTECTED] TP: 0 TN: 0 FP: 0 FN: 0 SC: 0 > NC: > 0 > [EMAIL PROTECTED] TP: 0 TN: 0 FP: 0 FN: 0 SC: 0 NC: > 0 > dspam TP: 87 TN: 8 FP: 1 FN: 7 SC: 0 NC: > 0 > > Notice all counters for the users are 0, however the only one that > increments is the "dspam" user counter. I noticed DSPAM entered a line in > my > users table for "dspam" after I sent the first message through the system. > Every message through the system gets counted in user dspam's counters and > every token and signature is put under that users UID. I see no other > UID's > in the databse. When I do a select on the dspam_stats table, I see only > that > dspam user as well. I deleted the "dspam" user from the users table, and > as > soon as I send another message to ANY user on the system, DSPAM puts the > user back in and starts the counters again. > > As a note, my "/etc/dspam/dspam.d/mysql.conf" file has the following lines > in it to integrate dspam with my existing postfix/mysql virtual users > setup: > > MySQLVirtualTable users > MySQLVirtualUIDField id > MySQLVirtualUsernameField email > > The "users" table is the table I track all valid virtual email addresses > in > that postfix accepts. I figured I would need to tie those together via > those > entries above to make it work properly rather than maintaining 2 separate > tables - One for postfix and one for DSPAM? > > One last note is that in the web frontend, my per-user analysis and > history > data is all correct. One small problem in the History is that when I > retrain > a message, it does not change colors or do anything in the GUI... however, > I > do see a token get added to the database, but again, under the user DSPAM > not the virtual user that I'm logged in as. It appears to be functioning > as > more of a global training method in that respect because of that. > > Hopefully that's enough information to discern what I missed in my > configuration... I can't seem to find anyone having similar issues in the > archives so I figured I'd join the list. I'm sure I probably missed > something small -- or at least I hope so. Thanks in advance! > That's not enough information. Can you post your main.cf, master.cf, the output of "dspam --version" and your dspam.conf file? > Travis > Steve > > > -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger !DSPAM:1011,485edc96150925455511767!
