mysql entry needed?

[Maurizio Caloro]

Hello

Installed Mysql on debian 10.9 and will ask you friendly to receive the 5
command to create this db on my mysql sever.

Please I don't know the command's and I don't found or see any nice example.

Postfix 3.4.14

 

virtual_mailbox_maps =               mysql:
/etc/postfix/mysql-virtual_mailbox_maps.cf

virtual_mailbox_domains =        mysql:
/etc/postfix/mysql-virtual_mailbox_domains.cf

virtual_alias_maps =                      mysql:
/etc/postfix/mysql-virtual_alias_maps.cf

smtpd_sender_login_maps =    mysql:
/etc/postfix/mysql-virtual_sender_permissions.cf

 

mysql-virtual_alias_maps.cf

                username, password, DBName, host

                SELECT goto FROM alias WHERE address = '%s'

 

mysql-virtual_gid_maps.cf

                username, password, DBName, host

                SELECT gid FROM mail_users WHERE email = '%s'

 

mysql-virtual_mailbox_domains.cf

                username, password, DBName, host

                SELECT domain FROM domain WHERE domain = '%s'

 

mysql-virtual_mailbox_maps.cf

                username, password, DBName, host

                SELECT username FROM mailbox WHERE username = '%s'

 

mysql-virtual_sender_permissions.cf

                username, password, DBName, host

                query = SELECT DISTINCT username FROM mail_users WHERE email
in ((SELECT mail_virtual.email_full FROM mail_virtual WHERE
mail_virtual.email = '%s' UNION SELECT mail_virtual.destination FROM
mail_virtual WHERE mail_virtual.email = '%s'));

 

thanks for possible update