1 Topic by manunauta

  • manunauta
  • Member
  • Offline
  • Registered: 2011-11-11
  • Posts: 40

Topic: iRedAdmin-Pro Internal server error

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

Hi,

I've just installed a new server with iRedMail 0.9.6, and I have no problems, IredAdmin Open Source edition works fine.

I've upgraded IredAdmin to last IredAdmin-Pro MySQL and now, I get "500 Internal Server Error" in the web browser.

If I return to the Open Source Edition, it works fine again.

Can you help me?

Thx.

Post's attachments

Captura.PNG
Captura.PNG 17.17 kb, file has never been downloaded. 

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro Internal server error

Any related error message in Apache log file?

3 Reply by manunauta

  • manunauta
  • Member
  • Offline
  • Registered: 2011-11-11
  • Posts: 40

Re: iRedAdmin-Pro Internal server error

These lines in Apache error.log:

[Fri Jun 02 19:45:25.954964 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981] mod_wsgi (pid=2533): Target WSGI script '/opt/www/
iredadmin/iredadmin.py' cannot be loaded as Python module.
[Fri Jun 02 19:45:25.955022 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981] mod_wsgi (pid=2533): Exception occurred processing
WSGI script '/opt/www/iredadmin/iredadmin.py'.
[Fri Jun 02 19:45:25.955076 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981] Traceback (most recent call last):
[Fri Jun 02 19:45:25.955118 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981]   File "/opt/www/iredadmin/iredadmin.py", line 8,
in <module>
[Fri Jun 02 19:45:25.955174 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981]     from libs import iredbase
[Fri Jun 02 19:45:25.955197 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981]   File "/opt/www/iredadmin/libs/iredbase.py", line
106, in <module>
[Fri Jun 02 19:45:25.955235 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981]     'enable_iredapd': settings.iredapd_enabled,
[Fri Jun 02 19:45:25.955272 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981] AttributeError: 'module' object has no attribute '
iredapd_enabled'

Any idea?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro Internal server error

manunauta wrote:

[Fri Jun 02 19:45:25.955272 2017] [wsgi:error] [pid 2533] [remote 10.0.0.9:43981] AttributeError: 'module' object has no attribute 'iredapd_enabled'

*) Do you have settings below in /opt/www/iredadmin/settings.py?

iredapd_enabled = True
iredapd_db_host = '127.0.0.1'
iredapd_db_port = '3306'
iredapd_db_name = 'iredapd'
iredapd_db_user = 'iredapd'
iredapd_db_password = 'password'

*) Do you have SQL database "iredapd"?

5 Reply by manunauta

  • manunauta
  • Member
  • Offline
  • Registered: 2011-11-11
  • Posts: 40

Re: iRedAdmin-Pro Internal server error

Hi again.

I had an error in the first line. Instead of 'iredapd_enabled = True', there was 'redapd_enabled = True'.

Now I have another error. When I try add an user or alias, or if I try to modify a domain, I get this error:

Error: OperationalError(1055, "Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vmail.sender_relayhost.relayhost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

Where is the problem?

Thx.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro Internal server error

manunauta wrote:

I had an error in the first line. Instead of 'iredapd_enabled = True', there was 'redapd_enabled = True'.

Please rename "redapd_enabled" to "iredapd_enabled', then restart Apache service. Also make sure you have other "iredapd_db_*" parameters (with correct values).

manunauta wrote:

Error: OperationalError(1055, "Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vmail.sender_relayhost.relayhost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

Which version of iRedAdmin-Pro are you running? Seems you're running an old release.

7 Reply by manunauta

  • manunauta
  • Member
  • Offline
  • Registered: 2011-11-11
  • Posts: 40

Re: iRedAdmin-Pro Internal server error

I was running iRedAdmin-Pro-SQL.2.5.0. Now, I've upgraded to iRedAdmin-Pro-SQL-2.6.0 and everything works fine.
The problem has been solved.

Thank you so much for your support.

Best regards.