> Hi list, > > I need to setup recipient_bcc_maps to get the following behaviour: > - by default, I need every message to be BBC'd to > [email protected] > - for particular recipients, I need the message to be BCC'd to > [email protected] (and to this address only) > > - I need particular recipients to be stored in mysql, because of > integration with other apps > > How should I get this? > My first solution is: > > recipient_bcc_maps = mysql:/etc/postfix/recipient_bcc_maps.cf, > regexp:/etc/postfix/recipient_bcc_maps.regexp > > /etc/postfix/recipient_bcc_maps.regexp: > /^.*$/ [email protected] > > The idea is: I look for "special" recipient addresses in mysql first > and fallback to the regexp in case of non-match only. > > Is this going to work? > If not, would you please point me to the relevant documentation? > > Thanks, > Fabio >
You may use something like this: bcc_table: address | enabled <empty_string> | 1 [email protected] | 1 SELECT case when `enabled` then '[email protected]' else '[email protected]' end FROM `bcc_table` where `address` in ('%s','') order by `address` desc limit 1; It's not perfect - just pointing into possible mysql solution whithout extra lookup table. You may also consider using WHERE clause with user_part= '%u' and domain='%d'. Regards V.Dimitrov
