using postgresql | sasl mailbox database for sendmail delivery?

[Andrew Koros]

Have you considerd using pam_pgsql and libnss_pgsql?
Check the following sites  
http://blue-labs.org/clue/NSS_pgsql.php
http://libpam-pgsql.codecastle.com

Otherwise there is a postfix patch for postgreSQL lookups with stored
procedure support here:http://www.rhyme.com.au/postfix.html

And if Platform did not matter I wrote a howto for RedHat Linux here:
http://home.teleport.ch/simix/RPMS/Cyrus-imapd/contrib/Postfix+cyrus+postgreSQL+web-cyradm.pdf

Andrew Koros.

On Fri, 2003-03-28 at 05:02, Palle Girgensohn wrote:
> Hi,
> 
> How can I get sendmail to use my sasl database as its mailbox database. 
> There is a note about this in the code and man page for mail.local (-D 
> mbdb) but it seems I have to patch sendmail to use anything but /etc/passwd 
> or possibly LDAP?
> 
> Ideally, what I would like is to keep all users in postgresql and 
> authenticate and edeliver based on lookups to this database. I have an 
> existsing web application that has a user database, and I want to offer 
> email account to these users. The users already have md5 encrypted 
> passwords in a table (created using FreeBSD's crypt(3)), and the ultimate 
> experience would to be able to use these passwords for authentication. 
> Perhaps this is too much; creating a new password would be OK.
> 
> The problem, as I see it, is two-fold:
> 
> 1. get sendmail to deliver to userids thar are *not* in either /etc/passwd 
> nor LDAP, but in some other database, preferrably (but not neccesarily) 
> postgresql. I would consider dumping sendmail for postfix if it has a 
> turn-key solution for this.
> 
> 2. get cyrus to authenticate users with that same database.
> 
> 
> 1 might be accomplished using mail.local -D pgsql or similar, but I would 
> have to write the code from scratch. Unfortunately, there is no time for 
> that...
> 
> 2, well there is a pam module, or I guess it would be easy to modify the 
> sasl mysql module for postgres...
> 
> I use FreeBSD 4.8 (well, almost) w/ sendmail 8.12.8. the cyrus imapd & sasl 
> would both be 2.1.12.
> 
> Any tips/ideas?
> 
> Thanks in advance,
> Palle
-- 
Andrew Koros
Developer, Systems Services
UUNET (Kenya) Ltd
http://www.uunet.co.ke
Tel: +254 2 69088618
Fax: +254 2 69088001
Email: akoros at ke.uu.net   


NOTICE: This e-mail message and all attachments transmitted with it may
contain legally privileged and confidential information intended solely
for the use of the addressee. If the reader of this message is not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or
its attachments is strictly prohibited. If you have received this
message in error, please notify the sender immediately by electronic
mail, and delete this message and all copies and backups thereof. Thank
you.