[Exim] partial- type lookups for SQL?

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Larry Rosenman
日付:  
To: exim-users
題目: [Exim] partial- type lookups for SQL?
--
I'm looking to make a SQL based Domain type blacklist for those that
have managed to really piss me off.

I had a list in my Sendmail Access File, and would like to convert it
to a PostgreSQL DB with a table structure containing at least the following:

domain text,
message text

What I want to be able to do is match the sender (From: and envelope, and
the host names) and match even if the host part of the domain is different,
I.E:

domain='bad.domain.com'

I want to be able to match host222.bad.domain.com as well as just
bad.domain.com.

Anyone have any hints, suggestions examples, etc?

The partial- type queries look to be what I want, but they don't (based on
my read of the docs) work with SQL type queries.

Thanks!

LER


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@???
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
--
[ Content of type application/pgp-signature deleted ]
--