Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th July 2013, 22:45
laptop_user laptop_user is offline
Member
 
Join Date: Aug 2011
Posts: 78
Thanks: 34
Thanked 7 Times in 7 Posts
Default 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.

Last edited by laptop_user; 5th July 2013 at 22:58.
Reply With Quote
Sponsored Links
  #2  
Old 6th July 2013, 12:14
laptop_user laptop_user is offline
Member
 
Join Date: Aug 2011
Posts: 78
Thanks: 34
Thanked 7 Times in 7 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Roundcube 0.8.5 login mod for ISPconfig arty.lv Tips/Tricks/Mods 1 12th March 2013 12:59
How I saved my RoundCube users emails cvgeeks Server Operation 1 11th July 2012 05:08
How to upgrade Roundcube 0.3 to 0.7 on Ubuntu 10.04 LTS cbj4074 Tips/Tricks/Mods 1 19th January 2012 19:50
403 errors & freezing in ispconfig3, roundcube webmail cvgeeks Server Operation 5 26th June 2011 00:35
ISPConfig 3 & Roundcube atjensen11 Installation/Configuration 11 3rd September 2009 19:51


All times are GMT +2. The time now is 07:22.


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