1 Topic by Mauricio

  • Mauricio
  • Mauricio
  • Member
  • Offline
  • From: Costa Rica
  • Registered: 2013-12-10
  • Posts: 16

Topic: ERROR Internal Server Error

Hi we have new iRedAdmin-Pro-MySql version ( 1.9.2 ) and I can log in without problem, but when we try to access some domain or user display INTERNAL SERVER ERROR, if i change to our old symbolic link to iRedAdmin.1.8.1 all work fine.
Now in the log I have this:
[Sat Mar 07 13:27:52 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)pache/2.2.15 (Unix) DAV/2 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips mod_wsgi/3.2 Python/2.6.6 configured
[Sat Mar 07 13:27:53 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Mar 07 13:27:53 2015] [notice] Digest: done
[Sat Mar 07 13:27:54 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips mod_wsgi/3.2 Python/2.6.6 configured -- resuming normal operations
[Sat Mar 07 14:39:42 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Mar 07 14:39:43 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Mar 07 14:39:43 2015] [notice] Digest: done
[Sat Mar 07 14:39:44 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips mod_wsgi/3.2 Python/2.6.6 configured -- resuming normal operations
~
Thank you for help!
==== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend : MySQL
- Linux/BSD distribution name and version: Centos 6.6 64 bits
====

----

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: 31,088

Re: ERROR Internal Server Error

Any related log in /var/log/httpd/ssl_error_log?

3 Reply by Mauricio

  • Mauricio
  • Mauricio
  • Member
  • Offline
  • From: Costa Rica
  • Registered: 2013-12-10
  • Posts: 16

Re: ERROR Internal Server Error

Tank you very much,

I did VirtualBox machine yesterday night to test this 'issue' and answerer myself, problem is that a I need create new columns on MySQL on Vmail database:

$ mysql -uroot -p
mysql> USE vmail;
mysql> ALTER TABLE mailbox ADD COLUMN enablelmtp TINYINT(1) NOT NULL DEFAULT 1;
mysql> ALTER TABLE mailbox ADD INDEX (enablelmtp);

mysql> ALTER TABLE mailbox ADD COLUMN settings TEXT;
mysql> ALTER TABLE domain ADD COLUMN settings TEXT;
mysql> ALTER TABLE admin ADD COLUMN settings TEXT;

mysql> ALTER TABLE alias ADD COLUMN islist TINYINT(1) NOT NULL DEFAULT 0;
mysql> ALTER TABLE alias ADD INDEX (islist);
mysql> UPDATE alias SET islist=1 WHERE address NOT IN (SELECT username FROM mailbox);
mysql> UPDATE alias SET islist=0 WHERE address=domain;    -- domain catch-all account

-- Remove old columns and store their value into new column: domain.settings
mysql> UPDATE domain SET settings='';
mysql> UPDATE domain SET settings=CONCAT(settings, IF(defaultlanguage IS NULL OR defaultlanguage='', '', CONCAT('default_language:', defaultlanguage, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(defaultuserquota IS NULL OR defaultuserquota=0, '', CONCAT('default_user_quota:', defaultuserquota, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(defaultuseraliases IS NULL OR defaultuseraliases='', '', CONCAT('default_groups:', defaultuseraliases, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(minpasswordlength IS NULL OR minpasswordlength=0, '', CONCAT('min_passwd_length:', minpasswordlength, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(maxpasswordlength IS NULL OR maxpasswordlength=0, '', CONCAT('max_passwd_length:', maxpasswordlength, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(disableddomainprofiles IS NULL OR disableddomainprofiles='', '', CONCAT('disabled_domain_profiles:', disableddomainprofiles, ';')));
mysql> UPDATE domain SET settings=CONCAT(settings, IF(disableduserprofiles IS NULL OR disableduserprofiles='', '', CONCAT('disabled_user_profiles:', disableduserprofiles, ';')));

mysql> ALTER TABLE domain DROP defaultlanguage;
mysql> ALTER TABLE domain DROP defaultuserquota;
mysql> ALTER TABLE domain DROP defaultuseraliases;
mysql> ALTER TABLE domain DROP minpasswordlength;
mysql> ALTER TABLE domain DROP maxpasswordlength;
mysql> ALTER TABLE domain DROP disableddomainprofiles;
mysql> ALTER TABLE domain DROP disableduserprofiles;
mysql> exit

So I can access all options on domains and user inside iRedAdmin-Pro-0.9.2, now very happy!