[Dovecot] Does the list work?

Osvaldo Alvarez Pozo nebano at gmail.com
Tue Sep 11 14:12:18 EEST 2007


My sql.conf:
user_query = SELECT concat('/var/vmail/', maildir, 'Maildir') as home,
concat('maildir:/var/vmail/', maildir, 'Maildir') as mail, 5000 AS
uid, 8 AS gid, concat('maildir:storage=', floor(quota/1024)) AS quota
FROM mailbox WHERE username = '%u' AND active = '1'

password_query = SELECT username as user, password,
concat('/var/vmail/', maildir, 'Maildir') as home,
concat('maildir:/var/vmail/', maildir, 'Maildir') as mail , 5000 as
uid, 12 as gid FROM mailbox WHERE username = '%u' AND active = '1'


Dovecot logs:
dovecot: 2007-09-11 15:01:55 Info: auth(default): master in: USER       1
contact at rexemple.com        service=deliver

dovecot: 2007-09-11 15:01:55 Info: auth-worker(default):
sql(contact at exemple.com): SELECT concat('/var/vmail/', maildir,
'Maildir') as home, concat('maildir:/var/vmail/', maildir, 'Maildir')
as mail, 5000 AS uid, 8 AS gid, concat('maildir:storage=',
floor(quota/1024)) AS quota FROM mailbox WHERE username =
'contact at exemple.com' AND active = '1'

dovecot: 2007-09-11 15:01:55 Info: auth(default): master out: USER
 1       contact at exemple.com
home=/var/vmail/exemple.com/contact/Maildir
mail=maildir:/var/vmail/exemple.com/contact/Maildir        uid=5000
    gid=8   quota=maildir:storage=1000

dovecot: 2007-09-11 15:12:21 Info: auth(default): master in: USER
 1       contact at exemple.com        service=deliver

dovecot: 2007-09-11 15:12:21 Info: auth-worker(default):
sql(contact at exemple.com): SELECT concat('/var/vmail/', maildir,
'Maildir') as home, concat('maildir:/var/vmail/', maildir, 'Maildir')
as mail, 5000 AS uid, 8 AS gid, concat('maildir:storage=',
floor(quota/1024)) AS quota FROM mailbox WHERE username =
'contact at exemple.com' AND active = '1'

dovecot: 2007-09-11 15:12:21 Info: auth(default): master out: USER
 1       contact at exemple.com
home=/var/vmail/exemple.com/contact/Maildir
mail=maildir:/var/vmail/exemple.com/contact/Maildir        uid=5000
    gid=8   quota=maildir:storage=1000

But quota does not work
Thanks

