Topic: Roundcube login fails

[chrislaurie]

Hi

I installed RoundCube as per the wiki but when I log on it fails with the following error message:

Connection to storage server failed

Any ideas?

[stephdl]

did you do ?

 yum --enablerepo=smecontribs install smeserver-roundcube
and
signal-event post-upgrade; signal-event reboot

it works out of the box for me, you should take a look to the logs

less /var/log/messages
and
less /var/log/httpd/error_log

[chrislaurie]

I copied and pasted the install instructions as is. On 2 servers in fact. One was migrated using affa (new install, become affa of old sme7, then rise) and the other a clean install of sme 8 - both have the same problem.

If I enter the wrong login details it says login failed (expected). If I enter a correct username and password it says loading for a second or 2 an then: "Connection to storage server failed."

There is nothing in less /var/log/messages or /var/log/httpd/error_log - but I did find something in /opt/roundcube/logs/error:

[04-Dec-2013 05:11:42 +0200]: IMAP Error: Login failed for admin from 192.168.0.104. Could not connect to acron.biz:143: Connection refused in /opt/roundcube/program/lib/Roundcube/rcube_imap.php on line 184 (POST /roundcube/?_task=login&_action=login)

I have used PuTTy to telnet to port 143 and I get this response:
* OK imapfront ready. + stunnel

I know it works out of the box for you but it does unfortunately not for me.

Any ideas on what I can try, please?

[Stefano]

who is acron.biz?

[stephdl]

some ideas :

-can you use the webmail horde with the same credentials of users ?
-the url where roundcube is reachable is https://sme-ip/roundcube ?
-do you have dovecot updated manually ?
-didi you install te old version of roundcube previously in sme7contribs ?
-do you take a look to google when you search "Connection to storage server failed."
-who is acron.biz ?

[chrislaurie]

Thanx for the response:

-can you use the webmail horde with the same credentials of users ?
     yes using ip, servername and domain.
-the url where roundcube is reachable is https://sme-ip/roundcube ?
     yes, the login page loads and the
-do you have dovecot updated manually ?
     no, I don't think so
-didi you install te old version of roundcube previously in sme7contribs ?
     I don't think so on this server. I did check that there was no trace of roundcube but I may have missed something. On the second server definitely not. It is a brand new install of sme8.2.
-do you take a look to google when you search "Connection to storage server failed."
     I did, but did not yet find an idea as to what might be going on. Those installs are also quite different with roundcube living in /opt etc.
-who is acron.biz ?
     That is my domain. It fails on both the domain and the server name.

[chrislaurie]

So I found this post http://www.roundcubeforum.net/index.php?topic=14742.0

The user says his schoolboy error was that he needed the following entry in the  /ete/rc.conf file:

dovecot_enable="YES"

but sme does not have a rc.conf file

[stephdl]

are you in "server and gateway" or "server_only" for the configuration of your smeserver ?

[chrislaurie]

server only for the moment.

[stephdl]

please report the output of

/sbin/e-smith/audittools/newrpms

/sbin/e-smith/audittools/repositories

[chrislaurie]

Thanks again for your response. Here are the answers.

/sbin/e-smith/audittools/newrpms:

libmcrypt.x86_64                      2.5.8-4.el5.centos               installed
php53-mcrypt.x86_64                   5.3.3-1.el5                      installed
php53-php-gettext.noarch              1.0.11-3.el5                     installed
phpMyAdmin3.noarch                    3.5.8.1-1.el5                    installed
roundcube.noarch                      0.9.5-1.el5.sme                  installed
smeserver-phpmyadmin.noarch           3.5.2.2-6.el5.sme                installed
smeserver-release.noarch              26:8.1-0.beta2.el5.sme           installed
smeserver-roundcube.noarch            0.9-18.el5.sme                   installed

/sbin/e-smith/audittools/repositories:
addons: disabled
base: disabled
centosplus: disabled
contrib: disabled
dag: disabled
epel: disabled
extras: disabled
geekery: disabled
nethsme: disabled
smeaddons: enabled
smecontribs: disabled
smedev: disabled
smeextras: enabled
smeos: enabled
smetest: disabled
smeupdates: enabled
smeupdates-testing: disabled
snetram: disabled
sogo: disabled
squeezecenter-release: disabled
squeezecenter-testing: disabled
squeezecenter-unstable: disabled
stephdl: disabled
through-ip: disabled
updates: disabled

