1 Topic by ikabsd

  • ikabsd
  • Member
  • Offline
  • Registered: 2018-04-04
  • Posts: 1

Topic: Dovecot 2.3 FreeBSD

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
0.9.8 MARIADB edition
- Linux/BSD distribution name and version:
FreeBSD  11.1-RELEASE FreeBSD 11.1-RELEASE #0 r321309: amd64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
MariaDB
- Web server (Apache or Nginx):
Nginx
- Manage mail accounts with iRedAdmin-Pro?
No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
First Stage:
Apr  3 20:18:49 mx01 dovecot: doveconf: Warning: Obsolete setting in /usr/local/etc/dovecot/dovecot.conf:43: ssl_protocols has been replaced by ssl_min_protocol
Apr  3 20:18:49 mx01 dovecot: doveconf: Error: Could not find a minimum ssl_min_protocol setting from ssl_protocols = !SSLv2 !SSLv3: Unrecognized protocol 'SSLv2'
Apr  3 20:18:49 mx01 dovecot: doveconf: Warning: Obsolete setting in /usr/local/etc/dovecot/dovecot.conf:55: ssl_dh_parameters_length is no longer needed
Second Stage:
Apr  3 20:25:07 mx01 dovecot: imap-login: Login: user=<postmaster@xxxxxx.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=3332, secured, session=<SzaagPdo8MN/AAAB>
Apr  3 20:25:07 mx01 dovecot: imap(postmaster@xxxxxx.com): Error: Plugin 'imap_stats' not found from directory /usr/local/lib/dovecot
Apr  3 20:27:38 mx01 dovecot: lda: Fatal: Plugin 'stats' not found from directory /usr/local/lib/dovecot

First issue:
1)Need to comment out ssl_protocols line
2) Optional add ssl_min_protocol = !TLSv1
3) need to provide dh.pem file ( in my case I added:  ssl_dh = </etc/ssl/dh.pem )
Second issue:
imap_stats and stats plugins not found because of deprecation in new version and needs to be changed in
/usr/local/etc/dovecot/dovecot.conf imap_stats to imap_old_stats and stats to old_stats

Links used for troubleshooting:
https://wiki2.dovecot.org/Upgrading/2.3

I believe you will fix this things asap. Thank you.

P.S Dovecot version: 2.3.1 (8e2f634)

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by RattleAndHum

  • RattleAndHum
  • Member
  • Offline
  • Registered: 2011-03-17
  • Posts: 14

Re: Dovecot 2.3 FreeBSD

Hi,
I've also upgraded to Dovecot 2.3 on a FreeBSD 11.1 system. Changed the dovecot.conf settings above. The dovecot service starts, but get the following messages in dovecot.log:

Apr 04 20:49:50 auth-worker(39281): Warning: mysql: Query failed, retrying: Unknown column 'enableimaptls' in 'where clause'
Apr 04 20:49:50 auth-worker(39281): Error: sql(admin@domain.com,A.B.C.D,<V3S4SQppm+BTo2s+>): Password query failed: Unknown column 'enableimaptls' in 'where clause'

Running 0.9.6 MySQL Edition.

What is wrong here?

Thank you in advance!

With kind regards,
Lars Wittebrood

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Dovecot 2.3 FreeBSD

Seems Dovecot replaces 'secured' by 'tls' as the secure connection mark internally.
You have to create new SQL column "mailbox.enableimaptls" like this:

sql> USE vmail;
sql> ALTER TABLE mailbox ADD COLUMN enableimaptls TINYINT(1) NOT NULL DEFAULT 1;
sql> ALTER TABLE mailbox ADD INDEX (`enableimaptls`);

But i'm afraid that some other SQL columns will have same issue due to this Dovecot internal change. Will check later.

4 Reply by RattleAndHum

  • RattleAndHum
  • Member
  • Offline
  • Registered: 2011-03-17
  • Posts: 14

Re: Dovecot 2.3 FreeBSD

Thank you very much for the quick reply! Looks like this solved it!

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Dovecot 2.3 FreeBSD

Dear all,

Please help review Dovecot upgrade tutorial:
https://docs.iredmail.org/upgrade.dovecot.2.2-2.3.html

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Dovecot 2.3 FreeBSD

iRedMail-0.9.8 has been repacked with the Dovecot-2.3 support.