1 Topic by urbanekp

  • urbanekp
  • Member
  • Offline
  • Registered: 2011-10-10
  • Posts: 17

Topic: Store SpamAssassin bayes in SQL - not working

==== Required information ====
- iRedMail version: v1.8.1 (pro)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  mysql
- Web server (Apache or Nginx): apache
- Linux/BSD distribution name and version: wheezy/sid
- Related log if you're reporting an issue:
====

I set up SpamAssassin Bayes mysql
the instructions http://www.iredmail.org/docs/store.spam … n.sql.html

Rouncube plugin works.
The following data into mysql. Marks and moves spam to a junk folder.

newcomers emails (spam) are not sorted as spam, but as a normal email.
In doing so, we have to click on the label is spam. (repeated 10 times on the same emails)

In the settings local.cf have everything according to instructions
plus

bayes_min_ham_num 1
bayes_min_spam_num 3

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Store SpamAssassin bayes in SQL - not working

What do you mean "not working"? You reported several emails and it should mark the same email as spam immediately?

3 Reply by urbanekp

  • urbanekp
  • Member
  • Offline
  • Registered: 2011-10-10
  • Posts: 17

Re: Store SpamAssassin bayes in SQL - not working

Yes, I mark spam 3x and should then automatically be filtered as spam.
When you get a correct email and is marked as spam, click the Not Spam and the next has come as a correct email.

I do not have many users, I for one spam email could let's handle is spam 200x.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Store SpamAssassin bayes in SQL - not working

Dear urbanekp,

I suggest you read articles listed on Bayes FAQ page first (it's mentioned in our tutorial, section 'References'):
http://wiki.apache.org/spamassassin/BayesFaq

5 Reply by urbanekp

  • urbanekp
  • Member
  • Offline
  • Registered: 2011-10-10
  • Posts: 17

Re: Store SpamAssassin bayes in SQL - not working

I read section References.
What exactly do you mean?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Store SpamAssassin bayes in SQL - not working

urbanekp wrote:

In doing so, we have to click on the label is spam. (repeated 10 times on the same emails)

Reporting same email 10 times doesn't increase the learn data in bayes database. It's same as learnt one email.

Please try to follow this tutorial to always insert 'X-Spam-*' headers on all emails:
http://www.iredmail.org/docs/no.x-spam.headers.html

Then you can check email header to see whether sa-learn is working.

7 Reply by urbanekp

  • urbanekp
  • Member
  • Offline
  • Registered: 2011-10-10
  • Posts: 17

Re: Store SpamAssassin bayes in SQL - not working

it is possible to reduce the number of emails that must be reported as spam to be marked as spam email?

at 200 emails it works as it should.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Store SpamAssassin bayes in SQL - not working

*) why so rush?
*) You already have the answer:

bayes_min_spam_num 3

Reference: http://wiki.apache.org/spamassassin/BayesNotWorking