On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

RoundCube webmail is not accessible on Plesk: DATABASE ERROR: CONNECTION FAILED

Follow

Comments

9 comments

  • Avatar
    Micha Rozenhart

    So after the update of about a week ago, my Roundcube on a fully upgrade Plesk Onyx on Ubuntu started showing an empty Inbox.
    After the latest update I hoped that would be fixed (but it wasn't).

    I've removed Roundcube and reinstalled it: still empty Inboxes.
    I then removed it again and noticed an error about /usr/lib/psa-roundcube folder not being removed because it wasn't empty.
    I then manually deleted the folder and reinstalled, which cause the database connection error mentioned in this article.

    I checked that the user was there and did everything is step 6.
    On Step 7 I keep getting an error that the roundcube database doesn't exist (and I've re-installed Roundcube multiple times and it always results in a message that the install was successful).


    I hope there's a fix for this, because I really dislike Horde.. :(

    Server details:
    OS:  ‪Ubuntu 16.04.4 LTS‬
    Product:  Plesk Onyx - Web pro edition
    Version 17.8.11 Update #7, last updated on May 8, 2018 07:28 PM

    0
    Comment actions Permalink
  • Avatar
    Lars-Erik H.Bergland

    Step 6 refers to setting priveliges on roundcubemail which I have, but 7 refers to testing if roundcube exits, which I dont have. Does roundcube use 2 databases?

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Lars-Erik H.Bergland, 

    RoundCube uses one database. Step 6 is for creating the database user. Step 7 is for recreating RoundCube database in case it does not exist.

     

    0
    Comment actions Permalink
  • Avatar
    Edwin C (Edited )

    For me after the system update the file /usr/share/psa-roundcube/config/config.inc.php was renamed to config.inc.php.dpkg-old and replaced with new file which had empty password. I copied the password from config.inc.php.dpkg-old and pasted it in new file.

    Also ran /usr/share/psa-roundcube/bin/update.sh to complete the roundcube update.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov (Edited )

    Hello @Edwin C,

    Thank you for sharing your user experience.

    0
    Comment actions Permalink
  • Avatar
    Tushar Bhagat

    I have tried that, but it's not working for me. Apparently I have to tables in my database

     

    show databases like "%roundcube%";

    +------------------------+

    | Database (%roundcube%) |

    +------------------------+

    | roundcube              |

    | roundcubemail          |

    +------------------------+

    2 rows in set (0.000 sec)

     

    I have imported a dump of my previous mySQL db. How can I resolve this? 

    0
    Comment actions Permalink
  • Avatar
    Anzhelika Khapaknysh

    @Tushar Bhagat,

    The issue may be caused by various reasons.
    I'd recommend contacting our Support Team directly, so they may investigate your particular case thoroughly. 

    0
    Comment actions Permalink
  • Avatar
    Tushar Bhagat

    I changed the user name and password to a known working set in /usr/share/psa-roundcube/config/config.inc.php and voila :)

    0
    Comment actions Permalink
  • Avatar
    Christian

    I could solve my problem for roundcube database connection error via same solution, but only by reading the configured password manually and then set it in mysql:

    1. nano /usr/share/psa-roundcube/config/config.inc.php and look for the password before "@localhost"
    2. plesk db to go to mysql
    3. update user set password=PASSWORD('READ_FROM_STEP1') where user ='roundcube';
    4. flush privileges;

    done. could then enter webmail.DOMAIN.com.

    It did not work with the provided solution above, despite I did not get any error!

    1
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request