11.24 Upgrade: Roundcube Database Connect Error

[RickG]

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?

[nerbonne]

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.

[sirotex]

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.

[nerbonne]

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.

[RickG]

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.

[BuffaloWeb]

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.

Can you give some specific instructions please? Which user, which db?

[RickG]

Can you give some specific instructions please? Which user, which db?

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