1 Topic by darth_wells

  • darth_wells
  • Member
  • Offline
  • Registered: 2011-10-07
  • Posts: 80

Topic: iredadmin extremely slow to login

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

iRedMail version (check /etc/iredmail-release):
1.0

- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
Debian

- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
mysql
- Web server (Apache or Nginx):
Apache

- Manage mail accounts with iRedAdmin-Pro?
Yes

after upgrade to iRedAdmin-Pro-SQL-4.1.2, login into iredadmin can take between 5 to 15 minutes

----

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

2 Reply by ZhangHuangbin

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

Re: iredadmin extremely slow to login

Do you have many SQL records in database "amavisd"? Please run script "/opt/www/iredadmin/tools/cleanup_amavisd_db.py" manually to clean old records first, then try login again.

3 Reply by darth_wells

  • darth_wells
  • Member
  • Offline
  • Registered: 2011-10-07
  • Posts: 80

Re: iredadmin extremely slow to login

ZhangHuangbin wrote:

Do you have many SQL records in database "amavisd"? Please run script "/opt/www/iredadmin/tools/cleanup_amavisd_db.py" manually to clean old records first, then try login again.



nm2:/usr/share/apache2/iredadmin/tools# ./cleanup_amavisd_db.py
Amavisd is not enabled. SKIP.
nm2:/usr/share/apache2/iredadmin/tools# ./cleanup_db.py
* Backend: mysql
* SQL server: 127.0.0.1:3306
* Delete old admin activity log (> 365 days)
*       - 0 removed, 2761 left.
* Delete old domain ownership verification records (> 30 days)
*       - 0 removed, 0 left.
* Delete expired newsletter subscription confirm tokens (> 24 hours)
*       - 0 removed, 0 left.

nm2:/usr/share/apache2/iredadmin/tools# ps aux | grep amavisd
amavis    1132  0.0  1.0  59624 41792 ?        Ss   07:33   0:00 /usr/sbin/amavisd-new (master)                                                   
amavis    6184  0.0  1.1  63408 46780 ?        S    08:39   0:03 /usr/sbin/amavisd-new (ch18-avail)                                               
amavis    7435  0.0  1.1  63404 46816 ?        S    09:00   0:03 /usr/sbin/amavisd-new (ch18-avail)                                               
amavis    7580  0.0  1.1  63156 46576 ?        S    09:02   0:03 /usr/sbin/amavisd-new (ch15-avail)                                               
amavis    7590  0.0  1.1  63088 46380 ?        S    09:03   0:03 /usr/sbin/amavisd-new (ch18-avail)                                               
amavis    8226  0.0  1.1  62504 46044 ?        S    09:12   0:02 /usr/sbin/amavisd-new (ch12-avail)                                               
amavis    8424  0.1  1.1  63388 46896 ?        S    09:15   0:03 /usr/sbin/amavisd-new (ch15-avail)                                               
amavis    8904  0.1  1.1  63580 46952 ?        S    09:21   0:04 /usr/sbin/amavisd-new (ch18-avail)                                               
amavis    8973  0.0  1.1  62992 46408 ?        S    09:23   0:02 /usr/sbin/amavisd-new (ch11-avail)                                               
amavis    9220  0.0  1.1  63184 46616 ?        S    09:29   0:01 /usr/sbin/amavisd-new (ch9-avail)                                               
amavis    9510  0.1  1.1  63228 46568 ?        S    09:34   0:03 /usr/sbin/amavisd-new (ch16-avail)                                               
amavis    9686  0.1  1.1  62964 46148 ?        S    09:38   0:02 /usr/sbin/amavisd-new (ch11-avail)                                               
amavis    9738  0.0  1.1  62356 45924 ?        S    09:38   0:00 /usr/sbin/amavisd-new (ch4-avail)                                               
amavis   10003  0.0  1.1  62552 46128 ?        S    09:40   0:01 /usr/sbin/amavisd-new (ch7-avail)                                               
amavis   10448  0.0  1.1  62504 45880 ?        S    09:48   0:01 /usr/sbin/amavisd-new (ch6-avail)                                               
amavis   11351  0.2  1.1  62340 45840 ?        S    10:02   0:00 /usr/sbin/amavisd-new (ch3-avail)                                               

I am not sure what Amavisd is not enabled. SKIP.   means?