Re: milter requirement [socket map for FEATURE(`ldap_routing')]

Res <res@xxxxxxxxxx> wrote:

Anyone know of an existing milter that will query a MySQL database for
a user@name and accept/reject? wanna see if we can eliminate milter
that has to ask an internal server (which then has to ask sql), cut
out the middle man , so to speak :)

I would suggest you customizing MIMEDefang.org milter (GPL licensed).
Mimedefang filtering script is written in perl so adding SQL queries via
perl DBI should be doable and relatively simple.

-------------------------------------------------------------------------

I would suggest using FEATURE(`ldap_routing') with socket map(s) used
instead of default LDAP queries. It will allow you "easy switch" to
classic ldap_routing based on LDAP.


MIMEDefang can serve socket maps. As I understand you need to define
filter_map function in your mimedefang filtering script.
It will be called as below:

my ($code, $value) = filter_map($map_name, $lookup_key);

List of valid codes:
"OK" value for key found and passwd in $value
"NOTFOUND" value for key not found
"TEMP" temporary problem with lookup
"TIMEOUT" lookup timeout
"PERM" permanent problem with lookup

List of map_names used by ldap_routing:
"ldapmh" (mh -> mail host)
"ldapmra" (mra -> mail routing address)

P.S.
Would you like to be insulted with more detailed advises? ;-)


URL(s):
http://www.mimedefang.org/
http://www.sendmail.org/m4/ldap_routing.html

--
[pl>en Andrew] Andrzej Adam Filip : anfi@xxxxxxx : anfi@xxxxxxxx
Be wary of strong drink. It can make you shoot at tax collectors and miss.
-- Lazarus Long, "Time Enough for Love"
.

Relevant Pages

  • Re: Using criteria in select query for recoding of variables
    ... find a way without the lookup table. ... The greatest book is probably the query designer, at least, for start. ... You can take a look at the generated SQL. ... or Skill, is a field, and if a table is a junction table, it is often made ...
    (microsoft.public.access.queries)
  • Re: map / class lookup from milter
    ... to lookup into sendmail internal data from inside ... any milter, including mimedefang. ... conceptually, sendmail already have read the whole class, and stores ... With maps, a lookup from milter isn't so big deal, as sendmail ...
    (comp.mail.sendmail)
  • Re: Using criteria in select query for recoding of variables
    ... "Michel Walsh" wrote: ... I will try it as a means of learning about lookup applications. ... It will be my first time using a sql ... In other words your Tobe field is exactly ...
    (microsoft.public.access.queries)
  • Re: access project question
    ... you need to ALWAYS first test your queries in the SQL ... LOOKUP in my SQL server backend. ...
    (comp.databases.ms-access)
  • Re: DTS Lookup in DDQ failing on datetime comparison
    ... I changed my Lookup SQL ... SELECT CatID ... I have a Data Driven Query task including a lookup. ... It's not a problem with Update query, ...
    (microsoft.public.sqlserver.dts)
Loading