mrjhb3
I finally figured out what the heck my problem was and fixed it.
Basically, the issue was of course with the new version of MYSQL 4.1.11 and the way it handles passwords.
That's why I was getting the ....
"A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator" error.
What I did to fix it is so simple it's almost laughable but unless you know what to do it's rather impossible to fix.
Here is what I had to do:
At the command line type this:
1) mysql
2) UPDATE user SET Password=OLD_PASSWORD('your_Horde_password_here') WHERE User='horde';
3) FLUSH PRIVILIGES;
That's it!! Now it all works like a dream
Thanks for your help and maybe others that will inevitably run into the same situation will now know how to resolve it.
Cheers
Ed
I too am having this problem.
However, the solution above didn't work for me as mysql kept giving me errors about not selecting a database.
So I used phpmyadmin to reset the password, which seems to have gone in OK - only I still can't use horde webmail (fallen back on the not so familiar Twig).
Here's what I've got in phpmyadmin for the users table in the 'mysql' database:
Edit Delete localhost root XXXXX Y Y Y Y Y Y Y Y Y Y Y Y Y Y
Edit Delete fleable root XXXXX Y Y Y Y Y Y Y Y Y Y Y Y Y Y
Edit Delete localhost horde YYYYY N N N N N N N N N N N N N N
Edit Delete % radius ZZZZZ N N N N N N N N N N N N N N
Edit Delete % horde YYYYY N N N N N N N N N N N N N N
Edit Delete localhost www AAAAA N N N N N N N N N N N N N N
Edit Delete localhost twig CCCCC N N N N N N N N N N N N N N
Edit Delete fleable horde YYYYY N N N N N N N N N N N N N N
Is this as it should be?
Where else can I tweak things
This all started when my ssl certificate expired and I made a new one. I followed the SSL how-to in the documentation and updated the .pem files for the securemail daemons - is there somewhere in Horde that I should have copied the ssl certificate to as well?
All advice gratefully received!
David.