1 Topic by maikeldus (edited by maikeldus 2012-09-11 06:01:15)

  • maikeldus
  • Member
  • Offline
  • Registered: 2012-09-11
  • Posts: 2

Topic: Cannot login with RoundCube after fresh install iRedMail

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

Sep 10 23:12:09 imap-login: Info: Aborted login (auth failed, 1 attempts): user=<test@xxxxx.xx>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

So i started a fresh install with iRedAdmin. But when i finish the install i can't login with Roundcube, it drives me crazy :S.

Install seems to go fine (except it can't directly start dovecot because an syntax error in the config file, firstline is a whiteline). But i've started it manually and seems to work fine.

In the roundcube config states the following:

$rcmail_config['default_host'] = "127.0.0.1";

// TCP port used for IMAP connections
$rcmail_config['default_port'] = 143;

// IMAP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
// best server supported one)
$rcmail_config['imap_auth_type'] = "LOGIN";

Which seems to be right?

Whats going on?

----

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: 30,788

Re: Cannot login with RoundCube after fresh install iRedMail

Please turn on debug mode in Dovecot to see why it happened. Reference:
http://www.iredmail.org/wiki/index.php? … In.Dovecot

3 Reply by maikeldus (edited by maikeldus 2012-09-11 19:33:19)

  • maikeldus
  • Member
  • Offline
  • Registered: 2012-09-11
  • Posts: 2

Re: Cannot login with RoundCube after fresh install iRedMail

Thankyou for your reply:

After i checked the login, it queries the database, which is empty. It seems that during the install the inserts / right of the PGSQL database are messed up.

The SQL structure is there, but there are no rows inserted, and every user except postgres had no rights to read any database. After i've put these rights on every account i got this from iredmail:

[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx] Traceback (most recent call last):
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/application.py", line 235, in process
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     return p(lambda: process(processors))
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/session.py", line 82, in _processor
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     self._cleanup()
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/session.py", line 168, in _cleanup
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     self.store.cleanup(timeout)
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/session.py", line 315, in cleanup
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 906, in delete
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     db_cursor = self._db_cursor()
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 566, in _db_cursor
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     return self.ctx.db.cursor()
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 507, in _getctx
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     self._load_context(self._ctx)
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 518, in _load_context
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     ctx.db = self._connect(self.keywords)
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 960, in _connect
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     conn = DB._connect(self, keywords)
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]   File "/usr/lib/python2.6/site-packages/web/db.py", line 546, in _connect
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]     return self.db_module.connect(**keywords)
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx] OperationalError: FATAL:  password authentication failed for user "iredadmin"
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]
[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx]
[Tue Sep 11 15:14:58 2012] [error] Exception KeyError: KeyError(-1208215728,) in <module 'threading' from '/usr/lib/python2.6/threading.pyc'> ignored
[Tue Sep 11 15:14:59 2012] [error] Exception KeyError: KeyError(-1208215728,) in <module 'threading' from '/usr/lib/python2.6/threading.pyc'> ignored
[Tue Sep 11 15:15:07 2012] [error] Exception KeyError: KeyError(-1208215728,) in <module 'threading' from '/usr/lib/python2.6/threading.pyc'> ignored

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: Cannot login with RoundCube after fresh install iRedMail

1: You should paste related log in Dovecot log file (/var/log/dovecot.log), not Apache log.
2: You have incorrect password in iRedAdmin config file /var/www/iredadmin/settings.ini:

maikeldus wrote:

[Tue Sep 11 15:14:05 2012] [error] [client xxxxxxxxxx] OperationalError: FATAL:  password authentication failed for user "iredadmin"