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 F0310D1C4B9; Mon, 28 Jul 2003 11:46:42 +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 81849-09; Mon, 28 Jul 2003 08:45:46 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 2C74AD1D722; Mon, 28 Jul 2003 08:46:38 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 72FD01024D; Mon, 28 Jul 2003 07:39:30 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-81.tor.dsl.tht.net [134.22.133.81]) by mailav.tor1.inquent.com (Postfix) with ESMTP id AA92310248; Mon, 28 Jul 2003 07:39:27 -0400 (EDT) Subject: Re: [PHP] Accessing Postgres db from apache using PHP From: Rod Taylor To: bedouglas@earthlink.net Cc: pgsql-novice@postgresql.org, pgsql-php@postgresql.org In-Reply-To: <000501c354c4$33708080$0301a8c0@Mesa.com> References: <000501c354c4$33708080$0301a8c0@Mesa.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-poV80NVIUrE+sey9m6Sq" Message-Id: <1059392845.8643.23.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 28 Jul 2003 07:47:26 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/266 X-Sequence-Number: 7801 --=-poV80NVIUrE+sey9m6Sq Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > my pg_hba.conf looks like: > # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE > AUTH_ARGUMENT >=20 > #local all trust > #host all 127.0.0.1 255.255.255.255 trust >=20 > # Using sockets credentials for improved security. Not available everywhe= re, > # but works on Linux, *BSD (and probably some others) >=20 > #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 >=20 > i've logged into the server as gforge, and tried to do the psql command > -> psql -h localhost gforge >=20 > 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? --=-poV80NVIUrE+sey9m6Sq Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/JQ1N6DETLow6vwwRAmtkAJ0bePQl+UuBDns4Uju37yOyzgh2BQCfdz/1 MhYOKbzy6lx/BObS7rdA478= =fgNE -----END PGP SIGNATURE----- --=-poV80NVIUrE+sey9m6Sq--