dbTalk Databases Forums  

Authentication failed for user...

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Authentication failed for user... in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manu M P
 
Posts: n/a

Default Authentication failed for user... - 12-11-2003 , 11:43 PM






Friends

I created a superuser "user1" and given permissions to create users and data bases. I then tried to connect the user to the data base "test" using the psql meta command "\c test user1" . The command returned the message "IDENT Authentication failed for the user user1". Why this happens. How can i eliminate the problem?

Thanks


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


Reply With Quote
  #2  
Old   
Oliver Elphick
 
Posts: n/a

Default Re: Authentication failed for user... - 12-13-2003 , 01:17 AM






On Fri, 2003-12-12 at 05:43, Manu M P wrote:
Quote:
Friends

I created a superuser "user1" and given permissions to create users
and data bases. I then tried to connect the user to the data base
"test" using the psql meta command "\c test user1" . The command
returned the message "IDENT Authentication failed for the user user1".
Why this happens. How can i eliminate the problem?
User authentication is controlled by the pg_hba.conf file in $PGDATA.
Read the manual chapter on Client Authentication.

Briefly, your system is set to check that users have the same names as
their UNIX login. You will need to choose a different authentication
method to let you change identity with \c.

--
Oliver Elphick Oliver.Elphick (AT) lfix (DOT) co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For thou art my hope, O Lord GOD; thou art my trust
from my youth." Psalms 71:5


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.