Thread: pop3 server and Postgresql

Does anyone know of a POP3 server that can use a Postgresql DB to
authenticate usernames & passwords ?

Thanks

Steve

--
thorNET  - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax:   01454 854412
http://www.thornet.co.uk

On 10 Oct 2001, Steve Heaven wrote:

> Does anyone know of a POP3 server that can use a Postgresql DB to
> authenticate usernames & passwords ?

No.

Alternatives:

   - extract the information from the PostgreSQL DB hourly/daily/whatever
     and populate the POP server private authentification database

   - if the POP server supports PAM, and if someone has written a
     PG module for it, it should be possible.

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

> > Does anyone know of a POP3 server that can use a Postgresql DB to
> > authenticate usernames & passwords ?

  vpopmail has support for it.  Combine it with qmail, and you've got a
very serious mail server.   vpopmail has a bunch of other nifty features
that make it very desirable as a pop3 server, as well.

http://www.inter7.com/vpopmail/features.html

steve

There are modules to do that for Cyrus. It would not be very complex to
implement postgresql access in pretty much any pop server that supports
pluggable authentication modules.

Of course, its another subject whether you _want_ to do this. Like it or
not, email requires 24/7 availability. Database itself will provide less
than that. I suggest you don't rely on database direct but extract data
every so often from it into a file.

-alex

On Fri, 12 Oct 2001, Marc SCHAEFER wrote:

> On 10 Oct 2001, Steve Heaven wrote:
>
> > Does anyone know of a POP3 server that can use a Postgresql DB to
> > authenticate usernames & passwords ?
>
> No.
>
> Alternatives:
>
>    - extract the information from the PostgreSQL DB hourly/daily/whatever
>      and populate the POP server private authentification database
>
>    - if the POP server supports PAM, and if someone has written a
>      PG module for it, it should be possible.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>