Horde-squirrelmail-roundcube DB error.

[mail2sacp]

Hi,

I have strange problem and did not found anything on google or anywhere.

Actually the dbs of all this webmails(horde,squirelmail,roundcube) are already there on server and also mysql is working fine.

But I am getting db error when I click one of this three.

Following is the error of each webmail.
-------------
1) Horde.
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.
-------------
2) Squirelmail
Error:
ERROR: Connection dropped by IMAP server.
-------------
3) RoundCube
DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.
---------------------------

As per this errors there seems to be issue with database but don't have any idea were exactly we need to fix it.

If anyone can help on this would be really really great and God Bless Him.

Regards
Mail2Sacp.

[lngtanseco]

Have you tried restarting MySQL service?

WHM >> SQL Server (MySQL)

You may also want to check if you have enough storage space.

# df -h

Also, check the mysql log. Below code should give you the log file name.

ls /var/lib/mysql/*.err

[mak_the_admin]

Have you tried restarting MySQL service?

WHM >> SQL Server (MySQL)

You may also want to check if you have enough storage space.

# df -h

Also, check the mysql log. Below code should give you the log file name.

ls /var/lib/mysql/*.err

Mysql is working fine and also enough free space is available.

[Snowman30]

we have seen this occur on one of our servers running the latest CURRENT 11.24 release

havent been able to find the cause yet however

[nerbonne]

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]

I am running 11.23.2 STABLE. It appears as if you are saying this issue is caused by running RELEASE or CURRENT versions. If so, how can this issue be my issue?

[sirotex]

I never said this was a RELEASE/CURRENT issue, I did indeed say this is an IMAP issue. Anyways Dovecot is the problem if you're running Courier then it isnt the same problem. Basically just trying to fit everyone into the answer Running Courier on 11.24 causes problems, thus people will need to run STABLE untill they fix the bugs

[Infopro]

Running Courier on 11.24 causes problems, thus people will need to run STABLE untill they fix the bugs

Where did you read that?

[sirotex]

I didn't read it - There is problems running Courier on 11.24. I didn't bother checking error logs yet though instead went back to STABLE branch untill we have enough time.

I'd be very intrested to know if you run cPanel 11.24 & Courier without any problems

[nakuls77]

You need to check out the entries for your domains in /etc/localdomains as well as /etc/remotedomains

A entry should exist but only in a single file of the 2 mentioned above depending upon the mail server the domain uses.

Make sure you clear all the session files in /tmp and it does have adequate free space to create new sessions, once you've verified all these restart the IMAP service using /scripts/restartsrv_imap

[_xandih]

Hi

upcp --force didn't work here.
courierup --force either

Anyone finds a solution?

Thanks

[cuongvttt]

For Horde
/usr/local/cpanel/bin/update-horde --force

For SquirrelMail
/usr/local/cpanel/bin/update-squirrelmail --force

For Roundcube
/usr/local/cpanel/bin/update-roundcube --force


Enjoy it

http://dcuong.wordpress.com/category...%87-thong-tin/