- dovecot - dovecot.org

[Dovecot] problem mysql and dovecot 1.2
by debian＠robertain.com 23 Jul '10

23 Jul '10

Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages | +----+-----------+----------------------------------+---------------------------+----------+----------------+ | 1 | 1 | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxx(a)domain.com | 10000000 | 0 | .................. Before my time in 1.2. I did this for the quota management: user_query = SELECT CONCAT('/var/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))) AS home, 5000 AS uid, 5000 AS gid, CONCAT('maildir:storage=',quota_kb,':messages=',quota_messages) AS quota FROM virtual_users WHERE email='%u'; My configuration dovecot -n # 1.2.11: /etc/dovecot/dovecot.conf # OS: Linux 2.6.30-2-686 i686 Debian squeeze/sid ext3 log_path: /var/vmail/dovecot-deliver.log info_log_path: /var/vmail/dovecot-deliver.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imaps pop3s managesieve ssl_cert_file: /etc/ssl/certs/popimap.crt ssl_key_file: /etc/ssl/private/popimap.key verbose_ssl: yes 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 login_executable(managesieve): /usr/lib/dovecot/managesieve-login mail_max_userip_connections(default): 10 mail_max_userip_connections(imap): 10 mail_max_userip_connections(pop3): 3 mail_max_userip_connections(managesieve): 10 mail_location: maildir:/var/vmail/%d/%n/Maildir mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugins(managesieve): 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 mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve namespace: type: private separator: . prefix: INBOX. inbox: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)mydomain.com mail_plugins: quota sieve auth_socket_path: /var/run/dovecot/auth-master auth default: mechanisms: plain login passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: static args: uid=5000 gid=5000 home=/var/vmail/%d/%n allow_all_users=yes 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: sieve: ~/.dovecot.sieve sieve_dir: ~/sieve quota: dict:user::proxy::quotadict quota_rule: *:storage=100M quota_warning: storage=95%% /usr/local/bin/quota-warning.sh 95 dict: quotadict: mysql:/etc/dovecot/dovecot-dict-sql.conf my configuration dovecot-sql.conf cat dovecot-sql.conf #protocols = imap imaps pop3 pop3s # Database driver: mysql, pgsql, sqlite driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailsuer password=***** default_pass_scheme = PLAIN-MD5 password_query = SELECT email,password FROM virtual_users WHERE email='%u'; #user_query = SELECT home, uid, gid, concat('*:storage=', quota_bytes, 'B') AS quota_rule FROM virtual_users WHERE userid = '%u' #user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, CONCAT('*:storage=', quota_bytes, 'B') AS quota_rule FROM virtual_users WHERE userid = '%u' #user_query = SELECT maildir AS home , 5000 AS uid, 5000 AS gid, CONCAT('*:storage=',quota, 'B') AS quota_rule FROM virtual_users WHERE username = '%u' #user_query = SELECT maildir AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM quota WHERE username = '%u' AND active = '1 I used all these configurations but none work. yet but the quotas work through this option: quota_rule: *:storage=100M The problem is that quotas are not personalized. I'm looking for a way to use quotas, but using my mysql database. I galley for some time. So if someone has an idea I am willing

4 6

[Dovecot] quota-warning example script from wiki2
by Daniel Luttermann 22 Jul '10

22 Jul '10

Hi, in the wiki there's an example script for sending an email to an user that has exceeded his quota. Link: http://wiki2.dovecot.org/Quota/Configuration The dovecot deliver command line is: dovecot-lda -d $USER -o "plugin/quota=maildir:User quota:noenforcing" I wonder about -o: seems to be "undocumented" because I've found no information about this parameter. If this parameter is needed what if I use dict instead of maildir? Is the syntax different? Thanks. -- Daniel

2 1

[Dovecot] v2.0.rc3 released
by Timo Sirainen 22 Jul '10

22 Jul '10

http://dovecot.org/releases/2.0/rc/dovecot-2.0.rc3.tar.gz http://dovecot.org/releases/2.0/rc/dovecot-2.0.rc3.tar.gz.sig A lot of dsync fixes. I think I've fixed now all of the bugs ever reported about dsync and I'm hopeful that it's now stable. All the rest of Dovecot looks pretty good too. Maybe v2.0.0 will be out next week. Changes since rc2: * Single-dbox is now called "sdbox" instead of "dbox". "dbox" will stay as an alias for it for now. + Added mail_temp_dir setting, used by deliver and lmtp for creating temporary mail files. Default is /tmp. + doveadm: Added "director map" command to list user -> host mappings. - imap: Fixed checking if list=children namespace has children. - director: If all login processes died, director stopped reading proxy-notify input and caused future login processes to hang - mail_log plugin configuration was broken - Using more than 2 plugins could have caused broken behavior - mdbox: Race condition fixes related to copying and purging - dsync: Lots of fixes

5 14

[Dovecot] [2.0] Auth Cache
by Luigi Rosa 22 Jul '10

22 Jul '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Is there a way to trace the auth cache? Something like how many items are in the chache, how many bytes of the cache are used.... Thank you. Ciao, luigi - -- / +--[Luigi Rosa]-- \ In a dark time the eye begins to see. --Theodore Roethke -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxInjwACgkQ3kWu7Tfl6ZQWrgCdEL9wy33xQiwU+ORKi5bNOawm DC4AnRci869XpYobkHfhw+b1WnapiJqk =cyE5 -----END PGP SIGNATURE-----

2 2

[Dovecot] Help with some features to do in a plugin
by Alex Baule 22 Jul '10

22 Jul '10

Hello Everyone.... I need to develop some plugins, but i can't know if is possible to do or not. 1 - There is a way to deny a email to be moved from one folder to another ? example: the user is only allowed to move mails in Spam Folder to Trash Folder. If yes, were i can find a code example or a plugin to extract some idea. 2 - It's possible to deny a user to create a subscription folder ? example: with autocreate plugin, i create a Spam Folder, but if the autocreate is not configured to this user, it can't create manually this same folder. If yes, were i can find a code example or a plugin to extract some idea. Tks !

2 2

[Dovecot] shared folders - dbox
by Hajo Locke 22 Jul '10

22 Jul '10

Hello, iam interested in using dbox format with dovecot2. Ist it possible to use shared folders with this storage format? i only see references to Maildir. Thanks, Hajo

2 1

[Dovecot] doveadm mailbox create -7 … returns 0
by Pascal Volk 22 Jul '10

22 Jul '10

Hi Timo, I'm using doveadm in my script to create [sm]dboxes. For some reason I forgot to remove the -7 option in my script. I wondered why no mailboxes were created and the script didn't report an error - it checks the exit status from doveadm. The problem: doveadm mailbox create -7 … returns 0 Regards, Pascal -- The trapper recommends today: f007ba11.1020305(a)localdomain.org

1 1

[Dovecot] NFS Maildirs
by Martijn de Munnik 22 Jul '10

22 Jul '10

Hi, We have our user homedirs on nfs so I enabled nfs parameters in dovecot.conf. Everything works fine but when I want to delete a homedir of a user I can't delete it because I can't remove the .nfs files in the Maildir. I don't want to stop dovecot, remove the homedir and start dovecot. Is there another way to accomplish this. Thanks, Martijn # 1.2.12: /etc/opt/redknot/dovecot.conf Warning: fd limit 256 is lower than what Dovecot can use under full load (more than 4096). Either grow the limit or change login_max_processes_count and max_mail_processes settings # OS: SunOS 5.11 sun4v log_path: /var/log/dovecot.log protocols: imap imaps managesieve ssl_cert_file: /etc/opt/redknot/ssl/secure.redknot.nl.cer ssl_key_file: /etc/opt/redknot/ssl/secure.redknot.nl.key disable_plaintext_auth: no login_dir: /opt/redknot/var/run/dovecot/login login_executable(default): /opt/redknot/libexec/dovecot/imap-login login_executable(imap): /opt/redknot/libexec/dovecot/imap-login login_executable(managesieve): /opt/redknot/libexec/dovecot/managesieve-login login_processes_count: 5 login_max_processes_count: 1024 max_mail_processes: 2048 first_valid_uid: 200 first_valid_gid: 10 mail_location: maildir:~/Maildir mmap_disable: yes mail_nfs_storage: yes mail_nfs_index: yes mail_executable(default): /opt/redknot/libexec/dovecot/imap mail_executable(imap): /opt/redknot/libexec/dovecot/imap mail_executable(managesieve): /opt/redknot/libexec/dovecot/managesieve mail_plugins(default): antispam mail_plugins(imap): antispam mail_plugins(managesieve): mail_plugin_dir(default): /opt/redknot/lib/dovecot/imap mail_plugin_dir(imap): /opt/redknot/lib/dovecot/imap mail_plugin_dir(managesieve): /opt/redknot/lib/dovecot/managesieve auth default: mechanisms: plain login passdb: driver: pam args: other userdb: driver: passwd socket: type: listen client: path: /opt/redknot/var/run/dovecot/auth-client mode: 432 master: path: /opt/redknot/var/run/dovecot/auth-master mode: 384 plugin: antispam_signature: X-DSPAM-Signature antispam_signature_missing: error antispam_trash: Trash antispam_spam: Junk antispam_allow_append_to_spam: yes antispam_dspam_binary: /opt/redknot/bin/dspam antispam_dspam_args: --deliver;--user;%u;--debug antispam_dspam_result_header: X-DSPAM-Result antispam_dspam_result_blacklist: Virus YoungGuns Kasteleinenkampweg 7b 5222 AX 's-Hertogenbosch T. 073 623 56 40 F. 073 623 56 39 www.youngguns.nl KvK 18076568

2 2

[Dovecot] Applemail did not sync when MailTags enabled
by mailinglists＠belfin.ch 22 Jul '10

22 Jul '10

Hi I run dovecot 1.2.11. One of my users turned on MailTags in his AppleMail with the effect that he could not anymore synchronize his imap folders. No error message, just endless waiting. Has anybody experienced a similar behaviour? Thanks John

1 0

[Dovecot] Feature request: usernames and passwords
by Thanos Chatziathanassiou 21 Jul '10

21 Jul '10

A relatively recent development that spammers got wind of is users that have username==password, with/without the domain. I am tracking numerous 1-off attempts from bots to gain access to mailboxes this way. Situation isn't made any better if you're also using dovecot as SMTP AUTH provider for I am ashamed to admit I've relayed some spam that way. Would it be possible to deny login if username==password with a (non?)polite/custom message to go change your password to something less obvious ?

10 18