On Sat, 2005-08-20 at 12:52 +0200, Sebastjan Trepca wrote:

Hello,

I have a postgresql database which contains users that will access dovecot, but their passwords are hashed and I don't have them in plain text. I was reading documentation that you can add tell dovecot which password scheme should it use. For example:

password_query = "select '{MD5}'||password from users where userid=%u"

Which would mean that dovecot will hash the password with MD5 from client and match it with the one in database. Did I understand this correctly ?

Right. Or you could also just change default_pass_scheme to MD5.

BTW. MD5 means "md5crypt" passwords. There are also PLAIN-MD5 and others for simple MD5-hashed passwords if that's what you need.