1

Topic: iRedAdmin-Pro-SQL-2.9.0 has been released

Dear all,

iRedAdmin-Pro-SQL-2.9.0 (iRedAdmin-Pro for MySQL, MariaDB and PostgreSQL backends) is now available for upgrading and purchasing.

How to download the latest iRedAdmin-Pro

iRedAdmin-Pro customers can get download link of this new release by following steps below:

  • Login to iRedAdmin-Pro as global admin

  • Click "License" on the top-right corner, it will show you basic license info and a "Download" button if new version is available for upgrading.

If above steps don't work for you, please send an email to support @ iredmail.org to get download link of the latest release.

Below are detailed changes since iRedAdmin-Pro-SQL-2.8.0:

RESTful API
  • Show allocated domain quota while getting domain profile (`GET /api/domain/<domain>`).

  • Able to manage alias domains while updating domain profile (`GET /api/domain/<domain>`):

    • `aliasDomains`: reset all alias domains

    • `addAliasDomain`: add new alias domains

    • `removeAliasDomain`: remove existing alias domains

  • Parameter names changed while updating domain profile (`PUT /api/domain/<domain>`):

    • `enableService` was renamed to `addService`

    • `disableService` was renamed to `removeService`

    • `removeAllServices` was renamed to `services`

Improvements
  • mlmmj mailing list integration. Mailing list is now subscribable via email or web. Admin can migrate existing mail alias account to subscribable mailing list in account profile page with one click, all profiles (members/moderators, access policy, etc) will be fully migrated.

  • Able to export all managed accounts with one click.

  • Able to disable domain ownership verification per admin for newly created domain.

  • Able to disable normal domain admin to view mail log and manage quarantined mails.

Fixed issues
  • Not correctly set spam policy while no options were updated.

  • self-service: user cannot update white/blacklists while removing log of received/sent mails. Thanks Jochen Häberle <jochen _at_ haeberle _dot_ net> for the feedback in forum.

  • Not delete records which use removed mail accounts as destination bcc address.

  • Not display stored messages and size in user profile page if user has unlimited mailbox quota.

  • Cannot set user mailbox quota to unlimited by leaving the input field empty.

  • Cannot correctly indicate managed domains in user profile page. Thanks Slawomir Wrobel <slawek _at_ studio-it.pl> for the report.

  • Filter on domain list page shows only first letter of all existing domains instead of hard-coded letters.

  • Dead link used to display greylisting tracking data.

  • Per-user bcc settings were removed while updating per-domain bcc settings.

  • Email address with extension is considered as not existing.

  • Not correctly display indicator of mail forwarding in search result page. Thanks Luke6283 <support _at_ sbcjolley.com> for the report in forum.

  • Not correct set spam policy if `Quarantine spam` is not checked in spam policy setting page. Thanks Jorge <jorge _at_ bsd.com.br> for the report in forum.

  • Normal admin cannot edit user mailbox quota. Thanks Adil Demiri <adil _at_ sgn.net> for the report.

  • tools/notify_quarantined_recipients.py: Cannot get correct timestamp of quarantined emails.

  • tools/cleanup_amavisd_db.py: endless loop in some case with PostgreSQL.

Updated translations
  • German (de_DE). Thanks Peter <info _at_ nuw.biz>.

  • Italian (it_IT). Thanks Francesco <frankonet _at_ infinito.it>.

2

Re: iRedAdmin-Pro-SQL-2.9.0 has been released

Getting "internal server error" when creating new users, but they still create.

Getting "internal server error" when trying to modify user settings, no work around for the that, we can no longer reset user passwords

iRedAdmin-Pro-SQL-2.9.0
Debian, Buster

3

Re: iRedAdmin-Pro-SQL-2.9.0 has been released

darth_wells wrote:

Getting "internal server error" when creating new users, but they still create.

Getting "internal server error" when trying to modify user settings, no work around for the that, we can no longer reset user passwords

iRedAdmin-Pro-SQL-2.9.0
Debian, Buster