[stephdl]

can you do the same command line on the two computers (on upgraded and one installed from scratch) to understand why it doesn't work, and specify which server it is

[stephdl]

this output is normal i do not understand, probably you have to remove completely roundcube and its mysql DB and reinstall again, with a big attention to the yum output

[janet]

chrislaurie

Some of your repos are configured incorrectly & you would be missing vital updates packages, your server could be in a real mess as a result.
These should be status=enabled
base
updates

See
http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Which_repositories_should_be_enabled
Follow the instructions for enabling these & then you should run yum update

[mmccarn]

Hi

I installed RoundCube as per the wiki but when I log on it fails with the following error message:

Connection to storage server failed

Any ideas?

According to this thread, you may see this error if there is no mailbox on the SME server for the user you are trying to login:
http://www.roundcubeforum.net/index.php?topic=9886.0

According to this thread, the problem may be damaged dovecot indexes:
http://help.directadmin.com/item.php?id=473

There is a db connection string in /opt/roundcube/config/db.inc.php:
$rcmail_config['db_dsnw'] = 'mysql://<dbuser>:<dbpassword>@<dbhost>/dbname>';
Do the specified username, password, host, and database name work correctly?  You can test this using:

Code: [Select]

mysql -u <dbuser> -p -e "show databases;"Copy and paste the password from your connect string.  The output should look like this:

Code: [Select]

+--------------------+
| Database           |
+--------------------+
| information_schema |
| <dbname>           |
| test               |
+--------------------+

[chrislaurie]

@janet I also saw that - not sure how that happened. Trying to work out the command line that turns them on because they do not appear in the server-manager front end.

@mmccarn - I think you are on to something. On the production server I roundcube cannot get verified by the password as specified, but admin can get a list of databases. On the other completely fresh SME8.1 neither can get access.

I veriffied this after a compete uninstall and re-install. Removed the databases and roundcube users. I say users, because when I went to remove the user there were 2 roundcube users! One with host % and onw with host: localhost. One last thing I tried, before the uninstall and re-install was to give the password in   /opt/roundcube/config/db.inc.php to the roundcube users with phpmyadmin in MySql. This had some effect: the screen looked as if the logon passed but there was an error about failure to connect as well.

Anyway I now have one user, a roundcube database, but still no luck past the Connection to storage failed.

Is it save to delete the dovecot indices?

Is the logon failure a permissions thing?

Should I try changing the password again?

Thank you all for helping me so far.

[stephdl]

just one question.
When you want to perform an authentication to roundcube do you do just with the name of your user

for example

Code: [Select]

userthen issue the password

or do you try

Code: [Select]

user@acron.biz
that is not good

[janet]

chrislaurie

@janet I also saw that - not sure how that happened.

Possibly a carry over from the late days of sme7 & repo changes/shutdowns if you upgraded to sme8.
You should have used the commands to reset all repos to standard.

Trying to work out the command line that turns them on because they do not appear in the server-manager front end.

You need to read the FAQ link a bit more thoroughly, see
http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Adding.2C_removing_or_disabling_repositories

I strongly advise you to stop troubleshooting roundcube for now, fix your repos, run yum update, post-upgrade & reboot, then once your system is up to date try again with roundcube.

[chrislaurie]

OK so I fixed the repos, ran update (it found 3 files one of them was grub). And now I am back to troubleshooting Roundcube.

The mysql login is my current suspect.

[chrislaurie]

I just tried to change the pasword of the roundcube user in MySql to the password in the db.inc.php.

I get past the login screen but the then there is a database connection error in the middle of the page. The mail, address book, calendar  and settings icons is visible but nothing works just the error message is shown.

[egareg]

Hi all !

