1

Topic: Internal server error on login

==== Required information ====
- iRedMail version: 0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Linux/BSD distribution name and version: Centos 6.3 x86_64
- Related log if you're reporting an issue: Log attached
====

Hi,

I'm getting a strange error after install, I go to the admin page, and I just get a message saying: Internal server error

I look at the logs, there is nothing in httpd error log, openldap log, or mysql log indicating an error.

Logs below:
[root@www iRedMail-0.8.3]# tail -f /var/log/mysqld.log
121205 01:40:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121205 01:40:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121205  1:40:46 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
121205  1:40:46 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
121205  1:40:46  InnoDB: Initializing buffer pool, size = 8.0M
121205  1:40:46  InnoDB: Completed initialization of buffer pool
121205  1:40:50  InnoDB: Started; log sequence number 0 3561774
121205  1:40:51 [Note] Event Scheduler: Loaded 0 events
121205  1:40:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.66'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

[root@www iRedMail-0.8.3]# tail -f /var/log/httpd/error_log
[Wed Dec 05 01:40:28 2012] [error] Exception KeyError: KeyError(139684255336416,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Dec 05 01:40:28 2012] [error] Exception KeyError: KeyError(139684255336416,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Dec 05 01:40:28 2012] [error] Exception KeyError: KeyError(139684255336416,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Dec 05 01:40:28 2012] [notice] caught SIGTERM, shutting down
[Wed Dec 05 01:40:55 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Dec 05 01:40:55 2012] [notice] Digest: generating secret for digest authentication ...
[Wed Dec 05 01:40:55 2012] [notice] Digest: done
[Wed Dec 05 01:40:56 2012] [warn] mod_wsgi: Compiled for Python/2.6.2.
[Wed Dec 05 01:40:56 2012] [warn] mod_wsgi: Runtime using Python/2.6.6.
[Wed Dec 05 01:40:56 2012] [notice] Apache/2.2.15 (Unix) DAV/2 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_wsgi/3.2 Python/2.6.6 configured -- resuming normal operations

[root@www iRedMail-0.8.3]# tail -f /var/log/openldap.log
Dec  5 01:40:41 tmcc slapd[544]: @(#) $OpenLDAP: slapd 2.4.23 (Aug  8 2012 16:29:21) $#012#011mockbuild@c6b10.bsys.dev.centos.org:/builddir/build/BUILD/openldap-2.4.23/openldap-2.4.23/build-servers/servers/slapd
Dec  5 12:47:58 tmcc slapd[31694]: @(#) $OpenLDAP: slapd 2.4.23 (Aug  8 2012 16:29:21) $#012#011mockbuild@c6b10.bsys.dev.centos.org:/builddir/build/BUILD/openldap-2.4.23/openldap-2.4.23/build-servers/servers/slapd
Dec  5 12:48:09 tmcc slapd[31708]: @(#) $OpenLDAP: slapd 2.4.23 (Aug  8 2012 16:29:21) $#012#011mockbuild@c6b10.bsys.dev.centos.org:/builddir/build/BUILD/openldap-2.4.23/openldap-2.4.23/build-servers/servers/slapd

This is most strange, I have installed it on this server configuration before without the same problem.

Thanks,

Phil

2

Re: Internal server error on login

philtrick wrote:

[root@www iRedMail-0.8.3]# tail -f /var/log/httpd/error_log

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

3

Re: Internal server error on login

ZhangHuangbin wrote:
philtrick wrote:

[root@www iRedMail-0.8.3]# tail -f /var/log/httpd/error_log

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

Hi,

Thanks for the reply.

Yes, it looks as if there is not a table in mysql that is required:

[root@tmcc iRedMail-0.8.3]# tail -f /var/log/httpd/ssl_error_log
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]   File "/usr/lib/python2.6/site-packages/web/db.py", line 907, in delete
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]     self._db_execute(db_cursor, q)
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]   File "/usr/lib/python2.6/site-packages/web/db.py", line 587, in _db_execute
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]     out = cur.execute(query, params)
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]     self.errorhandler(self, exc, value)
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]     raise errorclass, errorvalue
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23] ProgrammingError: (1146, "Table 'iredadmin.sessions' doesn't exist")
[Fri Dec 07 00:11:46 2012] [error] [client 178.167.254.23]



I have imported the iredadmin.mysql file in the samples folder, are there any others I need to import?

Phi

4

Re: Internal server error on login

Database "iredadmin" should be created automatically during iRedMail installation, no idea why it didn't on your server.

philtrick wrote:

I have imported the iredadmin.mysql file in the samples folder, are there any others I need to import?

Just this file.
And, please make sure you have correct SQL username/password set in /var/www/iredadmin/settings.ini.