pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres authentication
5+ messages / 4 participants
[nested] [flat]

* postgres authentication
@ 2002-07-10 20:48  acchung@mit.edu
  0 siblings, 1 reply; 5+ messages in thread

From: acchung@mit.edu @ 2002-07-10 20:48 UTC (permalink / raw)
  To: pgsql-admin

Hi,  
  
 I changed my pg_hba.conf file so that I am authenticating using  
md5 from passwdfile which is a file i created to hold my passwords.  
I didn't add postgres onto that file but when I type psql template1  
under postgres, it prompts me for my password.  i type it in  
and it gives me  
  
 psql: FATAL 1:  Password authentication failed for user "postgres"  
  
 I only have one password for postgres which I used perfectly fine  
to log into linux.  I also use the same password to switch between   
 postgres and other non-root users in the bash shell.  i tried adding postgres  
into the passwdfile file but to no avail.  How do I correct this   
 password bug for postgres so that  I can do stuff as a superuser?  
HELP!  
  
 Alex  
 
 



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

* Re: postgres authentication
@ 2002-07-11 02:59  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: acchung@mit.edu
  0 siblings, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 2002-07-11 02:59 UTC (permalink / raw)
  To: acchung@mit.edu; +Cc: pgsql-admin

acchung@mit.edu wrote:
> Hi,  
>   
>  I changed my pg_hba.conf file so that I am authenticating using  
> md5 from passwdfile which is a file i created to hold my passwords.  
> I didn't add postgres onto that file but when I type psql template1  
> under postgres, it prompts me for my password.  i type it in  
> and it gives me  
>   
>  psql: FATAL 1:  Password authentication failed for user "postgres"  
>   
>  I only have one password for postgres which I used perfectly fine  
> to log into linux.  I also use the same password to switch between   
>  postgres and other non-root users in the bash shell.  i tried adding postgres  
> into the passwdfile file but to no avail.  How do I correct this   
>  password bug for postgres so that  I can do stuff as a superuser?  
> HELP!  

That file is used for secondary passwords.  It is going away in 7.3 so I
suggest using ALTER USER PASSWORD to set the password for the user in
the pg_shadow table.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  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] 5+ messages in thread

* postgres authentication
@ 2007-08-08 00:45  Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Tena Sakai @ 2007-08-08 00:45 UTC (permalink / raw)
  To: pgsql-admin

Hi everybody,

I am having a problem with crating user.  It has to do
with authentication.  What I want is to authenticate
a user via an ldap server.

I created postgres account by:
    create user donder with
           createdb
           login
           in group analysis;

and added the following line to pg_hba.conf file:
    host    all     donder          ldap://amarula.egcrc.orgsent 

sent a hup signal like this:
    pg_ctl -D /usr/local/pgsql/data reload

When I become user donder to connect to database, this is what I get:
    psql: FATAL:  missing or erroneous pg_hba.conf file
    HINT:  See server log for details.

The serverlog says:
    LOG:  invalid IP address "ldap:" in file "/usr/local/pgsql/data/pg_hba.conf" line 55: Name or service not known
    FATAL:  missing or erroneous pg_hba.conf file
    HINT:  See server log for details.

I am looking at the manual, PostgreSQL 8.2.1 Documentation, chapter 20.
In section 20.2.5, they talk about ldap authentication, but it's
a bit sketchy.  The example given is:
  ldap://ldap.example.net/dc=example,dc=net;EXAMPLE\

I have no idea what "dc=" means, and what does ";EXAMPLE\" mean?
Can anyone please explain what this means?  If you have done
what I am trying to do, please furnish a working example.

Many thanks.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

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

* Re: postgres authentication
@ 2007-08-08 04:31  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2007-08-08 04:31 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> and added the following line to pg_hba.conf file:
>     host    all     donder          ldap://amarula.egcrc.orgsent

I know nothing about ldap, but this is clearly not a correct host line:
you forgot the address field(s), and that last bit should be an option
not the auth method name.  I would imagine that what you need is
something like

host    all     donder  192.168.1.0/24  ldap ldap://amarula.egcrc.orgsent

(adjust address to suit, of course)

			regards, tom lane



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

* Re: postgres authentication
@ 2007-08-08 18:15  Tena Sakai <tsakai@gallo.ucsf.edu>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Tena Sakai @ 2007-08-08 18:15 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Hi Tom,

Thanks for your comment/advice.  It is an improvement, but...

I adjusted the line in pg_hba.conf to:
    host    all     donder          172.16.XX.XX/32 ldap ldap://amarula.egcrc.org
and what I get as user donder is:
    -bash-3.00$ psql canon
    Password: 
    psql: FATAL:  password authentication failed for user "donder"
In the serverlog file, I get:
    FATAL:  password authentication failed for user "donder"

I need a working ldap example for pg_hba.conf desparately.
Can somebody please help?

Also, if somebody can explain what the example on page 352 of 8.2.1
manual:
    ldap://ldap.example.net/dc=example,dc=net;EXAMPLE\
means, I would appreciate it greatly.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tue 8/7/2007 9:31 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres authentication 
 
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> and added the following line to pg_hba.conf file:
>     host    all     donder          ldap://amarula.egcrc.orgsent

I know nothing about ldap, but this is clearly not a correct host line:
you forgot the address field(s), and that last bit should be an option
not the auth method name.  I would imagine that what you need is
something like

host    all     donder  192.168.1.0/24  ldap ldap://amarula.egcrc.orgsent

(adjust address to suit, of course)

			regards, tom lane

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


end of thread, other threads:[~2007-08-08 18:15 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-10 20:48 postgres authentication acchung@mit.edu
2002-07-11 02:59 ` Bruce Momjian <pgman@candle.pha.pa.us>
2007-08-08 00:45 postgres authentication Tena Sakai <tsakai@gallo.ucsf.edu>
2007-08-08 04:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-08 18:15   ` Tena Sakai <tsakai@gallo.ucsf.edu>

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