1

Topic: Domains and accounts error

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.3
- Linux/BSD distribution name and version: FreeBSD 10.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue: upgradehttpd-error.txt
====

After upgrading to 0.9.3 and iRedAdmin-Pro 2.2.0, clicking on any domain defined under "Domains and accounts" returns "internal server error".

I thought I had done all the upgrade steps but perhaps I'm missing something. I have attached the most recent error output from httpd-error.txt in the file upgradehttpd-error.txt. Thanks in advance for troubleshooting help with this.

----

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

2

Re: Domains and accounts error

No attachment in your post. Perhaps you forgot it?

3

Re: Domains and accounts error

I did attach a file. Here are the contents of the file pasted into the body of this message:

[Sun Jan 03 20:54:17.964170 2016] [:error] [pid 1081] 'module' object has no attribute 'iredapd_db_host'
[Sun Jan 03 20:54:17.964489 2016] [:error] [pid 1081] [remote 75.82.83.187:0] Traceback (most recent call last):
[Sun Jan 03 20:54:17.964502 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/lib/python2.7/site-packages/web/application.py", line 239, in process
[Sun Jan 03 20:54:17.964509 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     return self.handle()
[Sun Jan 03 20:54:17.964515 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/lib/python2.7/site-packages/web/application.py", line 230, in handle
[Sun Jan 03 20:54:17.964521 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     return self._delegate(fn, self.fvars, args)
[Sun Jan 03 20:54:17.964527 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/lib/python2.7/site-packages/web/application.py", line 420, in _delegate
[Sun Jan 03 20:54:17.964533 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     return handle_class(cls)
[Sun Jan 03 20:54:17.964538 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/lib/python2.7/site-packages/web/application.py", line 396, in handle_class
[Sun Jan 03 20:54:17.964544 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     return tocall(*args)
[Sun Jan 03 20:54:17.964550 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/www/iredadmin/libs/sqllib/decorators.py", line 26, in proxyfunc
[Sun Jan 03 20:54:17.964556 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     return func(*args, **kw)
[Sun Jan 03 20:54:17.964561 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/www/iredadmin/controllers/sql/domain.py", line 168, in GET
[Sun Jan 03 20:54:17.964568 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     qr = lib_greylist.get_greylist_setting_and_whitelists(account='@' + self.domain)
[Sun Jan 03 20:54:17.964574 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/www/iredadmin/libs/iredapd/greylist.py", line 9, in get_greylist_setting_and_whitelists
[Sun Jan 03 20:54:17.964580 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     gl = Greylisting()
[Sun Jan 03 20:54:17.964585 2016] [:error] [pid 1081] [remote 75.82.83.187:0]   File "/usr/local/www/iredadmin/libs/iredapd/__init__.py", line 44, in __init__
[Sun Jan 03 20:54:17.964591 2016] [:error] [pid 1081] [remote 75.82.83.187:0]     self.db.supports_multiple_insert = True
[Sun Jan 03 20:54:17.964597 2016] [:error] [pid 1081] [remote 75.82.83.187:0] AttributeError: 'Greylisting' object has no attribute 'db'
[Sun Jan 03 20:54:17.964609 2016] [:error] [pid 1081] [remote 75.82.83.187:0]

4

Re: Domains and accounts error

cvcvelo wrote:

[Sun Jan 03 20:54:17.964597 2016] [:error] [pid 1081] [remote 75.82.83.187:0] AttributeError: 'Greylisting' object has no attribute 'db'

Please make sure you have "policyd_enabled = False" in iRedAdmin-Pro config file, and have all "iredapd_*" parameters with proper values too. then restart Apache service and try again.

Note: Do you have below parameters in iRedAdmin-Pro config file?

iredapd_enabled =
iredapd_db_host =
iredapd_db_port =
iredapd_db_name =
iredapd_db_user =
iredapd_db_password =

5

Re: Domains and accounts error

Hmm. policyd_enabled is set to False. Also, the only "iredapd_" line in the config file is:

iredapd_enabled = True

I followed the instructions about migrating from cluebringer to iRedAPD, and that did not mention anything about the other iredapd_ lines. Where is the documentation for that?

Thanks!

6

Re: Domains and accounts error

You can find "iredapd_*" settings in sample iRedAdmin-Pro config file under iRedAdmin-Pro root directory: settings.py.mysql.sample.

7

Re: Domains and accounts error

ZhangHuangbin wrote:

You can find "iredapd_*" settings in sample iRedAdmin-Pro config file under iRedAdmin-Pro root directory: settings.py.mysql.sample.

Thanks. With those settings added, and with a new password for the iredapd user, iRedAdmin-Pro can now access domains without complaint.