0
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\ ROM users WHERE userid = 'test@mydomain.eu' and mysql_pass = password('psw' at line 1.
Here my config:
driver = mysql connect = "host=127.0.0.1 dbname=dbname user=userdb password=psw" default_pass_scheme = SHA512-CRYPT
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user \ FROM users $
user_query = SELECT username AS user, domain, password FROM accounts WHERE username = '%n$
iterate_query = SELECT username, domain FROM accounts where sendonly = false;
My setup: I have installed mariadb, dovecot, postfix, postfixadmin.
When I create an email account with postfixadmin and use the same database with dovecot, I got the error. What am I doing wrong?
I'm not very experienced. If you need more informations, please ask.