On Fri, Jan 7, 2022 at 1:34 PM John Fawcett john@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'