spamassassin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wma <wes...@e-solutions.re>
Subject SpamAssassin with SQL (userpref table), still get emails
Date Fri, 27 May 2016 05:58:01 GMT
Hi,

I use SpamAssassin-3.4.1p2 on OpenBSD 5.9.
I also use sauserprefs plugin (v1.15-git) in Roundcube 1.1.4.

I have a database 'mail' with the table 'userpref'.
Through the sauserprefs, i can fill the userpref table.

Below a sample :

| username       | preference      | value                 | prefid
+------------------+-----------------+-----------------------------
| test@domn2.net | blacklist_from  | hiddenuser@gmail.com  | 1
| hello@domn1.net| blacklist frol  | anyuser@anydomains.com| 2


In /etc/mail/spamassassin/local.cf, i have theses lines inserted :
user_scores_dsn                 DBI:mysql:mail:localhost
user_scores_sql_username        mailadmin
user_scores_sql_password        mailadmin


In /etc/postfix/master.cf, i have also these lines inserted :

smtp inet  n  -  n   -    -       smtpd -o content_filter=spamassassin

spamassassin
      unix    -       n       n       -       -       pipe
  flags=Rqhu user=_spamdaemon argv=/usr/local/bin/spamc -u _spamdaemon -e 
/usr/sbin/sendmail -oi -f ${sender} ${recipient} ${user}@${domain}


The logs when i send an email from my gmail account to test@domn2.net :
May 27 09:46:47 openbsd postfix/smtpd[3494]: connect from 
mail-yw0-f194.google.com[209.85.161.194]
May 27 09:46:51 openbsd postfix/smtpd[3494]: 11B4558D135: 
client=mail-yw0-f194.google.com[209.85.161.194]
May 27 09:46:51 openbsd postfix/cleanup[17126]: 11B4558D135: 
message-id=<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nXyobpJ-4mVnGg@mail.gmail.com>
May 27 09:46:51 openbsd clamd[16211]: SelfCheck: Database status OK.
May 27 09:46:51 openbsd postfix/qmgr[7432]: 11B4558D135: 
from=<hiddenuser@gmail.com>, size=2625, nrcpt=1 (queue active)
May 27 09:46:51 openbsd spamd[22270]: spamd: connection from localhost 
[127.0.0.1]:31980 to port 783, fd 6
May 27 09:46:51 openbsd spamd[22270]: spamd: processing message 
<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nXyobpJ-4mVnGg@mail.gmail.com> for 
_spamdaemon:506
May 27 09:46:52 openbsd postfix/smtpd[3494]: disconnect from 
mail-yw0-f194.google.com[209.85.161.194] ehlo=2 starttls=1 mail=1 rcpt=1 
data=1 quit=1 commands=7
May 27 09:46:52 openbsd spamd[22270]: spamd: clean message (0.6/5.0) for 
_spamdaemon:506 in 0.9 seconds, 2574 bytes.
May 27 09:46:52 openbsd spamd[22270]: spamd: result: . 0 - 
DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,NO_DNS_FOR_FROM,T_SPF_HELO_TEMPERROR,T_SPF_TEMPERROR

scantime=0.9,size=2574,user=_spamdaemon,uid=506,required_score=5.0,rhost=localhost,raddr=127.0.0.1,rport=31980,mid=<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nXyobpJ-4mVnGg@mail.gmail.com>,autolearn=no

autolearn_force=no
May 27 09:46:52 openbsd postfix/pickup[8880]: A3C5D58D19F: uid=506 
from=<hiddenuser@gmail.com>
May 27 09:46:52 openbsd postfix/pipe[19192]: 11B4558D135: 
to=<test@domn2.net>, relay=spamassassin, delay=2.8, 
delays=1.8/0.01/0/0.95, dsn=2.0.0, status=sent (delivered via 
spamassassin service)
May 27 09:46:52 openbsd postfix/qmgr[7432]: 11B4558D135: removed
May 27 09:46:52 openbsd postfix/cleanup[17126]: A3C5D58D19F: 
message-id=<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nXyobpJ-4mVnGg@mail.gmail.com>
May 27 09:46:52 openbsd postfix/qmgr[7432]: A3C5D58D19F: 
from=<hiddenuser@gmail.com>, size=3059, nrcpt=1 (queue active)
May 27 09:46:52 openbsd dovecot: lda(test@domn2.net): sieve: 
msgid=<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nXyobpJ-4mVnGg@mail.gmail.com>: 
stored mail into mailbox 'INBOX'
May 27 09:46:52 openbsd postfix/pipe[29712]: A3C5D58D19F: 
to=<test@domn2.net>, relay=dovecot, delay=0.04, delays=0.01/0.01/0/0.03, 
dsn=2.0.0, status=sent (delivered via dovecot service)
May 27 09:46:52 openbsd spamd[4840]: prefork: child states: II
May 27 09:46:52 openbsd postfix/qmgr[7432]: A3C5D58D19F: removed

I still get emails in my INBOX.
Any idea ?

And if i use spamd -D -xq
Logs :
May 26 14:56:31.329 [13829] dbg: config: Conf:QL: executing SQL: select 
prefe$
ence, value from userpref where username = '_spamdaemon' or username = 
'@GLOBAL'
  order by username asc
May 26 14:56:31.330 [13829] dbg: config: retrieving prefs for 
_spamdaemon from S
QL server
May 26 14:56:31.331 [13829] dbg: info: user has changed

Thank you very much for your replies, your help.


Cheers,

Wesley

Mime
View raw message