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! Travis !DSPAM:1011,485d1917150921290420445!
