Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

11.24 Upgrade: Roundcube Database Connect Error

Discussion in 'General Discussion' started by RickG, Dec 25, 2008.

  1. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    North Carolina
    Just migrated from 11.23 -> 11.2411.24.4-R32603 without incident.

    Only issue is that users cannot access Roundcube webmail (they are getting DATABASE ERROR: CONNECTION FAILED!) when trying to bring up the URL.

    I've had roundcube installed under /usr/local/lib/php/roundcube/ and running w/o issue prior to the 11.24 upgrade. In the roundcube log file I'm finding:

    [25-Dec-2008 11:00:35 -0500] DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]

    Any thoughts?
     
    #1 RickG, Dec 25, 2008
    Last edited: Dec 26, 2008
  2. nerbonne

    nerbonne Well-Known Member

    Joined:
    Aug 19, 2007
    Messages:
    52
    Likes Received:
    1
    Trophy Points:
    58
    I get this same error after upgrading from 10.x to 11.x. Both Roundcube and Horde give this error, while squirrellmail works? Previously in 10.x we did not have Roundcube.

    I'd be really interested in a solution to this. Thanks.

    Horde error:

    A fatal error has occurred
    DB Error: connect failed
    Details have been logged for the administrator.


    Here is what my mysql error file says. Note that there are no new entries newer than the 18th, but the problem still occurs and I just tried to login and an error was not written:

    081118 10:03:41 [Warning] Found invalid password for user: 'bedflixc@localhost'; Ignoring user
    081118 10:03:41 [Warning] Found invalid password for user: 'bedflixc_psadmin@localhost'; Ignoring user
    081217 8:00:14 [Warning] Found invalid password for user: 'naturest@localhost'; Ignoring user
    081217 8:00:14 [Warning] Found invalid password for user: 'naturest_psadmin@localhost'; Ignoring user
    081218 8:00:36 [Warning] Found invalid password for user: 'afterpar@localhost'; Ignoring user
    081218 8:00:36 [Warning] Found invalid password for user: 'afterpar_afterpa@localhost'; Ignoring user



    Also note that the server came up normally with no errors:

    081225 12:14:38 InnoDB: Starting shutdown...
    081225 12:14:40 InnoDB: Shutdown completed; log sequence number 0 189056493
    081225 12:14:40 [Note] /usr/sbin/mysqld: Shutdown complete

    081225 12:14:40 mysqld ended

    081225 12:14:40 mysqld started
    081225 12:14:40 InnoDB: Started; log sequence number 0 189056493
    081225 12:14:40 [Note] /usr/sbin/mysqld: ready for connections.
     
    #2 nerbonne, Dec 25, 2008
    Last edited: Dec 25, 2008
  3. sirotex

    sirotex Well-Known Member

    Joined:
    Jul 10, 2008
    Messages:
    121
    Likes Received:
    0
    Trophy Points:
    66
    It isn't MySQL, it's IMAP. I've been playing with Courier & Dovecot all day. Using courier in 11.24 it fails to start, but yet can connect to webmail. Dovecot however stays up etc but isn't converting the mail DB's correctly so you will be best using Courier, and moving to STABLE untill they fix it.
     
    #3 sirotex, Dec 25, 2008
  4. nerbonne

    nerbonne Well-Known Member

    Joined:
    Aug 19, 2007
    Messages:
    52
    Likes Received:
    1
    Trophy Points:
    58
    Ok, I was able to fix my problem by setting courier to "manual update" and leaving all other software on never, and then running a cp update. After the update roundcube worked fine.

    Thanks for the help.
     
    #4 nerbonne, Dec 26, 2008
  5. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    North Carolina
    Resolved

    As part of troubleshooting process, I re-ran the Roundcube installer utility and discovered that the database user no longer had write permissions to the database. I re-granted all privileges to the user and we're back in business.

    Not certain what in the 11.24 upgrade might have caused this. All other php based MySQL applications have worked w/o error since the update.
     
    #5 RickG, Dec 26, 2008
    Last edited: Dec 26, 2008
  6. BuffaloWeb

    BuffaloWeb Well-Known Member

    Joined:
    Jul 1, 2003
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    156
    Can you give some specific instructions please? Which user, which db?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 BuffaloWeb, Dec 30, 2008
  7. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    North Carolina
    On the install instructions at http://trac.roundcube.net/wiki/Howto_Install, scroll down to Database Configuration. I simply "re-granted" privelieges (given the database was already set up) per their instructions and we were good to go. Still not certain what in the 11.24 upgrade caused this issue, as it only effected the RoundCube application (all other PHP/MySQL scripts continued to work w/o error).
     
    #7 RickG, Dec 31, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upgrade Roundcube Database
  1. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018 at 11:46 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    47
    cPanelMichael
    Jun 21, 2018 at 10:31 AM
  2. tld2004

    Upgrade PHP to v7 on VPS?

    tld2004, Jun 14, 2018, in forum: EasyApache
    Replies:
    2
    Views:
    49
    cPanelLauren
    Jun 14, 2018
  3. Edwin Tjallings

    In Progress [CloudLinux ALTPHP-524] Alt-php not working after mysql 5.7 upgrade

    Edwin Tjallings, Jun 13, 2018, in forum: CloudLinux
    Replies:
    5
    Views:
    175
    cPanelMichael
    Jun 19, 2018 at 8:11 AM
  4. linux4me2

    MariaDB Did Not Start Up After Upgrade

    linux4me2, Jun 10, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    68
    cPanelLauren
    Jun 11, 2018
  5. Bretas

    cPanel upgrade hanging on dcpumon

    Bretas, Jun 10, 2018, in forum: General Discussion
    Replies:
    10
    Views:
    147
    cPanelLauren
    Jun 18, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice