Aug 5, 2024: iRedMail-1.7.1 has been released.

**Casa.it** · 2011-03-14 22:42:22

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Topic: iRedAdmin 1.4.1

Hi

i have a problem with iredamin webpage after upgrade 1.4.1, it seems very slow, in the apache log i have this error:

[info] mod_wsgi (pid=30518): Cleanup interpreter ''.
[info] mod_wsgi (pid=30518): Terminating Python.
[error] Exception KeyError: KeyError(140701189789504,) in <module 'threading' from '/usr/lib/python2.6/threading.pyc'> ignored

Is this correct? and may be causing the slowness?

Thks

Enrico

----

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

**ZhangHuangbin** · 2011-03-14 23:21:49

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

This is strange. Does restarting apache fix it?

**Casa.it** · 2011-03-14 23:32:24

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

This is strange. Does restarting apache fix it?

I have restart apache, but this don't fix it.

I also set log to debug but there is only this error.

**ZhangHuangbin** · 2011-03-15 00:14:23

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

Which version of web.py do you use? check it with below command:

$ python -c "import web; print web.__version__"
0.34

If you're not running web.py-0.34 (the latest version), please try to install it via "easy_install":

# easy_install web.py

**Casa.it** · 2011-03-15 00:34:31

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

Which version of web.py do you use? check it with below command:
$ python -c "import web; print web.__version__"
0.34
If you're not running web.py-0.34 (the latest version), please try to install it via "easy_install":
# easy_install web.py

yes i have 0.33 version, now i have upgrade, there is other to upgrade? thks

**ZhangHuangbin** · 2011-03-15 00:36:55

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

Casa.it wrote:

yes i have 0.33 version, now i have upgrade, there is other to upgrade? thks

Is web.py v0.34 now? Does the issue happen again?

**Casa.it** · 2011-03-15 00:49:15

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

Does the issue happen again?

Yes now is the 0.34 version. the iredadmin is slow to connect to the dashboard.

there isn't error in the error.log

Thks

**ZhangHuangbin** · 2011-03-15 01:00:23

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

Casa.it wrote:

Yes now is the 0.34 version. the iredadmin is slow to connect to the dashboard.

- How about other pages? only dashboard is slow? or all pages?
- How many records do you have in MySQL database "amavisd" (table "msgs" and "maddr")? It will query this database when you accessing Dashboard page.
- iRedAdmin-Pro-LDAP has new user interface since v1.4.0, it will load more JavaScript/CSS files, so it will be a little slower than old versions, depends on your network bandwidth.

**Casa.it** · 2011-03-15 17:02:16

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

Casa.it wrote:
Yes now is the 0.34 version. the iredadmin is slow to connect to the dashboard.
- How about other pages? only dashboard is slow? or all pages?
- How many records do you have in MySQL database "amavisd" (table "msgs" and "maddr")? It will query this database when you accessing Dashboard page.
- iRedAdmin-Pro-LDAP has new user interface since v1.4.0, it will load more JavaScript/CSS files, so it will be a little slower than old versions, depends on your network bandwidth.

it's slow only in dashboard page, table msgs and maddr ha 2 milion of records, is it too?

can i delete this table?

Thks

**ZhangHuangbin** · 2011-03-15 17:39:53

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

hmm, 2 million. that's the problem. MySQL will take some time to query this database and show you statistics result.

With iRedAdmin-Pro-LDAP-1.4.0 and newer versions, when you access "System -> Sent Mails" or "Received Mails", it will delete records in table "msgs", 'msgrcpt' automatically which were older than 90 (default value) days. when you access "System -> Quarantined Mails", it will delete records in table "quarantine" automatically which were older than 30 (default value) days.

You can change default value in libs/iredutils.py:

AMAVISD_REMOVE_MAILLOG_IN_DAYS = 90
AMAVISD_REMOVE_QUARANTINED_IN_DAYS = 30

**ZhangHuangbin** · 2011-03-15 17:41:19

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

