Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2705313364DE for ; Thu, 7 Apr 2011 16:05:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 18836-08 for ; Thu, 7 Apr 2011 19:05:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 26CC71337BD2 for ; Thu, 7 Apr 2011 16:05:25 -0300 (ADT) Received: by vxi39 with SMTP id 39so2193467vxi.19 for ; Thu, 07 Apr 2011 12:05:25 -0700 (PDT) Received: by 10.52.0.130 with SMTP id 2mr1878449vde.180.1302203125397; Thu, 07 Apr 2011 12:05:25 -0700 (PDT) Received: from sidon.consistentstate.com (173-164-51-9-colorado.hfc.comcastbusiness.net [173.164.51.9]) by mx.google.com with ESMTPS id dm9sm477715vdb.19.2011.04.07.12.05.23 (version=SSLv3 cipher=OTHER); Thu, 07 Apr 2011 12:05:24 -0700 (PDT) Message-ID: <4D9E0B35.3060402@consistentstate.com> Date: Thu, 07 Apr 2011 13:06:29 -0600 From: Brian Fehrle User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> <4D9DFAB2.2080902@consistentstate.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201104/18 X-Sequence-Number: 4180 Is it trying to access /srv/httpd/htdocs/cms/ but your directory is at /srv/httpd/htdocs/cmsms/ by chance? On 04/07/2011 12:59 PM, Rich Shepard wrote: > On Thu, 7 Apr 2011, Brian Fehrle wrote: > >> These should let you see the connection information from the perspective >> of the database. > > Ah, I was looking at the wrong log file. Messages are in > /var/log/httpd/error_log: > > [Thu Apr 07 11:13:43 2011] [error] [client 127.0.0.1] File does not > exist: > /srv/httpd/htdocs/cms > [Thu Apr 07 11:51:11 2011] [error] [client 127.0.0.1] File does not > exist: > /srv/httpd/htdocs/cms > > From the access_log: > > 127.0.0.1 - - [07/Apr/2011:11:13:43 -0700] "GET /cms/index.php > HTTP/1.1" 404 211 > 127.0.0.1 - - [07/Apr/2011:11:51:11 -0700] "GET /cms/index.php > HTTP/1.1" 404 211 > > Yet: > > drwxr-xr-x 11 rshepard users 4096 Apr 5 16:45 cmsms/ > > and: > > I do see the Joomla-R-Us page, but neither a green "OK" nor an error > message; just the page with the script > > -rwxr-xr-x 1 rshepard users 22077 Apr 7 09:54 postgresql.php > > 127.0.0.1 - - [07/Apr/2011:11:54:56 -0700] "GET /postgresql.php > HTTP/1.1" 200 220 > > Rich >