From devi@informatika.lipi.go.id Tue Jan 18 10:20:19 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B10AA3A1CFE for ; Tue, 18 Jan 2005 10:20:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84279-05 for ; Tue, 18 Jan 2005 10:20:09 +0000 (GMT) Received: from proxy3.lipi.go.id (bima.lipi.go.id [202.155.39.180]) by svr1.postgresql.org (Postfix) with ESMTP id 8905B3A1AD8 for ; Tue, 18 Jan 2005 10:20:08 +0000 (GMT) Received: from kulo-bd.lipi.go.id (kulo-bd.lipi.go.id [192.168.225.27]) by proxy3.lipi.go.id (8.12.8/8.12.8) with SMTP id j0IABJM5003970 for ; Tue, 18 Jan 2005 17:11:20 +0700 Received: FROM informatika.lipi.go.id BY kulo-bd.lipi.go.id ; Tue Jan 18 17:23:28 2005 +0700 Received: (qmail 4303 invoked by uid 537); 18 Jan 2005 10:33:22 -0000 Received: from devi@informatika.lipi.go.id by informatika.lipi.go.id by uid 89 with qmail-scanner-1.22 (clamscan: 0.70. spamassassin: 2.63. Clear:RC:1(192.168.228.59):. Processed in 0.544218 secs); 18 Jan 2005 10:33:22 -0000 Received: from unknown (HELO Bukittinggi) (192.168.228.59) by 0 with SMTP; 18 Jan 2005 10:33:21 -0000 Message-ID: <01e701c4fd47$95e47820$3be4a8c0@Bukittinggi> From: "Devi Munandar" To: Subject: can't remote access from client with ODBC Date: Tue, 18 Jan 2005 17:22:17 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01E4_01C4FD82.422DCC50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.329 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/187 X-Sequence-Number: 16046 This is a multi-part message in MIME format. ------=_NextPart_000_01E4_01C4FD82.422DCC50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We run Postgres7.3.2 on a OpenBSD34 I try to connect to the postgres database from winxp boxes using = postgres odbc driver ver. 7.02.00.05 and then create a user dsn and then use a Borland Delphi tool called = ODBCTest and try but i get message "FATAL : no pg_hba.conf entry for host 192.168.228.59 = user postgres database template1". and than try to edit pg_hba.conf and = added command "host template1 postgres 192.168.228.59 = 255.255.255.0 trust" but still doesn't work. so I missed something = with ODBC? =20 dv ------=_NextPart_000_01E4_01C4FD82.422DCC50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
We run Postgres7.3.2 on a OpenBSD34
 I try to connect to = the=20 postgres database from winxp boxes using postgres odbc driver ver.=20 7.02.00.05
and then create a user dsn and = then use a=20 Borland Delphi tool called ODBCTest and try
but i get message "FATAL=20 : no pg_hba.conf entry for host 192.168.228.59 user postgres = database=20 template1". and than try to edit pg_hba.conf  and added = command=20 "host      = template1     =20 postgres     192.168.228.59   &nb= sp;=20 255.255.255.0     trust" but still doesn't work. so = I missed=20 something with ODBC? 
 
