1 (edited by murali 2021-02-19 01:48:03)

Topic: SQL_error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer?Downloadable Installer
- Linux/BSD distribution name and version: Debian 9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginix
- Manage mail accounts with iRedAdmin-Pro?iRedAdmin-Pro
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

We are recently facing issue that , lot of mails stuck in the queue with many sql errors. More over the user quota
and domian quota is not working. It is allowing more than the quota set to the domain and individual users. Can you please help in resolving this issue.
(
host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=03760-02, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id EGsObHigYw1T failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1034, HY000, DBD::mysql::st execute failed: Incorrect key file for table 'quarantine'; try to repair it at (eval 108) line 172. at (eval 111) line 291. at (eval 111) line 401., id=03760-02 at /usr/sbin/amavisd-new line 17116. (in reply to end of DATA command))




(host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=05879-19, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id Q_Fnqtan3CWc failed: writing mail text to SQL failed: Error closing, flush: sql inserting text failed, sql exec: err=1034, HY000, DBD::mysql::st execute failed: Incorrect key file for table 'quarantine'; try to repair it at (eval 108) line 172. at (eval 111) line 255. at (eval 111) line 118. at (eval 111) line 401., id=05879-19 at /usr/sbin/amavisd-new line 17116. (in reply to end of DATA command)



Quarantined mails are not displayed at all

I found a new problem in admin panel.  As a global admin i am allocating 200GB as domain quota and max per user quota as 5GB.
But domain admin could change the user quota to unlimited, by setting the value to 0 (domain admin should not be able to change max mailbox set by the global admin but domain admin is able to change) and users are able to receive mails even after the domain quota of 200GB exceeded.  We are having 3 separate servers with  iRedamin-Pro license, but in all the 3 servers we are facing the same issue. Please some one help me resolve the issue.

Thanks in advance

----

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

2

Re: SQL_error

murali wrote:

host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=03760-02, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id EGsObHigYw1T failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1034, HY000, DBD::mysql::st execute failed: Incorrect key file for table 'quarantine'; try to repair it at (eval 108) line 172. at (eval 111) line 291. at (eval 111) line 401., id=03760-02 at /usr/sbin/amavisd-new line 17116. (in reply to end of DATA command))

This seems a SQL issue caused by something like incident power off, you'd better repair the sql table first.

murali wrote:

But domain admin could change the user quota to unlimited, by setting the value to 0 (domain admin should not be able to change max mailbox set by the global admin but domain admin is able to change) and users are able to receive mails even after the domain quota of 200GB exceeded.  We are having 3 separate servers with  iRedamin-Pro license, but in all the 3 servers we are facing the same issue. Please some one help me resolve the issue.

Which iRedAdmin-Pro version are you running? Please upgrade to the latest version and try again.