Re: Lucene support for FTS - EOL date.
We are talking about the large-scale commercial use of Dovecot + lucene as an FTS. MIgration to SOLR is some kind of challenge that will take some time. I'm trying to find out how much time I have. On the one hand i would like to use only the newest version of Dovecot but on the other hand i'm not able to switch fts from lucene to solr in the near future sob., 5 lut 2022 o 21:26 Stuart Henderson napisał(a): > On 2022-02-05, Jacek Grabowski wrote: > > Ok but I have to know the date (approximate) when support for lucene will > > be removed completely from dovecot. > > Does anyone know when this will happen? It is scheduled in some version > in > > the future maybe? > > Why not assume that it could be removed at the next release and make > plans to migrate to a maintained FTS engine? If dovecot-fts-lucene is > currently working for you then dovecot-fts-flatcurve might be a good > alternative. (Another option is to not update. You might think that's > a bad idea, but with fts-lucene you already on something which is > outdated so that isn't new). > > > -- Pozdrawiam. Jacek Grabowski.
Re: Lucene support for FTS - EOL date.
On 2022-02-05, Jacek Grabowski wrote: > Ok but I have to know the date (approximate) when support for lucene will > be removed completely from dovecot. > Does anyone know when this will happen? It is scheduled in some version in > the future maybe? Why not assume that it could be removed at the next release and make plans to migrate to a maintained FTS engine? If dovecot-fts-lucene is currently working for you then dovecot-fts-flatcurve might be a good alternative. (Another option is to not update. You might think that's a bad idea, but with fts-lucene you already on something which is outdated so that isn't new).
Re: Password Mismatch when connecting from Email Client
My dovecot-sql.conf.ext file has this line: default_pass_scheme = MD5-CRYPT looking in the postfixadmin database passwords are encrypted On Fri, 04 Feb 2022 16:37:54 + Benny Pedersen wrote On 2022-02-04 17:17, Dr Francis Greaves wrote: > Any help much appreciated. what is stored in mysql on the password field ? you dont need to expose passwords in maillists
Re: How to "activate" a mail directory?
> On 05/02/2022 12:08 Peter Nabbefeld wrote: > > > Hello, > > as I need a mailbox locally only just for filtering, I've tried to > manually create it (using Maildir as backend): > > 1. Created a folder in the appropriate location under /home/vmail with > subfolders cur, new, tmp. > 2. Set the same user:group as for the other folders (i.e. vmail:vmail). > 3. Restarted Dovecot and Email-Client (Thunderbird). > > However, I cannot subscribe to the new folder. What am I missing here? > > Kind regards, > Peter You sure you put it in right place? You can check the path with doveadm mailbox path -u username MailboxName it does not have to exist to check the path. Aki
Re: v2.3.17 quota-dict related sql errors
> On 05/02/2022 21:01 Pascal Volk > wrote: > > > On 18/12/2021 20.56, Pascal Volk wrote: > > On 2021-12-04 22.18, I wrote: > >> Hi there, > >> > >> I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). > >> Right after the update, dovecot begun flooding the mail.log and > >> PostgreSQL's log. > >> ... > > Hi there, > > I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists: > > ERROR: invalid input syntax for type bigint: > "u...@localhost.localdomain.org" > > An excerpt from the journal is attached. > > > Regards, > Pascal > -- > The trapper recommends today: beeffeed.2203...@localdomain.org Can you provide your quota-dict config file (dovecot-dict-sql.conf.ext), please? Aki
Re: v2.3.17 quota-dict related sql errors
On 18/12/2021 20.56, Pascal Volk wrote: > On 2021-12-04 22.18, I wrote: >> Hi there, >> >> I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). >> Right after the update, dovecot begun flooding the mail.log and >> PostgreSQL's log. >> ... Hi there, I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists: ERROR: invalid input syntax for type bigint: "u...@localhost.localdomain.org" An excerpt from the journal is attached. Regards, Pascal -- The trapper recommends today: beeffeed.2203...@localdomain.orghost conf.d # journalctl -f -u dovecot.service Feb 05 19:38:48 host systemd[1]: Started Dovecot IMAP/POP3 email server. Feb 05 19:38:54 host dovecot[635]: master: Dovecot v2.3.18 (9dd8408c18) starting up for lmtp, pop3, imap, sieve Feb 05 19:42:00 host systemd[1]: Reloading Dovecot IMAP/POP3 email server... Feb 05 19:42:00 host dovecot[635]: master: Warning: SIGHUP received - reloading configuration Feb 05 19:42:00 host systemd[1]: Reloaded Dovecot IMAP/POP3 email server. Feb 05 19:42:28 host dovecot[1137]: imap-login: Login: user=, method=PLAIN, rip=2001:db8:815:1337:1234:5678:9abc, lip=2001:db8::143, mpid=1150, TLS, session= Feb 05 19:42:28 host dovecot[1137]: imap(u...@localhost.localdomain.org)<1150>: ID sent: name=Thunderbird, version=91.5.1 Feb 05 19:42:29 host dovecot[1137]: dict(1152): Warning: quota: dict(pgsql): sqlpool(pgsql): Query failed, retrying: ERROR: invalid input syntax for type bigint: "u...@localhost.localdomain.org" Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'u...@localhost.loca... Feb 05 19:42:29 host dovecot[1137]: dict: Error: ^ Feb 05 19:42:29 host dovecot[1137]: dict(1152): Error: quota: dict(pgsql): sqlpool(pgsql): Query failed, aborting: SELECT bytes FROM userquota WHERE uid = 'u...@localhost.localdomain.org' Feb 05 19:42:29 host dovecot[1137]: dict(1152): Error: quota: Lookup failed: ERROR: invalid input syntax for type bigint: "u...@localhost.localdomain.org" Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'u...@localhost.loca... Feb 05 19:42:29 host dovecot[1137]: dict: Error: ^ Feb 05 19:42:29 host dovecot[1137]: imap(u...@localhost.localdomain.org)<1150>: Error: Failed to get quota resource STORAGE: quota-dict: dict_lookup(priv/quota/storage) failed: dict-server returned failure: ERROR: invalid input syntax for type bigint: "u...@localhost.localdomain.org" Feb 05 19:42:29 host dovecot[1137]: imap: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'u...@localhost.loca... Feb 05 19:42:29 host dovecot[1137]: imap: Error: ^ (reply took 0.099 secs (0.100 in dict wait, 0.000 in other ioloops, 0.000 in locks, async-id reply 0.010 secs ago, started on dict-server 0.029 secs ago, took 0.029 secs))
Re: Lucene support for FTS - EOL date.
Ok but I have to know the date (approximate) when support for lucene will be removed completely from dovecot. Does anyone know when this will happen? It is scheduled in some version in the future maybe? pt., 4 lut 2022 o 22:57 Michael Slusarz napisał(a): > On 02/04/2022 4:03 AM Jacek Grabowski wrote: > > Actually on the https://doc.dovecot.org/configuration_manual/fts/lucene/ > site we can read about lucene fts plugin: > > "This plugin is no longer maintained in Dovecot (as of 2.3+) and will be > removed in the future." > > Does anyone know about approximate EOL date for lucene plugin support in > Dovecot? > > Realistically ... many years ago. There has been no maintenance or > testing of the code for years now. > > michael > -- Pozdrawiam. Jacek Grabowski.
How to "activate" a mail directory?
Hello, as I need a mailbox locally only just for filtering, I've tried to manually create it (using Maildir as backend): 1. Created a folder in the appropriate location under /home/vmail with subfolders cur, new, tmp. 2. Set the same user:group as for the other folders (i.e. vmail:vmail). 3. Restarted Dovecot and Email-Client (Thunderbird). However, I cannot subscribe to the new folder. What am I missing here? Kind regards, Peter
Password Mismatch when connecting from Email Client [SOLVED]
Alexander, that has fixed it! Many thanks to all who contributed. Regards Francis On Fri, 04 Feb 2022 17:58:23 + Alexander Dalloz wrote Am 04.02.2022 um 18:33 schrieb Francis Greaves: > Well my PostfixAdmin is setup like this: > > $CONF['encrypt'] = 'md5crypt'; > > and dovecot default_pass_scheme = MD5-CRYPT Use $CONF['encrypt'] = 'dovecot:MD5-CRYPT' $CONF['dovecotpw'] = "/path/to/doveadm pw"; in conf.inc.php of Postfixadmin. Alexander