Thread

1. pop3 server and Postgresql

   Steve Heaven <steve@thornet.co.uk> — 2001-10-10T10:53:21Z

   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
   
   

2. Re: pop3 server and Postgresql

   Marc SCHAEFER <schaefer@alphanet.ch> — 2001-10-12T20:17:19Z

   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.
   
   
   
   
   
   

3. Re: pop3 server and Postgresql

   Steve Wolfe <steve@iboats.com> — 2001-10-12T22:01:02Z

   > > 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
   
   
   
   

4. Re: pop3 server and Postgresql

   Palle Girgensohn <girgen@partitur.se> — 2001-10-12T23:02:38Z

   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
   
   

5. Re: pop3 server and Postgresql

   Alex Pilosov <alex@pilosoft.com> — 2001-10-12T23:03:08Z

   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
   > 
   >