Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
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.


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

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

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 its showin the error...

the code is as follows :-

if test -n "$DB_PASSWORD"
SQL_SUFFIX="identified by '$DB_PASSWORD'"
psql -U $DB_LOGIN template1
createdb $DB_NAME;
#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
LQ 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
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

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



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 > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 10:54 AM.

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