web mail error

[y2krex]

Hi Guys,

I am getting erros when trying to connect to webmail. Its a fresh install and when I first click webmail an error came up about not being able to get the webmail password. A post on this forum then said to create a file called .webmail.shadow under /etc/psa. Once I did this a new error appeard which is :

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

any help would be appreciated.

Regards,

Jay

 

[Stucco]

http://faq.sw-soft.com/article_50_940_en.html

 

[Stucco]

Check your log file for the context of your error!

The error I was getting in my log file was

Nov 03 11:13:25 HORDE [emergency] [horde] DB Error: connect failed: [nativecode=Client does not support authentication protocol requested by server; consider upgrading MySQL client] Array [on line 1329 of "/usr/share/psa-horde/lib/Horde/DataTree/sql.php"]

For some reason I had 2 horde users in my database, one for localhost, and one for any host (%). I deleted the one for any host, and ran

set password for 'horde'@'localhost' = OLD_PASSWORD('MYPASSWORDFROMWEBMAILSHADOW');

and that fixed the problem.