[Dovecot] Postgresql and Dovecot

[Michael Ducy]

I didn't touch the logging settings, however I would be more than happy
too. :)  I didn't set a verboseness level in dovecot.conf.  I am now
putting informational messages into a file.  Any other settings I should
change?

I have another question.  I am authenticating against an existing
database.  Postfix drops mail in /var/spool/mail/%u .  The existing
database only has login (the username) and password.  My user_query is:

user_query = SELECT '/var/spool/mail'||login as mail, 89 AS uid, 89 AS
gid FROM user_common WHERE login='%u';

I am getting :
+OK dovecot ready.
user username
+OK
pass password
+OK Logged in.
* BYE Internal login failure.
Connection closed by foreign host.

default_mail_env is set to:
default_mail_env = mbox:/var/spool/mail/%u

89 is the uid and gid of the dovecot user which is what auth_user is set
to.

Any ideas on the "Internal login failure" failure?

Thanks,
Michael

On Fri, 2003-08-29 at 09:15, Timo Sirainen wrote:
> On Friday, Aug 29, 2003, at 17:00 Europe/Helsinki, Michael Ducy wrote:
> 
> > user_query= SELECT .....;
> 
> OK, have to fix that. The space shouldn't be so important there.
> 
> > dovecot doesn't like that (and doesn't let me know that :) )
> 
> Maybe you're just looking into wrong place, or configured logging wrong 
> in some way? :)
> 
> Aug 29 17:12:38 hurina dovecot: Dovecot starting up
> Aug 29 17:12:39 hurina dovecot-auth: Error in configuration file 
> /usr/local/etc/dovecot-pgsql.conf line 81: Missing value
> Aug 29 17:12:39 hurina dovecot: Auth process died too early - shutting 
> down
> Aug 29 17:12:39 hurina dovecot: child 11731 (auth) returned error 89