Thanks for all the messages that i recieved
> GRANT ALL PRIVILEGES ON mailserver.* TO markus@'domain.com > <mailto:markus@'domain.com> > <mailto:markus@'domain.com> ' IDENTIFIED BY The problem was that Markus was created on the wrong database 😊 But me old question still exist, if adding the alias to mar...@domain.com like "mae" the mail will only deliver to mae and not forwarded to mar...@domain.com SQL i see here this Alias visible. # SELECT goto FROM alias WHERE goto LIKE '%s%'; postmap -q <mailto:m...@domain.com> m...@domain.com mysql:/etc/postfix/mysql/mysql-virtual-alias-maps.cf <mailto:mar...@domain.com> mar...@domain.com please how i can set to forrwarding this? I think this will by also done on sql site? That the mail from: m...@domain.com <mailto:m...@domain.com> >> will be f orrwarded to mar...@domain.com <mailto:mar...@domain.com> Thanks -----Ursprüngliche Nachricht----- Von: Simon Hoffmann via Postfix-users <postfix-users@postfix.org> Gesendet: Dienstag, 30. Januar 2024 21:26 An: postfix-users@postfix.org Betreff: [pfx] Re: problem to add, alias failed Maurizio Caloro via Postfix-users wrote: > if adding a new user with postfixadmin 3.3.8 or with cli this will run > without problem. > > > > GRANT ALL PRIVILEGES ON mailserver.* TO <mailto:markus@'domain.com> > markus@'domain.com > < <mailto:markus@'domain.com> mailto:markus@'domain.com> ' IDENTIFIED BY > '***********************************'; you now have created a database (admin) user that has all privileges on your database with the username of markus. With the @domain part you have allowed that user to remotely connect to you database if the connection comes from a host with a hostname of domain.com (unless mariadb only listens on localhost for DB connections). Please use REVOKE to delete this user. To add a new entry to the accounts or alias table, use INSERT INTO mailserver.alias VALUES ... according to the DB layout. Since you are using postfixadmin, why are you not using the Web UI to add a new mailbox? > > > but if adding with postfixadmin any alias, this will bounce, with > following error > postfix/lmtp[102470]: 3E101208A1: to= < <mailto:mar...@domain.com> > mailto:mar...@domain.com> > <mailto:mar...@domain.com> mar...@domain.com, > relay=mail.domain.com[private/dovecot-lmtp], markus is not a mail user, as explained above. However, you just said that adding *any* alias you cannot receive email. Have you added the other aliases with the same way as above or have you actually used the postfixadmin web ui to add those aliases. If you have used the web ui, how does you main.cf look like? Simply adding > virtual_transport = lmtp:unix:private/dovecot-lmtp to the main.cf tells postfix to deliver mail to dovecot, but it neither tells postfix nor dovecot to connect to the database to look up if a user exists or not. Since you are talking about aliases, you need to tell postfix a way to query the database to get the target email addresses to actually send the email to, and dovecot needs to know if a target user exists in order to accept email. If you send the (relevant) contents of main.cf to the list someone might be able to point out a configuration error. For the correct config of dovecot please see the dovecot documentation or ask for help on a dovecot mailing list. Cheers, Simon _______________________________________________ Postfix-users mailing list -- <mailto:postfix-users@postfix.org> postfix-users@postfix.org To unsubscribe send an email to <mailto:postfix-users-le...@postfix.org> postfix-users-le...@postfix.org
_______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org
