pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeduser connection over tcp
4+ messages / 3 participants
[nested] [flat]
* user connection over tcp
@ 2005-04-18 13:31 Frank Habermann <postgres@lordlamer.de>
0 siblings, 1 reply; 4+ messages in thread
From: Frank Habermann @ 2005-04-18 13:31 UTC (permalink / raw)
To: pgsql-sql
hello!
i have some problems to understand the manual with pg_hba.conf.
i use a tcp connection with phppgadmin to connect to the db. in my pg_hba.conf i say for this connection trust! in phppgadmin i need the for my user the right password to connect. but the manual says that every password will accepted. why isnt that work at me?
i also try password in pg_hba.conf for my tcpconnections. but after this i cant connect to the db. but the manual says that users with right password can connect. but this doesnt work here.
can somebody explain me whats wrong with me or my postgre?!
thx
frank habermann
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user connection over tcp
@ 2005-04-18 13:42 Sean Davis <sdavis2@mail.nih.gov>
parent: Frank Habermann <postgres@lordlamer.de>
0 siblings, 1 reply; 4+ messages in thread
From: Sean Davis @ 2005-04-18 13:42 UTC (permalink / raw)
To: Frank Habermann <postgres@lordlamer.de>; pgsql-sql
Did you start the postmaster with -i to allow tcp connections? What is the
error that you get when you try to connect?
Sean
----- Original Message -----
From: "Frank Habermann" <postgres@lordlamer.de>
To: <pgsql-sql@postgresql.org>
Sent: Monday, April 18, 2005 9:31 AM
Subject: [SQL] user connection over tcp
> hello!
>
> i have some problems to understand the manual with pg_hba.conf.
>
> i use a tcp connection with phppgadmin to connect to the db. in my
> pg_hba.conf i say for this connection trust! in phppgadmin i need the for
> my user the right password to connect. but the manual says that every
> password will accepted. why isnt that work at me?
>
> i also try password in pg_hba.conf for my tcpconnections. but after this i
> cant connect to the db. but the manual says that users with right password
> can connect. but this doesnt work here.
>
> can somebody explain me whats wrong with me or my postgre?!
>
> thx
>
> frank habermann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user connection over tcp
@ 2005-04-18 13:47 Dinesh Pandey <dpandey@secf.com>
parent: Sean Davis <sdavis2@mail.nih.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Dinesh Pandey @ 2005-04-18 13:47 UTC (permalink / raw)
To: 'Sean Davis' <sdavis2@mail.nih.gov>; 'Frank Habermann' <postgres@lordlamer.de>; pgsql-sql
Edit "postgres.conf" and "pg_hba.conf" to access database from a remote
machine
Edit "postgres.conf":
------------------------------------------
listen_addresse='*'
Edit "pg_hba.conf":
------------------------------------------
host all all 10.1.11.54 255.255.255.0
trust
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Sean Davis
Sent: Monday, April 18, 2005 7:13 PM
To: Frank Habermann; pgsql-sql@postgresql.org
Subject: Re: [SQL] user connection over tcp
Did you start the postmaster with -i to allow tcp connections? What is the
error that you get when you try to connect?
Sean
----- Original Message -----
From: "Frank Habermann" <postgres@lordlamer.de>
To: <pgsql-sql@postgresql.org>
Sent: Monday, April 18, 2005 9:31 AM
Subject: [SQL] user connection over tcp
> hello!
>
> i have some problems to understand the manual with pg_hba.conf.
>
> i use a tcp connection with phppgadmin to connect to the db. in my
> pg_hba.conf i say for this connection trust! in phppgadmin i need the for
> my user the right password to connect. but the manual says that every
> password will accepted. why isnt that work at me?
>
> i also try password in pg_hba.conf for my tcpconnections. but after this i
> cant connect to the db. but the manual says that users with right password
> can connect. but this doesnt work here.
>
> can somebody explain me whats wrong with me or my postgre?!
>
> thx
>
> frank habermann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user connection over tcp
@ 2005-04-18 13:57 Frank Habermann <postgres@lordlamer.de>
0 siblings, 0 replies; 4+ messages in thread
From: Frank Habermann @ 2005-04-18 13:57 UTC (permalink / raw)
To: pgsql-sql
hello again.
ok. i can connect over tcp!!! this works! my problem is that i only can connect with trust! if i use password i cant connect. with trustmode i need the right password for the user!
frank
-- Original-Nachricht --
Von: "Frank Habermann" <postgres@lordlamer.de>
An: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Datum: Montag 18 April 2005 15:31:10
Betreff: user connection over tcp
> hello!
>
> i have some problems to understand the manual with pg_hba.conf.
>
> i use a tcp connection with phppgadmin to connect to the db. in my pg_hba.conf i say for this connection trust! in phppgadmin i need the for my user the right password to connect. but the manual says that every password will accepted. why isnt that work at me?
>
> i also try password in pg_hba.conf for my tcpconnections. but after this i cant connect to the db. but the manual says that users with right password can connect. but this doesnt work here.
>
> can somebody explain me whats wrong with me or my postgre?!
>
> thx
>
> frank habermann
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-04-18 13:57 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-18 13:31 user connection over tcp Frank Habermann <postgres@lordlamer.de>
2005-04-18 13:42 ` Sean Davis <sdavis2@mail.nih.gov>
2005-04-18 13:47 ` Dinesh Pandey <dpandey@secf.com>
2005-04-18 13:57 Re: user connection over tcp Frank Habermann <postgres@lordlamer.de>
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