dovecot - Jan 2011 - dovecot v1.2.15 - Unknown dict module: quota - Fatal: Quota root storage=200000 proxy init [postfix, dovecot LDA, postfixadmin, mysql]

Dear everyone,

I am trying to get my Email set-up to work, and wonder if someone would
shed some light onto this?

Best regards, J.
------------------------------------------------------------------

Set-up is :

    postfix -> dovecot LDA  -> mysql <- postfixadmin

What works:
postfix delivers to dovecot.
postfixadmin is configured, and have created one domain test.info.

What is broken:
dovecot is mis-configured.
postfixadmin might well be mis-configured.

I have followed the instructions in the
postfixadmin/DOCUMENTS/DOVECOT.TXT for the additional dovecot configuration.


*** ERROR MESSAGES
All Emails passed from postfix to dovecot generate:
Jan  4 20:35:02 logout dovecot: deliver(test at test.info): Unknown dict
module: quota
Jan  4 20:35:02 logout dovecot: deliver(test at test.info): Fatal: Quota
root storage=200000 proxy init() failed
Jan  4 20:57:18 logout dovecot: IMAP(test at test.info):
mkdir(/var/mail/vmail/test.info/test at test.info/cur) failed: Permission
denied (euid=5000(vmail) egid=5000(vmail) missing +w perm: /var/mail)

** DOVECOT -n
# 1.2.15: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-xxxxxxxx-xxxxx x86_64 Debian squeeze/sid
log_timestamp: %Y-%m-%d %H:%M:%S
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable: /usr/lib/dovecot/imap-login
login_chroot: no
first_valid_uid: 106
mail_privileged_group: mail
mail_location: maildir:/var/mail/vmail/%d/%u/
mbox_write_locks: fcntl dotlock
lda:
  log_path:
  auth_socket_path: /var/run/dovecot/auth-master
  postmaster_address: postmaster at test.info
  mail_plugins: sieve quota
auth default:
  mechanisms: plain login
  passdb:
    driver: pam
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  userdb:
    driver: passwd
  userdb:
    driver: static
    args: uid=5000 gid=5000 home=/var/vmail/%d/%n allow_all_users=yes
  userdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  socket:
    type: listen
    client:
      path: /var/spool/postfix/private/auth
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail
plugin:
  quota: dict:storage=200000 proxy::quota
  quota: dict:storage=200000 proxy::quota:w
dict:
  quota: mysql:/etc/dovecot/dovecot-dict-quota.conf


*** MYSQL DOVECOT FILES
# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf
connect = host=localhost dbname=xxxxx user=xxxxx password=xxxxx
driver = mysql
default_pass_scheme = MD5-CRYPT
password_query = SELECT username AS user,password FROM mailbox WHERE
username = '%u' AND active='1'
user_query = SELECT CONCAT('/var/vmail/', maildir) AS home, 106 AS uid,
110 AS gid,
        CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE
username = '%u' AND active='1'
## Note: 106:110 = postfix:avahi   For some reason squeeze drops postfix
into avahi group: To Fix.


*** DICT QUOTA
# cat /etc/dovecot/dovecot-dict-quota.conf
driver = mysql
connect = host=localhost dbname=xxxxx user=xxxxx password=xxxxx
default_pass_scheme = MD5-CRYPT
table = quota
select_field = current
where_field = path
username_field = username


*** /VAR/VMAIL  directory
# ls -la /var/vmail
total 28
drwxrwx---  3 vmail vmail  4096 Jan  4 20:53 .
drwxr-xr-x 15 root  root   4096 Jan  3 12:19 ..
-rw-r--r--  1 root  root      0 Jan  3 15:14 auth_socket_path
-rw-r--r--  1 root  root    173 Dec 31 12:15 globalsieverc
-rw-r--r--  1 root  root      0 Jan  3 15:14 info_log_path
-rw-r--r--  1 root  root      0 Jan  3 15:14 log_path
drwx------  2 root  root  16384 Jan  4 15:28 lost+found
-rw-r--r--  1 root  root      0 Jan  3 15:14 mail_plugins
-rw-r--r--  1 root  root      0 Jan  3 15:14 postmaster_address

*** VMAIL user
vmail:x:5000:5000::/var/vmail:/bin/sh  (soon to be changed to /bin/false
after testing completed)
dovecot:x:109:114:Dovecot mail server,,,:/usr/lib/dovecot:/bin/false
postfix:x:106:110::/var/spool/postfix:/bin/false

On Tue, 2011-01-04 at 21:07 +0100, JKL wrote:
> plugin:
>   quota: dict:storage=200000 proxy::quota
>   quota: dict:storage=200000 proxy::quota:w
> dict:
>   quota: mysql:/etc/dovecot/dovecot-dict-quota.conf
Are you sure you want to use dict quota? Maildir++ quota would be
simpler.

Anyway, the plugin { quota } lines are wrong (and there should be only
one of them). Use:

plugin {
  quota = dict:user::proxy::quota
}

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20110105/4ecc17f9/attachment-0002.bin>

On 01/05/2011 01:36 PM, Timo Sirainen wrote:
> On Tue, 2011-01-04 at 21:07 +0100, JKL wrote:
>> plugin:
>>   quota: dict:storage=200000 proxy::quota
>>   quota: dict:storage=200000 proxy::quota:w
>> dict:
>>   quota: mysql:/etc/dovecot/dovecot-dict-quota.conf
> Are you sure you want to use dict quota? Maildir++ quota would be
> simpler.
>
> Anyway, the plugin { quota } lines are wrong (and there should be only
> one of them). Use:
>
> plugin {
>   quota = dict:user::proxy::quota
> }
>
Hi Timo,

Many thanks for getting back to me.

*** quota
Thank-you.  The error has now gone, and it generated a new one:D

    Dictionary URI is missing ':': quota

I am quite happy to use Maildir++ quota, so long as it'll work with
postfixadmin. 


***  Regarding an upgrade to dovecot 2:
I shall upgrade to v2 when I have the current set-up working. It should
be easier to convert a working doveconf.conf file than a broken one.

I read on the dovecot wiki  [ http://wiki.dovecot.org/PrebuiltBinaries
]  that I could add this for v2.0:-
deb http://xi.rename-it.nl/debian/ testing-auto/dovecot-2.0 main
Since this is meant to be a production server, I changed the testing to
stable:
deb http://xi.rename-it.nl/debian/ stable-auto/dovecot-2.0 main
If the above is correct, then to upgrade should I:
1. backup my dovecot files
2. apt-get remove dovecot-imapd dovecot-common
3. apt-get -t stable-auto install dovecot-imapd dovecot-common  (I won't
use POP)
4. convert dovecot.conf :  doveconf -n -c dovecot-1.conf > dovecot-2.conf