1 Topic by gondim (edited by gondim 2018-04-08 10:05:29)

  • gondim
  • Member
  • Offline
  • Registered: 2010-07-24
  • Posts: 76

Topic: Problem with dovecot

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: FreeBSD 11.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- 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.
====

New instalation. Email client error in check email. My log:

Apr  7 22:42:49 mail dovecot: auth-worker(24266): Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  7 22:42:49 mail dovecot: auth-worker(24266): Error: sql(gondim@bsdinfo.com.br,2804:xxxx:f18:0:9dd1:8e36:5116:59cf,<9QIraExpYMIoBBBUDxgAAJ3RjjZRFlnP>): Password query failed: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  7 22:42:52 mail dovecot: pop3-login: Disconnected (auth service reported temporary failure): user=<gondim@bsdinfo.com.br>, method=PLAIN, rip=2804:xxxx:f18:0:9dd1:8e36:5116:59cf, lip=2804:xxxx:dead:b1ba::163, TLS, session=<9QIraExpYMIoBBBUDxgAAJ3RjjZRFlnP>

changing mailbox.enablepop3secured to mailbox.enablepop3tls   works

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Problem with dovecot

gondim wrote:

changing mailbox.enablepop3secured to mailbox.enablepop3tls   works

Don't do this, we need both of them.

SQL structure is now mentioned in our upgrade tutorial:
https://docs.iredmail.org/upgrade.dovecot.2.2-2.3.html

P.S. iRedMail-0.9.8 was repacked to include this SQL structure change.

3 Reply by gondim

  • gondim
  • Member
  • Offline
  • Registered: 2010-07-24
  • Posts: 76

Re: Problem with dovecot

Hi Zhang,

I've done the documentation [1] and the problem keeps happening ..

[1] https://docs.iredmail.org/upgrade.dovecot.2.2-2.3.html

Apr  8 11:42:10 mail dovecot: auth-worker(3367): Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  8 11:42:10 mail dovecot: auth-worker(3367): Error: sql(gondim@bsdinfo.com.br,2804:xxxx:f18:0:9dd1:8e36:5116:59cf,<9iZWS1dpU80oBBBUDxgAAJ3RjjZRFlnP>): Password query failed: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  8 11:42:14 mail dovecot: pop3-login: Disconnected (auth service reported temporary failure): user=<gondim@bsdinfo.com.br>, method=PLAIN, rip=2804:xxxx:f18:0:9dd1:8e36:5116:59cf, lip=2804:xxxx:dead:b1ba::163, TLS, session=<9iZWS1dpU80oBBBUDxgAAJ3RjjZRFlnP>
Apr  8 11:42:14 mail dovecot: auth-worker(3367): Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  8 11:42:14 mail dovecot: auth-worker(3367): Error: sql(gondim@linuxinfo.com.br,2804:xxxx:f18:0:9dd1:8e36:5116:59cf,<CgRYS1dpVM0oBBBUDxgAAJ3RjjZRFlnP>): Password query failed: Unknown column 'mailbox.enablepop3tls' in 'where clause'
Apr  8 11:43:56 mail dovecot: pop3-login: Disconnected (auth service reported temporary failure): user=<gondim@linuxinfo.com.br>, method=PLAIN, rip=2804:xxxx:f18:0:9dd1:8e36:5116:59cf, lip=2804:xxxx:dead:b1ba::163, TLS, session=<CgRYS1dpVM0oBBBUDxgAAJ3RjjZRFlnP>
Apr  8 11:44:19 mail dovecot: imap-login: Disconnected (no auth attempts in 1 secs): user=<>, rip=141.212.122.81, lip=191.xxx.120.163, TLS, session=<U7QEU1dpPcCN1HpR>

4 Reply by gondim

  • gondim
  • Member
  • Offline
  • Registered: 2010-07-24
  • Posts: 76

Re: Problem with dovecot

My dovecot.conf: https://pastebin.com/109YwYky

5 Reply by gondim

  • gondim
  • Member
  • Offline
  • Registered: 2010-07-24
  • Posts: 76

Re: Problem with dovecot

I believe that it is necessary to create mailbox.enablepop3tls in the database too:

USE vmail;
ALTER TABLE mailbox ADD COLUMN enablepop3tls TINYINT(1) NOT NULL DEFAULT 1;
ALTER TABLE mailbox ADD INDEX (enablepop3tls);

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Problem with dovecot

Updated the doc with this new column:
https://docs.iredmail.org/upgrade.dovecot.2.2-2.3.html

Thanks for the feedback.