Hi:
I'm trying to set up a mysql table for: recipient_bcc_maps I've read this, repeatedly: http://www.postfix.org/postconf.5.html recipient_bcc_maps It doesn't really help me. I found this: https://groups.google.com/g/mailing.postfix.users/c/m6pvn2pytEI Apparently I can add this to main.cf: recipient_bcc_maps = mysql:/etc/postfix/recipient_bcc_maps.cf <http://recipient_bcc_maps.cf> I can't figure out what fields I need in the table or what the query should be. I don't know what variables are available for bcc or what postfix will look for. I don't know how to write the query. My virtual_users table has fields domain_id (a number from id in virtual_domains), email, password (SHA512-CRYPT encoded). I found this : SELECT concat(u.id,'@duplicator.localhost') FROM users u WHERE u.username='%u' AND u.domain='%d' AND u.active='1' and u.type=0 /* 0=mailbox; 1=forwarding */ limit 1; Which to me looks like this: SELECT email AS u FROM virtual_users WHERE email = %u If that email address exists in the virtual_users table this query would return the email address. If not it would return nothing. For virtual_users %u is the email of the user. In this case, I'm not sure what %u is. It appears to be the bcc email address. I don't see anything about what email address the bcc should be added to. I need to tell postfix the email address of the recipient whose emails I want to add a bcc to and then tell postfix what email address(s) to bcc. How can I do that?
