1

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

2

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.

3

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

4

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?

5

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

6

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".