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

[Roger Klorese]

Replace 127.0.0.1 with the domain name.
On Tue, Nov 28, 2017 at 10:08 AM Spike98 <spike98 at protonmail.com> wrote:

> 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