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