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,<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@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