Topic: Roundcube login fails

[Stefano]

is imap enabled on your server (acron.biz)?
does your server resolve acron.biz?

[stephdl]

# config show roundcube

see db command to find the password DB

is your mysql is working ?

[chrislaurie]

@stefano - IMAP is enabled. My server does resolve to acron.biz.

@stephdl - mysql is definitely working. If I use the password returned by config show roundcube, then the show databases command still fails. (This works for user admin)

[stephdl]

well and you can see the databases roundcube with your admin user ?

[chrislaurie]

Yes, the mysql show databases using:

mysql -u admin -p -e "show databases;"

and entering the root password, shows the roundcube database as one of the databases.

I have tried to change the db password using setprop and then changing the password of the roundcube user but that did not work either.

There is a slight change - when I load roundcube I get the page with the menu (mail, address book, calendar, settings) with a black top and grey body background. In the middle of the body the following message in a white  box:


DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.


In /opt/roundcube/logs/errors the following is shown in relation to this login attempt:

[18-Jan-2014 07:04:01 +0200]: DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /opt/roundcube/program/lib/Roundcu
be/rcube_db.php on line 154 (GET /roundcube/)
[18-Jan-2014 07:04:01 +0200]: DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/)

[stephdl]

well there is something misconfigured on your server which not appears on other server.

You should install a virtual machine to test the installation of roundcube, clone the VM (as this you can do more tests) and then you will see it works out of the box. Further more, once you will have an infrastructure of VM, you could help the sme server development by verifying bugs or test workaround....thanks in advance.

However I guess you need to completely remove all roundcube installation and try to reinstall it and see if you have an error message...then raise a bug.

Code: [Select]

yum clean all
yum remove smeserver-roundcube roundcube
signal-event console-save
config delete roundcube
log to mysql

Code: [Select]

mysql
then issue this command line to erase all databases and users

Code: [Select]

drop database roundcube;
USE mysql;
DELETE FROM user WHERE user = 'roundcube';
FLUSH PRIVILEGES;
then install roundcube

Code: [Select]

yum install smeserver-roundcube roundcube
signal-event conf-roundcube
I propose that all these CL need to be tested on a virtual machine first

[brianr]

I can confirm these instructions worked.

[warren]

I was asked to help someone with the same issue : ( his domain DNS server was set to : Internet DNS Servers)

What I found ( and can replicate the problem ) is that  under Manage Domains, if Domain DNS servers is set to : Internet DNS 
then roundcube login fails.

If under Manage Domains, Domains DNS servers is set to : Resolve locally , one can then login.

I tested this on VM running Proxmox with public IP's.

Might help others

[stephdl]

confirmed also here

if you set the dns setting to another thing than locally resolved you can not login to roundcube.

But I don't know why ????

Does the sme domain you set is reachable on the WWW ?, in fact the login is based on imap authentication so that can be an explanation.

[warren]

Does the sme domain you set is reachable on the WWW ?

Yes.
What prompted me to test further , was that webmail worked.

[Stefano]

just a guessing:

if you set up a domain to be externally resolved and try to connect from lan side, domain is resolved in his public ip.. so, at the end, we have a client (private ip) connecting from lan side to the external/wan side IP.. normally firewall would not permit such a kind of connection..

my 2c

[stephdl]

In fact it is internal to the sme, once the dns resolver set to external, the sme can not solve its own first domain

Code: [Select]

host mycompany.local
Host mycompany.local not found: 3(NXDOMAIN)

bug or not bug...

does someone can verify on sme8

EDIT : let's drop :p

[stephdl]

Can you test and reproduce also, please

set your dns resolver to external
set the imap access to public

login to roundcube and report back

[warren]

Code: [Select]

imap=service
    ConcurrencyLimit=400
    ConcurrencyLimitPerIP=12
    TCPPort=143
    access=public
    status=enabled

and

Code: [Select]

Description=Primary domain
    Nameservers=internet
    Removable=no
    SystemPrimaryDomain=yes


Results : Successfull logon to roundcube

[warren]

just a guessing:

if you set up a domain to be externally resolved and try to connect from lan side, domain is resolved in his public ip.. so, at the end, we have a client (private ip) connecting from lan side to the external/wan side IP.. normally firewall would not permit such a kind of connection..

my 2c

Confirmed, it resolves to the external

In fact it is internal to the sme, once the dns resolver set to external, the sme can not solve its own first domain

Code: [Select]

host mycompany.local
Host mycompany.local not found: 3(NXDOMAIN)

bug or not bug...

does someone can verify on sme8

EDIT : let's drop :p

Correct