Dec 29, 2023: iRedMail-1.6.8 has been released.

**srd2010** · 2017-10-30 23:50:00

srd2010
Member
Offline

Registered: 2013-08-06
Posts: 37

Topic: BCC Settings on Alias Domain

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Debian 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
====

Hi,

we've adapted a new Customer with multiple Domains.
We used one domain as Main Domain and added the others as Alias Domains.

Now, the customer wants the email for one regular user account to also be forwarded to another e-mail address, so we figured we just use BCC on incoming emails.

user@maindomain.net -> example@domain.com | OK
user@aliasdomain.com -> example@domain.com | NOT WORKING

This works for the Main Account, but sending an e-mail to the same account with an alias Domain, the mail is not forwarded, but both e-mails are received within the original account.

Is this a bug or how can we achieve that ?

Thanks,
Frank

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

**ZhangHuangbin** · 2017-10-31 13:18:05

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

BCC supports only one recipient, you should try mail forwarding instead.

**srd2010** · 2017-10-31 19:21:49

srd2010
Member
Offline

Registered: 2013-08-06
Posts: 37

Re: BCC Settings on Alias Domain

Hi Zhang,

maybe i did not explain it correctly.
It's only one receipient.

the account is user@maindomain.net" where the BCC incoming mail is set to example@domain.com

now, there are also alias domains to maindomain.net, for example: aliasdomain.com

so user will receive emails to his account to either address:
user@maindomain.net
user@aliasdomain.com

Now, the only thing not working is the BCC if the receiving email is one of the alias Domains, so a mail to:
user@maindomain.net -> example@domain.com | OK
user@aliasdomain.com -> example@domain.com | NOT WORKING

But both emails are delivered to the main account.

Hope explanation helps to understand the problem.

Thanks
Frank

**ZhangHuangbin** · 2017-11-06 21:51:07

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

Understand now. Seems Postfix BCC lookup doesn't query alias domain at all. I will try to fix it today.

**ZhangHuangbin** · 2017-11-06 22:06:33

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

Unfortunately, i cannot reproduce this issue. Could you please try commands below and paste me the output?

cd /etc/postfix/mysql/
for i in $(ls *bcc*); do echo $i; postmap -q 'user@aliasdomain.com' mysql:./$i; done

Please replace 'user@aliasdomain.com' by the real address in alias domain.

**srd2010** · 2017-11-11 23:24:23

srd2010
Member
Offline

Registered: 2013-08-06
Posts: 37

Re: BCC Settings on Alias Domain

MAIN DOMAIN:

for i in $(ls *bcc*); do echo $i; postmap -q 'user@maindomain.net' mysql:./$i; done
recipient_bcc_maps_domain.cf
recipient_bcc_maps_user.cf
BCCEMAIL@BCCDOMAIN.COM
sender_bcc_maps_domain.cf
sender_bcc_maps_user.cf

ALIAS DOMAIN:

for i in $(ls *bcc*); do echo $i; postmap -q 'user@aliasdomain.com' mysql:./$i; done
recipient_bcc_maps_domain.cf
recipient_bcc_maps_user.cf
sender_bcc_maps_domain.cf
sender_bcc_maps_user.cf

**ZhangHuangbin** · 2017-11-12 20:16:16

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

srd2010 wrote:

ALIAS DOMAIN:
for i in $(ls *bcc*); do echo $i; postmap -q 'user@aliasdomain.com' mysql:./$i; done
recipient_bcc_maps_domain.cf
recipient_bcc_maps_user.cf
sender_bcc_maps_domain.cf
sender_bcc_maps_user.cf

hmm, no bcc returned.

