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 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>
> 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 -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org

Reply via email to