poqdavid there seems to be seomething wrong, it should look like this:
Did you replace the XXXXXXXXXXXXXXXXXXX with your DQS key?
EnglishNeed help setting up Spamhaus
- Edited
DocFraggle Oh yes it looks like that for the Data Query Service Test with the key but it’s all red for Public Mirrors Test
and I am not sure if that’s normal or not
2 months later
- Edited
I have the same issue as poqdavid. I think there is a misunterstading cause there a two Test you can run. One is named “Data Query Service Test” and the other “Public Mirrors Test”.
With the manual changes which DocFraggle mentions the “Data Query Service Test” indeed flips to green. But the result of the “Public Mirrors Test” does not change. I think here is another postfix config needed.
I think i found a soultion.
i added this block to my extra.cf:
reject_rbl_client zen.spamhaus.org=127.0.0.[2..11],
reject_rhsbl_sender dbl.spamhaus.org=127.0.1.[2..99],
reject_rhsbl_helo dbl.spamhaus.org=127.0.1.[2..99],
reject_rhsbl_reverse_client dbl.spamhaus.org=127.0.1.[2..99],
warn_if_reject reject_rbl_client zen.spamhaus.org=127.255.255.[1..255],So my full extra.cf looks like this:
myhostname = myhostname
smtpd_recipient_restrictions = check_recipient_mx_access proxy:mysql:/opt/postfix/conf/sql/mysql_mbr_access_maps.cf,
permit_sasl_authenticated,
permit_mynetworks,
check_recipient_access proxy:mysql:/opt/postfix/conf/sql/mysql_tls_enforce_in_policy.cf,
reject_invalid_helo_hostname,
reject_unauth_destination,
reject_rbl_client zen.spamhaus.org=127.0.0.[2..11],
reject_rhsbl_sender dbl.spamhaus.org=127.0.1.[2..99],
reject_rhsbl_helo dbl.spamhaus.org=127.0.1.[2..99],
reject_rhsbl_reverse_client dbl.spamhaus.org=127.0.1.[2..99],
warn_if_reject reject_rbl_client zen.spamhaus.org=127.255.255.[1..255],
reject_rhsbl_sender XXXXXXXXXXXXXXX.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_helo XXXXXXXXXXXXXXX.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_reverse_client XXXXXXXXXXXXXXX.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_sender XXXXXXXXXXXXXXX.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rhsbl_helo XXXXXXXXXXXXXXX.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rhsbl_reverse_client XXXXXXXXXXXXXXX.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rbl_client XXXXXXXXXXXXXXX.zen.dq.spamhaus.net=127.0.0.[2..255]
rbl_reply_maps = hash:/opt/postfix/conf/dnsbl-reply-map@[deleted] Hope it helps
@[deleted] is this okay or this the “wrong” approach and should be configured somewhere else?
2 months later
is this still a thing?
im on version 2023-11a, il added my dqs key (mailcow.conf) and run the test
dnsbl_reply.map
xxx.sbl.dq.spamhaus.net sbl.spamhaus.org
xxx.xbl.dq.spamhaus.net xbl.spamhaus.org
xxx.pbl.dq.spamhaus.net pbl.spamhaus.org
xxx.zen.dq.spamhaus.net zen.spamhaus.org
xxx.dbl.dq.spamhaus.net dbl.spamhaus.org
xxx.zrd.dq.spamhaus.net zrd.spamhaus.org
did i missed/forgot something?
@esackbauer @DocFraggle any hint for me? would be nice <3
Did you have a look at my workaround? 
Spamhaus Config mailcow community
It’s in German, but you’ll get what I’m doing there
- Edited
yes, hmm still necessary i guess? :/
so simply copy/paste this part (add personal key instead of xxx) in extra.cf and restart
okay, this fixed it. the dnsbl reply map file name changed to dnsbl_reply.map
if someone also wants to adjust the current version, please pay attention. you can also see the logs (error) if you check them 
@[deleted] danke dir! 
btw. is the bug known to the mailcow team (must confess, I haven’t searched the bugtracker)
fyi:
log was showing
error: open database /opt/postfix/conf/dnsbl_reply.map.db: No such file or directory
postmap /opt/postfix/conf/dnsbl_reply.map (in Container)
need to run afterwards to create the db
KaiserN yes, I wrote that in my workaround
4 days later
looks like since postfix restarted by itself the following showed up in the log file, just a warning so no problem.
warning: database /opt/postfix/conf/dnsbl_reply.map.db is older than source file /opt/postfix/conf/dnsbl_reply.map
did u fixed it somehow? or just ignore and hope it will be fixed if mailcow fixed the spamhaus setup routine?
KaiserN did u fixed it somehow?
No, I didn’t even notice that yet 
I’m confused, it seems I myself added the dnsbl_reply file to Mailcow with this Commit 
mailcow/mailcow-dockerized9f39af4
So the only thing missing is creating the postmap file while/after deploying the container
ohh shiiiiit. il fucked up the file name in postmap guess… il added the .map to the end somehow
recreated, now i got
dnsbl_reply
dnsbl_reply.db
dnsbl_reply.map
- Edited
I added the .map file extension in my workaround above before I created the PR, so I guess you copied it from there 
KaiserN OK, there is a slight misunderstanding concerning the files
the dns_reply.map file is created while starting the Postfix container:
mailcow/mailcow-dockerizedblob/master/data/Dockerfiles/postfix/postfix.sh#L441-L449
It just contains the “normal” DQS config, which leads to not all tests being green.
In my workaround, I created an extra file named “dnsbl-reply-map ” (should use another name…) which contains the extra config:
XXXXXXXXXXXXXXXXXXXXX.sbl.dq.spamhaus.net=127.0.0.[2..255] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using sbl.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.xbl.dq.spamhaus.net=127.0.0.[2..255] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using xbl.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.pbl.dq.spamhaus.net=127.0.0.[2..255] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using pbl.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.sbl-xbl.dq.spamhaus.net=127.0.0.[2..255] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using sbl-xbl.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.zen.dq.spamhaus.net=127.0.0.[2..255] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using zen.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.dbl.dq.spamhaus.net=127.0.1.[2..99] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using dbl.spamhaus.org${rbl_reason?; $rbl_reason}
XXXXXXXXXXXXXXXXXXXXX.zrd.dq.spamhaus.net=127.0.2.[2..24] $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using zrd.spamhaus.org${rbl_reason?; $rbl_reason}This file has to be hashed with the posthash command before starting postfix AND it has to be referenced in the config via
rbl_reply_maps = hash:/opt/postfix/conf/dnsbl-reply-map
I just don’t have the time currently to implement it properly
6 months later
The solution is: add the DQOS key to mailcow.conf, then create an extra.cf under /data/conf/postfix and add the following content there:
smtpd_recipient_restrictions =
reject_rhsbl_sender xxxxxxx.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_helo xxxxxxx.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_reverse_client xxxxxxx.dbl.dq.spamhaus.net=127.0.1.[2..99],
reject_rhsbl_sender xxxxxxx.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rhsbl_helo xxxxxxx.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rhsbl_reverse_client xxxxxxx.zrd.dq.spamhaus.net=127.0.2.[2..24],
reject_rbl_client xxxxxxx.zen.dq.spamhaus.net=127.0.0.[2..255]
Sorry for my bad English
4 months later
Do we have an official solution to this problem?
Are there any plans?
I find it strange that you have to add something to /extra.conf which does not contain the same names as those shown in the image.
Do you have any solutions?
No one is typing