1 Topic by adipose (edited by adipose 2021-02-12 09:08:05)

  • adipose
  • Member
  • Offline
  • Registered: 2020-10-29
  • Posts: 11

Topic: Quota does not show correctly on "users under domain"

- iRedMail version 1.3.2
- Deployed with downloadable installer
- Linux/BSD distribution name and version: Ubuntu 18
- Store mail accounts in MySQL
- Web server: Nginx
- Manage mail accounts with iRedAdmin-Pro: yes

The quotas are not showing for all users in the "users under domain" view.  If you click on an individual user, you can see the total emails and space used, but on the main page, it simply shows

0% (0 Emails / 0) / 1 GB

Nothing seems to get these to show up. I recalculated quotas, but it didn't change what showed on the main page.  Since it seems to know the quota, but can't find it for the main page, it seems like an interface bug.

----

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

2 Reply by adipose

  • adipose
  • Member
  • Offline
  • Registered: 2020-10-29
  • Posts: 11

Re: Quota does not show correctly on "users under domain"

I just noticed that the same accounts don't show "last login," either--despite having logged in.

3 Reply by adipose

  • adipose
  • Member
  • Offline
  • Registered: 2020-10-29
  • Posts: 11

Re: Quota does not show correctly on "users under domain"

I solved it.  Turns out that you can create vmail.mailbox with mixed case, but the rest of the tables are lowercase by default.  SQL joins just fine, but python doesn't recognize it is the same email.

Probably should be fixed in the python to grab lower() of the email, but for now I just updated my database.

4 Reply by ZhangHuangbin

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

Re: Quota does not show correctly on "users under domain"

The "username" column in "vmail.mailbox" table must be in lower cases.