UPDATE `user` SET user_password = CONCAT(‘:A:’, MD5(‘somepass’)) WHERE user_name = ‘someuser’;

http://www.mediawiki.org/wiki/Manual:Resetting_passwords

question

I’ve just installed Zentyal 3.0 and configured it exactly as I have 2.2 and 3.0r1/r2 and have found that Zarafa webaccess isn’t working. When I try to login to http://mydomain.com/webaccess I get a popup window asking for username and password — not the usual Zafara login screen with username/password.

Anybody else get this error?

answer

If you don’t have your clients sending Kerberos SSO authentication to the server is not going to work :-), so if your clients are not “kerberized”, don’t enable SSO :P

https://forum.zentyal.org/index.php?topic=12005.0