Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA84940; Wed, 22 Sep 1999 12:03:29 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.8/8.8.8) with ESMTP id SAA16880; Wed, 22 Sep 1999 18:03:26 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 22 Sep 1999 18:06:07 +0200 To: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org From: Herouth Maoz Subject: Re: [INTERFACES] Q: Mac: Openlink->Linux: Openlink-PostgreSQL At 09:12 +0200 on 22/09/1999, Jelle Ruttenberg wrote: > - password-file: PGDATA/pg_pwd > - users in the password-file: added with CREATE USER > - the passwords aren't encrypted > - connecting the database with 'psql -u' works > - OpenLink uses the generic database-agent for PostgreSQL (95?) to > connect to the database I am a bit on shaky ground here, but I think the frontend-backend protocol changed sometime between version 6.2 and 6.3. The specific change was in fact related to password authentication. (Gurus, correct me if I'm mistaken in this). The bottom line of all this is that if you want to use passwords, you have to have a frontend-backend agent/driver/module which is compatible with the new protocol. If you mentioned Postgre 95, it's probably an old, old agent. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma