[Dovecot] SHA1

[Andrew Hutchings]

Hi Marco,

The SQL query needs an apostrophe at the beginning of the localpart as
well, this may be the problem.

Regards
Andrew

On Wed, 2004-12-08 at 22:20 +0100, Marco Herrn wrote:
> Hi,
> 
> I am currently installing doveot as POP and IMAP server, but I a have
> a few difficulties configuring it correctly. 
> 
> I use postgresql to store the user information. The passwords are
> stored SHA1 encrypted. Now I have the problem that dovecot isn't
> accepting the user. In dovecot-pgsql.conf I defined
>   default_pass_scheme = SHA1
> I am not quite sure about whether this is corrents, since it is not
> mentioned in the documentation, but it is mentioned in the wiki (under
> the name SHA) and it doesn't produce an error (as specifying SHA
> does). So I assume this is correct.
> 
> But when I log in with a user I always geht the following log output:
> 
> dovecot-auth: Dec 08 22:18:20 Info: PGSQL: Performing query: SELECT
>    passwd FROM mailbox WHERE localpart = érwin' AND domainname ='poiu.de'
> dovecot-auth: Dec 08 22:18:20 Info: pgsql(erwin at poiu.de): Password mismatch
> imap-login: Dec 08 22:18:20 Info: Aborted login [82.82.66.4]
> dovecot-auth: Dec 08 22:18:20 Info: Login process 9 disconnected
> dovecot-auth: Dec 08 22:18:20 Info: Login process 9 connected
> dovecot-auth: Dec 08 22:18:20 Info: Login process 9 sent handshake: PID 22222
> 
> Is there a way to get a more excessive debugging? I already set
> auth_verbose and auth_debug to yes.
> 
> Or does anyone have an idea what the problem can be here?
> 
> Regards
> Marco
> 
-- 
Andrew Hutchings
Systems Operator / Developer / Linux Guru
Netserve Consultants Ltd.
http://www.domaincity.co.uk/