pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Cant connect to psql on winxp
5+ messages / 3 participants
[nested] [flat]

* Cant connect to psql on winxp
@ 2006-10-07 05:35 Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 06:55 ` Re: Cant connect to psql on winxp Adam Radlowski <adamr@informatyka.gdansk.pl>
  0 siblings, 1 reply; 5+ messages in thread

From: Wolfgang Schedl @ 2006-10-07 05:35 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I have a postgresql-server 8.1 running on a winxp-server. I want to
connect with my ubuntu at home (in the end, it should work with a
ASP.net-program) to the db, but it fails to connect. The port is open - I
can prove this with a working telnet connection.
-----
user@pc:~$ telnet 83.xxx.xxx.xxx 5432
Trying 83.xxx.xxx.xxx...
Connected to 83.xxx.xxx.xxx.
Escape character is '^]'.
-----
The problem is, that the psql-connection fails.
-----
-----
My admin-tool for the pqsql-Server is pgadminIII. I tried to change the
pg_hba.conf and added a line with my IP-adress with the pgadminIII. The
line is correct in the pg_hba.conf.
-----
host	 all	 all	 62.xxx.xxx.xxx	 md5
-----
In the config-file everything looks fine, but when I start
pgadminIII->Tools->Server Configuration->pg_hba.conf, it still doesn't
show this line. Could this be the problem or is it just a
pgadminIII-WinXP-bug?

Any ideas, how I could solve the problem?

Thanks

Mit freundlichen Grüssen / Best Regards
---------------------------------------
Wolfgang Schedl




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Cant connect to psql on winxp
  2006-10-07 05:35 Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
@ 2006-10-09 06:55 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
  2006-10-09 09:20   ` Re: Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  0 siblings, 1 reply; 5+ messages in thread

From: Adam Radlowski @ 2006-10-09 06:55 UTC (permalink / raw)
  To: wosforum@consult-it.biz; +Cc: pgsql-admin

Four thigs:
1. Do You have in "postgresql.conf" in section "CONNECION AND 
AUTENTICATION" active opction (default is 'localhost'):
listen_adress='*' (if You want to be more safe, read PDF with PostgreSQL 
doc chapter 17)
2. You're telneting 83.xxx.xxx.xxx, but You have 62.xxx.xxx.xxx in 
pg_hba.conf
3. Try using mode "open for all": 0.0.0.0/0.  If You have this mode and 
"listen_adress='*'" You have fully open PostgreSQL. If You have still 
problems, this should be TCP/IP connection problem. If You want to be 
more safe: if You are using 24 mode adress, so in pg_hba.conf You will 
have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF 
with PostgreSQL doc (chapter 20)
4. Do You have really telnet service started on 5432 port ? I suggest to 
stop this service, when You are using other service on tis same port.

With greetings
Adam

Wolfgang Schedl wrote:

