1 Topic by hliguori

  • hliguori
  • Member
  • Offline
  • Registered: 2010-12-04
  • Posts: 12

Topic: Mailbox Quota (way to manage it)

Hi friends,

this is the first time that i use iRedMail, and i'm loving it. But, i'm missing some way to manage the quota from each mailbox, i can insert the limit from quota when i create each account and change this limit editing the account, that is great, but, as the network manage i need to know which mailbox have the full quota used, which have still full quota used, etc... can someone help me?

thanks a lot

Harlei

----

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

2 Reply by BigMichi1

  • BigMichi1
  • Member
  • Offline
  • Registered: 2009-09-21
  • Posts: 27

Re: Mailbox Quota (way to manage it)

use the latest version of postfixadmin 2.3.2 if you are on mysql, there you can see the quota usage
if on ldap use iRedAdmin

3 Reply by hliguori

  • hliguori
  • Member
  • Offline
  • Registered: 2010-12-04
  • Posts: 12

Re: Mailbox Quota (way to manage it)

BigMichi1 wrote:

use the latest version of postfixadmin 2.3.2 if you are on mysql, there you can see the quota usage
if on ldap use iRedAdmin

I use on mysql, and have postfixadmin 2.3.2 from debian stable (lenny) instaled... need i install other postfixadmin version?

4 Reply by ZhangHuangbin

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

Re: Mailbox Quota (way to manage it)

I guess you are looking for this:
http://www.iredmail.org/wiki/index.php? … a.In.MySQL

5 Reply by hliguori

  • hliguori
  • Member
  • Offline
  • Registered: 2010-12-04
  • Posts: 12

Re: Mailbox Quota (way to manage it)

ZhangHuangbin wrote:

I guess you are looking for this:
http://www.iredmail.org/wiki/index.php? … a.In.MySQL

Still...

but there is a way to show the result on the postfixadmin...

there is a configuration on /usr/share/apache2/postfixadmin-2.3.2/config.inc.php like this:

// Optional:
// Show used quotas from Dovecot dictionary backend in virtual
// mailbox listing.
// See: DOCUMENTATION/DOVECOT.txt
//      http://wiki.dovecot.org/Quota/Dict
//
$CONF['used_quotas'] = 'NO';

if i change NO to YES, i have some error showing that vmail.quota does not exist... probably the mysql select or dunno what are wrong, but, i cannot solve this sad

6 Reply by hliguori

  • hliguori
  • Member
  • Offline
  • Registered: 2010-12-04
  • Posts: 12

Re: Mailbox Quota (way to manage it)

hliguori wrote:
ZhangHuangbin wrote:

I guess you are looking for this:
http://www.iredmail.org/wiki/index.php? … a.In.MySQL

Still...

but there is a way to show the result on the postfixadmin...

there is a configuration on /usr/share/apache2/postfixadmin-2.3.2/config.inc.php like this:

// Optional:
// Show used quotas from Dovecot dictionary backend in virtual
// mailbox listing.
// See: DOCUMENTATION/DOVECOT.txt
//      http://wiki.dovecot.org/Quota/Dict
//
$CONF['used_quotas'] = 'NO';

if i change NO to YES, i have some error showing that vmail.quota does not exist... probably the mysql select or dunno what are wrong, but, i cannot solve this sad

Can someone help me on this case?

7 Reply by ZhangHuangbin

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

Re: Mailbox Quota (way to manage it)

hliguori wrote:

if i change NO to YES, i have some error showing that vmail.quota does not exist... probably the mysql select or dunno what are wrong, but, i cannot solve this

Did you create table "vmail.quota"?

In our tutorial, it uses "iredadmin.used_quota" for example, you can change it to "vmail.quota":
http://www.iredmail.org/wiki/index.php? … a.In.MySQL

8 Reply by ZhangHuangbin

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

Re: Mailbox Quota (way to manage it)

I just realize that PostfixAdmin has two options for dovecot dict quota:

# This is for dovecot-1.1.x
$CONF['used_quotas'] = 'NO';

# This is for dovecot-1.2.x
$CONF['new_quota_table'] = 'NO';

Our wiki tutorial uses dovecot-1.2.x, so you should set

$CONF['new_quota_table'] = 'YES'

In our toturial, we add two new columns in exist table "vmail.mailbox", so if you want to use these two columns instead of create a new table, you should modify file: PostfixAdmin-2.3.2/functions.inc.php:

# Change 'quota2' to 'mailbox'.
#$table_quota2 = table_by_key ('quota2');

$table_quota2 = table_by_key ('mailbox');