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@sbt.net.au,110.175.246.167,
): 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/d h.pem Mar 03 16:23:57 imap-login: Info: Login: user=voytek@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