From loic@ext.cri74.org Wed May 31 09:53:30 2000 Received: from aravis.cur-archamps.fr (aravis.cur-archamps.fr [195.202.0.99]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA86532 for ; Wed, 31 May 2000 05:53:30 -0400 (EDT) (envelope-from loic@ext.cri74.org) Received: from pc01.cri.cur-archamps.fr (pc01.cri.cur-archamps.fr [10.10.10.2]) by aravis.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id LAA01753 for ; Wed, 31 May 2000 11:52:57 +0200 Received: from ext.cri74.org (localhost [127.0.0.1]) by pc01.cri.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id LAA27666 for ; Wed, 31 May 2000 11:52:57 +0200 Message-ID: <3934E0F9.F8B13881@ext.cri74.org> Date: Wed, 31 May 2000 11:52:57 +0200 From: =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: fr-FR, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pgaccess use wrong password Content-Type: multipart/alternative; boundary="------------4DEEB441D7DB68BF3AC38F0E" X-Archive-Number: 200005/52 --------------4DEEB441D7DB68BF3AC38F0E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Excuse me for the latest message , i've found the solution local all password passwdfile Now , passwords are stored (and crypted) in passwdfile . The authentication with psql is ok But pgaccess still use the password in clear in pg_shadow . Is there an option , i've not set correctly ? thanks loic@ext.cri74.org --------------4DEEB441D7DB68BF3AC38F0E Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit        Excuse me for the latest message , i've found the solution

local    all    password    passwdfile

Now , passwords are stored (and crypted) in passwdfile .
The authentication with psql is ok

But pgaccess still use the password in clear in pg_shadow . Is there an option , i've not set correctly ?
 

        thanks

                                                                                    loic@ext.cri74.org --------------4DEEB441D7DB68BF3AC38F0E-- From e99re41@DoCS.UU.SE Wed May 31 11:28:54 2000 Received: from meryl.it.uu.se (root@meryl.it.uu.se [130.238.12.42]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA78219 for ; Wed, 31 May 2000 07:28:54 -0400 (EDT) (envelope-from e99re41@DoCS.UU.SE) Received: from Gepard.DoCS.UU.SE (e99re41@Gepard.DoCS.UU.SE [130.238.9.100]) by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id NAA05980; Wed, 31 May 2000 13:28:50 +0200 (MET DST) Received: from localhost (e99re41@localhost) by Gepard.DoCS.UU.SE (8.6.12/8.6.12) with ESMTP id NAA00867; Wed, 31 May 2000 13:28:48 +0200 X-Authentication-Warning: Gepard.DoCS.UU.SE: e99re41 owned process doing -bs Date: Wed, 31 May 2000 13:28:47 +0200 (MET DST) From: Peter Eisentraut Reply-To: Peter Eisentraut To: =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= cc: pgsql-admin@postgresql.org Subject: Re: pgaccess use wrong password In-Reply-To: <3934E0F9.F8B13881@ext.cri74.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id HAA78226 X-Archive-Number: 200006/14 On Wed, 31 May 2000, Loïc TREGOUËT wrote: > Excuse me for the latest message , i've found the solution > > local all password passwdfile > > Now , passwords are stored (and crypted) in passwdfile . > The authentication with psql is ok > > But pgaccess still use the password in clear in pg_shadow . Is there an > option , i've not set correctly ? Perhaps pgaccess is not connecting via `local', but through TCP/IP localhost? -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden From pgman@candle.pha.pa.us Wed May 31 13:10:01 2000 Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA68238 for ; Wed, 31 May 2000 09:10:01 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id JAA28541; Wed, 31 May 2000 09:09:39 -0400 (EDT) From: Bruce Momjian Message-Id: <200005311309.JAA28541@candle.pha.pa.us> Subject: Re: pgaccess use wrong password In-Reply-To: <3934E0F9.F8B13881@ext.cri74.org> =?ISO-8859-1?Q?from_Lo=EFc_TREGOU=CBT_at_May_31=2C_2000_11=3A52=3A57_am?= To: =?ISO-8859-1?Q?Lo=EFc_TREGOU=CBT?= Date: Wed, 31 May 2000 09:09:39 -0400 (EDT) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200005/56 > Excuse me for the latest message , i've found the solution > > local all password passwdfile > > Now , passwords are stored (and crypted) in passwdfile . > The authentication with psql is ok > > But pgaccess still use the password in clear in pg_shadow . Is there an > option , i've not set correctly ? I bet pgaccess is using tcp communications. Try adding a 'host' line too. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 From loic@ext.cri74.org Wed May 31 13:13:47 2000 Received: from aravis.cur-archamps.fr (aravis.cur-archamps.fr [195.202.0.99]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA73849 for ; Wed, 31 May 2000 09:13:47 -0400 (EDT) (envelope-from loic@ext.cri74.org) Received: from pc01.cri.cur-archamps.fr (pc01.cri.cur-archamps.fr [10.10.10.2]) by aravis.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id PAA06870 for ; Wed, 31 May 2000 15:13:15 +0200 Received: from ext.cri74.org (localhost [127.0.0.1]) by pc01.cri.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id PAA28037 for ; Wed, 31 May 2000 15:13:15 +0200 Message-ID: <39350FEA.E1133121@ext.cri74.org> Date: Wed, 31 May 2000 15:13:14 +0200 From: =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: fr-FR, en MIME-Version: 1.0 CC: pgsql-admin@postgresql.org Subject: Re: pgaccess use wrong password References: <200005311309.JAA28541@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/57 Bruce Momjian wrote: > > Excuse me for the latest message , i've found the solution > > > > local all password passwdfile > > > > Now , passwords are stored (and crypted) in passwdfile . > > The authentication with psql is ok > > > > But pgaccess still use the password in clear in pg_shadow . Is there an > > option , i've not set correctly ? > > I bet pgaccess is using tcp communications. Try adding a 'host' line > too. > > -- > Bruce Momjian | http://www.op.net/~candle > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Thanks a lot , I was a little bit tired and i forgot to reboot postmaster : it's all ! I will be careful for the next time ! loic