1 Topic by posa68 (edited by posa68 2011-07-08 16:18:06)

  • posa68
  • Member
  • Offline
  • Registered: 2011-06-30
  • Posts: 111

Topic: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

Hi,

I install redmail + iredadmin pro wich I purchase on a clean Centos 5.6

The installation goes without error but when o try to enter in administration secion (https://your_server_ip_address/iredadmin/) I always obtain error (internal server error)...

Can you help me?

----

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,136

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

Any error log in Apache error log file?
It could be caused by incorrect file permission of config file (settings.ini), or incorrect MySQL accounts in settings.ini. Apache error log is helpful for troubleshooting.

3 Reply by posa68

  • posa68
  • Member
  • Offline
  • Registered: 2011-06-30
  • Posts: 111

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

This is very strange: it seems that is an error on file & path structure, I will check more deeper...

[Thu Jul 07 03:57:55 2011] [error] [client 202.75.211.206] File does not exist: /var/www/html/w00tw00t.at.blackhats.romanian.anti-sec:)
[Thu Jul 07 03:57:56 2011] [error] [client 202.75.211.206] File does not exist: /var/www/html/MyAdmin
[Thu Jul 07 03:57:56 2011] [error] [client 202.75.211.206] File does not exist: /var/www/html/phpmyadmin

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,136

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

Please check Apache config files: /etc/httpd/conf.d/ssl.conf.
It should contains some alias config for these web applications. For example:

Alias /mail "/var/www/roundcubemail/"
Alias /webmail "/var/www/roundcubemail/"
Alias /roundcube "/var/www/roundcubemail/"
Alias /phpldapadmin "/var/www/phpldapadmin/"
Alias /ldap "/var/www/phpldapadmin/"
Alias /phpmyadmin "/var/www/phpmyadmin/"
Alias /awstats/icon "/var/www/awstats/icon/"
ScriptAlias /awstats "/var/www/awstats/"

5 Reply by posa68

  • posa68
  • Member
  • Offline
  • Registered: 2011-06-30
  • Posts: 111

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

I reinstall the whole iredadminpro, now the error in apache log is:


[Thu Jul 07 09:25:09 2011] [notice] caught SIGTERM, shutting down
[Thu Jul 07 09:25:09 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 07 09:25:10 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 07 09:25:10 2011] [notice] Digest: done
[Thu Jul 07 09:25:10 2011] [notice] Apache configured -- resuming normal operations

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,136

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

posa68 wrote:

I reinstall the whole iredadminpro, now the error in apache log is:

These are normal log message, please check /var/log/httpd/ssl_error_log instead.

7 Reply by posa68

  • posa68
  • Member
  • Offline
  • Registered: 2011-06-30
  • Posts: 111

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

This is lasw few rows of /var/log/httpd/ssl_error_log ...


[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41] Traceback (most recent call last):
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/application.py", line 234, in process
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     return p(lambda: process(processors))
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/session.py", line 78, in _processor
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     self._cleanup()
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/session.py", line 161, in _cleanup
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     self.store.cleanup(timeout)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/session.py", line 308, in cleanup
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/db.py", line 890, in delete
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     db_cursor = self._db_cursor()
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/db.py", line 566, in _db_cursor
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     return self.ctx.db.cursor()
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/db.py", line 507, in _getctx
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     self._load_context(self._ctx)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/db.py", line 518, in _load_context
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     ctx.db = self._connect(self.keywords)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/web/db.py", line 546, in _connect
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     return self.db_module.connect(**keywords)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 75, in Connect
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     return Connection(*args, **kwargs)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]   File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 164, in __init__
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]     super(Connection, self).__init__(*args, **kwargs2)
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")
[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41]
[Thu Jul 07 11:55:52 2011] [error] [client 82.190.117.41] File does not exist: /var/www/html/favicon.ico

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,136

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

posa68 wrote:

[Thu Jul 07 11:55:51 2011] [error] [client 82.190.117.41] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

Got it.
You don't have correct password of MySQL user 'iredadmin' in iRedAdmin-Pro config file 'settings.ini'. It's defined in section '[iredadmin]'. Looks like below:

[iredadmin]

host = 127.0.0.1
port = 3306
db = iredadmin
user = iredadmin
passwd = plain_password          # <-- this one is incorrect

Please update it to the correct one, then restart Apache service to make it work.

9 Reply by posa68

  • posa68
  • Member
  • Offline
  • Registered: 2011-06-30
  • Posts: 111

Re: [SOLVED] iRedAdmin Pro MySQL 1.2.1 and server internal error...

WORKED!
My Fault...

Thanks Zhang: great support!