TLS connection closed unexpectedly

[Mark Moseley]

On Fri, Jan 7, 2022 at 1:34 PM John Fawcett <john at voipsupport.it> wrote:

> 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.
>
>

Does it help at all if you use backticks around the column names for uid
and gid? I.e.

from:
user_query = SELECT maildir, 2000 AS uid, 2000 AS gid FROM mailbox WHERE
username = '%u' AND active='1'

to:
user_query = SELECT maildir, 2000 AS `uid`, 2000 AS `gid` FROM mailbox
WHERE username = '%u' AND active='1'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20220107/4a6b8235/attachment.htm>