dv

 
------=_NextPart_000_01E4_01C4FD82.422DCC50-- From Luc.Jouneau@jouy.inra.fr Tue Jan 18 10:35:27 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4EFE23A18AF for ; Tue, 18 Jan 2005 10:35:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86617-04 for ; Tue, 18 Jan 2005 10:35:12 +0000 (GMT) Received: from jais.jouy.inra.fr (jais.jouy.inra.fr [138.102.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 542C53A1AB5 for ; Tue, 18 Jan 2005 10:35:13 +0000 (GMT) Received: from jouy.inra.fr (localhost [127.0.0.1]) by jais.jouy.inra.fr (8.10.1/8.10.1) with ESMTP id j0IAZ8117831 for ; Tue, 18 Jan 2005 11:35:08 +0100 (CET) Received: from pc502jlo (pc502ljo [138.102.3.71]) by jouy.inra.fr (8.10.1/8.10.1) with SMTP id j0IAZ7i04236 for ; Tue, 18 Jan 2005 11:35:07 +0100 (CET) Message-ID: <006801c4fd49$61be06e0$4703668a@pc502jlo> From: "Jouneau Luc" To: References: <01e701c4fd47$95e47820$3be4a8c0@Bukittinggi> Subject: Re: can't remote access from client with ODBC Date: Tue, 18 Jan 2005 11:35:08 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0065_01C4FD51.C365BF20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.138 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE, MIME_BASE64_TEXT X-Spam-Level: X-Archive-Number: 200501/226 X-Sequence-Number: 16085 This is a multi-part message in MIME format. ------=_NextPart_000_0065_01C4FD51.C365BF20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: base64 SGksDQogZGlkIHlvdSBhc2tlZCB0aGUgc2VydmVyIHRvIHJlbG9hZCBjb25maWd1cmF0aW9uIGZp bGVzIHdpdGggYSByZXN0YXJ0IG9yIGEgInBnX2N0bCByZWxvYWQiID8NCmxqDQoNCiAgLS0tLS0g T3JpZ2luYWwgTWVzc2FnZSAtLS0tLSANCiAgRnJvbTogRGV2aSBNdW5hbmRhciANCiAgVG86IHBn c3FsLWFkbWluQHBvc3RncmVzcWwub3JnIA0KICBTZW50OiBUdWVzZGF5LCBKYW51YXJ5IDE4LCAy MDA1IDExOjIyIEFNDQogIFN1YmplY3Q6IFtBRE1JTl0gY2FuJ3QgcmVtb3RlIGFjY2VzcyBmcm9t IGNsaWVudCB3aXRoIE9EQkMNCg0KDQogIFdlIHJ1biBQb3N0Z3JlczcuMy4yIG9uIGEgT3BlbkJT RDM0DQogICBJIHRyeSB0byBjb25uZWN0IHRvIHRoZSBwb3N0Z3JlcyBkYXRhYmFzZSBmcm9tIHdp bnhwIGJveGVzIHVzaW5nIHBvc3RncmVzIG9kYmMgZHJpdmVyIHZlci4gNy4wMi4wMC4wNQ0KICBh bmQgdGhlbiBjcmVhdGUgYSB1c2VyIGRzbiBhbmQgdGhlbiB1c2UgYSBCb3JsYW5kIERlbHBoaSB0 b29sIGNhbGxlZCBPREJDVGVzdCBhbmQgdHJ5DQogIGJ1dCBpIGdldCBtZXNzYWdlICJGQVRBTCA6 IG5vIHBnX2hiYS5jb25mIGVudHJ5IGZvciBob3N0IDE5Mi4xNjguMjI4LjU5IHVzZXIgcG9zdGdy ZXMgZGF0YWJhc2UgdGVtcGxhdGUxIi4gYW5kIHRoYW4gdHJ5IHRvIGVkaXQgcGdfaGJhLmNvbmYg IGFuZCBhZGRlZCBjb21tYW5kICJob3N0ICAgICAgdGVtcGxhdGUxICAgICAgcG9zdGdyZXMgICAg IDE5Mi4xNjguMjI4LjU5ICAgICAyNTUuMjU1LjI1NS4wICAgICB0cnVzdCIgYnV0IHN0aWxsIGRv ZXNuJ3Qgd29yay4gc28gSSBtaXNzZWQgc29tZXRoaW5nIHdpdGggT0RCQz8gIA0KDQogIGR2DQoN Cg0K ------=_NextPart_000_0065_01C4FD51.C365BF20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu dD0idGV4dC9odG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDYuMDAuMjkwMC4yNTIzIiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT48L1NUWUxFPg0KPC9IRUFE Pg0KPEJPRFkgYmdDb2xvcj0jZmZmZmZmPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsPkhpLDwvRk9O VD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbD4mbmJzcDtkaWQgeW91IGFza2VkIHRoZSBz ZXJ2ZXIgdG8gcmVsb2FkIGNvbmZpZ3VyYXRpb24gDQpmaWxlcyB3aXRoIGEgcmVzdGFydCBvciBh ICJwZ19jdGwgcmVsb2FkIiA/PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsPmxq PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsPjwvRk9OVD4mbmJzcDs8L0RJVj4N CjxCTE9DS1FVT1RFIGRpcj1sdHIgDQpzdHlsZT0iUEFERElORy1SSUdIVDogMHB4OyBQQURESU5H LUxFRlQ6IDVweDsgTUFSR0lOLUxFRlQ6IDVweDsgQk9SREVSLUxFRlQ6ICMwMDAwMDAgMnB4IHNv bGlkOyBNQVJHSU4tUklHSFQ6IDBweCI+DQogIDxESVYgc3R5bGU9IkZPTlQ6IDEwcHQgYXJpYWwi Pi0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0gPC9ESVY+DQogIDxESVYgDQogIHN0eWxlPSJC QUNLR1JPVU5EOiAjZTRlNGU0OyBGT05UOiAxMHB0IGFyaWFsOyBmb250LWNvbG9yOiBibGFjayI+ PEI+RnJvbTo8L0I+IA0KICA8QSB0aXRsZT1kZXZpQGluZm9ybWF0aWthLmxpcGkuZ28uaWQgDQog IGhyZWY9Im1haWx0bzpkZXZpQGluZm9ybWF0aWthLmxpcGkuZ28uaWQiPkRldmkgTXVuYW5kYXI8 L0E+IDwvRElWPg0KICA8RElWIHN0eWxlPSJGT05UOiAxMHB0IGFyaWFsIj48Qj5Ubzo8L0I+IDxB IHRpdGxlPXBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnIA0KICBocmVmPSJtYWlsdG86cGdzcWwt YWRtaW5AcG9zdGdyZXNxbC5vcmciPnBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnPC9BPiA8L0RJ Vj4NCiAgPERJViBzdHlsZT0iRk9OVDogMTBwdCBhcmlhbCI+PEI+U2VudDo8L0I+IFR1ZXNkYXks IEphbnVhcnkgMTgsIDIwMDUgMTE6MjIgDQogIEFNPC9ESVY+DQogIDxESVYgc3R5bGU9IkZPTlQ6 IDEwcHQgYXJpYWwiPjxCPlN1YmplY3Q6PC9CPiBbQURNSU5dIGNhbid0IHJlbW90ZSBhY2Nlc3Mg ZnJvbSANCiAgY2xpZW50IHdpdGggT0RCQzwvRElWPg0KICA8RElWPjxCUj48L0RJVj4NCiAgPERJ Vj5XZSBydW4gUG9zdGdyZXM3LjMuMiBvbiBhIE9wZW5CU0QzNDxCUj4mbmJzcDtJIHRyeSB0byBj b25uZWN0IHRvIHRoZSANCiAgcG9zdGdyZXMgZGF0YWJhc2UgZnJvbSZuYnNwO3dpbnhwIGJveGVz IHVzaW5nIHBvc3RncmVzIG9kYmMgZHJpdmVyIHZlci4gDQogIDcuMDIuMDAuMDU8QlI+PEZPTlQg ZmFjZT1BcmlhbD5hbmQgdGhlbiZuYnNwO2NyZWF0ZSBhIHVzZXIgZHNuIGFuZCB0aGVuIHVzZSBh IA0KICBCb3JsYW5kIERlbHBoaSB0b29sIGNhbGxlZCBPREJDVGVzdCBhbmQgdHJ5PEJSPmJ1dCBp IGdldCBtZXNzYWdlICJGQVRBTCANCiAgOiZuYnNwO25vIHBnX2hiYS5jb25mIGVudHJ5IGZvciBo b3N0IDE5Mi4xNjguMjI4LjU5IHVzZXImbmJzcDtwb3N0Z3JlcyANCiAgZGF0YWJhc2UgdGVtcGxh dGUxIi4mbmJzcDthbmQgdGhhbiZuYnNwO3RyeSB0byBlZGl0IHBnX2hiYS5jb25mJm5ic3A7IGFu ZCANCiAgYWRkZWQgY29tbWFuZCAiaG9zdCZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAN CiAgdGVtcGxhdGUxJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KICBwb3N0Z3JlcyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzE5Mi4xNjguMjI4LjU5Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7IA0KICAyNTUuMjU1LjI1NS4wJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IHRydXN0 IiBidXQgc3RpbGwgZG9lc24ndCB3b3JrLiBzbyBJIA0KICBtaXNzZWQgc29tZXRoaW5nIHdpdGgg T0RCQz8mbmJzcDsgPC9GT05UPjwvRElWPg0KICA8RElWPjxGT05UIGZhY2U9QXJpYWw+PC9GT05U PiZuYnNwOzwvRElWPg0KICA8RElWPjxGT05UIGZhY2U9QXJpYWw+ZHY8L0ZPTlQ+PC9ESVY+DQog IDxESVY+PEJSPjwvRElWPg0KICA8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPjwvRk9OVD4m bmJzcDs8L0RJVj48L0JMT0NLUVVPVEU+PC9CT0RZPjwvSFRNTD4NCg== ------=_NextPart_000_0065_01C4FD51.C365BF20--