horder and roundcube can't connect to database error

[dxm]

Hi,
I recently noticed that horde and roundcube don't work, i.e. once one has logged in and selects one of those programs one gets a database connection error.

whm version: WHM 11.23.2 cPanel 11.23.4-R26138

Horde error is DB Error: connect failed and the roundcube error is Unable to connect to the database!

Squirrelmail is working ok.

I updated to the latest version of cpanel but no change.
mysqld is running ok.

I've searched the forums but I haven't found anything that helps yet.

Any suggestions?

Thanks.

[verdon]

I read somewhere that if you have set your mysql root pass to something containing special characters, you'll have these connection problems. Have you recently changed that pass?

[dxm]

Actually I think that the mysql root password on that box is blank (bad, I know).
If I change the root password, do I have to update the horde and roundcube configs anywhere?

thanks.

[dxm]

To answer my own question, my google fu appears to have returned this evening.
Basically horde (and roundcube) were looking for /tmp/mysql.sock , so by creating a symlink as per this post horde and roundcube started working just fine.

http://forums.spry.com/showthread.php?t=1423

[cpanforum]

Because the symlink is in /tmp, would this get delete in the future if the server reboots or by accident?

It works, but is this the permanent solution?

To answer my own question, my google fu appears to have returned this evening.
Basically horde (and roundcube) were looking for /tmp/mysql.sock , so by creating a symlink as per this post horde and roundcube started working just fine.

http://forums.spry.com/showthread.php?t=1423

[MaestriaNick]

yea, there is a solution.

go to the folder /usr/local/cpanel/3rdparty/etc

there is a folder for application like horde, roundcube etc.

for horde , go to the folder /usr/local/cpanel/3rdparty/etc/horde

edit , php.ini and set

mysql.default_socket =

to

mysql.default_socket = /var/lib/mysql/mysql.sock

make the same changes to roundcube etc. if you want

[phred_02]

Thanks MaestriaNick for the solution. I was having the same problem and this fixed it. However, does anyone know why this happened in the first place? I want to be sure it don't happen again.

Thanks,

Steve

[fniederm]

Hi
it didn't work out for me, but I am having the same problem with horde and roundcube after harddisk crash and new install..oh such a mess..

Any other ideas?