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=...@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=< m...@teknickel.net>, method=PLAIN, rip=192.168.77.119, lip=192.168.77.254 Dec 15 14:58:42 teknickel dovecot: POP3(m...@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 <t...@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). >