1 Topic by mc.choice (edited by mc.choice 2013-06-28 06:28:40)

  • mc.choice
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 4

Topic: IredMail installation

==== Required information ====
- iRedMail version: 0.8.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 12.10.1
- Related log if you're reporting an issue: /
====

Greetings, developers and fellow IRedMail-ers smile

I have a problem... (obviously). I am trying to install iRedMail on a server over Putty, cuz I don't have psyhical access to it. I followed these instructions carefully:

http://www.iredmail.org/install_iredmail_on_ubuntu.html

And now, when I try to enter admin panel at "https://server/iredadmin/", I see the login screen, but when I enter login information, which I get from "iRedMail.tips", I get an Internal Server Error. I turned on Debug mode, and this is what I get:

<type 'exceptions.TypeError'> at /login
__init__() should return None

Python    /usr/share/apache2/iredadmin/controllers/mysql/basic.py in POST, line 38
Web    POST https://server/iredadmin/login

Line 38 in that file is: auth = core.Auth()



Any ideas? I really have to make this work sad

I am new here, I just registred. If I did something wrong with posting this (wrong thread, topic, etc...) - I apologize.

Tnx in advance!

----

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

Re: IredMail installation

The log you paste is not enough, please paste full error log in Apache log file.

3 Reply by mc.choice (edited by mc.choice 2013-06-28 15:45:49)

  • mc.choice
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 4

Re: IredMail installation

ZhangHuangbin wrote:

The log you paste is not enough, please paste full error log in Apache log file.

Hey ZhangHuangbin, tnx 4 fast reply! smile


Here is apache error.log from /var/log/apache2/error.log



