SymptomsI cannot login to any Horde Webmail account after H-Sphere CP migration.
I get an error message:
A fatal error has occurred
DB Error: connect failed
More informative error can be found at /hsphere/local/var/horde/log/horde.log :
DB Error: connect failed: [nativecode=Access denied for user 'horde'@'localhost' (using password: YES)]
ResolutionGet mysql horde username and password from /hsphere/shared/apache/htdocs/horde/config/conf.php file.
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '79WliG2SPLg';
Login to mysql database and update the password:
mysql> update user set Password=PASSWORD('79WliG2SPLg') where User= "horde";
mysql> FLUSH PRIVILEGES;
If the password has been changed, then that was the reason and you should be able to access Webmail now.