1 Topic by kmihalj

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Topic: Releasing mail from quarantine ...

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.3
- Linux/BSD distribution name and version: CentOS 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Ldap
- Web server (Apache or Nginx):Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue: don't know where to look
====

I set spam, virus, banned to go to quarantine, ... but when I release mail from quarantine, It disepar from Quarantine list, but there in no that mail in users inbox .... where it should be afther I release them ...

Where is that mail gone ? And how can I achieve correct behaviour for Release function ?

----

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

kmihalj's Website

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

Released email should be delivered to user's mailbox. Did you see any error in Postfix log file after released email?

3 Reply by kmihalj (edited by kmihalj 2015-12-26 21:11:05)

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

I got in maillog this when I release mail from quarantene:

Dec 26 14:07:56 iredmail amavis[27063]: (rel-HLR6lg3hxKkc) Amavis::IO::SQL::open key=nEmlMTp0FmTz, p_tag=0: no such record
Dec 26 14:07:56 iredmail amavis[27063]: (rel-HLR6lg3hxKkc) (!!)policy_server FAILED: Can't open sql obj for reading: Nema takve datoteke ili direktorija at (eval 125) line 376, <GEN17> line 5.

croatian: Nema takve datoteke ili direktorija
english: no such file or directory

kmihalj's Website

4 Reply by kmihalj

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

Found in logwatch every day

Miscellaneous warnings ------------------------------------------------------------------
        1      policy_server FAILED: Can't open sql obj for reading: Nema takve datoteke ili direk...

kmihalj's Website

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

Do you have correct SQL username/password in Amavisd setting: @storage_sql_dsn (and @lookup_sql_dsn if it's enabled)?

6 Reply by kmihalj (edited by kmihalj 2015-12-28 16:15:53)

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

password are ok for @storage_sql_dsn
@lookup_sql_dsn is set like this so it should be ok also
@lookup_sql_dsn = @storage_sql_dsn;

All looks good, except I cannot release any mail from quarantene sad

kmihalj's Website

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

kmihalj wrote:

Dec 26 14:07:56 iredmail amavis[27063]: (rel-HLR6lg3hxKkc) Amavis::IO::SQL::open key=nEmlMTp0FmTz, p_tag=0: no such record

Looks like i misunderstood this log. It cannot find requested SQL record of quarantined mail.

Did it happen every time? or just some times (but frequently)?

8 Reply by kmihalj

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

It happen every time I release mail from quarantine .... mail disepears from list in iRedAdmin Pro, but no released mail in users inbox.

kmihalj's Website

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

Is it possible to let me login to your server for deeper debug? If it's ok, please contact me: zhb _at_ iredmail.org.

10 Reply by kmihalj

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

I found way to release mail from quarantine ....

file /var/spool/amavisd/amavisd.sock does not exist, but file /var/run/amavisd/amavisd.sock does.

I changed in /bin/amavisd-release:
#  $socketname = '/var/spool/amavisd/amavisd.sock';
  $socketname = '/var/run/amavisd/amavisd.sock';

In iRedAdmin Pro I "expand" header of quarantined mail .... and find line X-Quarantine-ID and value in that

than on CLI I use command

amavisd-release ID

and with sock properly set I can release mail ....

but still I cannot release quarantined mail from iRedAdminPro web gui. When I try to release from web gui in log i get error as such as this:

Jan  7 11:20:59 iredmail amavis[12304]: (rel-Pjp9b0qoJeEH) Amavis::IO::SQL::open key=GPW4UFaZOgBE, p_tag=0: no such record
Jan  7 11:20:59 iredmail amavis[12304]: (rel-Pjp9b0qoJeEH) (!!)policy_server FAILED: Can't open sql obj for reading: Nema takve datoteke ili direktorija at (eval 125) line 376, <GEN27> line 4.

and mail is deleted from database, but not released to users inbox.

...

Post's attachments

Obilježeno_010.png
Obilježeno_010.png 3.45 kb, file has never been downloaded. 

Obilježeno_011.png
Obilježeno_011.png 9.66 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

kmihalj's Website

11 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

Releasing quarantined email through socket should be just fine as it's defined in Amavisd official document:
https://www.ijs.si/software/amavisd/README.protocol.txt

The command used to release quarantined in iRedAdmin-Pro works fine if you run it on shell manually:

$ telnet localhost 9998

request=release
mail_id=xxxxxxxxxxxx
secret_id=xxxxxxxxxxxx
quar_type=Q

I'm confused too because i cannot reproduce this issue on my testing machine, and no other customer reported this issue.

I suggest you to ask in Amavisd mailing list instead:
https://www.ijs.si/software/amavisd/#support

12 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Releasing mail from quarantine ...

Dear kmihalj,

I fixed this issue today, here's patch:
http://www.iredmail.org/forum/post45790.html#p45790

13 Reply by kmihalj

  • kmihalj
  • Member
  • Offline
  • From: Croatia
  • Registered: 2013-07-03
  • Posts: 78

Re: Releasing mail from quarantine ...

ZhangHuangbin wrote:

Dear kmihalj,

I fixed this issue today, here's patch:
http://www.iredmail.org/forum/post45790.html#p45790

Thanx !!! big_smile

now all parts of mailserver works great

kmihalj's Website