1

Topic: Release Quarantined Mails from Phpmyadmin

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP:
- Linux/BSD distribution name and version: Centos 6.5
- Related log if you're reporting an issue:
====

Is it possible to release quarantined mails from Phpmyadmin? if yes how?

----

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

2

Re: Release Quarantined Mails from Phpmyadmin

Releasing quarantined mail requires invoking 'amavisd-release' command. Refer to our wiki tutorial for sample usage:
http://www.iredmail.org/wiki/index.php? … g.Messages

3

Re: Release Quarantined Mails from Phpmyadmin

ZhangHuangbin wrote:

Releasing quarantined mail requires invoking 'amavisd-release' command. Refer to our wiki tutorial for sample usage:
http://www.iredmail.org/wiki/index.php? … g.Messages

Thanks Zhang,

i always use it but i see the lbdata1 is very huge about 44GB,i emptied quarantine table data which was 38GB and msg table data which was 4GB large but still i  see no difference .

drwxr-xr-x.  8 mysql mysql 4.0K Jul  8 10:46 .
drwxr-xr-x. 24 root  root  4.0K Feb  6 17:47 ..
drwx------.  2 mysql mysql 4.0K Jul  7  2012 amavisd
-rw-rw----.  1 mysql mysql  44G Jul  8 11:11 ibdata1
-rw-rw----.  1 mysql mysql 5.0M Jul  8 11:11 ib_logfile0
-rw-rw----.  1 mysql mysql 5.0M Jul  8 10:34 ib_logfile1
drwx------.  2 mysql mysql 4.0K Sep  5  2011 iredadmin
drwx------.  2 mysql mysql 4.0K Sep  5  2011 mysql
srwxrwxrwx   1 mysql mysql    0 Jul  8 10:46 mysql.sock
drwx------.  2 mysql mysql 4.0K Jul  8 10:47 policyd
drwx------.  2 mysql mysql 4.0K Sep  5  2011 roundcubemail
drwx------.  2 mysql mysql 4.0K Sep  5  2011 test

I have tried to remove via command line manually but  no row is affected,it is like the quarantined mails no longer exists

mysql> DELETE FROM msgs               WHERE content IN ('S', 's', 'V', 'Y')               AND quar_type IN ('Q', 'F')               AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY));
Query OK, 0 rows affected (0.00 sec)

4

Re: Release Quarantined Mails from Phpmyadmin

It's safe to truncate all SQL tables in Amavisd, they're just basic info (sender/recipient, subject, date) of in/out emails.

5

Re: Release Quarantined Mails from Phpmyadmin

ZhangHuangbin wrote:

It's safe to truncate all SQL tables in Amavisd, they're just basic info (sender/recipient, subject, date) of in/out emails.

Thanks for your reply,i truncated all the sql tables in amavisd database as per your suggestion and restarted MySQL as well as amavisd but no changes in size i still see /var/lib/mysql taking almost 44gb of space.

45752504        /var/lib/mysql.

6

Re: Release Quarantined Mails from Phpmyadmin

Which files under /var/lib/mysql take most disk space?

7

Re: Release Quarantined Mails from Phpmyadmin

ZhangHuangbin wrote:

Which files under /var/lib/mysql take most disk space?

ibdata1

-rw-rw----.  1 mysql mysql  44G Jul  8 17:23 ibdata1

8

Re: Release Quarantined Mails from Phpmyadmin

Reference: http://stackoverflow.com/questions/3456 … e-in-mysql

9

Re: Release Quarantined Mails from Phpmyadmin

Thanks i will try during off peak hours.

10

Re: Release Quarantined Mails from Phpmyadmin

Bozra wrote:

Thanks i will try during off peak hours.

Just to be sure for the case of iRedMAill  system ( i will backup and restore the following databases) namely amavisd,iredadmin,policyd and roundcubemail.

Is there a need to backup and  restore procedures and triggers  ? is  information_schema db the same as performance_schema as refered on the link you provided?

11

Re: Release Quarantined Mails from Phpmyadmin

No.