You can find RAW SQL command used to delete them manually or via crontab here:
http://www.iredmail.org/forum/topic1692 … -mail.html
http://www.iredmail.org/forum/post7893.html#p7893

**Casa.it** · 2011-03-15 17:49:10

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ok I understand the problem!

Thks a lot!

**Casa.it** · 2011-03-15 18:07:41

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

the table with many records is msgs and msgrcpt.

I try to cancel with the link that you have posted but this don't' run, records are the same.

**ZhangHuangbin** · 2011-03-15 18:56:31

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

Casa.it wrote:

I try to cancel with the link that you have posted but this don't' run, records are the same.

What did you do? How many days do you want to keep?

**Casa.it** · 2011-03-15 21:35:08

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

What did you do? How many days do you want to keep?

i want to keep a 7 days sent and receive mail

**ZhangHuangbin** · 2011-03-15 22:36:30

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

What did you do?

Try to set 'AMAVISD_REMOVE_MAILLOG_IN_DAYS = 7' and visit "System -> Sent Mails', iRedAdmin-Pro will delete records which older than 7 days.

**Casa.it** · 2011-03-15 23:08:19

Casa.it
Member
Offline

Registered: 2010-06-15
Posts: 75

Re: iRedAdmin 1.4.1

ZhangHuangbin wrote:

What did you do?
Try to set 'AMAVISD_REMOVE_MAILLOG_IN_DAYS = 7' and visit "System -> Sent Mails', iRedAdmin-Pro will delete records which older than 7 days.

For the future is possible to make a search for sent and receive mail? search for sender, search for recipient.

Now is ok Thks!

**ZhangHuangbin** · 2011-03-15 23:44:58

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,135

Re: iRedAdmin 1.4.1

Casa.it wrote:

For the future is possible to make a search for sent and receive mail? search for sender, search for recipient.

Sender/recipient based searching is high priority on my TODO list, it will be available in next release.

Aug 5, 2024: iRedMail-1.7.1 has been released.

iRedAdmin 1.4.1

Posts: 18

1 Topic by Casa.it 2011-03-14 22:42:22

Topic: iRedAdmin 1.4.1

2 Reply by ZhangHuangbin 2011-03-14 23:21:49

Re: iRedAdmin 1.4.1

3 Reply by Casa.it 2011-03-14 23:32:24

Re: iRedAdmin 1.4.1

4 Reply by ZhangHuangbin 2011-03-15 00:14:23

Re: iRedAdmin 1.4.1

5 Reply by Casa.it 2011-03-15 00:34:31

Re: iRedAdmin 1.4.1

6 Reply by ZhangHuangbin 2011-03-15 00:36:55

Re: iRedAdmin 1.4.1

7 Reply by Casa.it 2011-03-15 00:49:15

Re: iRedAdmin 1.4.1

8 Reply by ZhangHuangbin 2011-03-15 01:00:23

Re: iRedAdmin 1.4.1

9 Reply by Casa.it 2011-03-15 17:02:16

Re: iRedAdmin 1.4.1

10 Reply by ZhangHuangbin 2011-03-15 17:39:53

Re: iRedAdmin 1.4.1

11 Reply by ZhangHuangbin 2011-03-15 17:41:19

Re: iRedAdmin 1.4.1

12 Reply by Casa.it 2011-03-15 17:49:10

Re: iRedAdmin 1.4.1

13 Reply by Casa.it 2011-03-15 18:07:41

Re: iRedAdmin 1.4.1

14 Reply by ZhangHuangbin 2011-03-15 18:56:31

Re: iRedAdmin 1.4.1

15 Reply by Casa.it 2011-03-15 21:35:08

Re: iRedAdmin 1.4.1

16 Reply by ZhangHuangbin 2011-03-15 22:36:30

Re: iRedAdmin 1.4.1

17 Reply by Casa.it 2011-03-15 23:08:19

Re: iRedAdmin 1.4.1

18 Reply by ZhangHuangbin 2011-03-15 23:44:58

Re: iRedAdmin 1.4.1

Posts: 18