X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B9EB59FA9BD for ; Thu, 4 May 2006 16:01:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09386-01-7 for ; Thu, 4 May 2006 16:00:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by postgresql.org (Postfix) with ESMTP id 9C8529FA65C for ; Thu, 4 May 2006 16:00:13 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id i30so429371wra for ; Thu, 04 May 2006 12:00:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=EDDATkmursPzmy10YtoGDquA8/46TQrUeLBST0e2QcGymeMMsFsIXDRCP4ib1O4Tc25o7sXVGpSAlOEq4YpJ0kHXKelwJ2TqnEgYu21jsT94lhCvAOlaGN9WVCGINbx8H8GtzKX6KAGO8J2fkKWnKrcmtQeWeb971V9ROJL4Erk= Received: by 10.54.103.19 with SMTP id a19mr1450515wrc; Thu, 04 May 2006 12:00:00 -0700 (PDT) Received: by 10.54.135.14 with HTTP; Thu, 4 May 2006 12:00:00 -0700 (PDT) Message-ID: <63c4c13c0605041200i36b6ad0bw21e6b9ab967df47a@mail.gmail.com> Date: Thu, 4 May 2006 22:00:00 +0300 From: "Catalin Pitis" To: pgsql-sql@postgresql.org Subject: Re: Connecting to Postgres from other machines (outside localhost) In-Reply-To: <63c4c13c0605041134k75a5e51bg88d1b4f5a230e58e@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_10339_27557252.1146769200327" References: <63c4c13c0605041052q4212965bua0a3a376ba8abf3f@mail.gmail.com> <445A4159.2060707@oisinglynn.com> <63c4c13c0605041134k75a5e51bg88d1b4f5a230e58e@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/55 X-Sequence-Number: 25086 ------=_Part_10339_27557252.1146769200327 Content-Type: multipart/alternative; boundary="----=_Part_10340_2918612.1146769200327" ------=_Part_10340_2918612.1146769200327 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline After I've changed the pg_hba.conf, I got the following error when connecting (from log file) 2006-05-04 21:57:26 LOG: invalid entry in file "C:/Program Files/PostgreSQL/8.0/data/pg_hba.conf" at line 68, token "192.168.0.1/192" 2006-05-04 21:57:26 FATAL: missing or erroneous pg_hba.conf file 2006-05-04 21:57:26 HINT: See server log for details. The pg_hba.conf file is attached... Catalin On 5/4/06, Catalin Pitis wrote: > > I did all you said: > > I set pg_hba.conf: > > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > host all all 192.168.197.1/192 md5 > host all all 192.168.123.1/192 md5 > host all all 192.168.0.1/192 md5 > > > I set postgres.conf: > > listen_addresses =3D '*' # what IP interface(s) to listen on; > # defaults to localhost, '*' =3D any > port =3D 5433 > max_connections =3D 100 > > I'm using jdbc with the following URL: > > jdbc:postgresql://192.168.197.1:5433/postgres8 > > Where postgres8 is the name of the database. > > I still can't connect... > > Can you give me a hint? > > Thanks > Catalin > > > On 5/4/06, Oisin Glynn wrote: > > > > Catalin Pitis wrote: > > > Hello > > > > > > I installed PostgreSQL 8.0 on Windows and I can connect from localhos= t > > > > > only. How can I configure the server to allow connection from other > > > machines? > > > > > > Thank you > > > Catalin > > Under > > Start-> Programs->PostgreSQLXX->Configuration files > > postgresql.conf > > pg_hba.conf > > > > Are the 2 files I modified. Please be aware my settings are for a dev > > box and are WIDE OPEN AS SHOWN HERE this might allow alot more people > > connect than you want. > > > > postgresql.conf > > # - Connection Settings - > > > > listen_addresses =3D '*' # what IP address(es) to listen on; > > # comma-separated list of addresses; > > # defaults to 'localhost', '*' =3D all > > port =3D 5432 > > max_connections =3D 100 > > > > pg_hba.conf > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > > > # IPv4 local connections: > > host all all 127.0.0.1/32 md5 > > host all all 192.168.10.1/24 md5 > > # IPv6 local connections: > > #host all all ::1/128 md5 > > > > > ------=_Part_10340_2918612.1146769200327 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
After I've changed the pg_hba.conf, I got the following error when con= necting (from log file)
 