On 9/11/07, Umut Arus <umuta at sabanciuniv.edu> wrote:
>
>  Hello,
>
>  I had compiled only those parameters,
>  ./configure --with-ssl=openssl --with-mysql --with-ldap
> --prefix=/usr/local/dovecot
>
>  My mysql.conf running user_query configuration is,
>  user_query  = SELECT home, uid, gid,
> concat('maildir:storage=',quota) as quota, mail_plugins
> FROM users WHERE userid = '%u'
>
>  Check your, dovecot-deliver.log
>
>  Healtly dovecot's (in maillog) log,
>  Sep 10 17:05:30 mail2 dovecot: auth(default): pam(umuta,10.10.1.121):
> lookup service=dovecot
>  Sep 10 17:05:30 mail2 dovecot: auth(default): client out: OK    1
> user=umuta
>  Sep 10 17:05:30 mail2 dovecot: auth(default): master in: REQUEST        1
>     26162   1
>  Sep 10 17:05:30 mail2 dovecot: auth-worker(default):
> sql(umuta,10.10.1.125): SELECT home, uid, gid,
> concat('maildir:storage=',quota) as quota, mail_plugins
> FROM users WHERE userid = 'umuta'
>  Sep 10 17:05:30 mail2 dovecot: auth(default): master out: USER  1
> umuta   home=/home/umuta        uid=8287        gid=100
> quota=maildir:storage=2048      mail_plugins=quota imap_quota
>
>
>  regards,
>
>  Osvaldo Alvarez Pozo wrote:
>  Hi
> I thank you very much for your answer
> I am testing with dovecot-1.0.5.tar.gz i configured it like this:
> ./configure --prefix=/usr/local/dovecot --with-deliver
> --with-sql-drivers --with-ioloop=epoll --with-notify=dnotify
> --with-pop3d --with-mysql --with-static-userdb --with-prefetch-userdb
> --with-sql --with-ssl=openssl
>
> I think i 'am a litle lost with the configuration parametres. I was
> reading the wiki but maybe I 'm missing something.
>
> Thanks Very much.
>
>
> On 9/11/07, Umut Arus <umuta at sabanciuniv.edu> wrote:
>
>
>  Hello,
>
> What is your dovecot version? If you are not using dovecot-1.0.5 (below
> versions are buggy) you cannot set the users' quota from mysqldb. I had
> tried with one of buggy version two days.
>
> regards,
>
>
> Osvaldo Alvarez Pozo wrote:
>
>
>
>  Hi all
> Does the list work?
> I have sent two mail without answer up today.
> I want to change Courrier-imap by dovecot but i have problems with
> quota and sieve in dovecot. would you help validating dovecot? I this
> does not work i would have to stay with courier-imap.
>
>
> This is the mail I sent before.
>
>
> Hi
> Well my problem is with quota it is not taken into account by deliver
> i compiled dovecot from sorces and the resault is the same.
>
> thoses are my files:
>
> File /etc/dovecot/dovecot.conf
> ssl_cert_file = /etc/apache2/ssl/server.crt
> ssl_key_file = /etc/apache2/ssl/server.key
> #ssl_ca_file = /etc/pki/dovecot/certs/ca-bundle.crt
> protocols = imap pop3 imaps pop3s
> log_timestamp = "%Y-%m-%d %H:%M:%S "
> #mail_location = maildir:/export/mail/%d/%u
> mail_location = maildir:/var/vmail/%d/%u/Maildir
> mail_extra_groups = mail
> first_valid_uid = 5000
> last_valid_uid = 5000
> maildir_copy_with_hardlinks = yes
> disable_plaintext_auth = no
> protocol imap {
>  mail_plugins = quota imap_quota
>  imap_client_workarounds = outlook-idle delay-newmail
> }
> protocol pop3 {
>  mail_plugins = quota
>  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
> protocol lda {
>  postmaster_address = postmaster at example.com
>  mail_plugins = quota
>  log_path = /var/log/dovecot-deliver.log
>  info_log_path = /var/log/dovecot-deliver.log
>  mail_plugins = cmusieve
> # sieve_global_dir = /etc/dovecot/sieve/
> global_script_path =/etc/dovecot/sieve/dovecot.sieve
> }
> auth default {
> # Having "login" also as a mechanism make sure outlook can use the
> auth smtpd as well
> # http://wiki.dovecot.org/Authentication/Mechanisms
>  mechanisms = plain login
>  passdb sql {
>  args = /etc/dovecot/sql.conf
>  }
>  userdb sql {
>  args = /etc/dovecot/sql.conf
>  }
>  userdb prefetch {
>  }
>  user = nobody
> socket listen {
>  master {
>  path = /var/run/dovecot/auth-master
>  mode = 0660
>  user = vmail
>  group = mail
>  }
> client {
>  path = /var/spool/postfix/private/auth
>  mode = 0660
>  user = postfix
>  group = mail
>  }
>  }
> }
> dict {
> }
> plugin {
>  quota = maildir:storage=10240:messages=1000
>  acl = vfile:/etc/dovecot/acls
>  trash = /etc/dovecot/trash.conf
> }
> file /etc/dovecot/sql.conf
> driver = mysql
> default_pass_scheme = MD5
> connect = host=localhost dbname=postfix user=postfix password=password
> user_query = SELECT concat('/var/vmail/', maildir, 'Maildir') as home,
> concat('maildir:/var/vmail/', maildir, 'Maildir') as mail, 5000 AS
> uid, 8 AS gid, concat('maildir:storage=', floor(quota/1024)) AS quota
>
>  >FROM mailbox WHERE username = '%u' AND active = '1'
>
>
>  password_query = SELECT username as user, password,
> concat('/var/vmail/', maildir, 'Maildir') as userdb_home,
> concat('maildir:/var/vmail/', maildir, 'Maildir') as userdb_mail, 5000
> as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND
> active = '1'
>
> Thanks
>
> Thanks in advance
>
>
>
>
>
>
>  --
> Umut ARUS
> System Specialist
> Sabanci University
> Information Technology
> Tel: 0216 483 9172
>
>


More information about the dovecot mailing list