1

Topic: Iredadmin Not Showing Used Quota

==== Provide required information ====
- iRedMail version and backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Any related log? Log is helpful for troubleshooting.
==== ==== Provide required information ====
- iRedMail version and backend (LDAP/MySQL/PGSQL):iRedAdmin-Pro-LDAP
- Linux/BSD distribution name and version:Centos
- Any related log? Log is helpful for troubleshooting.
====

In the view "Users under domain" i cannot see per user used quota.

Can you help me also for this problem?

Post's attachments

quota.jpg
quota.jpg 73.8 kb, 1 downloads since 2012-06-01 

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

2

Re: Iredadmin Not Showing Used Quota

Do you have "show_used_quota = True" in iRedAdmin-Pro config file (settings.ini)? For example:

[general]
...
show_used_quota = True

Restarting Apache web server is required after updating settings.ini.

3

Re: Iredadmin Not Showing Used Quota

Sorry, I was closing this ticket by myself. I've found the solution reading the forum.

4 (edited by HV 2012-06-11 21:57:17)

Re: Iredadmin Not Showing Used Quota

I can see correct information about quota for some domain and for some other domain quota information is incorrect. Can you say me why?
See attached pictures.
1. Quota per domain - yes, quota per user - no
2. Quota per domain - yes, quota per user - yes

iRedAdmin-Pro-MySQL
ver. 1.4.0

Post's attachments

quota.jpg
quota.jpg 95.62 kb, 2 downloads since 2012-06-11 

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

5

Re: Iredadmin Not Showing Used Quota

Dear HV,

May i know the version of iRedMail and Linux/BSD distribution you're running? Is your iRedMail server upgraded from an old iRedMail release?

I see david@ has 9.9TB as mailbox quota, you mean it's incorrect?

Could you please show me below info to help troubleshoot:

1: Go to user profile page of david@ (click the Gear icon), tell me what the quota is displayed in profile page.
2: Paste me output of below SQL command (replace 'david@[DOMAIN]' by the real email address):

sql> USE vmail;
sql> SELECT username, quota, active FROM mailbox WHERE username = 'david@[DOMAIN]';
sql> SELECT * FROM used_quota WHERE username = 'david@[DOMAIN]';

6

Re: Iredadmin Not Showing Used Quota

I'm sorry, informations about my system are here:
iRedAdmin-Pro-MySQL
ver. 1.4.0
openSUSE 12.1 (x86_64)

Domain quota for David's domain is 10GB and I see this now:
david@[DOMAIN]         10.1 TB / Unlimited

1. Mailbox Quota - nothing/clear MB (quota is for domain only)
2.
mysql> SELECT username, quota, active FROM mailbox WHERE username = 'david@[DOMAIN]';
+----------------+-------+--------+
| username       | quota | active |
+----------------+-------+--------+
| david@[DOMAIN] |     0 |      1 |
+----------------+-------+--------+
1 row in set (0.00 sec)

mysql> SELECT * FROM used_quota WHERE username = 'david@[DOMAIN]';
+----------------+----------+----------+
| username       | bytes    | messages |
+----------------+----------+----------+
| david@[DOMAIN] | 10593909 |       46 |
+----------------+----------+----------+
1 row in set (0.01 sec)

7

Re: Iredadmin Not Showing Used Quota

Dear HV,

This is a bug in iRedAdmin-Pro-MySQL (and iRedAdmin-Pro-PGSQL).

You can fix it manually with below steps:

1: Copy templates/default/mysql/user/list.html to other directory as a backup copy.
2: Open file templates/default/mysql/user/list.html, find line 100:

                            <td class="vcenter">{{ usedQuotaBytes |filesizeformat(baseMB=True) }} / {{ _('Unlimited') }}</td>

3: Remove (baseMB=True), save changes.

                            <td class="vcenter">{{ usedQuotaBytes |filesizeformat }} / {{ _('Unlimited') }}</td>

That's all.

This fix will be available in next release of iRedAdmin-Pro-MySQL and iRedAdmin-Pro-PGSQL. Thanks very much for your feedback. smile

8

Re: Iredadmin Not Showing Used Quota

Thank you, it helps