Re: ODBC and crypted passwords - Mailing list pgsql-interfaces

From Alex Verstak
Subject Re: ODBC and crypted passwords
Date
Msg-id 200004092022.QAA09151@averstak.campus.vt.edu
Whole thread Raw
In response to Re: ODBC and crypted passwords  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ODBC and crypted passwords  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-interfaces
Tom Lane wrote:
> Hmm.  Can we find a freely-distributable version of libcrypt anywhere?
> 
> (Actually, now that I think about it, I'm not entirely sure that crypt()
> implements exactly the same transformation on every Unix platform.
> It may be that you have to have a version of crypt() that matches the
> one on your server's platform.  That would be a pain in the neck ...
> but if we did find an open-source libcrypt, maybe we could standardize
> on using it in preference to vendor crypts...)
 I have no problem running the PostgreSQL server on Solaris and using a FreeBSD client with crypt authentication.  Both
systemsuse DES.  Problems arise when systems try to work around the US export restrictions and supply MD5 or other weak
encryption. For the same reason, you cannot make strong authentication code available on your website.  The best you
cando is provide a pointer to some DES implementation outside the US and instruct users to download and use this one if
theirsystems do not work together.  Another alternative is to include MD5 in the distribution, but use the system crypt
bydefault, with a configuration option to switch to MD5.  =alex
 


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: ODBC and crypted passwords
Next
From: Stephen Davies
Date:
Subject: Re: ODBC and crypted passwords