2006-05-04 21:57:26 LOG:  invalid entry in file "C:/Program = Files/PostgreSQL/8.0/data/pg_hba.conf" at line 68, token "192.168.0.1/192"
2006-05-04 21:57:2= 6 FATAL:  missing or erroneous pg_hba.conf file
2006-05-04 21:57:26 HINT:  See server log for details.
 
The pg_hba.conf file is attached...
 
Catalin

 
On 5/4/06, C= atalin Pitis <cpitis.pgsql= @gmail.com> wrote:
I did all you said:
 
I set pg_hba.conf:
 
# IPv4 local connections:host    all        = ; all         127.0.0.1/32           md5
host    all   &= nbsp;     all       =   192.168.197.1/192 &nbs= p;        md5
host   = all         all   &= nbsp;    =20 192.168.123.1/192   = ;       md5
host    all&nbs= p;        all    &nb= sp;    192.168.0.1/192          m= d5
 
 
I set postgres.conf:
 
listen_addresses =3D '*' # what IP interface(s) to listen on;     # defaults to localhost, '*' =3D any
port =3D 5= 433
max_connections =3D 100
 
I'm using jdbc with the following URL:
 
jdbc:postgresql://192.168.197.1:5433/postgres8
 
Where postgres8 is the name of the database.
 
I still can't connect...
 
Can you give me a hint?
 
Thanks
Catalin

 
On 5/4/06, O= isin Glynn <me@oisinglynn.com> wrote: =20
Catalin Pitis wrote:
> Hel= lo
>
> I installed PostgreSQL 8.0 on Windows and I can connect = from localhost=20
> only. How can I configure the server to allow connection from othe= r
> machines?
>
> Thank you
> Catalin
Under
S= tart-> Programs->PostgreSQLXX->Configuration files
postgresql.c= onf
pg_hba.conf

Are the 2 files I modified.  Please be aw= are my settings are for a dev
box and are WIDE OPEN AS SHOWN HERE this m= ight allow alot more people
connect than you want.

postgresql.con= f
# - Connection Settings -=20

listen_addresses =3D '*'       &= nbsp;# what IP address(es) to listen on;
     &= nbsp;           &nbs= p; # comma-separated list of addresses;
     &n= bsp;            = ; # defaults to 'localhost', '*' =3D all
port =3D 5432
max_connection= s =3D 100=20

pg_hba.conf
# TYPE  DATABASE    US= ER        CIDR-ADDRESS  &= nbsp;       METHOD

# IPv4 local c= onnections:
host    all     = ;    all         127.0.0.1/32          = ;md5
host    all      =    all         192.168.10.1/24     &= nbsp;    md5
# IPv6 local connections:
#host    all      &nb= sp;  all         ::1/128 =             &nb= sp; md5



