migrating/cloning 2.2 > 2.3?

Voytek Eymont voytek at sbt.net.au
Sun Mar 3 07:29:27 EET 2019


> 11:30:12 auth-worker(32307): Warning: sqlpool(mysql): Query failed,
> retrying: Unknown column 'mailbox.enableimaptls' in 'where clause'
> Mar 03 11:30:12 auth-worker(32307): Error:
> sql(voytek at sbt.net.au,110.175.246.167,<xBk6viWDzrRur/an>): User query
> failed: Unknown column 'mailbox.enableimaptls' in 'where clause'

I've found a page with SQL table mods that seems to have fixed some of my
issues, after modifying SQL, I can log in

Mar 03 16:23:34 master: Info: Dovecot v2.3.4.1 (3c0b8769e) starting up for
pop3,
 imap, sieve (core dumps disabled)
Mar 03 16:23:56 config: Warning: please set ssl_dh=</etc/dovecot/dh.pem
Mar 03 16:23:56 config: Warning: You can generate it with: dd
if=/var/lib/doveco
t/ssl-parameters.dat bs=1 skip=88 | openssl dhparam -inform der >
/etc/dovecot/d
h.pem
Mar 03 16:23:57 imap-login: Info: Login: user=<voytek at sbt.net.au>,
method=PLAIN,
 rip=110.175.246.167, lip=103.106.168.106, mpid=2757, TLS,
session=<283B2CmDccdu
r/an>

I'll do the dh.pem next

//these are SQL mods I've done

ALTER TABLE mailbox ADD COLUMN enableimaptls TINYINT(1) NOT NULL DEFAULT 1;
ALTER TABLE mailbox ADD INDEX (enableimaptls);
ALTER TABLE mailbox ADD COLUMN enablepop3tls TINYINT(1) NOT NULL DEFAULT 1;
ALTER TABLE mailbox ADD INDEX (enablepop3tls);
ALTER TABLE mailbox ADD COLUMN enablesievetls TINYINT(1) NOT NULL DEFAULT 1;
ALTER TABLE mailbox ADD INDEX (enablesievetls);//

-- 
Voytek



More information about the dovecot mailing list