How to blacklist a whole sender domain in postfix?

[Dehumanizer]

When I add "@domain.com" in the postfix blacklist configuration as a sender, it does not work, postfix is always searching the whole email in the database, the mysql query goes like this:
SELECT access FROM mail_access WHERE source='email@domain.com' and type = 'sender' and active = 'y' and server_id = 1

and of course if the record in the database is just @domain.com, the above query does not match it.

Is there any way how to completely blacklist the whole sender domain?

Thanks.

[Dehumanizer]

Nobody? Hmm...

[till]

Have you tried to add just "domain.com" and not "@domain.com"?

See Postfix access manpage:

http://www.postfix.org/access.5.html

[Dehumanizer]

Originally Posted by till

Have you tried to add just "domain.com" and not "@domain.com"?

See Postfix access manpage:

http://www.postfix.org/access.5.html

Yes, I tried domain.com and also .domain.com
The problem is that the SQL query always includes the complete email address so no matter what I have in the database it will not match that unless there is a match for complete email address.

[till]

Ok, then it might be that the other access blocking types are not supported for mysql based access lists. You can en e.g. try to add a second file based access list in postfix for that domain.

[Dehumanizer]

Strange, I don't know what I've done but it works now (without the leading @, just the domain name has to be in the blacklist to blacklist whole domain)... Well, whatever, at least the problem is solved. Thanks.