LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 03-14-2006, 02:41 AM   #1
Manashi
LQ Newbie
 
Registered: Jan 2006
Posts: 27

Rep: Reputation: 15
Question psql: FATAL: IDENT authentication failed for user "manashi"


hi...
i am workin on PHP with postgreSQl for the past 2 months...
both r completely new for me....
there is an install script of our application that will check for certain things and then it will create the DB and tables..
when i am executin it...Its givin an error..

psql: FATAL: IDENT authentication failed for user "manashi"
psql: FATAL: IDENT authentication failed for user "manashi"


the install script will check for followin things b4 creatin the DB :-

1.Check to see if web server is up and running
2.Check to see if Python is installed on not
3.Get the web root
4.Get the host access
5.Check to see if postgreSQL has been installed
6.Check to see if PostgreSQL support for PHP has been installed

every thing is fine till this point...

after that it will ask 4 :-
1.DB name
2.DB user name
3.DB password
4.chart server location name

then it will create the DB ....here its showin the error...

the code is as follows :-

if test -n "$DB_PASSWORD"
then
SQL_SUFFIX="identified by '$DB_PASSWORD'"
fi
psql -U $DB_LOGIN template1
createdb $DB_NAME;
\q
EOF
#cat >samp<../db/thinkdb-schema.sql
psql -U $DB_LOGIN $DB_NAME<../db/thinkdb-schema.sql


I am tryin to debug the error for the past 1 week bt was not able to do that

waitin for the reply ....
 
Old 03-14-2006, 11:08 AM   #2
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Please try spelling out your verbs: working, executing, etc.

As far as your problem:
1. Log in manually to verify that the correct PostgreSQL username/password is actually being set in the database.

... then, and ONLY then ...

2. Use "set -x" in your script to verify whether or not the shell variables are being set correctly

At that point, everything should work fine.

'Hope that helps .. PSM
 
Old 03-16-2006, 02:17 AM   #3
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,988
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
What is the content of your pg_hba.conf ?


Cheers,
Tink
 
  


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 Off
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
psql: FATAL 1: IDENT authentication failed for user "postgres" linuxtesting2 Linux - General 3 06-16-2004 12:48 PM
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 06:21 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