HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Roundcube "DATABASE ERROR: CONNECTION FAILED!" (http://www.howtoforge.com/forums/showthread.php?t=62453)

laptop_user 5th July 2013 22:45

Roundcube "DATABASE ERROR: CONNECTION FAILED!"
 
Hi everyone,

So today I update my Debian Squeeze to Wheezy and update my ispconfig to latest 3.0.5.2.

I can't login to webmail after update so I guess I need to reinstall roundcube.
I follow this tutorial here http://www.howtoforge.com/using-roun...wheezy-apache2 and somehow there's no step to enter roundcube user password.

Code:

MySQL application password for roundcube: <-- roundcubesqlpassword
- wizard don't show me the step above.


and also I get error because existing roundcube database has already existed so I drop it and created a new one with
Code:

dpkg-reconfigure roundcube-core

I try to login to roundcube database via phpmyadmin but failed. So I guess probably the password is wrong or something so I ran
Code:

vi /etc/roundcube/debian-db.php
and add my own password:
Code:

$dbpass='mypassword';
but unfortunately nothing change. I can't login to roundcube db via phpmyadmin.

So now my problem is my website roundcube www.hello.com/webmail is giving me this error:
Code:

DATABASE ERROR: CONNECTION FAILED!

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

Now I'm not sure in what way I can troubleshoot? Anyone know how to solve this? Thanks in advance.

laptop_user 6th July 2013 12:14

The issue has been resolved. I login to console as root and then change the roundcube user password manually.

Quote:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password = PASSWORD ('putyourroundcubepass') WHERE User='roundcube';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.39 sec)

mysql> quit
Bye
Thanks everyone :)


All times are GMT +2. The time now is 21:28.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.