pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Paul Roberts <paul.roberts@trinity-bris.ac.uk>
To: Byron Nikolaidis <byronn@insightdist.com>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] M$oft Win95, ODBC and 'crypt-ed' Passwords
Date: Mon, 08 Jun 1998 08:35:31 +0100
Message-ID: <357B9443.376EFE16@trinity-bris.ac.uk> (raw)
References: <3574FDE7.20B5DBF0@trinity-bris.ac.uk>
	<35783177.4C039AF9@insightdist.com>

Byron Nikolaidis wrote:

> Paul Roberts wrote:
>
> > ODBC is working fine.  However, I'm none-too-keen on routinely sending
> > unencrypted passwords over the Internet link between the different sites
> > at the moment of connection.
> >
> > It also offers crypt / decrypt, which UN&X/Linux could offer, but is
> > there a M$ en-crypting solution?
> >
>
> Currently, the odbc driver can't handle the encrypting passwords option of
> authentication.
> When the request comes back from postgres to encrypt the password with the
> "salt", the driver will just error out, saying that authentication type is
> not supported.  Same for kerberos 4/5 authentication.
>
> I hope to add encrypted passwords someday.
>
> I noticed the jdbc driver has some encryption algorithm built in.  Can
> someone please elaborate on that, like where did you get it, or did you
> write it, etc??

OK, that's fine.  I gather what you have in mind is that the driver would do
the crypting - neat!

BTW the driver is great!  As a complete newbie in both postgreSQL and ODBC
terms, I got it up with no pain.  (The only glitch was needing to run
postmaster with -i, which subsequently looking at this list seems to be an old
chestnut.)

Paul




view thread (3+ messages)

Message-ID: <357B9443.376EFE16@trinity-bris.ac.uk>
Permalink:  ../357B9443.376EFE16@trinity-bris.ac.uk/
Also on:    postgresql.org/message-id/357B9443.376EFE16@trinity-bris.ac.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: paul.roberts@trinity-bris.ac.uk, byronn@insightdist.com
  Subject: Re: [INTERFACES] M$oft Win95, ODBC and 'crypt-ed' Passwords
  In-Reply-To: <357B9443.376EFE16@trinity-bris.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox