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:
    18
    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:
    6
    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:
    16
    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.
     
  4. nerbonne

    nerbonne Well-Known Member

    Joined:
    Aug 19, 2007
    Messages:
    52
    Likes Received:
    1
    Trophy Points:
    6
    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.
     
  5. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    18
    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:
    6
    Can you give some specific instructions please? Which user, which db?
     
  7. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    18
    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).
     
Loading...

Share This Page