problem about mbox with quota

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

problem about mbox with quota

Zhang Huangbin
Hi, all.

Does mbox format support quota?

I got this error in log file:

dovecot: May 18 02:10:36 Error: POP3([hidden email]): Unknown quota backend:
storage=10240

How can i solved it?

Thanks very much. :)

My dovecot configuration:

# /etc/dovecot.conf
log_path: /var/log/dovecot.log
protocols: pop3 pop3s imap imaps
ssl_cert_file: /etc/pki/dovecot/certs/dovecotCert.pem
ssl_key_file: /etc/pki/dovecot/private/dovecotKey.pem
login_dir: /var/run/dovecot/login
login_executable(default): /usr/libexec/dovecot/imap-login
login_executable(imap): /usr/libexec/dovecot/imap-login
login_executable(pop3): /usr/libexec/dovecot/pop3-login
mail_location: mbox:/%Lh/%Ld/%Ln:INBOX=/%Lh/%Ld/%Ln
mbox_write_locks: dotlock fcntl
mbox_min_index_size: 10240
mbox_very_dirty_syncs: yes
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3): quota
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
auth default:
  mechanisms: plain login
  user: vmail
  passdb:
    driver: sql
    args: /etc/dovecot-mysql.conf
  userdb:
    driver: sql
    args: /etc/dovecot-mysql.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: 432
      user: vmail
      group: vmail

# /etc/dovecot-mysql.conf
driver = mysql
default_pass_scheme = CRYPT
connect = host=127.0.0.1 dbname=vmail user=vmail
password=6737$11626@27301!17044&11769*16758)17720
password_query = SELECT password FROM mailbox WHERE username='%u' AND
active='1'
user_query = SELECT 2000 AS uid, 2000 AS gid, "/home/vmail" AS home,
maildir, CONCAT('storage=',quota) AS quota FROM mailbox WHERE
username='%u' AND active='1'

--
Best Regards.

Zhang Huangbin

- OpenBSD 4.2 -release, i386.
- RHEL 5.1 Client


Reply | Threaded
Open this post in threaded view
|

Re: problem about mbox with quota

Timo Sirainen
On May 18, 2008, at 5:13 AM, Zhang Huangbin wrote:

> Hi, all.
>
> Does mbox format support quota?

dirsize backend should work pretty well.

> dovecot: May 18 02:10:36 Error: POP3([hidden email]): Unknown quota  
> backend: storage=10240

You need to select the backend.

> user_query = SELECT 2000 AS uid, 2000 AS gid, "/home/vmail" AS home,  
> maildir, CONCAT('storage=',quota) AS quota FROM mailbox WHERE  
> username='%u' AND active='1'

CONCAT('dirsize:storage=',quota)


PGP.sig (201 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: problem about mbox with quota

Zhang Huangbin
Hi, Timo.

Timo Sirainen wrote:

> On May 18, 2008, at 5:13 AM, Zhang Huangbin wrote:
>
>> Hi, all.
>>
>> Does mbox format support quota?
>
> dirsize backend should work pretty well.
>
>> dovecot: May 18 02:10:36 Error: POP3([hidden email]): Unknown quota
>> backend: storage=10240
>
> You need to select the backend.
>
>> user_query = SELECT 2000 AS uid, 2000 AS gid, "/home/vmail" AS home,
>> maildir, CONCAT('storage=',quota) AS quota FROM mailbox WHERE
>> username='%u' AND active='1'
>
> CONCAT('dirsize:storage=',quota)
>

Thanks very much. :)

I think we should add this tip in wiki page:
http://wiki.dovecot.org/Quota
OR
http://wiki.dovecot.org/MailLocation/Mbox

--
Best Regards.

Zhang Huangbin

- OpenBSD 4.2 -release, i386.
- RHEL 5.1 Client