- dovecot - dovecot.org

[Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'
by Thomas Creutz 20 Feb '14

20 Feb '14

Hi List, I have a problem with dovecot 2.2.12 and sieve-filter call: su -c 'sieve-filter -D -v -W -C -u account(a)domain.tld /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail gives me sieve-filter(vmail): Error: user account(a)domain.tld: Auth USER lookup failed sieve-filter(vmail): Fatal: Internal error occurred. Refer to server log for more information. on log file I see this: Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause' Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Error: sql(account(a)domain.tld): User query failed: Unknown column 'filter' in 'where clause' but I never used filter in dovecot: grep -iR filter /etc/dovecot/ gives me no result (and yes the dir is right). Any Idea whats wrong? I know it tells me, that the column is missing in the Database - but why I need it? I also never see it documented somewhere: http://wiki2.dovecot.org/AuthDatabase/SQL http://wiki2.dovecot.org/PasswordDatabase/ExtraFields Thomas

2 6

[Dovecot] virtualfolders all mails minus duplicates
by Francesco 19 Feb '14

19 Feb '14

Hello everyone, i'm trying to mess up a bit with virtual folders and i'm trying to perform something like this: i'd like to create an IMAP virtual folder which shows me all the emails in in INBOX and subfolders but by removing "duplicates" what i mean as duplicates? simply i can recognize duplicate emails as the ones with the same message-id in the header (this was just an idea). in that way if i have a message which is present in more then one folder then it's displayed only once. i considered the idea of using message-id in the header as a criteria, but i don't know if this can be done in this way or in any way at all. any suggestion is really welcome. i'm using dovecot 1.2.15. this is a namespace example just for reference: for INBOX: namespace private { separator = . prefix = INBOX. #subscriptions = yes #list = no inbox = yes } for virtuals: namespace private { prefix = v. separator = . location = virtual:/var/utenti/%Ld/%n/VirtualFolders list = yes inbox = no subscriptions = yes hidden = no } as of now i'm running a virtualfolder which shows messages flagged as important which is done like this: INBOX INBOX.* all flagged hope you can provide me with some hints. Thanks very much Francesco

2 1

[Dovecot] Use header from instead envelope sender - quota exceed
by pgala 19 Feb '14

19 Feb '14

Hi, i want use dovecot and plugin quota to inform users about exceeded space. I also configure postfix to rewrite envelope_sender so envelope_sender<>header: from. Dovecot sent mail with information about exceeded space to email in envelope_sender. It is possible to configure that dovecot sent mail to header from address? I need use sender_canonical_maps in postfix because i want also relay mail outgoing. Thanks for helping me, Piotr -- View this message in context: http://dovecot.2317879.n4.nabble.com/Use-header-from-instead-envelope-sende… Sent from the Dovecot mailing list archive at Nabble.com.

3 2

[Dovecot] Filtering spam in an offlineimap + dovecot setup
by Alan Schmitt 19 Feb '14

19 Feb '14

Hello, To easily access my mail both offline on my computer and on my phone, I am synchronizing a local copy on my computer using offlineimap. As the spam filtering options provided on the server are not sufficient, I am now looking into client-side spam filtering. My current setup is as follows. Mail is synchronized using offlineimap, and delivered to a local dovecot server: --8<---------------cut here---------------start------------->8--- [Repository LocalIMAP] type = IMAP preauthtunnel = /usr/local/Cellar/dovecot/2.2.10/libexec/dovecot/imap -c ~/.dovecotzimbra.rc --8<---------------cut here---------------end--------------->8--- The configuration of the local server is simply: --8<---------------cut here---------------start------------->8--- protocols = imap mail_location = maildir:~/.Maildir/zimbra:INBOX=~/.Maildir/zimbra/.INBOX --8<---------------cut here---------------end--------------->8--- I then read my mail using gnus, and index it using notmuch. A suggestion I've been considering is use the pigeonhole sieve extprograms plugin (http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Extprograms) to call the spam filter (I've been looking at dspam at the moment). However, I could not find how to configure the use of sieves in the context of offlineimap. Hence my questions: Is it possible to use dovecot sieves in such a setting? Is there a howto that explains how to do it? Should I try to do things in a different way? (I'm ready to change my setup, as long as I can keep an offline copy of my email in sync with a server copy.) Thanks a lot for any suggestion, Alan PS: I used to use SpamSieve (http://c-command.com/spamsieve/) on a Mac Mini that was running continuously as a spam filter drone. This machine has been retired and I'm basically looking for leaner ways to do a similar thing.

5 9

[Dovecot] dovecot antispam plugin not found
by Alan Schmitt 19 Feb '14

19 Feb '14

Hello, I'm trying to setup dovecot-antispam, and even though the configuration and the installation seem to have gone well, dovecot is telling me it's not finding it. Here is the symptom: schmitta@top-wifi ~> /usr/local/Cellar/dovecot/2.2.10/libexec/dovecot/imap -c ~/.dovecotzimbra.rc Fatal: Plugin 'antispam' not found from directory /usr/local/Cellar/dovecot/2.2.10/lib/dovecot However there seems to be a plugin there: schmitta@top-wifi ~> ls -al /usr/local/Cellar/dovecot/2.2.10/lib/dovecot/ | grep antispam -rwxr-xr-x 1 schmitta admin 38460 18 fév 22:40 lib90_antispam_plugin.bundle I note that it is the only plugin with the ".bundle" extension, if it's important. My configuration file is as follows (I'm not finished with the antispam configuration yet): --8<---------------cut here---------------start------------->8--- protocols = imap mail_location = maildir:~/.Maildir/zimbra:INBOX=~/.Maildir/zimbra/.INBOX default_login_user = _dovenull default_internal_user = _dovecot protocol imap { # mail_plugins = $mail_plugins antispam } protocol lda { log_path = ~/.logs/dovecot-lda-errors.log info_log_path = ~/.logs/dovecot-lda.log mail_plugins = $mail_plugins sieve } plugin { sieve = ~/.dovecot.sieve sieve_plugins = sieve_extprograms sieve_extensions = +vnd.dovecot.filter sieve_filter_bin_dir = /usr/local/lib/dovecot/sieve-filter antispam_backend = DSPAM antispam_signature = X-DSPAM-Signature } --8<---------------cut here---------------end--------------->8--- Should I do something special to be able to load the antispam plugin? Thanks, Alan

2 3

[Dovecot] Virtual folder for selected users only? (1.2.15)
by Sebastian Schäfer 19 Feb '14

19 Feb '14

hi, i want to set up virtual folders just for some users on our mailserver. the server is set up with a virtual system-user for each of our clients having multiple mailboxes/users (provided by dovecot-mysql). mailboxes are located: /var/mails/SYSUSER/MAILBOX f.e. my mailbox-folder is set to /var/mails/bergschaf/sebastian[at]bergschaf.net {homedir} = /var/mails {maildir} = bergschaf/sebastian[at]bergschaf.net user_query = SELECT homedir AS home, concat('maildir:', maildir) AS mail, uid, gid, concat('maildir:storage=', (quota*1024)) as quota FROM mail_users WHERE username = '%u' now i want to add virtual folders to my mailbox without affecting any other client/mailbox on the server. i already tried to add a namespace "virtual" like mentioned in the wiki and in some other hotwo-guides, but this points to the need to create a "virtual"-folder for each mailbox what i would like to avoid. (f.e. location = %h/%u/virtual => /var/mails/sebastian[at]bergschaf.net). is it possible to enable a namespace just for some selected users on the server? if that's not possible - i'm not sure how to set the location-directive correctly, because i can't find a variable pointing to the maildir: %u => sebastian[at]bergschaf.net %h => /var/mails ...but how should i point the location to {homedir}/{maildir}/virtual? thanks! sebastian dovecot --version 1.2.15

4 3

[Dovecot] failed: Message has been copied too many times
by Angel L. Mateo 19 Feb '14

19 Feb '14

Hello, I'm running dovecot 2.1.16 in a ubuntu 12.04 server, with lazy_expunge, SiS and mdbox format. The problem I'm having is that the index for one the mailboxes of one of my users is growing too much. This is not the first time of this problem. In previous cases, is because a message is duplicated thousand of times (I haven't found any reason for this). In these cases, moving messages to other folder and moving again to this same folder fixes the problem. So I have tried this, and I have moved all messages from this folder to another one. But this time, after this, indexes directory is still using a lot of space. And the folder seems to have more serious problems: amateo_adm@myotis51:~$ sudo doveadm search -u vlo mailbox BORRADOS.INBOX.MNCS doveadm(vlo): Error: Syncing mailbox BORRADOS.INBOX.MNCS failed: Message has been copied too many times (59306 + -1) I have tried to delete the folder, with the same result: amateo_adm@myotis51:~$ sudo doveadm mailbox delete -u vlo BORRADOS.INBOX.MNCS doveadm(vlo): Error: Can't delete mailbox BORRADOS.INBOX.MNCS: Message has been copied too many times (59306 + -1) And to purge user's mailbox, but it didn't fix the problem. PS: If this could help, BORRADOS. is the namespace used by lazy_expunge plugin. -- Angel L. Mateo Martínez Sección de Telemática Área de Tecnologías de la Información y las Comunicaciones Aplicadas (ATICA) http://www.um.es/atica Tfo: 868887590 Fax: 868888337

4 9

Re: [Dovecot] Virtual folder for selected users only? (1.2.15)
by Sebastian Schäfer 19 Feb '14

19 Feb '14

> thats very outdated, you should upgrade 2.1.x / 2.2.x latest I would like to avoid this, because the 1.2.15 is running extremely stable for a long time. (also it's the most recent version on this old squeeze-machine if not using backports) As far as I see, the virtual folders are fully supported since 1.2.x - am I wrong? What are the advantages of upgrading to 2.x? Are there security issues? Thanks! best, sebastian

2 1

[Dovecot] Dovecot, mysql, and quota
by David Mehler 19 Feb '14

19 Feb '14

Hello, I'm running dovecot 2.2 and wanting to get quotas going. I've got the plugins loaded appropriately and am wanting to configure a dictionary backend to talk to my mysql database. I've got a single database called mail which has all the mail-related items in it. One table is for virtual users which postfix uses. It looks like this: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `password` varchar(128) NOT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; and a user looks like: INSERT INTO `mail`.`virtual_users` ( `id` , `domain_id` , `password` , `email` ) VALUES ( '1', '1', SHA2( 'PasswordGoesHere', 512) , 'username(a)domain.com' ); plugin { # SQL backend: quota = dict:User quota::proxy::sqlquota } dict { sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } Now when creating the quota table i'd like to have the username field linked to my virtual_users table username field, so I don't have to set up two tables both with the same username information in it. Can someone check me on this design so that if I delete a virtual user out of the virtual_users table the coresponding row in the quota table is also eliminated? My second question has to do with global and per user quotas. If I have something like this: CREATE TABLE quota ( username varchar(100) not null, bytes bigint not null default 262144, messages integer not null default 0, primary key (username) ); 256MB for all users by default, but then if I give a user a 100MB value in the bytes field of their quota entry would that be a per-user quota? Thanks. Dave.

2 1

[Dovecot] Index corruption with 2.2.12 when moving a message
by Bojan Smojver 19 Feb '14

19 Feb '14

Just bumped into this today, when I upgraded to a testing package in Fedora: https://admin.fedoraproject.org/updates/FEDORA-2014-2672/dovecot-2.2.12-1.f… For details, see this bug: https://bugzilla.redhat.com/show_bug.cgi?id=1066709 Haven't seen this kind of thing before. Sure, it worked the second time I tried to move the message to another folder (I'm guessing index got rebuilt or something), but still, looks suspicious. Anyway, I'm using mbox format mailboxes, if it matters. Client was Gnome Evolution 3.10.4. -- Bojan

1 0