Quote:with dovecot and enabled imap quota it works flawless...
Yeah ? I did also try it now but have the same Problem:
![[Image: quotan.th.jpg]](http://img21.imageshack.us/img21/8627/quotan.th.jpg)
I enabled the debug Modus in the dovecotc.conf.
Here is the output from the mail.log
Code:
Mar 6 21:18:05 vsXXXXX dovecot: Dovecot v1.0.15 starting up
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(pysieved): mysql: Connected to localhost (ispcp)
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(pysieved): mysql: Connected to localhost (ispcp)
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(pysieved): mysql: Connected to localhost (ispcp)
Mar 6 21:18:05 vsXXXXX dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Mar 6 21:18:32 vsXXXXX dovecot: imap-login: Login: user=<bene@mydomain.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Loading modules from directory: /usr/lib/dovecot/modules/imap
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Effective uid=1000, gid=8, home=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Namespace: type=private, prefix=INBOX., sep=, inbox=yes, hidden=no, subscriptions=no
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: data=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: root=/var/mail/virtual/mydomain.tld/bene, index=/var/mail/virtual/mydomain.tld/bene, control=, inbox=
Mar 6 21:18:32 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Disconnected: Logged out
Mar 6 21:18:33 vsXXXXX dovecot: imap-login: Login: user=<bene@mydomain.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Loading modules from directory: /usr/lib/dovecot/modules/imap
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Effective uid=1000, gid=8, home=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Namespace: type=private, prefix=INBOX., sep=, inbox=yes, hidden=no, subscriptions=no
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: data=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: root=/var/mail/virtual/mydomain.tld/bene, index=/var/mail/virtual/mydomain.tld/bene, control=, inbox=
Mar 6 21:18:33 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Disconnected: Logged out
Mar 6 21:18:36 vsXXXXX dovecot: imap-login: Login: user=<bene@mydomain.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Loading modules from directory: /usr/lib/dovecot/modules/imap
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Effective uid=1000, gid=8, home=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Namespace: type=private, prefix=INBOX., sep=, inbox=yes, hidden=no, subscriptions=no
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: data=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: root=/var/mail/virtual/mydomain.tld/bene, index=/var/mail/virtual/mydomain.tld/bene, control=, inbox=
Mar 6 21:18:36 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Disconnected: Logged out
Mar 6 21:18:40 vsXXXXX dovecot: imap-login: Login: user=<bene@mydomain.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Loading modules from directory: /usr/lib/dovecot/modules/imap
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Effective uid=1000, gid=8, home=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Namespace: type=private, prefix=INBOX., sep=, inbox=yes, hidden=no, subscriptions=no
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: data=/var/mail/virtual/mydomain.tld/bene
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): maildir: root=/var/mail/virtual/mydomain.tld/bene, index=/var/mail/virtual/mydomain.tld/bene, control=, inbox=
Mar 6 21:18:40 vsXXXXX dovecot: IMAP(bene@mydomain.tld): Disconnected: Logged out
Looks like the Quota Modul is loaded. Of course there is a quota in the ispCP DB. I used the 10MB default and did not changed it. Before i did changed the dovecot and add the Quota like:
Code:
protocol imap {
mail_plugins = quota imap_quota
}
protocol pop3 {
mail_plugins = quota
}
protocol lda {
mail_plugins = quota
}
and modified the dovecot-sql-domain.conf as described in the HowTo:
Code:
user_query = SELECT concat('/var/mail/virtual/', domain.domain_name, '/',mail_acc) as home, '1001' as uid, '8' as gid, concat('maildir:storage=', floor(quota/1024)) AS quota FROM mail_users inner join domain on mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and (mail_type='normal_mail' OR mail_type='normal_mail,normal_forward');
the Text "Speicherplatz: unbegrenzt" was not there.
So roundcube understand the new feature in any way, but no correct ?!
(The only thing i changed was the UID i did.)
Here is my dovecot config:
Code:
dovecot -n
# 1.0.15: /etc/dovecot/dovecot.conf
base_dir: /var/run/dovecot/
protocols: imap pop3 imaps pop3s
disable_plaintext_auth: no
login_dir: /var/run/dovecot//login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
mail_access_groups: mail
mail_location: maildir:/var/mail/virtual/%d/%n
mail_debug: yes
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/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/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
pop3_uidl_format(default):
pop3_uidl_format(imap):
pop3_uidl_format(pop3): %u-%v
namespace:
type: private
prefix: INBOX.
inbox: yes
auth pysieved:
mechanisms: plain login
verbose: yes
passdb:
driver: checkpassword
args: /var/www/ispcp/engine/ispcp-dovecot-mngr
userdb:
driver: prefetch
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-domain.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-aliasdomain.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-subdomain.conf
socket:
type: listen
client:
path: /var/run/pysieved/auth
mode: 432
user: vmail
group: mail
master:
path: /var/run/pysieved/auth-master
mode: 432
user: vmail
group: mail
auth default:
mechanisms: plain login
verbose: yes
passdb:
driver: checkpassword
args: /var/www/ispcp/engine/ispcp-dovecot-mngr
userdb:
driver: prefetch
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-domain.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-aliasdomain.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql-subdomain.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: mail
I checked it many time but cant find the error
BTW: Is the change in the sql File not also needed for Alias and subdomains ?
Greez BeNe
//EDIT
Is there the
Code:
and domain.domain_name='%d'
missing in the new sqlfile ?
Search
Member List
Calendar
Help
![[Image: quotan.th.jpg]](http://img21.imageshack.us/my.php?image=quotan.jpg)