>Hello,
>
>I have a postgresql-server 8.1 running on a winxp-server. I want to
>connect with my ubuntu at home (in the end, it should work with a
>ASP.net-program) to the db, but it fails to connect. The port is open - I
>can prove this with a working telnet connection.
>-----
>user@pc:~$ telnet 83.xxx.xxx.xxx 5432
>Trying 83.xxx.xxx.xxx...
>Connected to 83.xxx.xxx.xxx.
>Escape character is '^]'.
>-----
>The problem is, that the psql-connection fails.
>-----
>-----
>My admin-tool for the pqsql-Server is pgadminIII. I tried to change the
>pg_hba.conf and added a line with my IP-adress with the pgadminIII. The
>line is correct in the pg_hba.conf.
>-----
>host	 all	 all	 62.xxx.xxx.xxx	 md5
>-----
>In the config-file everything looks fine, but when I start
>pgadminIII->Tools->Server Configuration->pg_hba.conf, it still doesn't
>show this line. Could this be the problem or is it just a
>pgadminIII-WinXP-bug?
>
>Any ideas, how I could solve the problem?
>
>Thanks
>
>Mit freundlichen Grüssen / Best Regards
>---------------------------------------
>Wolfgang Schedl
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
>  
>




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Cant connect to psql on winxp
  2006-10-07 05:35 Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 06:55 ` Re: Cant connect to psql on winxp Adam Radlowski <adamr@informatyka.gdansk.pl>
@ 2006-10-09 09:20   ` Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 12:39     ` Re: Cant connect to psql on winxp Ray Stell <stellr@cns.vt.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Wolfgang Schedl @ 2006-10-09 09:20 UTC (permalink / raw)
  To: Adam Radlowski <adamr@informatyka.gdansk.pl>; +Cc: pgsql-admin

Thanks, point 3 did the trick! Seems, I have to read the documentation
better....

Sorry for the simple question and thanks again
  Wolfgang

> Four thigs:
> 1. Do You have in "postgresql.conf" in section "CONNECION AND
> AUTENTICATION" active opction (default is 'localhost'):
> listen_adress='*' (if You want to be more safe, read PDF with PostgreSQL
> doc chapter 17)
> 2. You're telneting 83.xxx.xxx.xxx, but You have 62.xxx.xxx.xxx in
> pg_hba.conf
> 3. Try using mode "open for all": 0.0.0.0/0.  If You have this mode and
> "listen_adress='*'" You have fully open PostgreSQL. If You have still
> problems, this should be TCP/IP connection problem. If You want to be
> more safe: if You are using 24 mode adress, so in pg_hba.conf You will
> have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF
> with PostgreSQL doc (chapter 20)
> 4. Do You have really telnet service started on 5432 port ? I suggest to
> stop this service, when You are using other service on tis same port.
>
> With greetings
> Adam
>
> Wolfgang Schedl wrote:
>
>>Hello,
>>
>>I have a postgresql-server 8.1 running on a winxp-server. I want to
>>connect with my ubuntu at home (in the end, it should work with a
>>ASP.net-program) to the db, but it fails to connect. The port is open - I
>>can prove this with a working telnet connection.
>>-----
>>user@pc:~$ telnet 83.xxx.xxx.xxx 5432
>>Trying 83.xxx.xxx.xxx...
>>Connected to 83.xxx.xxx.xxx.
>>Escape character is '^]'.
>>-----
>>The problem is, that the psql-connection fails.
>>-----
>>-----
>>My admin-tool for the pqsql-Server is pgadminIII. I tried to change the
>>pg_hba.conf and added a line with my IP-adress with the pgadminIII. The
>>line is correct in the pg_hba.conf.
>>-----
>>host	 all	 all	 62.xxx.xxx.xxx	 md5
>>-----
>>In the config-file everything looks fine, but when I start
>>pgadminIII->Tools->Server Configuration->pg_hba.conf, it still doesn't
>>show this line. Could this be the problem or is it just a
>>pgadminIII-WinXP-bug?
>>
>>Any ideas, how I could solve the problem?
>>
>>Thanks
>>
>>Mit freundlichen Grüssen / Best Regards
>>---------------------------------------
>>Wolfgang Schedl
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: Don't 'kill -9' the postmaster
>>
>>
>>
>>
>
>
>


Mit freundlichen Grüssen / Best Regards
---------------------------------------
Wolfgang Schedl
Mobil  +43/699/143 695 77
Fax    +43/699/443 695 77
mailto:wolfgang.schedl@consult-it.biz
---------------------------------------
CONSULT|IT GmbH
A-7311 Neckenmarkt
www.consult-it.biz
---------------------------------------




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Cant connect to psql on winxp
  2006-10-07 05:35 Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 06:55 ` Re: Cant connect to psql on winxp Adam Radlowski <adamr@informatyka.gdansk.pl>
  2006-10-09 09:20   ` Re: Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
@ 2006-10-09 12:39     ` Ray Stell <stellr@cns.vt.edu>
  2006-10-09 12:36       ` Re: Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  0 siblings, 1 reply; 5+ messages in thread

From: Ray Stell @ 2006-10-09 12:39 UTC (permalink / raw)
  To: Wolfgang Schedl <wosforum@consult-it.biz>; +Cc: Adam Radlowski <adamr@informatyka.gdansk.pl>; pgsql-admin

On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote:
> Thanks, point 3 did the trick! Seems, I have to read the documentation
> better....

point 3 was a test, right?  You are not intending to leave it that way,
of course?



> > 3. Try using mode "open for all": 0.0.0.0/0.  If You have this mode and
> > "listen_adress='*'" You have fully open PostgreSQL. If You have still
> > problems, this should be TCP/IP connection problem. If You want to be
> > more safe: if You are using 24 mode adress, so in pg_hba.conf You will
> > have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF
> > with PostgreSQL doc (chapter 20)
> > 4. Do You have really telnet service started on 5432 port ? I suggest to
> > stop this service, when You are using other service on tis same port.


you can use the telnet client to connect to any port, the telnet service
does not have to be the service that syn/acks:

[postgresql@wireworm postgresql]$ telnet stell 25
Trying 198.82.169.14...
Connected to locust.cns.vt.edu (198.82.169.14).
Escape character is '^]'.
220 locust.cns.vt.edu ESMTP



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Cant connect to psql on winxp
  2006-10-07 05:35 Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 06:55 ` Re: Cant connect to psql on winxp Adam Radlowski <adamr@informatyka.gdansk.pl>
  2006-10-09 09:20   ` Re: Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
  2006-10-09 12:39     ` Re: Cant connect to psql on winxp Ray Stell <stellr@cns.vt.edu>
