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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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?
     
    #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. xml

    After upgrade from EasyApache3 to EasyApache4

    xml, Apr 21, 2018 at 12:12 PM, in forum: EasyApache
    Replies:
    3
    Views:
    56
    cPanelLauren
    Apr 23, 2018 at 9:15 AM
  2. Oualid

    Upgrade to KernelCare message

    Oualid, Apr 20, 2018 at 5:42 AM, in forum: Security
    Replies:
    2
    Views:
    56
    feldon27
    Apr 22, 2018 at 1:15 PM
  3. net@work

    LTS 62.0.42 ends Upgrade problems?

    net@work, Mar 29, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    285
    cPanelMichael
    Mar 29, 2018
  4. Andy83

    Upgrade Hard Drive

    Andy83, Mar 21, 2018, in forum: Data Protection
    Replies:
    7
    Views:
    129
    cPanelMichael
    Mar 26, 2018
  5. Trane Francks

    SOLVED Various Munin graph values 'nan' after upgrade to CLOUDLINUX 7.4

    Trane Francks, Mar 12, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    112
    cPanelMichael
    Mar 15, 2018

Share This Page