1

Topic: internal server error on editing domain settings

==== Required information ====
- iRedMail version: 1.8.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: debian 7.5, latest updates
- Related log if you're reporting an issue: /var/log/apache2/error.log
====

I can login to the /iredadmin page as postmaster (Admin) of my domains. Then "Domains & Accounts" -> "Edit Account Profile" resulting in text reading "internal server error".

/var/log/apache2/error.log gives me that output at that time:

[Fri Jul 11 19:42:07 2014] [error] [client 1.8.65.141] File does not exist: /var/www/favicon.ico
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141] Traceback (most recent call last):
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 239, in process
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     return self.handle()
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 230, in handle
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     return self._delegate(fn, self.fvars, args)
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 420, in _delegate
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     return handle_class(cls)
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 396, in handle_class
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     return tocall(*args)
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/share/apache2/iredadmin/controllers/decorators.py", line 11, in proxyfunc
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     return func(self, *args, **kw)
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]   File "/usr/share/apache2/iredadmin/controllers/mysql/domain.py", line 147, in GET
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]     domain_settings=iredutils.convert_sql_account_settings_to_dict(domain_profile['settings']),
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141] KeyError: 'settings'
[Fri Jul 11 19:42:30 2014] [error] [client 1.8.65.141]

I rarely use the Admin GUI. But I do apt-get update with updating the OS (security updates first, then package updates) regularily. IMHO this has broken iRedMail Admin Page.

Webmail is still working fine, all the services do work, too.

Pls give advise, what can be done to solve it - and - how to fix it permanently in future.

br
Walter

2

Re: internal server error on editing domain settings

We have some SQL structure changes in the latest iRedMail-0.8.7, please upgrade your iRedMail to the latest iRedMail-0.8.7 first.
Upgrade tutorials are available here:
http://www.iredmail.org/doc.html#upgrade_tutorial

3

Re: internal server error on editing domain settings

Well. Unsatisfactory.

Great:
cd <the-unpacked-roundcube-directory>
bin/installto.sh <your-existing-roundcube-directory>

Where is my existing round cube directory?

4

Re: internal server error on editing domain settings

root@mail:~/iRedMail-0.8.6-0.8.7-update/roundcubemail-1.0.1# ll /usr/share/apache2/roundcubemail
lrwxrwxrwx 1 root root 38 Feb 11 22:52 /usr/share/apache2/roundcubemail -> /usr/share/apache2/roundcubemail-0.9.5
root@mail:~/iRedMail-0.8.6-0.8.7-update/roundcubemail-1.0.1# cat /etc/apache2/conf.d/roundcubemail.conf
#
# File generated by iRedMail (2014.02.11.22.48.40):
#
# Version:  0.8.6
# Project:  http://www.iredmail.org/
#
# Community: http://www.iredmail.org/forum/
#

# Note: Please refer to /etc/apache2/sites-available/default-ssl for SSL/TLS setting.
Alias /mail "/usr/share/apache2/roundcubemail/"
<Directory "/usr/share/apache2/roundcubemail/">
    Options -Indexes
</Directory>
root@mail:~/iRedMail-0.8.6-0.8.7-update/roundcubemail-1.0.1#

Hmm. Wouldn't it be wise then to copy over the existing 0.9.5 to 1.0.1 and then do the update on the 1.0.1?

Still unsatifactory, but I understood, that I didn't pay for the iRedMail but for the Admin pages only... Maybe I should invest the $39 again.

5

Re: internal server error on editing domain settings

Just one SQL structure change is required, it's clearly mentioned in iRedMail upgrade tutorial here:
http://iredmail.org/wiki/index.php?titl … l_database

6

Re: internal server error on editing domain settings

Thanks for your very quick response and your support!

Indeed, just did the SQL updates worked for me! I didn't do any updates as stated in the full update steps but the MySQL queries only (I was a little bit afraid about breaking more than necessary and make it worse doing the SQL only in the first place).

br
Walter

7

Re: internal server error on editing domain settings

Please follow the upgrade tutorial to upgrade your iRedMail to the latest stable release, not just apply the SQL structure change.