@ 2006-10-09 12:36       ` Wolfgang Schedl <wosforum@consult-it.biz>
  0 siblings, 0 replies; 5+ messages in thread

From: Wolfgang Schedl @ 2006-10-09 12:36 UTC (permalink / raw)
  To: Ray Stell <stellr@cns.vt.edu>; +Cc: pgsql-admin

I meant, that the pga_postgres.conf-setting "listen_adress='*'" did the
trick! :-)

Thanks again
  Wolfgang

> On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote:
>> Thanks, point 3 did the trick! Seems, I have to read the documentation
>> better....
>
> point 3 was a test, right?  You are not intending to leave it that way,
> of course?
>
>
>
>> > 3. Try using mode "open for all": 0.0.0.0/0.  If You have this mode
>> and
>> > "listen_adress='*'" You have fully open PostgreSQL. If You have still
>> > problems, this should be TCP/IP connection problem. If You want to be
>> > more safe: if You are using 24 mode adress, so in pg_hba.conf You will
>> > have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF
>> > with PostgreSQL doc (chapter 20)
>> > 4. Do You have really telnet service started on 5432 port ? I suggest
>> to
>> > stop this service, when You are using other service on tis same port.
>
>
> you can use the telnet client to connect to any port, the telnet service
> does not have to be the service that syn/acks:
>
> [postgresql@wireworm postgresql]$ telnet stell 25
> Trying 198.82.169.14...
> Connected to locust.cns.vt.edu (198.82.169.14).
> Escape character is '^]'.
> 220 locust.cns.vt.edu ESMTP
>
>


Mit freundlichen Grüssen / Best Regards
---------------------------------------
Wolfgang Schedl
Mobil  +43/699/143 695 77
Fax    +43/699/443 695 77
mailto:wolfgang.schedl@consult-it.biz
---------------------------------------
CONSULT|IT GmbH
A-7311 Neckenmarkt
www.consult-it.biz
---------------------------------------




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-10-09 12:39 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-07 05:35 Cant connect to psql on winxp Wolfgang Schedl <wosforum@consult-it.biz>
2006-10-09 06:55 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
2006-10-09 09:20   ` Wolfgang Schedl <wosforum@consult-it.biz>
2006-10-09 12:39     ` Ray Stell <stellr@cns.vt.edu>
2006-10-09 12:36       ` Wolfgang Schedl <wosforum@consult-it.biz>

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