------=_Part_10340_2918612.1146769200327-- ------=_Part_10339_27557252.1146769200327 Content-Type: application/octet-stream; name="pg_hba.conf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="pg_hba.conf" X-Attachment-Id: f_emtgqt39 IyBQb3N0Z3JlU1FMIENsaWVudCBBdXRoZW50aWNhdGlvbiBDb25maWd1cmF0aW9uIEZpbGUNCiMg PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQojDQoj IFJlZmVyIHRvIHRoZSBQb3N0Z3JlU1FMIEFkbWluaXN0cmF0b3IncyBHdWlkZSwgY2hhcHRlciAi Q2xpZW50DQojIEF1dGhlbnRpY2F0aW9uIiBmb3IgYSBjb21wbGV0ZSBkZXNjcmlwdGlvbi4gIEEg c2hvcnQgc3lub3BzaXMNCiMgZm9sbG93cy4NCiMNCiMgVGhpcyBmaWxlIGNvbnRyb2xzOiB3aGlj aCBob3N0cyBhcmUgYWxsb3dlZCB0byBjb25uZWN0LCBob3cgY2xpZW50cw0KIyBhcmUgYXV0aGVu dGljYXRlZCwgd2hpY2ggUG9zdGdyZVNRTCB1c2VyIG5hbWVzIHRoZXkgY2FuIHVzZSwgd2hpY2gN CiMgZGF0YWJhc2VzIHRoZXkgY2FuIGFjY2Vzcy4gIFJlY29yZHMgdGFrZSBvbmUgb2YgdGhlc2Ug Zm9ybXM6DQojDQojIGxvY2FsICAgICAgREFUQUJBU0UgIFVTRVIgIE1FVEhPRCAgW09QVElPTl0N CiMgaG9zdCAgICAgICBEQVRBQkFTRSAgVVNFUiAgQ0lEUi1BRERSRVNTICBNRVRIT0QgIFtPUFRJ T05dDQojIGhvc3Rzc2wgICAgREFUQUJBU0UgIFVTRVIgIENJRFItQUREUkVTUyAgTUVUSE9EICBb T1BUSU9OXQ0KIyBob3N0bm9zc2wgIERBVEFCQVNFICBVU0VSICBDSURSLUFERFJFU1MgIE1FVEhP RCAgW09QVElPTl0NCiMNCiMgKFRoZSB1cHBlcmNhc2UgaXRlbXMgbXVzdCBiZSByZXBsYWNlZCBi eSBhY3R1YWwgdmFsdWVzLikNCiMNCiMgVGhlIGZpcnN0IGZpZWxkIGlzIHRoZSBjb25uZWN0aW9u IHR5cGU6ICJsb2NhbCIgaXMgYSBVbml4LWRvbWFpbiBzb2NrZXQsDQojICJob3N0IiBpcyBlaXRo ZXIgYSBwbGFpbiBvciBTU0wtZW5jcnlwdGVkIFRDUC9JUCBzb2NrZXQsICJob3N0c3NsIiBpcyBh bg0KIyBTU0wtZW5jcnlwdGVkIFRDUC9JUCBzb2NrZXQsIGFuZCAiaG9zdG5vc3NsIiBpcyBhIHBs YWluIFRDUC9JUCBzb2NrZXQuDQojDQojIERBVEFCQVNFIGNhbiBiZSAiYWxsIiwgInNhbWV1c2Vy IiwgInNhbWVncm91cCIsIGEgZGF0YWJhc2UgbmFtZSwgb3INCiMgYSBjb21tYS1zZXBhcmF0ZWQg bGlzdCB0aGVyZW9mLg0KIw0KIyBVU0VSIGNhbiBiZSAiYWxsIiwgYSB1c2VyIG5hbWUsIGEgZ3Jv dXAgbmFtZSBwcmVmaXhlZCB3aXRoICIrIiwgb3INCiMgYSBjb21tYS1zZXBhcmF0ZWQgbGlzdCB0 aGVyZW9mLiAgSW4gYm90aCB0aGUgREFUQUJBU0UgYW5kIFVTRVIgZmllbGRzDQojIHlvdSBjYW4g YWxzbyB3cml0ZSBhIGZpbGUgbmFtZSBwcmVmaXhlZCB3aXRoICJAIiB0byBpbmNsdWRlIG5hbWVz IGZyb20NCiMgYSBzZXBhcmF0ZSBmaWxlLg0KIw0KIyBDSURSLUFERFJFU1Mgc3BlY2lmaWVzIHRo ZSBzZXQgb2YgaG9zdHMgdGhlIHJlY29yZCBtYXRjaGVzLg0KIyBJdCBpcyBtYWRlIHVwIG9mIGFu IElQIGFkZHJlc3MgYW5kIGEgQ0lEUiBtYXNrIHRoYXQgaXMgYW4gaW50ZWdlcg0KIyAoYmV0d2Vl biAwIGFuZCAzMiAoSVB2NCkgb3IgMTI4IChJUHY2KSBpbmNsdXNpdmUpIHRoYXQgc3BlY2lmaWVz DQojIHRoZSBudW1iZXIgb2Ygc2lnbmlmaWNhbnQgYml0cyBpbiB0aGUgbWFzay4gIEFsdGVybmF0 aXZlbHksIHlvdSBjYW4gd3JpdGUNCiMgYW4gSVAgYWRkcmVzcyBhbmQgbmV0bWFzayBpbiBzZXBh cmF0ZSBjb2x1bW5zIHRvIHNwZWNpZnkgdGhlIHNldCBvZiBob3N0cy4NCiMNCiMgTUVUSE9EIGNh biBiZSAidHJ1c3QiLCAicmVqZWN0IiwgIm1kNSIsICJjcnlwdCIsICJwYXNzd29yZCIsDQojICJr cmI0IiwgImtyYjUiLCAiaWRlbnQiLCBvciAicGFtIi4gIE5vdGUgdGhhdCAicGFzc3dvcmQiIHNl bmRzIHBhc3N3b3Jkcw0KIyBpbiBjbGVhciB0ZXh0OyAibWQ1IiBpcyBwcmVmZXJyZWQgc2luY2Ug aXQgc2VuZHMgZW5jcnlwdGVkIHBhc3N3b3Jkcy4NCiMNCiMgT1BUSU9OIGlzIHRoZSBpZGVudCBt YXAgb3IgdGhlIG5hbWUgb2YgdGhlIFBBTSBzZXJ2aWNlLCBkZXBlbmRpbmcgb24gTUVUSE9ELg0K Iw0KIyBEYXRhYmFzZSBhbmQgdXNlciBuYW1lcyBjb250YWluaW5nIHNwYWNlcywgY29tbWFzLCBx dW90ZXMgYW5kIG90aGVyIHNwZWNpYWwNCiMgY2hhcmFjdGVycyBtdXN0IGJlIHF1b3RlZC4gUXVv dGluZyBvbmUgb2YgdGhlIGtleXdvcmRzICJhbGwiLCAic2FtZXVzZXIiIG9yDQojICJzYW1lZ3Jv dXAiIG1ha2VzIHRoZSBuYW1lIGxvc2UgaXRzIHNwZWNpYWwgY2hhcmFjdGVyLCBhbmQganVzdCBt YXRjaCBhDQojIGRhdGFiYXNlIG9yIHVzZXJuYW1lIHdpdGggdGhhdCBuYW1lLg0KIw0KIyBUaGlz IGZpbGUgaXMgcmVhZCBvbiBzZXJ2ZXIgc3RhcnR1cCBhbmQgd2hlbiB0aGUgcG9zdG1hc3RlciBy ZWNlaXZlcw0KIyBhIFNJR0hVUCBzaWduYWwuICBJZiB5b3UgZWRpdCB0aGUgZmlsZSBvbiBhIHJ1 bm5pbmcgc3lzdGVtLCB5b3UgaGF2ZQ0KIyB0byBTSUdIVVAgdGhlIHBvc3RtYXN0ZXIgZm9yIHRo ZSBjaGFuZ2VzIHRvIHRha2UgZWZmZWN0LiAgWW91IGNhbiB1c2UNCiMgInBnX2N0bCByZWxvYWQi IHRvIGRvIHRoYXQuDQoNCiMgUHV0IHlvdXIgYWN0dWFsIGNvbmZpZ3VyYXRpb24gaGVyZQ0KIyAt LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQojDQojIElmIHlvdSB3YW50IHRvIGFs bG93IG5vbi1sb2NhbCBjb25uZWN0aW9ucywgeW91IG5lZWQgdG8gYWRkIG1vcmUNCiMgImhvc3Qi IHJlY29yZHMuIEluIHRoYXQgY2FzZSB5b3Ugd2lsbCBhbHNvIG5lZWQgdG8gbWFrZSBQb3N0Z3Jl U1FMIGxpc3Rlbg0KIyBvbiBhIG5vbi1sb2NhbCBpbnRlcmZhY2UgdmlhIHRoZSBsaXN0ZW5fYWRk cmVzc2VzIGNvbmZpZ3VyYXRpb24gcGFyYW1ldGVyLA0KIyBvciB2aWEgdGhlIC1pIG9yIC1oIGNv bW1hbmQgbGluZSBzd2l0Y2hlcy4NCiMNCg0KDQoNCiMgVFlQRSAgREFUQUJBU0UgICAgVVNFUiAg ICAgICAgQ0lEUi1BRERSRVNTICAgICAgICAgIE1FVEhPRA0KDQojIElQdjQgbG9jYWwgY29ubmVj dGlvbnM6DQpob3N0ICAgIGFsbCAgICAgICAgIGFsbCAgICAgICAgIDEyNy4wLjAuMS8zMiAgICAg ICAgICBtZDUNCmhvc3QgICAgYWxsICAgICAgICAgYWxsICAgICAgICAgMTkyLjE2OC4wLjEvMTky ICAgICAgICAgIG1kNQ0KDQojIElQdjYgbG9jYWwgY29ubmVjdGlvbnM6DQo= ------=_Part_10339_27557252.1146769200327--