1 (edited by DVK 2021-02-24 18:03:59)

Topic: SOLVED: Roundcube login failed (error: -2)

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Deployed with iRedMail Easy or the downloadable installer? from FreeBSD ports
- Linux/BSD distribution name and version: FreeBSD 11.1-RELEASE
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I got weird problem: cannot login to accounts in Roundcube (all other IMAP/POP3 clients works ok).
In roundcube logs I see:
[24-Feb-2021 09:24:38 +0000]: <msbks13p> Failed login for user@domain from 7.9.7.5 in session msbks13p3
f7buj6rn000ieid82 (error: -2)

In SQL log:
[24-Feb-2021 09:24:37 +0000]: <msbks13p> [1] SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE
`sess_id` = 'msbks13p3f7buj6rn000ieid82';
[24-Feb-2021 09:24:37 +0000]: <msbks13p> [2] DELETE FROM `session` WHERE `sess_id` = 'msbks13p3f7buj6rn000ieid
82';
[24-Feb-2021 09:24:37 +0000]: <msbks13p> [3] SELECT * FROM `users` WHERE `mail_host` = '' AND `username` = '';
[24-Feb-2021 09:24:38 +0000]: <msbks13p> [4] DELETE FROM `session` WHERE `sess_id` = 'msbks13p3f7buj6rn000ieid
82';
[24-Feb-2021 09:24:38 +0000]: <msbks13p> [5] INSERT INTO `session` (`sess_id`, `vars`, `ip`, `changed`) VALUES
('msbks13p3f7buj6rn000ieid82', 'bGFuZ3VhZ2V8czo1OiJydV9SVSI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5IjtyZXF1ZXN0X3Rva
2VufHM6MzI6IjllekIxNmVOSk1JTlBtc0k5QTZtYTh3a0hSRG9iMlVPIjs=', '7.9.7.5', now());

tcpdump at lo0 shows no attempts to connect nor to port 143, nor to port 4190.

I'm confused why there is '' at mail_host and username in SELECT query? What can be wrong?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 (edited by DVK 2021-02-24 18:24:28)

Re: SOLVED: Roundcube login failed (error: -2)

SOLVED: just installed roundcube version 1.3.16 (was 1.3.5) and everything works fine with the same config.
Looks like it's better to keep software always updated to the latest version to avoid such problems.