Re: V1 Dovecot POP3 index migrate to V3
Thank you Christian. "pop3_save_uidl = yes" setting resolved the problem. Regards. On Mon, Apr 24, 2017 at 3:07 PM, Christian Balzer <ch...@gol.com> wrote: > > Hello, > > On Mon, 24 Apr 2017 14:48:01 +0300 Umut Arus wrote: > > > Hi, > > > > I've very old Dovecot version so I'm trying to migrate new disk and > current > > version of dovecot. But POP3 accounts have "version 1" > > .INBOX/dovecot-uidlist files so clients download the messages again. > > > > How can achieve not to download to mailbox after copy to new disk? Is > there > > any script or something to migrate index v1 to v3? > > > > thanks for your suggestions. > > > Have you actually looked at the configuration file in question > (20-pop3.conf)? > Setting "pop3_uidl_format = %v.%u" should do the trick and if you're using > maildir (we do) you can in addition set "pop3_save_uidl = yes" and in the > future change to different UID format. > > > Christian > -- > Christian BalzerNetwork/Systems Engineer > ch...@gol.com Global OnLine Japan/Rakuten Communications > http://www.gol.com/ > -- *Umut Arus* System Specialist Information Technology Sabancı University
V1 Dovecot POP3 index migrate to V3
Hi, I've very old Dovecot version so I'm trying to migrate new disk and current version of dovecot. But POP3 accounts have "version 1" .INBOX/dovecot-uidlist files so clients download the messages again. How can achieve not to download to mailbox after copy to new disk? Is there any script or something to migrate index v1 to v3? thanks for your suggestions.
[Dovecot] Deliver parameter problem!
Is there anybody having idea about this problem? thanks. Original Message Subject:Deliver parameter problem Date: Tue, 11 Sep 2007 14:21:56 +0300 From: Umut Arus [EMAIL PROTECTED] To: dovecot@dovecot.org Hello, I'm using dovecot-1.0.5 with postfix. I have to use deliver from procmail because I have some filters. There is no document about how to using deliver parameters (-d) other than http://wiki.dovecot.org/LDA . If I set -d parameters manually as a username everything is ok. I can not set users' mail quota (don't lookup) with mysql db if I haven't set -d parameter as receipt username in procmail. How can I describe user (-d) parameter's variable in procmail? Procmail configuration, :0 | /usr/local/dovecot/libexec/dovecot/deliver -f $blabla -d $blabla2 Output of the configuration, # 1.0.5: /usr/local/dovecot/etc/dovecot.conf protocols: imap imaps pop3 pop3s listen: 10.1.1.168 ssl_cert_file: /usr/local/dovecot/etc/dovecot.cert.pem ssl_key_file: /usr/local/dovecot/etc/dovecot.key.pem disable_plaintext_auth: no login_dir: /usr/local/dovecot/var/run/dovecot/login login_executable(default): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(imap): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3-login mail_location: maildir:%h/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u mail_debug: yes mail_full_filesystem_access: yes mail_executable(default): /usr/local/dovecot/libexec/dovecot/imap mail_executable(imap): /usr/local/dovecot/libexec/dovecot/imap mail_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): mail_plugin_dir(default): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/dovecot/lib/dovecot/pop3 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xv%08Xu namespace: type: private separator: / location: maildir:~/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u inbox: yes namespace: type: private separator: / prefix: mail/ location: maildir:~/Maildir/.mail:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u auth default: verbose: yes debug: yes passdb: driver: pam userdb: driver: sql args: /usr/local/dovecot/etc/dovecot-sql.conf userdb: driver: prefetch socket: type: listen master: path: /var/run/dovecot/auth-master mode: 438 plugin: quota: maildir:storage=50:ignore=trash regards,
Re: [Dovecot] Does the list work?
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 = [EMAIL PROTECTED] 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
Re: [Dovecot] Does the list work?
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: OK1 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/umutauid=8287gid=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 [EMAIL PROTECTED] 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 = [EMAIL PROTECTED] 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
Re: [Dovecot] Does the list work?
Please check /var/run/dovecot/auth-master files Is this file writeable or you can change mode=0777 in dovecot.conf and restart dovecot (file attributes will be change) then test quota. Regards, Osvaldo Alvarez Pozo wrote: 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 [EMAIL PROTECTED]service=deliver dovecot: 2007-09-11 15:01:55 Info: auth-worker(default): sql([EMAIL PROTECTED]): 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 = '[EMAIL PROTECTED]' AND active = '1' dovecot: 2007-09-11 15:01:55 Info: auth(default): master out: USER 1 [EMAIL PROTECTED] home=/var/vmail/exemple.com/contact/Maildir mail=maildir:/var/vmail/exemple.com/contact/Maildiruid=5000 gid=8 quota=maildir:storage=1000 dovecot: 2007-09-11 15:12:21 Info: auth(default): master in: USER 1 [EMAIL PROTECTED]service=deliver dovecot: 2007-09-11 15:12:21 Info: auth-worker(default): sql([EMAIL PROTECTED]): 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 = '[EMAIL PROTECTED]' AND active = '1' dovecot: 2007-09-11 15:12:21 Info: auth(default): master out: USER 1 [EMAIL PROTECTED] home=/var/vmail/exemple.com/contact/Maildir mail=maildir:/var/vmail/exemple.com/contact/Maildiruid=5000 gid=8 quota=maildir:storage=1000 But quota does not work Thanks On 9/11/07, Umut Arus [EMAIL PROTECTED] 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: OK1 user=umuta Sep 10 17:05:30 mail2 dovecot: auth(default): master in: REQUEST1 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/umutauid=8287gid=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 [EMAIL PROTECTED] 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
[Dovecot] Deliver parameter problem
Hello, I'm using dovecot-1.0.5 with postfix. I have to use deliver from procmail because I have some filters. There is no document about how to using deliver parameters (-d) other than http://wiki.dovecot.org/LDA . If I set -d parameters manually as a username everything is ok. I can not set users' mail quota (don't lookup) with mysql db if I haven't set -d parameter as receipt username in procmail. How can I describe user (-d) parameter's variable in procmail? Procmail configuration, :0 | /usr/local/dovecot/libexec/dovecot/deliver -f $blabla -d $blabla2 Output of the configuration, # 1.0.5: /usr/local/dovecot/etc/dovecot.conf protocols: imap imaps pop3 pop3s listen: 10.1.1.168 ssl_cert_file: /usr/local/dovecot/etc/dovecot.cert.pem ssl_key_file: /usr/local/dovecot/etc/dovecot.key.pem disable_plaintext_auth: no login_dir: /usr/local/dovecot/var/run/dovecot/login login_executable(default): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(imap): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3-login mail_location: maildir:%h/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u mail_debug: yes mail_full_filesystem_access: yes mail_executable(default): /usr/local/dovecot/libexec/dovecot/imap mail_executable(imap): /usr/local/dovecot/libexec/dovecot/imap mail_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): mail_plugin_dir(default): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/dovecot/lib/dovecot/pop3 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xv%08Xu namespace: type: private separator: / location: maildir:~/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u inbox: yes namespace: type: private separator: / prefix: mail/ location: maildir:~/Maildir/.mail:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u auth default: verbose: yes debug: yes passdb: driver: pam userdb: driver: sql args: /usr/local/dovecot/etc/dovecot-sql.conf userdb: driver: prefetch socket: type: listen master: path: /var/run/dovecot/auth-master mode: 438 plugin: quota: maildir:storage=50:ignore=trash regards,
[Dovecot] Deliver parameter problem
Hello, I'm using dovecot-1.0.5 with postfix. There is no document about how to using deliver parameters (-d). I can not set mail quota with mysql db if I haven't set this parameter. How can I describe user (-d) parameter to procmail. Procmail set, :0 | /usr/local/dovecot/libexec/dovecot/deliver -f blabla -d blabla regards,
[Dovecot] Deliver parameter problem
Hello, I'm using dovecot-1.0.5 with postfix. I have to use deliver from procmail because I have some filters. There is no document about how to using deliver parameters (-d) other than http://wiki.dovecot.org/LDA . If I set -d parameters manually as a username everything is ok. I can not set users' mail quota (don't lookup) with mysql db if I haven't set -d parameter as receipt username in procmail. How can I describe user (-d) parameter's variable in procmail? Procmail configuration, :0 | /usr/local/dovecot/libexec/dovecot/deliver -f $blabla -d $blabla2 Output of the configuration, # 1.0.5: /usr/local/dovecot/etc/dovecot.conf protocols: imap imaps pop3 pop3s listen: 10.1.1.168 ssl_cert_file: /usr/local/dovecot/etc/dovecot.cert.pem ssl_key_file: /usr/local/dovecot/etc/dovecot.key.pem disable_plaintext_auth: no login_dir: /usr/local/dovecot/var/run/dovecot/login login_executable(default): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(imap): /usr/local/dovecot/libexec/dovecot/imap-login login_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3-login mail_location: maildir:%h/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u mail_debug: yes mail_full_filesystem_access: yes mail_executable(default): /usr/local/dovecot/libexec/dovecot/imap mail_executable(imap): /usr/local/dovecot/libexec/dovecot/imap mail_executable(pop3): /usr/local/dovecot/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): mail_plugin_dir(default): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/dovecot/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/dovecot/lib/dovecot/pop3 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xv%08Xu namespace: type: private separator: / location: maildir:~/Maildir:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u inbox: yes namespace: type: private separator: / prefix: mail/ location: maildir:~/Maildir/.mail:INDEX=/var/no-quotas/index/%u:CONTROL=/var/no-quotas/control/%u auth default: verbose: yes debug: yes passdb: driver: pam userdb: driver: sql args: /usr/local/dovecot/etc/dovecot-sql.conf userdb: driver: prefetch socket: type: listen master: path: /var/run/dovecot/auth-master mode: 438 plugin: quota: maildir:storage=50:ignore=trash regards,