Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3D559475843 for ; Fri, 20 Sep 2002 18:43:40 -0400 (EDT) Received: from mx05.gis.net (mx05.gis.net [208.218.130.13]) by postgresql.org (Postfix) with ESMTP id EA6BD476DDC for ; Fri, 20 Sep 2002 18:43:37 -0400 (EDT) Received: from shell.gis.net ([208.218.129.18]) by mx05.gis.net; Fri, 20 Sep 2002 18:42:33 -0400 Date: Fri, 20 Sep 2002 18:37:55 -0400 (EDT) From: Chadwick Rolfs To: Warren Massengill Cc: hierophant@pcisys.net, pgsql-php@postgresql.org Subject: Re: form response In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/47 X-Sequence-Number: 1502 Sorry if this is repeating info you have already posted, but how about php.ini? Is the pgsql.so extension in there? That's the important part. You can have php/apache/postgresql, but it seems like your problem is with php/postgresql, not php/apache. If phpinfo works, then it's definitley not apache. This is what's at the very end of my php.ini file: extension=pgsql.so It was added by Debian, but you can do it manually:) If you are sure you have the pgsql extension (which you may need to download seperately), and have this line in php.ini, and restart apache. Then we may have a problem. On Fri, 20 Sep 2002, Warren Massengill wrote: > >From: Keary Suska > >To: Postgres-PHP > >Subject: Re: [PHP] form response > >Date: Thu, 19 Sep 2002 22:59:14 -0600 > > > >on 9/19/02 5:52 PM, warrenmassengill@hotmail.com purportedly said: > > > > > In: > > > /etc/httpd/conf/httpd.conf > > > AddType application/x-httpd-php .php > > > (appears as above plus an entry for each of php2,3,&4) > > > LoadModule php4_module modules/libphp4.so > > > LoadModule php_module modules/mod_php.so > > > > > > These were all uncommented in the generic installation of RedHat 7.2. > > > Where else can I look? > > > > > > I can create forms in php and tables in PostgreSQL but according to > > > phpinfo(), php is not configured for PostgreSQL. > > > If I survive this problem, that one is on the horizon. > > > >Hmm, if the above directives appear in your conf in that order I think that > >is the problem. I am surprised that Apache isn't croaking with an error, > >since the module may need to be loaded before Apache understands what to do > >with x-httpd-php. That may not truly be the case, but it does seem suspect. > >What happens when you move the AddType to below the AddModule? > > No, I reversed the sequence. These directives are at the very bottom, > under the caption 'Document Type' in 'Section 2 - Main Server Environment'. > > > AddType application/x-httpd-php .php .php4 .php3 .phtml > AddType application/x-httpd-php-source .phps > > > 'Section 1 - Global Environment' contains the modules under the caption > 'Dynamic Shared Object' > > Do the Apache > >error logs have anything to say? > > They reflect my manually stopping and restarting Apache - and do indicate > that PHP is running. > > Do these directives appear in a context > >(such as ? > > Yes. See above. > > How are you accessing phpinfo() if PHP scripts don't > >execute? > > That is strange! I cannot access phpinfo() inside a php file > (not from Mozilla nor from a terminal window) but I did run it > directly from inside Mozilla - not sure how, now. Remember, Mozilla > runs the PHP form script and produces the form. It only breaks down > when I try to call a PHP script from inside another script. > > >Are you *sure* you built PHP as a module and *not* as a cgi? > > No. I did not build PHP at all. I did not even select it. RedHat > just included it with Apache. > -Chadwick