1

Topic: No domains listed in control panel, error when creating new domain

======== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: Debian 9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? YES
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

In process of migrating to new server (and OS)  coming from 0.9.2 under FreeBSD to 0.9.8 under Debian 9

Copied over the db's from the daily backup, (vmail, iredadmin, amavisd, roundcubemail) imported them into the new system.

Logged into the new iRedAdmin-Pro control panel and see 9 domains indicated, click on that number and there are no domains listed.  Create a new domain and server throws an internal error.  logged into 'mysql' and queried the domains table and see my original 9 domains, plus the one I created.

No error is logged in /var/log/nginx/error.log

Post's attachments

iredpro_dashboard.PNG
iredpro_dashboard.PNG 19.81 kb, 1 downloads since 2018-08-31 

iredpro_domains.PNG
iredpro_domains.PNG 15.97 kb, 2 downloads since 2018-08-31 

You don't have the permssions to download the attachments of this post.

----

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

2

Re: No domains listed in control panel, error when creating new domain

Additional information:  I forgot to run the various SQL backend updates from 0.9.2 to 0.9.8 release.  Did that this morning and still no domains listed, adding domain via control panel still throws an error but don't see it logged anywhere.  Looking at the domain table I do see it created and the number of domains on the dashboard reports new domain in the total.

3

Re: No domains listed in control panel, error when creating new domain

- Any error in Nginx and / or uwsgi log files?
- Any error you got in web browser?

4

Re: No domains listed in control panel, error when creating new domain

ZhangHuangbin wrote:

- Any error in Nginx and / or uwsgi log files?
- Any error you got in web browser?

Here is the uwsgi/ireadmin.log file result when I attempt to add a new domain.

root@hades-ng:/var/log/uwsgi/app# tail -f iredadmin.log

hades-ng.ncreek.net [pid: 846|app: 0|req: 85/135] 168.103.154.139 () {52 vars in 786 bytes} [Sun Sep  2 12:03:05 2018] GET /iredadmin/login => generated 4922 bytes in 309 msecs (HTTP/1.1 200) 2 headers in 146 bytes (3 switches on core 0)
hades-ng.ncreek.net [pid: 846|app: 0|req: 86/136] 168.103.154.139 () {60 vars in 1035 bytes} [Sun Sep  2 12:03:08 2018] POST /iredadmin/login => generated 0 bytes in 7 msecs (HTTP/1.1 303) 3 headers in 221 bytes (2 switches on core 0)
hades-ng.ncreek.net [pid: 846|app: 0|req: 87/137] 168.103.154.139 () {56 vars in 946 bytes} [Sun Sep  2 12:03:08 2018] GET /iredadmin/dashboard/checknew => generated 17664 bytes in 2075 msecs (HTTP/1.1 200) 2 headers in 146 bytes (2 switches on core 0)
hades-ng.ncreek.net [pid: 846|app: 0|req: 88/138] 168.103.154.139 () {56 vars in 937 bytes} [Sun Sep  2 12:05:01 2018] GET /iredadmin/domains => generated 20830 bytes in 1502 msecs (HTTP/1.1 200) 2 headers in 146 bytes (2 switches on core 0)
hades-ng.ncreek.net [pid: 846|app: 0|req: 89/139] 168.103.154.139 () {56 vars in 938 bytes} [Sun Sep  2 12:05:05 2018] GET /iredadmin/create/domain => generated 61678 bytes in 1323 msecs (HTTP/1.1 200) 2 headers in 146 bytes (2 switches on core 0)
hades-ng.ncreek.net [pid: 845|app: 0|req: 51/140] 168.103.154.139 () {60 vars in 1061 bytes} [Sun Sep  2 12:05:19 2018] POST /iredadmin/create/domain => generated 0 bytes in 10 msecs (HTTP/1.1 303) 3 headers in 259 bytes (2 switches on core 0)
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/web/application.py", line 239, in process
    return self.handle()
  File "/usr/lib/python2.7/dist-packages/web/application.py", line 230, in handle
    return self._delegate(fn, self.fvars, args)
  File "/usr/lib/python2.7/dist-packages/web/application.py", line 462, in _delegate
    return handle_class(cls)
  File "/usr/lib/python2.7/dist-packages/web/application.py", line 438, in handle_class
    return tocall(*args)
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/libs/sqllib/decorators.py", line 32, in proxyfunc
    return func(*args, **kw)
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/controllers/sql/domain.py", line 298, in GET
    msg=web_input.get('msg'),
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/libs/iredbase.py", line 174, in render_template
    return jinja_env.get_template(template_name).render(context)
  File "/usr/lib/python2.7/dist-packages/jinja2/environment.py", line 989, in render
    return self.environment.handle_exception(exc_info, True)
  File "/usr/lib/python2.7/dist-packages/jinja2/environment.py", line 754, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/libs/../templates/default/sql/domain/profile.html", line 39, in top-level template code
    {% from "macros/msg_handlers.html" import domain_msg_handler with context %}
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/libs/../templates/default/layout.html", line 179, in top-level template code
    {% block main %}{% endblock %}
  File "/opt/www/iRedAdmin-Pro-SQL-2.9.0/libs/../templates/default/sql/domain/profile.html", line 484, in block "main"
    value="{% if profile.maillists > 0 %}{{ profile.maillists |e }}{% endif %}"
UndefinedError: 'web.utils.Storage object' has no attribute 'maillists'

hades-ng.ncreek.net [pid: 846|app: 0|req: 90/141] 168.103.154.139 () {56 vars in 1029 bytes} [Sun Sep  2 12:05:19 2018] GET /iredadmin/profile/domain/general/anothertestdomain.com?msg=CREATED => generated 21 bytes in 1940 msecs (HTTP/1.1 500) 3 headers in 190 bytes (2 switches on core 0)

Nothing shows up on the nginx/error.log

This is what displays in the browser window:

Post's attachments

iredadmin_domain_error.PNG
iredadmin_domain_error.PNG 142.35 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

5

Re: No domains listed in control panel, error when creating new domain

mikeg wrote:

UndefinedError: 'web.utils.Storage object' has no attribute 'maillists'

I'm sure that you missed at least one step while following iRedMail upgrade tutorials: SQL column "domain.maillists" does not exist.

FYI: https://docs.iredmail.org/upgrade.iredm … l-database

6

Re: No domains listed in control panel, error when creating new domain

ZhangHuangbin wrote:
mikeg wrote:

UndefinedError: 'web.utils.Storage object' has no attribute 'maillists'

I'm sure that you missed at least one step while following iRedMail upgrade tutorials: SQL column "domain.maillists" does not exist.

FYI: https://docs.iredmail.org/upgrade.iredm … l-database

I checked my command history and the 0.9.8 MySQL scripts were run, though a few of the columns where not created after I ran the script.  I created the missing columns and I can see all of the domains in the admin control panel now.