On Fri, Jan 7, 2022 at 1:34 PM John Fawcett <[email protected]> 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'
