Hello Stevan,

Tnx for the reply.

Il 15/06/2011 21.23, Stevan Bajić ha scritto:
> On Wed, 15 Jun 2011 13:21:19 +0200
> Claudio Prono <[email protected]> wrote:
>
>> Hello all,
>>
> Hello Claudio,
>
>
>> After a recent migration of a mailserver i have some problems with the
>> training of dspam: when i send a mail for retraining, i have this on logs:
>>
>> Jun 15 12:50:55 mail2 dspam[27718]: Signature retrieval for
>> '2,4df84600159243584
>> 817994' failed
>> Jun 15 12:50:55 mail2 dspam[27718]: Unable to find a valid signature.
>> Aborting.
>> Jun 15 12:50:55 mail2 dspam[27718]: process_message returned error -5. 
>> dropping
>>  message.
>>
>> I have checked, the signature is present into the database, but the
>> query of dspam is wrong (i have activate the mysql debug):
>>
>>      33 Connect   dspam@localhost on dspam
>>                    33 Query     SELECT uid FROM dspam_virtual_uids WHERE
>> username='spam'
>>                    33 Query     SHOW VARIABLES WHERE
>> variable_name='max_allowed_packet'
>>                    33 Query     SHOW VARIABLES WHERE
>> variable_name='max_allowed_packet'
>>                    33 Query     SELECT uid FROM dspam_virtual_uids WHERE
>> username='spam'
>>                    33 Query     SELECT uid FROM dspam_virtual_uids WHERE
>> username='spam'
>>
>> The username is always wrong, is not spam but the username of the sender
>> e-mail (like [email protected]).
>>
> this depends on how you have implemented that retraining.
>
>
>> Here is my relevant config on postfix:
>>
>> in master.cf:
>>
>> dspam     unix  -       n       n       -       10       pipe
>>   flags=u user=nobody argv=/usr/sbin/dspam --deliver=innocent
>> --feature=noise --user ${recipient}
>> spam    unix    -       n       n       -       -       pipe
>>   flags=u user=nobody argv=/usr/sbin/dspam --class=spam --source=error
>> --user spam
>> nospam  unix    -       n       n       -       -       pipe
>>   flags=u user=nobody argv=/usr/sbin/dspam --class=innocent
>> --source=error --user spam
>>
> Aha. See that "--user spam" in the process "spam" and "nonspam"?
>
>
Yes, i have noticed that, but with the config "ChangeUserOnParse full",
the user is changed with the rcpt to of the mail, according with the
documentation:

# ChangeUserOnParse: Automatically change the username to match that
specified
#   in the To: header. For example, [email protected] will set the
username
#   to bob, ignoring any --user passed in. This may not always be
desirable if
#   you are using virtual email addresses as usernames. Options:
#     on or user        take the portion before the @ sign only
#     full              take everything after the initial {spam,notspam}-.

Is right?
>> And my dspam.config of mysql:
>>
>> MySQLServer     /var/run/mysql/mysql.sock
>> MySQLPort
>> MySQLUser               dspam
>> MySQLPass               [pass]
>> MySQLDb                 dspam
>> MySQLCompress           true
>> MySQLVirtualTable          dspam_virtual_uids
>> MySQLVirtualUIDField       uid
>> MySQLVirtualUsernameField  username
>> MySQLUIDInSignature    on
>>
> This is all fine and dandy but the real relevant config is how you have setup 
> DSPAM to parse the user. Have you set "ParseToHeaders", "ChangeModeOnParse" 
> and/or "ChangeUserOnParse"?
>
here is my settings:

ParseToHeaders on
ChangeModeOnParse on
ChangeUserOnParse full

The thing i don't understand is: if i change  this values (like
ChangeUSerOnParse on), the mysql query is always done with the user
spam.....

The last thing i have tryied also is add the option "Broken
lineStripping", but nothing has changed....

What i can try ?

Cordially,

Claudio.

-- 
--------------------------------------------------------------------------------
Claudio Prono                         OPST
System Developer               
                                      Gsm: +39-349-54.33.258
@PSS Srl                              Tel: +39-011-32.72.100
Via San Bernardino, 17                Fax: +39-011-32.46.497
10141 Torino - ITALY                  http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc





------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Dspam-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to