On 07/01/2022 18:31, Ken Wright wrote:
On Fri, 2022-01-07 at 10:02 +0100, Christian Kivalo wrote:
On January 7, 2022 9:51:20 AM GMT+01:00, Ken Wright daddywarlock@gmail.com wrote:
I reinstalled Dovecot this evening, because I haven't been able to receive emails recently. After configuring and adjusting for the use of PostfixAdmin, I get the following error message in Evolution:;
Failed to open folder. The reported error was "Failed to authenticate: TLS connection closed unexpectedly".
Does anyone recognize this error? Do you have a connection attempt logged by dovecot? Is there anything in the logs on the server?
Here's the output of tail /var/log/mail.log:
.... Jan 7 12:23:02 grace dovecot: auth-worker(665770): Error: sql(www-data@mydomain.com): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM mailbox WHERE username = 'www-data@mydomain.com' AND active='1'' at line 1 Jan 7 12:23:02 grace dovecot: lmtp(www-data@mydomain.com)<666838><kNcEEfZ22GHWLAoAThsuZQ>: Error: auth-master: userdb lookup(www-data@mydomain.com): Auth USER lookup failed Jan 7 12:23:02 grace dovecot: lmtp(666838): Error: lmtp-server: conn unix:pid=666840,uid=117 [6]: rcpt www-data@mydomain.com: Failed to lookup user www-data@mydomain.com: Internal error occurred. Refer to server log for more information.
Hope this helps!
Ken
Ken
it may or may not be related to the tls issue, but I think you will want to investigate that message about the SQL query syntax error. You are not going to be able to login if the query is giving errors. Check the user_query in the dovecot configuration, since the SQL snippet in the log doesn't reveal the cause.
John