[Dovecot] Password auth scheme question with mysql

[Ed W]

On 24/01/2012 22:51, Ed W wrote:
> Hmm, so I try:
>
> # doveadm pw -p asdf -s sha256
> {SHA256}8OTC92xYkW7CWPJGhRvqCR0U1CR6L8PhhpRGGxgW4Ts=
>
> I enter this hash into my database column, then enabling debug logging 
> I see this in the logs:
>
..
> Jan 24 22:40:44 mail1 dovecot: auth-worker: Debug: 
> sql(demo at blah.com,1.2.24.129): SHA256({PLAIN}asdf) != 
> '8OTC92xYkW7CWPJGhRvqCR0U1CR6L8PhhpRGGxgW4Ts='

Gah.  Ok, so I discovered the "doveadm auth" command:


# doveadm auth -x service=pop3 demo asdf
passdb: demo auth succeeded
extra fields:
   user=demo at blah.com
   proxy
   host=1.2.24.129
   pass={SHA256}8OTC92xYkW7CWPJGhRvqCR0U1CR6L8PhhpRGGxgW4Ts=



So why do I get an auth failed and the log files I showed in my last 
email when I use "telnet localhost 110" and then the commands:

     user demo
     pass asdf


Help please...?

Ed W