[Thu Jun 27 12:41:19 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:41:19 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:41:20 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:41:20 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:41:20 2013] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_wsgi/3.4 Python/2.7.3 configured -- resuming norm$
[Thu Jun 27 12:41:35 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/javascripts, referer: http://beta.treeter$
[Thu Jun 27 12:41:35 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/javascripts, referer: http://beta.treeter$
[Thu Jun 27 12:41:35 2013] [error] [client 193.77.237.43] File does not exist: /var/www/beta/favicon.ico
[Thu Jun 27 12:41:43 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/favicon.ico
[Thu Jun 27 12:44:04 2013] [notice] caught SIGTERM, shutting down
[Thu Jun 27 12:44:30 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:44:30 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:44:30 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:44:30 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:44:30 2013] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_wsgi/3.4 Python/2.7.3 configured -- resuming norm$
[Thu Jun 27 12:50:40 2013] [notice] caught SIGTERM, shutting down
[Thu Jun 27 12:51:06 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:51:06 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:51:06 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:51:06 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:51:06 2013] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_wsgi/3.4 Python/2.7.3 configured -- resuming norm$
[Thu Jun 27 12:51:57 2013] [notice] caught SIGTERM, shutting down
[Thu Jun 27 12:52:23 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:52:23 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:52:23 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:52:23 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:52:23 2013] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_wsgi/3.4 Python/2.7.3 configured -- resuming norm$
[Thu Jun 27 12:53:44 2013] [notice] caught SIGTERM, shutting down
[Thu Jun 27 12:54:09 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:54:09 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:54:10 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jun 27 12:54:10 2013] [warn] RSA server certificate CommonName (CN) `treeters.com' does NOT match server name!?
[Thu Jun 27 12:54:10 2013] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_wsgi/3.4 Python/2.7.3 configured -- resuming norm$
[Thu Jun 27 12:55:13 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/favicon.ico
[Thu Jun 27 12:55:19 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/javascripts, referer: http://beta.treeter$
[Thu Jun 27 12:55:19 2013] [error] [client 193.77.237.43] File does not exist: /var/www/treeters.com/javascripts, referer: http://beta.treeter$
[Thu Jun 27 12:55:20 2013] [error] [client 193.77.237.43] File does not exist: /var/www/beta/favicon.ico
[Thu Jun 27 12:55:27 2013] [error] [client 193.77.237.43] File does not exist: /var/www/beta/favicon.ico




And this is what I get with tail -f /var/log/apache2/error.log



[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]     return handle_class(cls)
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 396, in handle_class
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]     return tocall(*args)
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]   File "/usr/share/apache2/iredadmin/controllers/mysql/basic.py", line 39, in POST
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]     auth = core.Auth()
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9] TypeError: __init__() should return None
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9]
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9] 0.0 (4): SELECT * FROM sessions WHERE session_id='48499a8deabbdd96fdad4cc86d086f1a4fe7ab38'
[Fri Jun 28 06:11:37 2013] [error] [client 89.212.180.9] 0.0 (5): UPDATE sessions SET data = 'KGRwMQpTJ3VzZXJuYW1lJwpwMgpOc1MnbGFuZycKcDMKUydlbl9VUycKcDQKc1MnaXAnCnA1ClY4\\nOS4yMTIuMTgwLjkKcDYKc1MnZW5hYmxlQW1hdmlzZExvZ2dpbmdJbnRvU1FMJwpwNwpJMDAKc1Mn\\nbG9nZ2VkJwpwOApJMDAKc1MnZW5hYmxlQW1hdmlzZFF1YXJhbnRpbmUnCnA5CkkwMApzUydzZXNz\\naW9uX2lkJwpwMTAKUyc0ODQ5OWE4ZGVhYmJkZDk2ZmRhZDRjYzg2ZDA4NmYxYTRmZTdhYjM4Jwpw\\nMTEKc1MnZW5hYmxlU2hvd1VzZWRRdW90YScKcDEyCkkwMApzUydzdG9yZVBhc3N3b3JkSW5QbGFp\\nbicKcDEzCkkwMApzUydlbmFibGVQb2xpY3lkJwpwMTQKSTAwCnNTJ2ZhaWxlZFRpbWVzJwpwMTUK\\nSTAKc1Mnd2VibWFzdGVyJwpwMTYKUyd3ZWJtYXN0ZXJAdHJlZXRlcnMuY29tJwpwMTcKcy4=\\n' WHERE session_id='48499a8deabbdd96fdad4cc86d086f1a4fe7ab38'
[Fri Jun 28 06:11:38 2013] [error] [client 89.212.180.9] File does not exist: /var/www/favicon.ico

4 Reply by mc.choice

  • mc.choice
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 4

Re: IredMail installation

Ok so I tried to fix the problem... now I got a new one big_smile

<class '_mysql_exceptions.OperationalError'> at /login
(1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")

Apache error.log (tail):


[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]     return self.db_module.connect(**keywords)
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]     return Connection(*args, **kwargs)
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]     super(Connection, self).__init__(*args, **kwargs2)
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] OperationalError: (1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9]
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] 0.0 (4): SELECT * FROM sessions WHERE session_id='48499a8deabbdd96fdad4cc86d086f1a4fe7ab38'
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] 0.0 (5): UPDATE sessions SET data = 'KGRwMQpTJ3VzZXJuYW1lJwpwMgpOc1MnbGFuZycKcDMKUydlbl9VUycKcDQKc1MnaXAnCnA1ClY4\\nOS4yMTIuMTgwLjkKcDYKc1MnZW5hYmxlQW1hdmlzZExvZ2dpbmdJbnRvU1FMJwpwNwpJMDAKc1Mn\\nbG9nZ2VkJwpwOApJMDAKc1MnZW5hYmxlQW1hdmlzZFF1YXJhbnRpbmUnCnA5CkkwMApzUydzZXNz\\naW9uX2lkJwpwMTAKUyc0ODQ5OWE4ZGVhYmJkZDk2ZmRhZDRjYzg2ZDA4NmYxYTRmZTdhYjM4Jwpw\\nMTEKc1MnZW5hYmxlU2hvd1VzZWRRdW90YScKcDEyCkkwMApzUydzdG9yZVBhc3N3b3JkSW5QbGFp\\nbicKcDEzCkkwMApzUydlbmFibGVQb2xpY3lkJwpwMTQKSTAwCnNTJ2ZhaWxlZFRpbWVzJwpwMTUK\\nSTAKc1Mnd2VibWFzdGVyJwpwMTYKUyd3ZWJtYXN0ZXJAdHJlZXRlcnMuY29tJwpwMTcKc1MnaXNN\\nYWlsVXNlcicKcDE4CkkwMApzLg==\\n' WHERE session_id='48499a8deabbdd96fdad4cc86d086f1a4fe7ab38'
[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] File does not exist: /var/www/favicon.ico

5 Reply by ZhangHuangbin

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

Re: IredMail installation

mc.choice wrote:

[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] OperationalError: (1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")

It's clear here.
Could you please verify the password of MySQL user "vmailadmin" in iRedAdmin config file (/usr/share/apache2/iredadmin/settings.ini)? Restarting Apache service is required if you updated the password.

6 Reply by mc.choice (edited by mc.choice 2013-06-28 20:47:50)

  • mc.choice
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 4

Re: IredMail installation

ZhangHuangbin wrote:
mc.choice wrote:

[Fri Jun 28 10:19:32 2013] [error] [client 89.212.180.9] OperationalError: (1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")

It's clear here.
Could you please verify the password of MySQL user "vmailadmin" in iRedAdmin config file (/usr/share/apache2/iredadmin/settings.ini)? Restarting Apache service is required if you updated the password.

Yes, I checked the password, and it sould be correct. It's the same password that I use to access Mysql.

# Database used to store mail accounts.
#
[vmaildb]
host = localhost
port = 3306
db = vmail
user = vmailadmin
passwd = <mypasswordhere>

What else could be wrong?

EDIT:

Now it's this:

<class '_mysql_exceptions.ProgrammingError'> at /login
(1146, "Table 'vmail.admin' doesn't exist")

I got this after trying to set permissions again:

GRANT ALL ON *.* TO iredadmin@mail.treeters.com IDENTIFIED BY '<mypasswordhere>';
GRANT ALL ON *.* TO vmailadmin@mail.treeters.com IDENTIFIED BY '<mypasswordhere>';

7 Reply by ZhangHuangbin

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

Re: IredMail installation

mc.choice wrote:

(1146, "Table 'vmail.admin' doesn't exist")

MySQL table "vmail.admin" doesn't exist? Looks like your iRedMail installation was not successfully completed, not sure what happened during installation.
I suggest you try to re-install your OS, then re-install iRedMail. It's the easiest way to get a working iRedMail server.