Обсуждение: md5 password encryption?
Hi, how can I use md5 password encryption? FAQ 3.4 just states that it will work but it doesn't explain how it is used. Server PostgreSQL 9.5 on UBUNTU 16.04.1 with the standard installation. postgresql.conf has SSL=ON so I expect it to work? :} Client is Access 2013 with psqlODBC 9.5.400. So I'd like to use an ADODB-Connection with VBA. I can allready connect with plaintext PW. Now I'like to add a bit of extra security by using encrypted login. Regards Andreas
On 11/09/2016 10:59 AM, Andreas wrote: > Hi, > > how can I use md5 password encryption? > FAQ 3.4 just states that it will work but it doesn't explain how it is > used. Because that behavior is determined by pg_hba.conf: https://www.postgresql.org/docs/9.5/static/auth-pg-hba-conf.html See: "auth-method md5 Require the client to supply a double-MD5-hashed password for authentication. See Section 19.3.2 for details." > > Server PostgreSQL 9.5 on UBUNTU 16.04.1 with the standard installation. > postgresql.conf has SSL=ON so I expect it to work? :} Has nothing to do with SSL. > > Client is Access 2013 with psqlODBC 9.5.400. > So I'd like to use an ADODB-Connection with VBA. > I can allready connect with plaintext PW. Now I'like to add a bit of > extra security by using encrypted login. I am suspect you may already be using md5. It still means you supply a plain text password on the client end, just that it encrypts it before sending across the wire. > > > Regards > Andreas > > -- Adrian Klaver adrian.klaver@aklaver.com