Re: [dspam-users] DSPAM Virtual Users Problem using Postfix & MySQL

-------- Original-Nachricht --------
> Datum: Sat, 21 Jun 2008 10:06:56 -0500
> Von: "Administrator" <admin@solutionsix.com>
> An: dspam-users@lists.nuclearelephant.com
> 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:
>
> admin@solutionsix.com TP: 0 TN: 0 FP: 0 FN: 0 SC: 0
> NC:
> 0
> td@travisdangel.com 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!