LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 06-15-2004, 04:46 PM   #1
linuxtesting2
Member
 
Registered: Mar 2004
Location: Norway
Distribution: Freebsd, Fedora, Redhat, Solaris 10
Posts: 169

Rep: Reputation: 30
psql: FATAL 1: IDENT authentication failed for user "postgres"


i know this is a know problem, but i cant seem to get it right

i do:

psql -d template1 -f pgsql_create.sql -U postgres psql: FATAL 1: IDENT authentication failed for user "postgres"


in my pg_hba.conf i have

local all ident sameuser
host all 127.0.0.1 255.0.0.0 ident sameuser
host all 0.0.0.0 0.0.0.0 reject


i have also had:

local all all ident sameuser

but same problem...i did restart postgresql every time...what is wrong ?

-k
 
Old 06-15-2004, 06:15 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,985
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
The things you posted don't state it, so I'll ask
the most obvious thing first:

You're actually logged in as the user postgres
when you do this?


Cheers,
Tink
 
Old 06-16-2004, 04:58 AM   #3
linuxtesting2
Member
 
Registered: Mar 2004
Location: Norway
Distribution: Freebsd, Fedora, Redhat, Solaris 10
Posts: 169

Original Poster
Rep: Reputation: 30
hehe...it worked with su - postgres...but i also need the following :

# psql -d horde -U horde -f auth.sql
# psql -d horde -U horde -f category.sql
# psql -d horde -U horde -f prefs.sql


but when i try that i get:

xxx:~# su - horde
Unknown id: horde
xxx:~# psql -d horde -U horde -f auth.sql
psql: FATAL 1: IDENT authentication failed for user "horde"
xxx:~#

Do i need to add a user horde....why cant just any user connet ?


-k
 
Old 06-16-2004, 12:48 PM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,985
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
because of
Quote:
ident sameuser
You're telling postgres to only accept users that
exist in Linux, and that they need the Linux password.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
user cannot log in "Authentication Failed" Fedora Core 4 clayharryman Linux - Security 8 08-04-2005 06:23 PM
Postgresql error FATAL: user "root" does not exist" cgetty Ubuntu 4 06-21-2005 02:11 PM
Why is pam_authenticate() returning "Authentication Failure" for valid user/passwd? jrsugar Programming 1 06-14-2005 08:18 AM
FTP Error, Help needed. "Must perform authentication before identifying USER" acalvin Linux - Software 0 07-27-2003 01:41 PM
X won't start: "Fatal server error: failed to initialize core devices" ! Debianewb Linux - Newbie 14 08-27-2002 05:21 PM


All times are GMT -5. The time now is 03:45 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration