Обсуждение: Cant connect to psql on winxp
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
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 > > > >
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 ---------------------------------------
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
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 ---------------------------------------