dovecot-sql.conf:
driver = mysql
connect = host=localhost dbname=postfix user=postfix password=postfix
default_pass_scheme = MD5-CRYPT
password_query = \
SELECT username, domain, password \
FROM mailbox WHERE username = '%u' AND domain = '%d' AND active = '1'
user_query = \
SELECT 1015 as u
On Wed, 2008-10-08 at 16:52 -0400, [EMAIL PROTECTED] wrote:
> 'maildir:/var/spool/mail/example.com/test111/Maildir' as mail,
> concat('maildir:storage=', quota) as quota, concat('*:storage=',
> quota, '') as quota_rule, FROM mailbox WHERE username =
You've a comma between quota_rule and FROM.
(and oops forgot to get my last post on the list)
Hmm, I pulled a cleaner log file and got this:
Oct 8 16:44:51 webmail dovecot: auth(default): new auth connection: pid=14573
Oct 8 16:44:55 webmail dovecot: auth(default): client in:
AUTH^I1^IPLAIN^Iservice=imap^Isecured^Ilip=127.0.0.1^Irip=127
On Tue, 2008-10-07 at 20:03 -0400, [EMAIL PROTECTED] wrote:
> I've been testing using telnet and getquotaroot. when I define the
> quota in dovecot.conf
>quota = dirsize
Note that dirsize is superslow with maildir. quota=maildir is much
better.
> user_query = \
> SELECT 1015 as uid, 105
I'm having problems getting dovecot to set imap quotas that are
defined as individual quotas for virtual users using mysql. I'm using
postfix/dovecot 1.1.3, just built from source about a week ago.
I've been testing using telnet and getquotaroot. when I define the
quota in dovecot.conf
