Error when logging in to Horde ("fatal error. DB Error: connect failed") / Linux

* Check /etc/my.cnf and make sure the following line exists:

socket=/var/lib/mysql/mysql.sock

Run the following command and make sure you can no errors are received:

#mysql -uhorde -p`cat /etc/psa/.webmail.shadow` -D horde

Type 'quit' to exit mysql.

If /etc/psa/.webmail.shadow is missing, create the file and type a password into the file. The file should only contain one password. Save the file and then update mysql with the new password:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql

Now type this at the mysql prompt:

update user set password=password("PASSWORD_FROM_WEBMAIL.SHADOW") where user="horde";

FLUSH PRIVILEGES;

# Also check /var/log/psa-horde/psa-horde.log for any errors. If you see something like this:

DB Error: connect failed: [nativecode=Access denied for user: 'root@localhost' (Using password: NO)]

# open the /etc/php.ini file and make sure sql.safe_mode is set to off, like this:

sql.safe_mode=off

Restart Apache if you edit the php.ini file:

# /usr/sbin/apachectl -k restart