pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgaccess use wrong password
4+ messages / 3 participants
[nested] [flat]

* pgaccess use wrong password
@ 2000-05-31 09:52 Loïc TREGOUËT <loic@ext.cri74.org>
  2000-05-31 11:28 ` Re: pgaccess use wrong password Peter Eisentraut <e99re41@DoCS.UU.SE>
  2000-05-31 13:09 ` Re: pgaccess use wrong password Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 2 replies; 4+ messages in thread

From: Loïc TREGOUËT @ 2000-05-31 09:52 UTC (permalink / raw)
  To: pgsql-admin

       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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pgaccess use wrong password
  2000-05-31 09:52 pgaccess use wrong password Loïc TREGOUËT <loic@ext.cri74.org>
@ 2000-05-31 11:28 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
  1 sibling, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2000-05-31 11:28 UTC (permalink / raw)
  To: Loïc TREGOUËT <loic@ext.cri74.org>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pgaccess use wrong password
  2000-05-31 09:52 pgaccess use wrong password Loïc TREGOUËT <loic@ext.cri74.org>
@ 2000-05-31 13:09 ` Bruce Momjian <pgman@candle.pha.pa.us>
  2000-05-31 13:13   ` Re: pgaccess use wrong password Loïc TREGOUËT <loic@ext.cri74.org>
  1 sibling, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2000-05-31 13:09 UTC (permalink / raw)
  To: Loïc TREGOUËT <loic@ext.cri74.org>; +Cc: pgsql-admin

>        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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pgaccess use wrong password
  2000-05-31 09:52 pgaccess use wrong password Loïc TREGOUËT <loic@ext.cri74.org>
  2000-05-31 13:09 ` Re: pgaccess use wrong password Bruce Momjian <pgman@candle.pha.pa.us>
@ 2000-05-31 13:13   ` Loïc TREGOUËT <loic@ext.cri74.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Loïc TREGOUËT @ 2000-05-31 13:13 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-05-31 13:13 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-31 09:52 pgaccess use wrong password Loïc TREGOUËT <loic@ext.cri74.org>
2000-05-31 11:28 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
2000-05-31 13:09 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-05-31 13:13   ` Loïc TREGOUËT <loic@ext.cri74.org>

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