1 Topic by mr.cocco

  • mr.cocco
  • Member
  • Offline
  • Registered: 2011-07-01
  • Posts: 22

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, file has never been downloaded. 

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 7,939

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 Reply by mr.cocco

  • mr.cocco
  • Member
  • Offline
  • Registered: 2011-07-01
  • Posts: 22

Re: Iredadmin Not Showing Used Quota

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

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

  • HV
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 23

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, 1 downloads since 2012-06-11 

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

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 7,939

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 Reply by HV

  • HV
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 23

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 7,939

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 Reply by HV

  • HV
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 23

Re: Iredadmin Not Showing Used Quota

Thank you, it helps