Re: pop3 server and Postgresql

Palle Girgensohn <girgen@partitur.se>

From: Palle Girgensohn <girgen@partitur.se>
To: Steve Heaven <steve@thornet.co.uk>
Cc: pgsql-general@postgresql.org
Date: 2001-10-12T23:02:38Z
Lists: pgsql-general
On 10 Oct 2001, Steve Heaven wrote:
> Does anyone know of a POP3 server that can use a Postgresql DB to
> authenticate usernames & passwords ?

The cyrus mail server has an authentication scheme whereby one
can very easily plug in different ways of authenticating users.
It is really cyrus sasl that does the authentication work, and
it can be configured for PAM, or for the nifty pwcheck program
that can easily be modified to query a postgres database.

Probably, PAM is safer:

pam_pgsql:
http://freshmeat.net/projects/pam_pgsql/download

sasl:
http://asg.web.cmu.edu/sasl/

cyrus mail server:
http://asg.web.cmu.edu/cyrus/

BTW, the cyrus server is *very* competent, and supports imap et
al as well. Warmly recommended.

Cheers,
Palle