pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem to connect
3+ messages / 3 participants
[nested] [flat]
* problem to connect
@ 2003-04-08 20:35 nicolas renie <nicolas.renie@wanadoo.fr>
0 siblings, 2 replies; 3+ messages in thread
From: nicolas renie @ 2003-04-08 20:35 UTC (permalink / raw)
To: pgsql-interfaces
Hye
I use linux mandrack 9.0 and postgres 7.2
I can't connect to postgresql (even in local) if I use a postgres user.
I don't know what to do.
I've started the daemon (root# etc/rc.d/init.d/postgresql start)
logged under postgres I made a user (createuser nico) and a database(createdb test)
But I can't access to this database if I am logged under an other user.
(su Eddy or anathor linux user)
When I try: psql test -h localhost -U nicolas I have the message :
IDENT authentification failed for user nicolas.
I can see the same message when I try to connect whith pgaccess.
If I try to start pgaccess with: "pgaccess test", the main PgAccess window
comes up, (empty) but there is an error message box in front of it. The message is:
"Error trying to connect to database "test" on host localhost.
is the postmaster running (with -i) at
'localhost' and accepting connections on TCP/IP port '5432'?"
Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
I started it logged under postgres with options ($ postmaster -h localhost -i )
I logged under another linux user
I tried : psql test -h localhost -U nicolas and received the message
No pga_hba.conf entry for host localhost, user nicolas, database test
I tryed to change the pg_dba.conf (trust) file but another message appears.
I would like to know what to do especially to use pgaccess
Please, help me !
regards
Nicolas RENIE
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: problem to connect
@ 2003-04-09 16:40 Wei Weng <wweng@kencast.com>
parent: nicolas renie <nicolas.renie@wanadoo.fr>
1 sibling, 0 replies; 3+ messages in thread
From: Wei Weng @ 2003-04-09 16:40 UTC (permalink / raw)
To: nicolas renie <nicolas.renie@wanadoo.fr>; +Cc: pgsql-interfaces
The default behavior for postgres uses IDENT. So you need to log on as
user nicolas to be able to use postgres user nicolas. You can look at
/var/lib/pgsql/data/pg_hba.conf for configuration detail.
Wei
nicolas renie wrote:
> Hye
>
> I use linux mandrack 9.0 and postgres 7.2
> I can't connect to postgresql (even in local) if I use a postgres user.
> I don't know what to do.
> I've started the daemon (root# etc/rc.d/init.d/postgresql start)
> logged under postgres I made a user (createuser nico) and a
> database(createdb test)
> But I can't access to this database if I am logged under an other user.
> (su Eddy or anathor linux user)
>
> When I try: psql test -h localhost -U nicolas I have the message :
> IDENT authentification failed for user nicolas.
> I can see the same message when I try to connect whith pgaccess.
>
> If I try to start pgaccess with: "pgaccess test", the main PgAccess
> window
> comes up, (empty) but there is an error message box in front of it.
> The message is:
>
> "Error trying to connect to database "test" on host localhost.
> is the postmaster running (with -i) at
> 'localhost' and accepting connections on TCP/IP port '5432'?"
>
> Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
> I started it logged under postgres with options ($ postmaster -h
> localhost -i )
>
> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>
> No pga_hba.conf entry for host localhost, user nicolas, database test
>
> I tryed to change the pg_dba.conf (trust) file but another message
> appears.
>
> I would like to know what to do especially to use pgaccess
>
>
> Please, help me !
> regards
>
> Nicolas RENIE
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: problem to connect
@ 2003-04-09 16:42 C. Maj <cmaj@freedomcorpse.info>
parent: nicolas renie <nicolas.renie@wanadoo.fr>
1 sibling, 0 replies; 3+ messages in thread
From: C. Maj @ 2003-04-09 16:42 UTC (permalink / raw)
To: nicolas renie <nicolas.renie@wanadoo.fr>; +Cc: pgsql-interfaces
On Tue, 8 Apr 2003, nicolas renie waxed:
8<'s
> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>
> No pga_hba.conf entry for host localhost, user nicolas, database test
>
> I tryed to change the pg_dba.conf (trust) file but another message appears.
In pg_hba.conf, do you have the following:
local all trust
host all 127.0.0.1 255.255.255.255 trust
Also, you need to be either root or the postgres user to edit the file.
To work with PgAccess, you will need to give the user you want to login
as SELECT permission on the pg_user table (if it's a different user than
that which created the database.)
--Chris
--
Chris Maj <cmaj_hat_freedomcorpse_hot_info>
0xC0051F6A
5EB8 2035 F07B 3B09 5A31 7C09 196F 4126 C005 1F6A
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-04-09 16:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-08 20:35 problem to connect nicolas renie <nicolas.renie@wanadoo.fr>
2003-04-09 16:40 ` Wei Weng <wweng@kencast.com>
2003-04-09 16:42 ` C. Maj <cmaj@freedomcorpse.info>
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