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'