[Dovecot] question about mysql authentication

[Chantal Rosmuller]

On Wednesday 16 January 2008 17:32:33 you wrote:
> On Wed, 2008-01-16 at 16:02 +0100, Chantal Rosmuller wrote:
> > When I use this:
>
> Starting from dovecot-example.conf would have worked better than trying
> to modify 0.99 configuration to work with v1.0.

actually I got the configuration from a howto, maybe I should have looked at 
the example instead :)
>
> > auth = mysql_auth
>
> Replace with:
>
> auth default {
>
> > passdb sql {
> >    args = /etc/dovecot-mysql.conf
> >  }
> >  userdb  sql {
>
> There's an extra space, probably doesn't matter, maybe does.
>
> >    args = /etc/dovecot-mysql.conf
> >  }
>
> }

Thanks! That works!

However now I get an error in the logfiles: 
auth(default): Error in configuration file /etc/dovecot-mysql.conf line 4: 
Unknown setting: db
Is there something wrong with my mysql configuration as well?



######dove-mysql.conf should look like this##########
db_host = 127.0.0.1
db_port = 3306
db      = postfix
db_user = postfix
db_passwd = secret
db_client_flags = 0
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as 
mail, 150 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM 
mailbox WHERE username ='%u' AND active ='1'
####################ends here####################