Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA27077 for ; Fri, 5 Jun 1998 14:24:45 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA00822 for pgsql-interfaces@postgreSQL.org; Fri, 5 Jun 1998 14:05:03 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA36866; Fri, 5 Jun 1998 13:58:24 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA41224; Fri, 5 Jun 1998 13:58:24 -0400 Message-Id: <35783177.4C039AF9@insightdist.com> Date: Fri, 05 Jun 1998 13:57:11 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Paul Roberts Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] M$oft Win95, ODBC and 'crypt-ed' Passwords References: <3574FDE7.20B5DBF0@trinity-bris.ac.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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?? Byron