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

**Kyle Harris** · 2014-01-24 07:28:33

Kyle Harris
Member
Offline

Registered: 2013-11-23
Posts: 13

Topic: "internal server error" when trying to modify domain attributes

==== Required information ====
- iRedMail version: MySQL v1.8.1 with patch as discussed below
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS 6.5
- Related log if you're reporting an issue:
====

Hello,

I finally got through my issue at the follow post:
http://www.iredmail.org/forum/topic5975 … perly.html

Now, I am having a very similar issue when I click on any of the domains under "Domains and Accounts". If I click on the domain or the gear icon for "Edit account profile" I get the same thing, "internal server error". So now I have no way to modify the domain properties of any of the hosted domains.

Can this be reproduced or should I create a support ticket?

Thank you.

Kyle

----

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

**ZhangHuangbin** · 2014-01-24 11:03:59

ZhangHuangbin
iRedMail Developers
Offline

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

Re: "internal server error" when trying to modify domain attributes

Any related error log in Apache log file? Apache always log detailed log of "internal server error" error.

**Kyle Harris** · 2014-01-24 18:57:39

Kyle Harris
Member
Offline

Registered: 2013-11-23
Posts: 13

Re: "internal server error" when trying to modify domain attributes

Hi Zhang,

Sorry, didn't think to look. Yes, all kinds of stuff. See below. Thoughts?

[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] Traceback (most recent call last):
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/application.py", line 239, in process
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return self.handle()
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/application.py", line 230, in handle
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return self._delegate(fn, self.fvars, args)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/application.py", line 420, in _delegate
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return handle_class(cls)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/application.py", line 396, in handle_class
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return tocall(*args)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/var/www/iredadmin/controllers/decorators.py", line 11, in proxyfunc
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return func(self, *args, **kw)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/var/www/iredadmin/controllers/mysql/domain.py", line 134, in GET
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] greylisted = gl.is_greylisted(self.domain)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/var/www/iredadmin/libs/policyd/greylist.py", line 40, in is_greylisted
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] limit=1,
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/db.py", line 682, in select
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] return self.query(qout, processed=True)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/db.py", line 644, in query
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] self._db_execute(db_cursor, sql_query)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib/python2.6/site-packages/web/db.py", line 587, in _db_execute
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] out = cur.execute(query, params)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] self.errorhandler(self, exc, value)
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] raise errorclass, errorvalue
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] ProgrammingError: (1146, "Table 'cluebringer.policy' doesn't exist")
[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16]

Thank you.

Kyle

**ZhangHuangbin** · 2014-01-24 20:45:28

ZhangHuangbin
iRedMail Developers
Offline

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

Re: "internal server error" when trying to modify domain attributes

Kyle Harris wrote:

[Fri Jan 24 04:56:13 2014] [error] [client 68.52.24.16] ProgrammingError: (1146, "Table 'cluebringer.policy' doesn't exist")

iRedAdmin-Pro detects you have Cluebringer integration enabled in /var/www/iredadmin/settings.py.
Could you please try below steps to fix it:

1: Restart Apache web server.
2: Logout of iReAdmin-Pro. (Or, delete all records in SQL table "iredadmin.sessions".)
3: Login to iRedAdmin-Pro.

If it doesn't work, please show us Policyd/Cluebringer related settings like below:

# grep '^policyd_' /var/www/iredadmin/settings.py | grep -v 'password'

Also, did you install Cluebringer manually?

**Kyle Harris** · 2014-01-26 20:19:43

Kyle Harris
Member
Offline

Registered: 2013-11-23
Posts: 13

Re: "internal server error" when trying to modify domain attributes

I think I have the problem fixed by clearing the sessions. However, I'm still not sure that Cluebringer is working properly. I followed the instructions to install it from this URL: http://iredmail.org/wiki/index.php?titl … inger/RHEL

I just stumbled on the following 2 scripts in the tools directory of MySQL v 1.8.1:
init_cluebringer_support.py
sync_cluebringer_internal_domains.py

Should I run those to finish my conversion from Policyd to Clubringer?

Thanks again.

Kyle

**ZhangHuangbin** · 2014-02-05 14:34:42

ZhangHuangbin
iRedMail Developers
Offline

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

Re: "internal server error" when trying to modify domain attributes

*) You don't need "init_cluebringer_support.py", it's merged into libs/cluebringer/*.py. It will be removed in next release.
*) Please execute script "sync_cluebringer_internal_domains.py".

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

"internal server error" when trying to modify domain attributes

Posts: 6

1 Topic by Kyle Harris 2014-01-24 07:28:33

Topic: "internal server error" when trying to modify domain attributes

2 Reply by ZhangHuangbin 2014-01-24 11:03:59

Re: "internal server error" when trying to modify domain attributes

3 Reply by Kyle Harris 2014-01-24 18:57:39

Re: "internal server error" when trying to modify domain attributes

4 Reply by ZhangHuangbin 2014-01-24 20:45:28

Re: "internal server error" when trying to modify domain attributes

5 Reply by Kyle Harris 2014-01-26 20:19:43

Re: "internal server error" when trying to modify domain attributes

6 Reply by ZhangHuangbin 2014-02-05 14:34:42

Re: "internal server error" when trying to modify domain attributes

Posts: 6