milter requirment

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


--
Cheers
Res

"The hopes we had, were much to high, way out of reach, but we have to
try, no need to hide, no need to run, cause all the answers come one by
one. The game will never be over, because we're keeping the dream alive"
-Freiheit

Res <res@ausics.net> 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@onet.eu : anfi@xl.wp.pl
Be wary of strong drink. It can make you shoot at tax collectors and miss.
-- Lazarus Long, "Time Enough for Love"

On Aug 31, 11:17 am, Andrzej Adam Filip <a...@onet.eu> wrote:
> P.S.
> Would you like to be insulted with more detailed advises? ;-)
>
Andrzej,

With answers like this, I'd love to be insulted on my
questions!

Tuc

On Sun, 31 Aug 2008, Andrzej Adam Filip wrote:

> The following message is a courtesy copy of an article
> that has been posted to comp.mail.sendmail as well.
>
> 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.


Trying to avoid all that, to do it your way we might as well leave our
sendmail front-ends using smf-sav talking to the backend qmail/vpopmail
stuff, because we would be just re-inventing a variant of the same wheel.

We are about to undertake large operation in upgrading hardware and then
move the prime mail server network to postfix since it has native MySQL
support and Claus has said thats not planned for sendmail, and as postfix
can take advantage of Dovecots LDA, it will be far simpler and less messy
and better redundancy then our existing setup, and the qmail routing boxes
in the middle wont be needed, so they can be used as extra webmail or
whatever


--
Cheers
Res

"The hopes we had, were much to high, way out of reach, but we have to
try, no need to hide, no need to run, cause all the answers come one by
one. The game will never be over, because we're keeping the dream alive"
-Freiheit

Res <res@ausics.net> wrote:
> [...]
> We are about to undertake large operation in upgrading hardware and
> then move the prime mail server network to postfix since it has native
> MySQL
> support and Claus has said thats not planned for sendmail, and as
> postfix can take advantage of Dovecots LDA, it will be far simpler and
> less messy and better redundancy then our existing setup, and the
> qmail routing boxes in the middle wont be needed, so they can be used
> as extra webmail or whatever

For my curiosity: Have you tried to make MySQL support natively socket
map protocol? :-) [yourself or by asking MySQL developers]

P.S.
I am under impression that I have achieved convincing Cyrus IMAP
developers to support socket map before it left sendmail's betas.

--
[pl>en Andrew] Andrzej Adam Filip : anfi@onet.eu : anfi@xl.wp.pl
"I have to convince you, or at least snow you ..."
-- Prof. Romas Aleliunas, CS 435