X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 795FDD1DA83; Mon, 28 Jul 2003 16:08:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 00799-09; Mon, 28 Jul 2003 13:07:27 -0300 (ADT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id 41CADD1DA60; Mon, 28 Jul 2003 13:08:22 -0300 (ADT) Received: from sys2 (12-232-24-239.client.attbi.com[12.232.24.239](untrusted sender)) by attbi.com (rwcrmhc12) with SMTP id <20030728160818014002o1ohe>; Mon, 28 Jul 2003 16:08:18 +0000 Reply-To: From: "bruce" To: "'Rod Taylor'" Cc: , Subject: Re: [PHP] Accessing Postgres db from apache using PHP Date: Mon, 28 Jul 2003 09:13:27 -0700 Message-ID: <003201c35523$2e386510$0301a8c0@Mesa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <1059392845.8643.23.camel@jester> Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/207 X-Sequence-Number: 7742 Rod.... psql -V shows that I have a 7.2.2 version.... I did restart the postgres server by using the services GUI provided by RH... I'm not sure what "HUP" is!!!! I also have the "-i" added to the postgresql file which should permit TCP/IP connections.... This is most frustrating..as I'm pretty sure it's a simple issue...!!! Rod.... If you don't mind... What's your phone number... You seem to be reasonably knowledgeable... If we spoke, I might be able to get the proverbial light going off!! Thanks Bruce bedouglas@earthlink.net -----Original Message----- From: Rod Taylor [mailto:rbt@rbt.ca] Sent: Monday, July 28, 2003 4:47 AM To: bedouglas@earthlink.net Cc: pgsql-novice@postgresql.org; pgsql-php@postgresql.org Subject: RE: [PHP] Accessing Postgres db from apache using PHP > my pg_hba.conf looks like: > # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE > AUTH_ARGUMENT > > #local all trust > #host all 127.0.0.1 255.255.255.255 trust > > # Using sockets credentials for improved security. Not available everywhere, > # but works on Linux, *BSD (and probably some others) > > #local all ident sameuser > #local all trust > #host all 127.0.0.1 255.255.255.255 trust > #host template1 127.0.0.1 255.255.255.255 trust > host gforge 127.0.0.1 255.255.255.255 trust > > i've logged into the server as gforge, and tried to do the psql command > -> psql -h localhost gforge > > psql: FATAL 1: No pg_hba.conf entry for host 127.0.0.1, user gforge, > database gforge Your using a 7.2.x database or 7.3.x? The file segments you have shown look like the 7.2.x format but the error message looks like something you would get out of a 7.3.x database (7.3.x added a user portion). If 7.3.x, try: # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host gforge gforge 127.0.0.1 255.255.255.255 trust If 7.2.x, did you HUP or restart the server after making changes to the file?