Could you please compare your /etc/postfix/mysql/*.cf with official config files first? Let's get rid of possible issues caused by custom SQL queries first.
https://bitbucket.org/zhb/iredmail/src/ … fix/mysql/

**srd2010** · 2017-11-16 17:48:47

srd2010
Member
Offline

Registered: 2013-08-06
Posts: 37

Re: BCC Settings on Alias Domain

There is a difference in File: virtual_alias_maps.cf

Our Query:
query = SELECT forwardings.forwarding FROM forwardings,domain WHERE forwardings.address='%s' AND forwardings.domain='%d' AND forwardings.domain=domain.domain AND forwardings.active=1 AND domain.backupmx=0 AND domain.active=1

Original Query:
query = SELECT forwardings.forwarding FROM forwardings,domain WHERE forwardings.address='%s' AND forwardings.domain=domain.domain AND forwardings.active=1 AND domain.backupmx=0 AND domain.active=1

We've changed the query to the orginal for testing purposes but no change in result.

**ZhangHuangbin** · 2017-11-17 12:24:29

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

Fixed. Please update the "query =" setting in 2 files:

File: /etc/postfix/mysql/recipient_bcc_maps_user.cf

query       = SELECT recipient_bcc_user.bcc_address
                FROM recipient_bcc_user,domain,alias_domain
               WHERE recipient_bcc_user.username='%s'
                     AND recipient_bcc_user.domain='%d'
                     AND ((recipient_bcc_user.domain=domain.domain)
                          OR (recipient_bcc_user.domain=alias_domain.alias_domain AND domain.domain = alias_domain.target_domain))
                     AND domain.backupmx=0
                     AND domain.active=1
                     AND recipient_bcc_user.active=1

File: /etc/postfix/mysql/sender_bcc_maps_user.cf

query       = SELECT sender_bcc_user.bcc_address
                FROM sender_bcc_user,domain,alias_domain
               WHERE sender_bcc_user.username='%s'
                     AND sender_bcc_user.domain='%d'
                     AND ((sender_bcc_user.domain=domain.domain)
                          OR (sender_bcc_user.domain=alias_domain.alias_domain AND domain.domain = alias_domain.target_domain))
                     AND domain.backupmx=0
                     AND domain.active=1
                     AND sender_bcc_user.active=1

Let me know whether it works for you.

**srd2010** · 2017-11-17 16:52:21

srd2010
Member
Offline

Registered: 2013-08-06
Posts: 37

Re: BCC Settings on Alias Domain

looking better for the ALIAS DOMAIN but now, for the Main Domain we get a massive amount of BCC Entries.

MAIN DOMAIN:
for i in $(ls *bcc*); do echo $i; postmap -q 'user@maindomain.net' mysql:./$i; done
recipient_bcc_maps_domain.cf
recipient_bcc_maps_user.cf
BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM,BCCEMAIL@BCCDOMAIN.COM
sender_bcc_maps_domain.cf
sender_bcc_maps_user.cf

ALIAS DOMAIN:
for i in $(ls *bcc*); do echo $i; postmap -q 'user@aliasdomain.com' mysql:./$i; done
recipient_bcc_maps_domain.cf
recipient_bcc_maps_user.cf
BCCEMAIL@BCCDOMAIN.COM
sender_bcc_maps_domain.cf
sender_bcc_maps_user.cf

This somehow doesn't feel correct. We changed back to old query.

**ZhangHuangbin** · 2017-11-18 10:40:23

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,785

Re: BCC Settings on Alias Domain

OK, try this:

See the new query condition like this?

                     AND ((sender_bcc_user.domain=domain.domain)
                          OR (sender_bcc_user.domain=alias_domain.alias_domain AND domain.domain = alias_domain.target_domain))

Try to improve it to make it right.

I will test it later these days, but how about giving it a try yourself to figure it out?

Dec 29, 2023: iRedMail-1.6.8 has been released.

BCC Settings on Alias Domain

Posts: 11

1 Topic by srd2010 2017-10-30 23:50:00 (edited by srd2010 2017-10-30 23:52:07)

Topic: BCC Settings on Alias Domain

2 Reply by ZhangHuangbin 2017-10-31 13:18:05

Re: BCC Settings on Alias Domain

3 Reply by srd2010 2017-10-31 19:21:49

Re: BCC Settings on Alias Domain

4 Reply by ZhangHuangbin 2017-11-06 21:51:07

Re: BCC Settings on Alias Domain

5 Reply by ZhangHuangbin 2017-11-06 22:06:33

Re: BCC Settings on Alias Domain

6 Reply by srd2010 2017-11-11 23:24:23 (edited by srd2010 2017-11-11 23:24:57)

Re: BCC Settings on Alias Domain

7 Reply by ZhangHuangbin 2017-11-12 20:16:16

Re: BCC Settings on Alias Domain

8 Reply by srd2010 2017-11-16 17:48:47

Re: BCC Settings on Alias Domain

9 Reply by ZhangHuangbin 2017-11-17 12:24:29

Re: BCC Settings on Alias Domain

10 Reply by srd2010 2017-11-17 16:52:21

Re: BCC Settings on Alias Domain

11 Reply by ZhangHuangbin 2017-11-18 10:40:23

Re: BCC Settings on Alias Domain

Posts: 11