How to make dovecot access a MySQL database with a certain domain?

[Tobi]

The @localhost part is correct if you connecting to mysql at 127.0.0.1. It's the rdns of the connecting client. 
Are you sure that the user postfix has access rights to postfix database? Can you connect on cli using something like
mysql -upostfix -ppostfix postfix 
?


Am 28. November 2017 19:08:12 MEZ schrieb Spike98 <spike98 at protonmail.com>:
>I am trying to make a mail server with Postfix using the Dovecot
>software. At the time of wanting to access my server from a mail
>client, it does not let me access and see the logs of my server with
>the command:
>
>    $ service dovecot status
>with the following error:
>
>dovecot: auth-worker(2769): Error: mysql(127.0.0.1): Connect failed to
>database (postfix): Access denied for user 'postfix'@'localhost' (using
>password: YES) - waiting for 125 seconds before retry
>
>From what I understand of this error is that it is trying to enter
>'postfix' @ 'localhost' instead of the domain that I specify when I
>made the database that is mydomain.com
>
>How can you make dovecot go to MySQL with postfix at mydomain.com instead
>of localhost
>
>This is my Dovecot configuration
>
>/etc/dovecot/dovecot-sql.conf.ext
>
>    driver=mysql
>
>    default_pass_scheme=PLAIN-MD5
>
>    connect=host=127.0.0.1 dbname=postfix user=postfix password=postfix
>
>password_query=SELECT username,domain,password FROM usuarios WHERE
>username='%n' AND domain='%d'
>
>user_query=SELECT 1007 as uid, 1007 as gid,
>concat("maildir:/var/vmail",domain,'/',username,'/') as mail FROM
>usuarios WHERE username='%n' AND domain='%d'
>
>    iterate_query=SELECT username,domain FROM usuarios

-- 
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.