1

Topic: Domain list is empty after upgrade from 2.8 to 2.9

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: Centos 7
- 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.
====

Hi,

After I upgraded my iRedmail-Pro from 2.8.0 to 2.9.0, all domains under "Domain and Accounts" are disappeared.
But the number of domains showing at Dashboard is correct, and the Top senders and receiver also empty.

Under "Admin" page, it can show out all admin accounts. If I click one of it, it will return "internal server error".

Please help!!

Regards,
Matt

2 (edited by MattHo 2018-06-04 14:09:53)

Re: Domain list is empty after upgrade from 2.8 to 2.9

Hi,

Update.

Now, I can show the "Domain and Accounts" information, but:
1/ If I click the user, the page will show out "internal server error"
2/ If I create a new user, the page will show out "internal server error". If I refresh the page the the new account will show in the maillist but the password is not what I input.
3/ Top sender and receiver problem.
https://drive.google.com/file/d/1Am5xfj … sp=sharing

What information I should provide? Please advise.

Regards,
Matt

3

Re: Domain list is empty after upgrade from 2.8 to 2.9

Checked the uwsgi by using “tail -f /var/log/messages”

Jun  5 22:53:40 mx01 uwsgi: webmail.domain.com [pid: 26016|app: 0|req: 66/66] 123.123.123.123 () {54 vars in 1017 bytes} [Tue Jun  5 22:53:38 2018] GET /iredadmin/profile/domain/general/domain.com => generated 133296 bytes in 2507 msecs (HTTP/1.1 200) 2 headers in 146 bytes (2 switches on core 0)
Jun  5 22:53:44 mx01 uwsgi: webmail.domain.com [pid: 26016|app: 0|req: 67/67] 123.123.123.123 () {54 vars in 1007 bytes} [Tue Jun  5 22:53:42 2018] GET /iredadmin/users/domain.com => generated 29118 bytes in 2056 msecs (HTTP/1.1 200) 2 headers in 146 bytes (2 switches on core 0)
Jun  5 22:53:51 mx01 uwsgi: Traceback (most recent call last):
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/web/application.py", line 239, in process
Jun  5 22:53:51 mx01 uwsgi: return self.handle()
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/web/application.py", line 230, in handle
Jun  5 22:53:51 mx01 uwsgi: return self._delegate(fn, self.fvars, args)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/web/application.py", line 420, in _delegate
Jun  5 22:53:51 mx01 uwsgi: return handle_class(cls)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/web/application.py", line 396, in handle_class
Jun  5 22:53:51 mx01 uwsgi: return tocall(*args)
Jun  5 22:53:51 mx01 uwsgi: File "/var/www/iRedAdmin-Pro-SQL-2.9.0/controllers/sql/user.py", line 322, in GET
Jun  5 22:53:51 mx01 uwsgi: _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
Jun  5 22:53:51 mx01 uwsgi: File "/var/www/iRedAdmin-Pro-SQL-2.9.0/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
Jun  5 22:53:51 mx01 uwsgi: r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/requests/api.py", line 68, in get
Jun  5 22:53:51 mx01 uwsgi: return request('get', url, **kwargs)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/requests/api.py", line 50, in request
Jun  5 22:53:51 mx01 uwsgi: response = session.request(method=method, url=url, **kwargs)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/requests/sessions.py", line 464, in request
Jun  5 22:53:51 mx01 uwsgi: resp = self.send(prep, **send_kwargs)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/requests/sessions.py", line 576, in send
Jun  5 22:53:51 mx01 uwsgi: r = adapter.send(request, **kwargs)
Jun  5 22:53:51 mx01 uwsgi: File "/usr/lib/python2.7/site-packages/requests/adapters.py", line 415, in send
Jun  5 22:53:51 mx01 uwsgi: raise ConnectionError(err, request=request)
Jun  5 22:53:51 mx01 uwsgi: ConnectionError: ('Connection aborted.', error(111, 'Connection refused'))
Jun  5 22:53:51 mx01 uwsgi: webmail.domain.com [pid: 26016|app: 0|req: 68/68] 123.123.123.123 () {54 vars in 1036 bytes} [Tue Jun  5 22:53:51 2018] GET /iredadmin/profile/user/general/support@domain.com => generated 21 bytes in 34 msecs (HTTP/1.1 500) 2 headers in 165 bytes (2 switches on core 0)
Jun  5 22:54:01 mx01 systemd: Created slice User Slice of sogo.
Jun  5 22:54:01 mx01 systemd: Starting User Slice of sogo.
Jun  5 22:54:01 mx01 systemd: Started Session 26938 of user sogo.
Jun  5 22:54:01 mx01 systemd: Starting Session 26938 of user sogo.
Jun  5 22:54:02 mx01 systemd: Removed slice User Slice of sogo.
Jun  5 22:54:02 mx01 systemd: Stopping User Slice of sogo.

Anyone can give me an advise?

