So, following problem. I'm trying to setup a Mailserver loosely following this tutorial here: https://workaround.org/ispmail/wheezy/
The problem starts when I try to send my first testmail (inside the system), I get the following:
postfix/pickup: F34B965841CF: uid=1000 from=<webmaster> postfix/cleanup: F34B965841CF: message-id=20160519164815.F34B965841CF@mysite.com> postfix/qmgr: F34B965841CF: from=<email@example.com>, size=398, nrcpt=1 (queue active) dovecot: auth-worker(15911): Warning: mysql: Query failed, retrying: 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 '@example.org.' at line 1 dovecot: auth-worker(15911): Error: sql(firstname.lastname@example.org): 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 '@example.org.' at line 1 dovecot: lda: Error: user email@example.com: Auth USER lookup failed dovecot: lda: Fatal: Internal error occurred. Refer to server log for more information. postfix/pipe: F34B965841CF: to=<firstname.lastname@example.org>, relay=dovecot, delay=0.02, delays=0.01/0/0/0.02, dsn=4.3.0, status=deferred (temporary failure)
Thing is, earlier in the Tutorial, you're supposed to manually try if your sql queries work with
postmap -q example.org mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
and so on. And for me, it does work. No problem at all.
My files look pretty much exactly like in the tutorial
user = mailuser password = <pw> hosts = mailserver query = SELECT 1 FROM virtual_domains WHERE name='%s'
user = mailuser password = <pw> hosts = mailserver query = SELECT destination FROM virtual_aliases WHERE source='%s'
and so on. Anyone ever encounter this before? Any solutions or ideas?