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. unlockr

    SOLVED crons stop working after upgrade from 5.4 to 5.6.30!

    unlockr, Jul 17, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    80
    cPanelMichael
    Jul 19, 2017
  2. WebHostPro

    How to remove old maildir files after upgrade?

    WebHostPro, Jul 7, 2017, in forum: E-mail Discussions
    Replies:
    6
    Views:
    88
    cPanelMichael
    Jul 12, 2017
  3. jndawson

    Deleting /usr/local/apache.ea3/ after upgrade to EA4

    jndawson, Jul 3, 2017, in forum: EasyApache
    Replies:
    4
    Views:
    119
    jndawson
    Jul 5, 2017
  4. WebHostPro

    Mailman error after mdbox upgrade

    WebHostPro, Jul 3, 2017, in forum: E-mail Discussions
    Replies:
    1
    Views:
    67
    cPanelMichael
    Jul 4, 2017
  5. sparek-3

    MariaDB Upgrade from command line

    sparek-3, Jun 30, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    113
    cPanelMichael
    Jun 30, 2017

Share This Page