Many thanks.

Regards,
Matt

4

Re: Domain list is empty after upgrade from 2.8 to 2.9

MattHo wrote:

Jun  5 22:53:51 mx01 uwsgi: ConnectionError: ('Connection aborted.', error(111, 'Connection refused'))

Service "mlmmjadmin" is not running. Please start it first.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

5 (edited by MattHo 2018-06-08 09:40:46)

Re: Domain list is empty after upgrade from 2.8 to 2.9

"mlmmjadmin" service cannot be start.

============================================================================================
[root@mx01 log]# systemctl status mlmmjadmin
● mlmmjadmin.service - RESTful API server used to manage mlmmj mailing list manager
   Loaded: loaded (/usr/lib/systemd/system/mlmmjadmin.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2018-06-08 09:21:23 HKT; 15min ago
  Process: 6801 ExecStopPost=/usr/bin/rm -rf /var/run/mlmmjadmin (code=exited, status=0/SUCCESS)
  Process: 6797 ExecStop=/usr/sbin/uwsgi --stop /var/run/mlmmjadmin/mlmmjadmin.pid (code=exited, status=255)
  Process: 6794 ExecStart=/usr/sbin/uwsgi --ini /opt/mlmmjadmin/rc_scripts/uwsgi/rhel.ini --pidfile /var/run/mlmmjadmin/mlmmjadmin.pid (code=exited, status=1/FAILURE)
  Process: 6791 ExecStartPre=/usr/bin/chmod 0755 /var/run/mlmmjadmin (code=exited, status=0/SUCCESS)
  Process: 6789 ExecStartPre=/usr/bin/chown mlmmj:mlmmj /var/run/mlmmjadmin (code=exited, status=0/SUCCESS)
  Process: 6786 ExecStartPre=/usr/bin/mkdir /var/run/mlmmjadmin (code=exited, status=0/SUCCESS)
Main PID: 6794 (code=exited, status=1/FAILURE)

Jun 08 09:21:23 mx01.domain.com uwsgi[6794]: your memory page size is 4096 bytes
Jun 08 09:21:23 mx01.domain.com uwsgi[6794]: detected max file descriptor number: 1024
Jun 08 09:21:23 mx01.domain.com uwsgi[6794]: VirtualHosting mode enabled.
Jun 08 09:21:23 mx01.domain.com uwsgi[6794]: lock engine: pthread robust mutexes
Jun 08 09:21:23 mx01.domain.com uwsgi[6794]: thunder lock: disabled (you can enable it with --thunder-lock)
Jun 08 09:21:23 mx01.domain.com systemd[1]: mlmmjadmin.service: main process exited, code=exited, status=1/FAILURE
Jun 08 09:21:23 mx01.domain.com uwsgi[6797]: signal_pidfile()/kill(): No such process [core/uwsgi.c line 1681]
Jun 08 09:21:23 mx01.domain.com systemd[1]: mlmmjadmin.service: control process exited, code=exited status=255
Jun 08 09:21:23 mx01.domain.com systemd[1]: Unit mlmmjadmin.service entered failed state.
Jun 08 09:21:23 mx01.domain.com systemd[1]: mlmmjadmin.service failed.

============================================================================================
[root@mx01 log]# tail messages

Jun  8 09:21:22 mx01 systemd: Starting RESTful API server used to manage mlmmj mailing list manager...
Jun  8 09:21:22 mx01 systemd: Started RESTful API server used to manage mlmmj mailing list manager.
Jun  8 09:21:22 mx01 uwsgi: [uWSGI] getting INI configuration from /opt/mlmmjadmin/rc_scripts/uwsgi/rhel.ini
Jun  8 09:21:23 mx01 uwsgi: *** Starting uWSGI 2.0.16 (64bit) on [Fri Jun  8 09:21:22 2018] ***
Jun  8 09:21:23 mx01 uwsgi: compiled with version: 4.8.5 20150623 (Red Hat 4.8.5-16) on 13 February 2018 02:48:03
Jun  8 09:21:23 mx01 uwsgi: os: Linux-3.10.0-862.2.3.el7.x86_64 #1 SMP Wed May 9 18:05:47 UTC 2018
Jun  8 09:21:23 mx01 uwsgi: nodename: mx01.domain.com
Jun  8 09:21:23 mx01 uwsgi: machine: x86_64
Jun  8 09:21:23 mx01 uwsgi: clock source: unix
Jun  8 09:21:23 mx01 uwsgi: pcre jit disabled
Jun  8 09:21:23 mx01 uwsgi: detected number of CPU cores: 8
Jun  8 09:21:23 mx01 uwsgi: current working directory: /
Jun  8 09:21:23 mx01 uwsgi: writing pidfile to /var/run/mlmmjadmin/mlmmjadmin.pid
Jun  8 09:21:23 mx01 uwsgi: detected binary path: /usr/sbin/uwsgi
Jun  8 09:21:23 mx01 uwsgi: dropping root privileges as early as possible
Jun  8 09:21:23 mx01 uwsgi: setgid() to 2003
Jun  8 09:21:23 mx01 uwsgi: setuid() to 2003
Jun  8 09:21:23 mx01 uwsgi: chdir() to /opt/mlmmjadmin
Jun  8 09:21:23 mx01 uwsgi: your processes number limit is 63447
Jun  8 09:21:23 mx01 uwsgi: your memory page size is 4096 bytes
Jun  8 09:21:23 mx01 uwsgi: detected max file descriptor number: 1024
Jun  8 09:21:23 mx01 uwsgi: VirtualHosting mode enabled.
Jun  8 09:21:23 mx01 uwsgi: lock engine: pthread robust mutexes
Jun  8 09:21:23 mx01 uwsgi: thunder lock: disabled (you can enable it with --thunder-lock)
Jun  8 09:21:23 mx01 uwsgi: uwsgi socket 0 bound to TCP address 127.0.0.1:7790 fd 6
Jun  8 09:21:23 mx01 uwsgi: dropping root privileges after socket binding
Jun  8 09:21:23 mx01 systemd: mlmmjadmin.service: main process exited, code=exited, status=1/FAILURE
Jun  8 09:21:23 mx01 uwsgi: Python version: 2.7.5 (default, Apr 11 2018, 07:36:10)  [GCC 4.8.5 20150623 (Red Hat 4.8.5-28)]
Jun  8 09:21:23 mx01 uwsgi: Python main interpreter initialized at 0x1d43b90
Jun  8 09:21:23 mx01 uwsgi: dropping root privileges after plugin initialization
Jun  8 09:21:23 mx01 uwsgi: python threads support enabled
Jun  8 09:21:23 mx01 uwsgi: your server socket listen backlog is limited to 100 connections
Jun  8 09:21:23 mx01 uwsgi: your mercy for graceful operations on workers is 60 seconds

============================================================================================

I've already try to re-do the mlmmj integration and re-install the iRedMail-Pro.

6

Re: Domain list is empty after upgrade from 2.8 to 2.9

Try this:

cd /opt/mlmmjadmin/
python mlmmjadmin.py

Any error on console?

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

7

Re: Domain list is empty after upgrade from 2.8 to 2.9

After run "python mlmmjadmin.py", I can click into the user account or create user, all working normal.
But, if I press "Ctrl + C" exit the python, it will show "internal server error" again.

=============================================
[root@mx01 mlmmjadmin]# python mlmmjadmin.py
http://127.0.0.1:7790/
127.0.0.1:50762 - - [09/Jun/2018 22:33:37] "HTTP/1.1 GET /api/subscriber/notice@domain.com/subscribed" - 200 OK
127.0.0.1:50816 - - [09/Jun/2018 22:34:09] "HTTP/1.1 GET /api/subscriber/notice@domain.com/subscribed" - 200 OK
127.0.0.1:50822 - - [09/Jun/2018 22:34:09] "HTTP/1.1 GET /api/subscriber/notice@domain.com/subscribed" - 200 OK
^C
[root@mx01 mlmmjadmin]#
=============================================

8

Re: Domain list is empty after upgrade from 2.8 to 2.9

MattHo wrote:

But, if I press "Ctrl + C" exit the python, it will show "internal server error" again.

After "Ctrl-C", please start the service by command "service mlmmjadmin restart", otherwise it's stopped.
If you still get error, please upgrade mlmmjadmin to the latest version 1.4 and try again. FYI:
https://docs.iredmail.org/upgrade.mlmmjadmin.html

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

9

Re: Domain list is empty after upgrade from 2.8 to 2.9

Cannot restart mlmmjadmin, still showing the same error even I upgraded to 1.4.
Anyway, we will trying to build a UAT with a fresh installation of iRedmail 0.9.8 and copy the production data to it.
Let see it will showing the same error or not, if no error will switch to new installation server.

10

Re: Domain list is empty after upgrade from 2.8 to 2.9

We can fix it on current server, just need to get right log message for troubleshooting.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

11

Re: Domain list is empty after upgrade from 2.8 to 2.9

Many thanks.

Could let me know which log I should provide?

12

Re: Domain list is empty after upgrade from 2.8 to 2.9

MattHo wrote:

Cannot restart mlmmjadmin, still showing the same error even I upgraded to 1.4.

No new error message of mlmmjadmin? If not, i'm afraid that i need direct ssh access for troubleshooting, is it ok for you?

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

13

Re: Domain list is empty after upgrade from 2.8 to 2.9

No new error message of mlmmjadmin.

Sure, if you don't mind ssh to my server and I just to an email.

14

Re: Domain list is empty after upgrade from 2.8 to 2.9

Fixed with ssh access, caused by incorrect permission of /var/vmail, was 0700, fixed to 0755.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee