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
+------------------+-----------------+-----------------------------
| t...@domn2.net | blacklist_from | hiddenu...@gmail.com | 1
| he...@domn1.net| blacklist frol | anyu...@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 t...@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-4mv...@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=<hiddenu...@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-4mv...@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-4mv...@mail.gmail.com>,autolearn=no
autolearn_force=no
May 27 09:46:52 openbsd postfix/pickup[8880]: A3C5D58D19F: uid=506
from=<hiddenu...@gmail.com>
May 27 09:46:52 openbsd postfix/pipe[19192]: 11B4558D135:
to=<t...@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-4mv...@mail.gmail.com>
May 27 09:46:52 openbsd postfix/qmgr[7432]: A3C5D58D19F:
from=<hiddenu...@gmail.com>, size=3059, nrcpt=1 (queue active)
May 27 09:46:52 openbsd dovecot: lda(t...@domn2.net): sieve:
msgid=<CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nxyobpj-4mv...@mail.gmail.com>:
stored mail into mailbox 'INBOX'
May 27 09:46:52 openbsd postfix/pipe[29712]: A3C5D58D19F:
to=<t...@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
