Posts Tagged ‘MySQL’

Horde Mail SQL SessionHandler issue

Saturday, February 2nd, 2008

If you have problems with Horde but SquirrelMail gives you the following message.

“A fatal error has occurred Could not connect to database for SQL SessionHandler. Details have been logged for the administrator.”

Here is what will fix the issue.

cd /tmp
ls |grep mysql

If you see nothing after that then type the following

ln -s /var/lib/mysql/mysql.sock

You will probably want to run /scripts/upcp after this to make sure that it updates everything else.

CPanel phpMyadmin MySQL Fix

Tuesday, November 6th, 2007

If you end up getting this error

#2002 - The server is not responding (or the local MySQL server’s socket is not correctly configured)

Then you need to do the following.

vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

find
$cfg['Servers'][$i]['socket'] = ”;
change to
$cfg['Servers'][$i]['socket'] = ‘/var/lib/mysql/mysql.sock’;

next line
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;

change to

$cfg['Servers'][$i]['connect_type'] = ’socket’;

You should be all set after that…