sql lookups in sendmail

Berhanie · 01-09-2006, 12:26 PM

All I found regarding the topic is a (possibly dormant?) sendmail-sql project in Sourceforge and some talk about socketmap, whatever that is. Can anyone shed some light on the topic, namely, Is it possible for Sendmail to do SQL lookups?

Tinkster · 01-09-2006, 01:09 PM

Quote:

Originally Posted by Berhanie

All I found regarding the topic is a (possibly dormant?) sendmail-sql project in Sourceforge and some talk about socketmap, whatever that is. Can anyone shed some light on the topic, namely, Is it possible for Sendmail to do SQL lookups?

Can you please elaborate on what you mean exactly?

Cheers,
Tink

Berhanie · 01-09-2006, 01:40 PM

For example, one might do an SQL lookup for an alias, instead of querying a local hash table. Similarly, an SQL query might be used to determine whether or not an address is a valid recipient address.

Tinkster · 01-09-2006, 02:15 PM

http://blue-labs.org/software/sm-pgsql/

Does this satisfy your needs?

Cheers,
Tink

Berhanie · 01-09-2006, 04:20 PM

Yes, thank you, Tinkster. That's what I was looking for. Unfortunately, it's an old patch (for sendmail 8.12.7), like the one in SourceForge. Also, the recent sendmail on Gentoo doesn't support the smpgsql USE flag mentioned in the article, as far as I can see. I guess the SQL capability is still only available in disparate patches, and is not part of standard sendmail. Thank you for you input.

Tinkster · 01-09-2006, 04:34 PM

http://www.dbmail.org/index.php?page=overview

Does a bit more than you asked for, but ...

Cheers,
Tink

Berhanie · 01-09-2006, 06:23 PM

Interesting. This is mail storage in a database (a bit different from what I was asking about). Thanks for your interest and persistence.

Berhanie · 01-09-2006, 06:25 PM

What I'm really after is the Sendmail equivalent of this, if it exists.