[Dovecot] vpopmail/mysql/quota

[Marty Diesburg]

Yes, you're right, I was testing the other auth method.  I took out all but
the two sql entries for passdb and userdb, then
re-tested with the same result.  It authenticates fine, yet qmail holds
delivery.  I posted the log entry for the
last client attempt after restarting dovecot.


Thanks,

Marty

Dec 15 14:58:19 teknickel dovecot: Dovecot v1.2.8 starting up (core dumps
disabled)
Dec 15 14:58:19 teknickel dovecot: auth-worker(default): mysql: Connected to
/var/lib/mysql/mysql.sock (vpopmail)
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9961
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9963
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9964
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9965
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9966
Dec 15 14:58:20 teknickel dovecot: auth(default): new auth connection:
pid=9962
=110       rport=2896      resp=AG1nZABhbGw0MG5lNw==
', pw_domain) AS user FROM vpopmail WHERE pw_name = 'mgd' AND pw_domain = '
teknickel.net'
Dec 15 14:58:42 teknickel dovecot: auth(default): client out: OK        1
    user=mgd at teknickel.net
Dec 15 14:58:42 teknickel dovecot: auth(default): master in: REQUEST    1
    9962    1
e, 508 AS uid, 503 AS gid, concat('maildir:backend=', pw_shell) AS
quota_rule FROM vpopmail WHERE pw_name = 'mgd' AND pw_domain = '
teknickel.net'
08 gid=503 quota_rule=maildir:backend=52428800S
Dec 15 14:58:42 teknickel dovecot: pop3-login: Login: user=<
mgd at teknickel.net>, method=PLAIN, rip=192.168.77.119, lip=192.168.77.254
Dec 15 14:58:42 teknickel dovecot: POP3(mgd at teknickel.net): Disconnected:
Logged out top=0/0, retr=0/0, del=0/0, size=0
Dec 15 14:58:43 teknickel dovecot: auth(default): new auth connection:
pid=10252


On Tue, Dec 15, 2009 at 1:18 PM, Timo Sirainen <tss at iki.fi> wrote:

> On Mon, 2009-12-14 at 08:11 -0600, Marty Diesburg wrote:
> > I'm new to the list and have a quota question.  I am building a new
> server
> > with dovecot/qmail/vpopmail/mysql and
> > emails are sending and recieving fine when the quota is set to NOQUOTA,
> but
> > when the quota is changed qmail
> > doesn't deliver any messages.
>
> Logs probably would have told you why it failed.
>
> >   passdb:
> >     driver: sql
> >     args: /home/vpopmail/dovecotsql.conf
> >   passdb:
> >     driver: vpopmail
> >     args: webmail=127.0.0.1
> >   userdb:
> >     driver: sql
> >     args: /home/vpopmail/dovecotsql.conf
> >   userdb:
> >     driver: vpopmaildriver = mysql
> >     args: quota_template=quota_rule=*:backend=%q
>
> Something's weird above. You probably should have only passdb sql and
> userdb sql, nothing else.
>
> > user_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_dir as
> home,
> > 508 AS uid, 503 AS gid, concat('maildir:backend=%q', pw_shell) AS
> quota_rule
>
> The %q is for userdb vpopmail, not for userdb sql. Just remove it and it
> should work (assuming pw_shell contains the quota).
>