/var/log/apache2/error.log

[Thu Apr 12 13:40:40.007070 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65273]
[Thu Apr 12 13:40:44.093113 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276] Traceback (most recent call last):
[Thu Apr 12 13:40:44.093196 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:40:44.093213 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return self.handle()
[Thu Apr 12 13:40:44.093228 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:40:44.093243 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:40:44.093258 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:40:44.093273 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return handle_class(cls)
[Thu Apr 12 13:40:44.093288 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:40:44.093303 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return tocall(*args)
[Thu Apr 12 13:40:44.093318 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:40:44.093333 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:40:44.093349 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:40:44.093364 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:40:44.093411 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:40:44.093427 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:40:44.093442 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:40:44.093458 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:40:44.093473 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:40:44.093488 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:40:44.093503 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:40:44.093518 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:40:44.093533 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:40:44.093548 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:40:44.093564 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/test2@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa372f76c>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:40:44.093594 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]
[Thu Apr 12 13:41:05.451044 2018] [mpm_prefork:notice] [pid 20492] AH00169: caught SIGTERM, shutting down
[Thu Apr 12 13:41:06.670785 2018] [so:warn] [pid 23240] AH01574: module uwsgi_module is already loaded, skipping
[Thu Apr 12 13:41:06.800322 2018] [mpm_prefork:notice] [pid 23241] AH00163: Apache/2.4.29 (Debian) mod_uwsgi/1.0 OpenSSL/1.1.0h mod_wsgi/4.5.17 Python/2.7 configured -- resuming normal operations
[Thu Apr 12 13:41:06.800479 2018] [core:notice] [pid 23241] AH00094: Command line: '/usr/sbin/apache2'
[Thu Apr 12 13:42:01.532861 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286] Traceback (most recent call last):
[Thu Apr 12 13:42:01.532962 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:42:01.532980 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return self.handle()
[Thu Apr 12 13:42:01.532996 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:42:01.533012 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:42:01.533028 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:42:01.533044 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return handle_class(cls)
[Thu Apr 12 13:42:01.533060 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:42:01.533076 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return tocall(*args)
[Thu Apr 12 13:42:01.533092 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:42:01.533109 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:42:01.533157 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:42:01.533173 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:42:01.533188 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:42:01.533204 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:42:01.533219 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:42:01.533234 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:42:01.533249 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:42:01.533264 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:42:01.533279 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:42:01.533294 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:42:01.533309 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:42:01.533324 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:42:01.533340 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/test@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2d7964c>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:42:01.533370 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]
[Thu Apr 12 13:42:12.367031 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300] Traceback (most recent call last):
[Thu Apr 12 13:42:12.367126 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:42:12.367147 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return self.handle()
[Thu Apr 12 13:42:12.367164 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:42:12.367185 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:42:12.367206 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:42:12.367224 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return handle_class(cls)
[Thu Apr 12 13:42:12.367240 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:42:12.367266 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return tocall(*args)
[Thu Apr 12 13:42:12.367295 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:42:12.367330 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:42:12.367360 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:42:12.367453 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:42:12.367475 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:42:12.367498 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:42:12.367531 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:42:12.367555 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:42:12.367587 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:42:12.367643 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:42:12.367674 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:42:12.367691 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:42:12.367709 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:42:12.367732 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:42:12.367776 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/lori@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2d183ec>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:42:12.367835 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]
[Thu Apr 12 13:53:14.277432 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451] Traceback (most recent call last):
[Thu Apr 12 13:53:14.277508 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:53:14.277526 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return self.handle()
[Thu Apr 12 13:53:14.277542 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:53:14.277558 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:53:14.277574 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:53:14.277591 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return handle_class(cls)
[Thu Apr 12 13:53:14.277607 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:53:14.277623 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return tocall(*args)
[Thu Apr 12 13:53:14.277639 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:53:14.277655 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     #        _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:53:14.277672 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:53:14.277688 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:53:14.277736 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:53:14.277752 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:53:14.277767 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:53:14.277782 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:53:14.277797 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:53:14.277811 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:53:14.277826 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:53:14.277841 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:53:14.277855 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:53:14.277870 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:53:14.277885 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/lori@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2ccd1ac>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:53:14.277913 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]
[Thu Apr 12 13:53:27.127355 2018] [mpm_prefork:notice] [pid 23241] AH00169: caught SIGTERM, shutting down
[Thu Apr 12 13:53:28.349820 2018] [so:warn] [pid 24182] AH01574: module uwsgi_module is already loaded, skipping

4

Re: iRedAdmin-Pro-SQL-2.9.0 has been released

darth_wells wrote:
darth_wells wrote:

Getting "internal server error" when creating new users, but they still create.

Getting "internal server error" when trying to modify user settings, no work around for the that, we can no longer reset user passwords

iRedAdmin-Pro-SQL-2.9.0
Debian, Buster

/var/log/apache2/error.log

[Thu Apr 12 13:40:40.007070 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65273]
[Thu Apr 12 13:40:44.093113 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276] Traceback (most recent call last):
[Thu Apr 12 13:40:44.093196 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:40:44.093213 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return self.handle()
[Thu Apr 12 13:40:44.093228 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:40:44.093243 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:40:44.093258 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:40:44.093273 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return handle_class(cls)
[Thu Apr 12 13:40:44.093288 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:40:44.093303 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return tocall(*args)
[Thu Apr 12 13:40:44.093318 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:40:44.093333 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:40:44.093349 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:40:44.093364 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:40:44.093411 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:40:44.093427 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:40:44.093442 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:40:44.093458 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:40:44.093473 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:40:44.093488 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:40:44.093503 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:40:44.093518 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:40:44.093533 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:40:44.093548 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:40:44.093564 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/test2@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa372f76c>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:40:44.093594 2018] [wsgi:error] [pid 20496] [remote 10.1.1.88:65276]
[Thu Apr 12 13:41:05.451044 2018] [mpm_prefork:notice] [pid 20492] AH00169: caught SIGTERM, shutting down
[Thu Apr 12 13:41:06.670785 2018] [so:warn] [pid 23240] AH01574: module uwsgi_module is already loaded, skipping
[Thu Apr 12 13:41:06.800322 2018] [mpm_prefork:notice] [pid 23241] AH00163: Apache/2.4.29 (Debian) mod_uwsgi/1.0 OpenSSL/1.1.0h mod_wsgi/4.5.17 Python/2.7 configured -- resuming normal operations
[Thu Apr 12 13:41:06.800479 2018] [core:notice] [pid 23241] AH00094: Command line: '/usr/sbin/apache2'
[Thu Apr 12 13:42:01.532861 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286] Traceback (most recent call last):
[Thu Apr 12 13:42:01.532962 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:42:01.532980 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return self.handle()
[Thu Apr 12 13:42:01.532996 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:42:01.533012 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:42:01.533028 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:42:01.533044 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return handle_class(cls)
[Thu Apr 12 13:42:01.533060 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:42:01.533076 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return tocall(*args)
[Thu Apr 12 13:42:01.533092 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:42:01.533109 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:42:01.533157 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:42:01.533173 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:42:01.533188 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:42:01.533204 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:42:01.533219 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:42:01.533234 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:42:01.533249 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:42:01.533264 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:42:01.533279 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:42:01.533294 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:42:01.533309 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:42:01.533324 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:42:01.533340 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/test@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2d7964c>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:42:01.533370 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65286]
[Thu Apr 12 13:42:12.367031 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300] Traceback (most recent call last):
[Thu Apr 12 13:42:12.367126 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:42:12.367147 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return self.handle()
[Thu Apr 12 13:42:12.367164 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:42:12.367185 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:42:12.367206 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:42:12.367224 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return handle_class(cls)
[Thu Apr 12 13:42:12.367240 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:42:12.367266 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return tocall(*args)
[Thu Apr 12 13:42:12.367295 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:42:12.367330 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:42:12.367360 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:42:12.367453 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:42:12.367475 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:42:12.367498 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:42:12.367531 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:42:12.367555 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:42:12.367587 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:42:12.367643 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:42:12.367674 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:42:12.367691 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:42:12.367709 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:42:12.367732 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:42:12.367776 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/lori@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2d183ec>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:42:12.367835 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65300]
[Thu Apr 12 13:53:14.277432 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451] Traceback (most recent call last):
[Thu Apr 12 13:53:14.277508 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process
[Thu Apr 12 13:53:14.277526 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return self.handle()
[Thu Apr 12 13:53:14.277542 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle
[Thu Apr 12 13:53:14.277558 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return self._delegate(fn, self.fvars, args)
[Thu Apr 12 13:53:14.277574 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate
[Thu Apr 12 13:53:14.277591 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return handle_class(cls)
[Thu Apr 12 13:53:14.277607 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class
[Thu Apr 12 13:53:14.277623 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return tocall(*args)
[Thu Apr 12 13:53:14.277639 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/share/apache2/iredadmin/controllers/sql/user.py", line 322, in GET
[Thu Apr 12 13:53:14.277655 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     #        _qr = mlmmj.get_subscribed_lists(mail=mail, query_all_lists=False)
[Thu Apr 12 13:53:14.277672 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/share/apache2/iredadmin/libs/mlmmj/__init__.py", line 327, in get_subscribed_lists
[Thu Apr 12 13:53:14.277688 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     r = requests.get(url, params=params, headers=api_headers, verify=_verify_ssl)
[Thu Apr 12 13:53:14.277736 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 72, in get
[Thu Apr 12 13:53:14.277752 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return request('get', url, params=params, **kwargs)
[Thu Apr 12 13:53:14.277767 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/api.py", line 58, in request
[Thu Apr 12 13:53:14.277782 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     return session.request(method=method, url=url, **kwargs)
[Thu Apr 12 13:53:14.277797 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 508, in request
[Thu Apr 12 13:53:14.277811 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     resp = self.send(prep, **send_kwargs)
[Thu Apr 12 13:53:14.277826 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/sessions.py", line 618, in send
[Thu Apr 12 13:53:14.277841 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     r = adapter.send(request, **kwargs)
[Thu Apr 12 13:53:14.277855 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]   File "/usr/lib/python2.7/dist-packages/requests/adapters.py", line 508, in send
[Thu Apr 12 13:53:14.277870 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]     raise ConnectionError(e, request=request)
[Thu Apr 12 13:53:14.277885 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451] ConnectionError: HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/lori@thedarktimes.us/subscribed?query_all_lists=no&email_only=no (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa2ccd1ac>: Failed to establish a new connection: [Errno 111] Connection refused',))
[Thu Apr 12 13:53:14.277913 2018] [wsgi:error] [pid 23244] [remote 10.1.1.88:65451]
[Thu Apr 12 13:53:27.127355 2018] [mpm_prefork:notice] [pid 23241] AH00169: caught SIGTERM, shutting down
[Thu Apr 12 13:53:28.349820 2018] [so:warn] [pid 24182] AH01574: module uwsgi_module is already loaded, skipping


I found post by lamagra

If i make # in this line -->   "/usr/share/apache2/iRedAdmin-Pro-SQL-2.9.0/controllers/sql/user.py", line 322" and restart uwsgi then i can edit user profile without any problem.

I now can edit user profile

5

Re: iRedAdmin-Pro-SQL-2.9.0 has been released

darth_wells wrote:

If i make # in this line -->   "/usr/share/apache2/iRedAdmin-Pro-SQL-2.9.0/controllers/sql/user.py", line 322" and restart uwsgi then i can edit user profile without any problem.

This is wrong solution.
Please try to start the "mlmmjadmin" service, if it runs, then no more this issue.

----

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

buy me a cup of coffee