TLS connection closed unexpectedly

John Fawcett john at voipsupport.it
Fri Jan 7 21:33:46 UTC 2022


On 07/01/2022 21:03, Ken Wright wrote:
> On Fri, 2022-01-07 at 18:50 +0100, John Fawcett wrote:
>> 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 log doesn't reveal the cause.
> Know anything about SQL queries, John?  Here's the user query in
> question:
>
> user_query = SELECT maildir, 2000 AS uid, 2000 AS gid FROM mailbox
> WHERE username = '%u' AND active='1'
>
> I copied this directly from the tutorial I've been following and this
> is the first time I've seen this error.
>
Hi Ken

looks fine to me. However, mariadb is not accepting it. I suggest you 
run with auth_debug = yes and check the logs.

John



More information about the dovecot mailing list