pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kis János Tamás <kjt@takarnet.hu>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres User Password File????
Date: Wed, 12 Sep 2007 09:34:35 +0200
Message-ID: <200709120934.37529.kjt@takarnet.hu> (raw)
In-Reply-To: <12558425.post@talk.nabble.com>
References: <12558425.post@talk.nabble.com>

péntek 07 szeptember 2007 18.13 dátummal smiley2211 ezt írta:
> Hello all,
>
> Where do I find the PASSWORDs for users on Postgresql???  It seems
> connections are failing because user PROOT's password is not
> correct - where do I find out what it's set to - do I need to
> change it???
>
> DataObjects_Users : CONNECT :
> a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20
>:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4
>:"code";i:-24;s:7:"message";s:24:"DB Error: connect
> failed";s:8:"userinfo";s:171:" [nativecode=Unable to connect to
> PostgreSQL server: FATAL: password authentication failed for user
> "proot"]
>
> Thanks...Michelle

Did you read the chapter 20.1 in PostgreSQL documentation?
Your pg_hba.conf is good?

If you can connect to template1, then you can to see the encrypted 
passwords: SELECT rolname, rolpassword FROM pg_catalog.pg_authid; but 
I think you don't need this...

Bye,
kjt


McAfee SCM 4.1 által ellenrizve!


view thread (8+ messages)

Message-ID: <200709120934.37529.kjt@takarnet.hu>
Permalink:  ../200709120934.37529.kjt@takarnet.hu/
Also on:    postgresql.org/message-id/200709120934.37529.kjt@takarnet.hu

 · 

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-admin@postgresql.org
  Cc: kjt@takarnet.hu
  Subject: Re: Postgres User Password File????
  In-Reply-To: <200709120934.37529.kjt@takarnet.hu>

* 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