-------- 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,485d84c4150926145425493!