I also tried to run RoundCube on my sme server (v8.0) but it failed when I want to access on roundcube.
I just follow the steps in the wiki (http://wiki.contribs.org/RoundCube), but I obtain an error : "DATABASE ERROR: CONNECTION FAILED!"

I tried also the database test mentionned by mmccarn. It failed (see below).

Code: [Select]

[root@sme ~]# mysql -u roundcube -p -e "show databases;"
Enter password:
ERROR 1045 (28000): Access denied for user 'roundcube'@'localhost' (using password: YES)

After all, I looked into mysql about this "odd" roundcube database. And I found... nothing !
The installation process might be incomplete because no database was created... But I didn't see any kind of error during installation process.
I don't know wich tables have to be created in this roundcube database. So I can't do it manually.

[EDIT]
I found the file mysql.initial.sql in the installation package on roundcube website.
My roundcube database is fully created, the tables also...
But the connection issue is still there...
[/EDIT]

[egareg]

Eureka ! 

Reading some stuff in the

Code: [Select]

/opt/roundcube/logs/errors file indicates that

Code: [Select]

Table 'roundcube.carddav_addressbooks' doesn't exist
To create it, just go to

Code: [Select]

/opt/roundcube/plugins/carddav/dbinit and execute the next command :

Code: [Select]

mysql -u roundcube -p roundcube < mysql.sql
That's it for me ! 

[EDIT]
The same action has to be achieved with calendar :

Code: [Select]

cd /opt/roundcube/plugins/calendar/drivers/database/sql
mysql -u roundcube -p roundcube < mysql.sql[/EDIT]

[mmccarn]

Congratulations!

If you have the time to help, you could open a bug report about 'installation does not configure mysql database correctly' using this URL:
http://bugs.contribs.org/enter_bug.cgi?product=SME%20Contribs&component=smeserver-roundcube&short_desc=&comment=

(assuming you agree with me about what happened).

[egareg]

I don't have account on bugs.contribs.org and I can't create one :

Code: [Select]

You don't have permission to access /createaccount.cgi on this server.

[egareg]

Is it possible to update the wiki page on contribs.org ?

How could I register on the wiki ?

[mmccarn]

I had no trouble creating a new bugzilla account just now -

I browsed to this page and entered an email address:
http://bugs.contribs.org/createaccount.cgi

I received a bugzilla registration confirmation email within seconds, and was prompted to change my password when I clicked on the account confirmation link in the email.


Wiki accounts are created by request based on your forum account:
http://wiki.contribs.org/Help:Contents#How_to_get_a_wiki_account.3F

[egareg]

Ho !
Unable to register on bugzilla with my Opera browser... I tried with Firefox and it's OK ! 
No matter.

I will open a bug report.

[egareg]

Oops ! 

I tried to install Tiny Tiny RSS on mys server and I noticed the same probleme : no database was created during installation...

I search around with 'database', 'MySQL' keywords and I found this page on the wiki : http://wiki.contribs.org/MySQL (not so far hidden ).
I noticed the MySQL root password chapter and try to reset it... just in case of... my mind said 'do it' (perhaps I did some stuff around that issue some time ago).

That's it ! 

I think that the password for MySQL root wasn't correct. It's not a bug from the contribs, just a bug from the server manager (me!).

[stephdl]

Thanks for reporting

[chrislaurie]

Still not working for me.
I reset the mysql root password.
I tested that I can connect with phpmyadmin and the show databases for the admin account.
I then un-installed roundcube, dropped the database and ensured that there is nothing that I can find left.
I then re-installed roundcube.
When I log as any of the known users I get the "Connection to storage server failed." message.
In /opt/roundcube/logs/errors I have the following entries:

[17-Jan-2014 15:46:49 +0200]: IMAP Error: Login failed for admin from 192.168.0.104. Could not connect to acron.biz:143: Connection refused in /opt/roundcube/program/lib/Round
cube/rcube_imap.php on line 184 (POST /roundcube/?_task=login&_action=login)
[17-Jan-2014 15:52:55 +0200]: IMAP Error: Login failed for chris from 192.168.0.104. Could not connect to acron.biz:143: Connection refused in /opt/roundcube/program/lib/Round
cube/rcube_imap.php on line 184 (POST /roundcube/?_task=login&_action=login)

The carddav_addressbooks table is there as is the database.

One thing using this command:

mysql -u roundcube -p -e "show databases;" fails as I do not know the roundcube user password.

Any suggestions welcomed!

[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

[stephdl]

i'm currently working on roundcube, I want to merge my own rpm and the epel rpm,so I will provide a patch to solve that issue, thank to have reported it.