1

Topic: Cannot display the Domain setting page after update

==== Required information ====
- iRedMail version: 0.
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CENTOS
- Related log if you're reporting an issue:
====

Hi,

After I upgrade the iRedAdmin-Pro to 1.8.0 MySQL, I cannot display the Domain edit page.

https://mail01.domain.com/iredadmin/pro … domain.com

Please help.

Thanks!

B.Rgds.
Roy Wong.

2

Re: Cannot display the Domain setting page after update

Hi Roy,

What do you mean "cannot display the domain edit page"? What's the error message? What's the related error log in Apache log file?

3

Re: Cannot display the Domain setting page after update

i found the following in ssl_error_log when I click on one of my domain :

[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58] Traceback (most recent call last):
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/application.py", line 239, in process
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return self.handle()
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/application.py", line 230, in handle
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return self._delegate(fn, self.fvars, args)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/application.py", line 420, in _delegate
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return handle_class(cls)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/application.py", line 396, in handle_class
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return tocall(*args)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/var/www/iredadmin/controllers/decorators.py", line 11, in proxyfunc
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return func(self, *args, **kw)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/var/www/iredadmin/controllers/mysql/domain.py", line 121, in GET
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     throttleLib = throttle.Throttle()
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/var/www/iredadmin/libs/cluebringer/core.py", line 78, in __init__
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     self.policy_ids = _get_all_policy_ids(self.db)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/var/www/iredadmin/libs/cluebringer/core.py", line 17, in _get_all_policy_ids
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     qr = conn.select('policies', what='id,name,priority')
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/db.py", line 682, in select
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     return self.query(qout, processed=True)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/db.py", line 644, in query
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     self._db_execute(db_cursor, sql_query)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib/python2.6/site-packages/web/db.py", line 587, in _db_execute
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     out = cur.execute(query, params)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     self.errorhandler(self, exc, value)
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]     raise errorclass, errorvalue
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58] ProgrammingError: (1146, "Table 'policyd.policies' doesn't exist")
[Fri Dec 20 12:49:33 2013] [error] [client 192.168.93.58]