1 Topic by swaclawski

  • swaclawski
  • Member
  • Offline
  • Registered: 2014-12-09
  • Posts: 30

Topic: LDA and e-mails in iRedAdmin-Pro

==== Required information ====
- iRedMail version: iRedamin-Pro-1.9.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04
- Related log if you're reporting an issue:
====

Hello,

I have some of the messages marked SPAM (i receive e-mail with notifications about them to root account). From what I can see the are going to Mailboxes via LDA.
Somehow I cannot see them in iRedAdmin-Pro in logs.

Any idea?

----

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: LDA and e-mails in iRedAdmin-Pro

Please show us output of below commands to help troubleshoot:

# grep '\$final_' /etc/amavis/conf.d/50-user
# grep '_sql_storage' /etc/amavis/conf.d/50-user

3 Reply by swaclawski

  • swaclawski
  • Member
  • Offline
  • Registered: 2014-12-09
  • Posts: 30

Re: LDA and e-mails in iRedAdmin-Pro

First:

root@mail1:/home/euro# grep '\$final_' /etc/amavis/conf.d/50-user
$final_virus_destiny      = D_DISCARD;
$final_banned_destiny     = D_PASS;
$final_spam_destiny       = D_PASS;
$final_bad_header_destiny = D_PASS;

Second:

root@mail1:/home/euro# grep '_sql_storage' /etc/amavis/conf.d/50-user
root@mail1:/home/euro#

4 Reply by ZhangHuangbin

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

Re: LDA and e-mails in iRedAdmin-Pro

Oh, sorry, my mistake in second command, it should be:

# grep '_sql_dsn' /etc/amavis/conf.d/50-user

5 Reply by ZhangHuangbin

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

Re: LDA and e-mails in iRedAdmin-Pro

swaclawski wrote:

$final_spam_destiny       = D_PASS;

D_PASS means Amavisd will deliver detected spam to mailbox.

Please show us output of below command:

# grep '\$spam_quarantine_' /etc/amavis/conf.d/50-user

6 Reply by swaclawski

  • swaclawski
  • Member
  • Offline
  • Registered: 2014-12-09
  • Posts: 30

Re: LDA and e-mails in iRedAdmin-Pro

root@mail1:/home/euro# grep '_sql_dsn' /etc/amavis/conf.d/50-user
#   - 'sql:', quarantine mail in SQL server specified in @storage_sql_dsn.
@storage_sql_dsn = (
#@lookup_sql_dsn =  (
root@mail1:/home/euro#

7 Reply by swaclawski

  • swaclawski
  • Member
  • Offline
  • Registered: 2014-12-09
  • Posts: 30

Re: LDA and e-mails in iRedAdmin-Pro

root@mail1:/home/euro# grep '\$spam_quarantine_' /etc/amavis/conf.d/50-user
$spam_quarantine_method = undef;
#$spam_quarantine_method = 'sql:';
#$spam_quarantine_to = 'spam-quarantine';
root@mail1:/home/euro#

8 Reply by ZhangHuangbin

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

Re: LDA and e-mails in iRedAdmin-Pro

Try to set below settings in /etc/amavis/conf.d/50-user:

$final_spam_destiny       = D_DISCARD;
$spam_quarantine_method = 'sql:';
$spam_quarantine_to = 'spam-quarantine';

Restarting Amavisd is required. Amavisd will quarantine detected spam to SQL database, then you can manage them with iRedAdmin-Pro.

9 Reply by swaclawski

  • swaclawski
  • Member
  • Offline
  • Registered: 2014-12-09
  • Posts: 30

Re: LDA and e-mails in iRedAdmin-Pro

I have changed as requested. Will test it and let you know.