pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAuthentification failed
6+ messages / 6 participants
[nested] [flat]
* Authentification failed
@ 2007-08-01 21:19 Judith <jaltamirano@correolux.com.mx>
0 siblings, 4 replies; 6+ messages in thread
From: Judith @ 2007-08-01 21:19 UTC (permalink / raw)
To: pgsql-sql
Hello everybody!!
I'm trying in SUSE to connect to a postgres db and this is the error:
Ident Authentification failed for user <<root>>
I'm already created the user with createuser root, but the error
persist, I would aprecciate some help, thanks in advanced
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Authentification failed
@ 2007-08-02 00:48 chester c young <chestercyoung@yahoo.com>
parent: Judith <jaltamirano@correolux.com.mx>
3 siblings, 0 replies; 6+ messages in thread
From: chester c young @ 2007-08-02 00:48 UTC (permalink / raw)
To: Judith <jaltamirano@correolux.com.mx>; +Cc: pgsql-sql
> I'm trying in SUSE to connect to a postgres db and this is the
> error:
>
> Ident Authentification failed for user <<root>>
>
others will guide better, but for now, in pg_hba.conf
# "local" is for Unix domain socket connections only
local all all ident sameuser
also, as postgres user, createuser <your-login>
this will let you into pg as yourself
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Authentification failed
@ 2007-08-02 00:52 Scott Marlowe <scott.marlowe@gmail.com>
parent: Judith <jaltamirano@correolux.com.mx>
3 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2007-08-02 00:52 UTC (permalink / raw)
To: Judith <jaltamirano@correolux.com.mx>; +Cc: pgsql-sql
On 8/1/07, Judith <jaltamirano@correolux.com.mx> wrote:
> Hello everybody!!
>
> I'm trying in SUSE to connect to a postgres db and this is the error:
>
> Ident Authentification failed for user <<root>>
>
> I'm already created the user with createuser root, but the error
> persist, I would aprecciate some help, thanks in advanced
you need to change auth methods in your pg_hba.conf file:
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
basically identd means that you are who you are on the unix box. no
-U flag, you can't log in as someone else.
note that a "root" user is a bit of a mysqlism. The postgres user is
the equivalent in postgresql. might you sudo su - postgres and try to
connect?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Authentification failed
@ 2007-08-03 01:15 Kenneth Gonsalves <lawgon@thenilgiris.com>
parent: Judith <jaltamirano@correolux.com.mx>
3 siblings, 0 replies; 6+ messages in thread
From: Kenneth Gonsalves @ 2007-08-03 01:15 UTC (permalink / raw)
To: Judith <jaltamirano@correolux.com.mx>; +Cc: pgsql-sql
On 02-Aug-07, at 2:49 AM, Judith wrote:
> I'm trying in SUSE to connect to a postgres db and this is the error:
>
> Ident Authentification failed for user <<root>>
>
> I'm already created the user with createuser root, but the error
> persist, I would aprecciate some help, thanks in advanced
edit your pg_hba.conf file to allow tcp/ip access from localhost. And
please dont try to access postgres as 'root'
--
regards
kg
http://lawgon.livejournal.com
http://nrcfosshelpline.in/web/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Authentification failed
@ 2007-08-14 08:30 Bryce Nesbitt <bryce1@obviously.com>
parent: Judith <jaltamirano@correolux.com.mx>
3 siblings, 1 reply; 6+ messages in thread
From: Bryce Nesbitt @ 2007-08-14 08:30 UTC (permalink / raw)
To: pgsql-sql; +Cc: Judith <jaltamirano@correolux.com.mx>
Judith wrote:
> Hello everybody!!
>
> I'm trying in SUSE to connect to a postgres db and this is the error:
>
> Ident Authentification failed for user <<root>>
>
> I'm already created the user with createuser root, but the error
> persist, I would aprecciate some help, thanks in advanced
...or just cheat and get in as the postgres root user:
psql -U postgres
Which on SUSE has no password.
--
----
Visit http://www.obviously.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Authentification failed
@ 2007-08-14 11:40 Terry Fielder <terry@ashtonwoodshomes.com>
parent: Bryce Nesbitt <bryce1@obviously.com>
0 siblings, 0 replies; 6+ messages in thread
From: Terry Fielder @ 2007-08-14 11:40 UTC (permalink / raw)
To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql@postgresql.org, Judith <jaltamirano@correolux.com.mx>
Connecting as root may be ill advised (doing stuff as root is a bad
idea unless one HAS to).
All that notwithstanding, you need to setup the correct permissions to
allow the connections you want in pg_hba.conf, usually is
/var/lib/pgsql/data/pg_hba.conf
Terry
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bryce Nesbitt wrote:
> Judith wrote:
>
>> Hello everybody!!
>>
>> I'm trying in SUSE to connect to a postgres db and this is the error:
>>
>> Ident Authentification failed for user <<root>>
>>
>> I'm already created the user with createuser root, but the error
>> persist, I would aprecciate some help, thanks in advanced
>>
> ...or just cheat and get in as the postgres root user:
> psql -U postgres
> Which on SUSE has no password.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-08-14 11:40 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-01 21:19 Authentification failed Judith <jaltamirano@correolux.com.mx>
2007-08-02 00:48 ` chester c young <chestercyoung@yahoo.com>
2007-08-02 00:52 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-08-03 01:15 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2007-08-14 08:30 ` Bryce Nesbitt <bryce1@obviously.com>
2007-08-14 11:40 ` Terry Fielder <terry@ashtonwoodshomes.com>
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