From warrenmassengill@hotmail.com Thu Sep 19 23:52:43 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 97C92475E14 for ; Thu, 19 Sep 2002 19:52:43 -0400 (EDT) Received: from hotmail.com (f127.law15.hotmail.com [64.4.23.127]) by postgresql.org (Postfix) with ESMTP id 07029475D64 for ; Thu, 19 Sep 2002 19:52:43 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 19 Sep 2002 16:52:45 -0700 Received: from 205.188.209.107 by lw15fd.law15.hotmail.msn.com with HTTP; Thu, 19 Sep 2002 23:52:45 GMT X-Originating-IP: [205.188.209.107] From: "Warren Massengill" To: pgsql-php@postgresql.org Subject: form response Date: Thu, 19 Sep 2002 18:52:45 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 19 Sep 2002 23:52:45.0976 (UTC) FILETIME=[A6EC3180:01C26037] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/44 X-Sequence-Number: 1499 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. Thanks, Warren Keary Suska Wed, 18 Sep 2002 18:43:12 -0600 on 9/18/02 5:17 PM, warrenmassengill@hotmail.com purportedly said: >RedHat 7.2 RPM with PostgreSQL 7.1.x and PHP 4.0.6 > >Page 111 of PHP and PostgreSQL, this form displays in Mozilla. The submit >button is expected to run a script called reaction.php but it opens the >script and displays the code. The response is the same with or without >variable input. > >I changed the script file to executable: no effect. > >I can run 'reaction.php' from the shell and it works. >What is the problem here? Apache is not configured properly to recognize the .php extension. Look at the installation instructions for the AddType directives you must have. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" --------------------------------- form --------------------------------------------------------------- A Simple Form



------------- Reaction.php ------------------------------------------------------------ Reaction.php ---------------------- run as stand alone php ------------------------------------------------------------ bash-2.05$ php < reaction.php X-Powered-By: PHP/4.0.6 Content-type: text/html nothing has been passed to this script -------------------------------------------------------------- _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx From hierophant@pcisys.net Fri Sep 20 04:59:55 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9187D4764A8 for ; Fri, 20 Sep 2002 00:59:55 -0400 (EDT) Received: from marsha.pcisys.net (marsha.pcisys.net [216.229.32.146]) by postgresql.org (Postfix) with ESMTP id AF8AD475BC3 for ; Fri, 20 Sep 2002 00:59:54 -0400 (EDT) Received: from [216.229.45.53] (moe.rbe45-53.cos.pcisys.net [216.229.45.53]) by marsha.pcisys.net (8.12.5/8.12.5) with ESMTP id g8K4xE7V025978 for ; Thu, 19 Sep 2002 22:59:14 -0600 (MDT) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Thu, 19 Sep 2002 22:59:14 -0600 Subject: Re: form response From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/45 X-Sequence-Number: 1500 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? Do the Apache error logs have anything to say? Do these directives appear in a context (such as ? How are you accessing phpinfo() if PHP scripts don't execute? Are you *sure* you built PHP as a module and *not* as a cgi? Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" From warrenmassengill@hotmail.com Fri Sep 20 14:29:37 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 40464475CB4 for ; Fri, 20 Sep 2002 10:29:37 -0400 (EDT) Received: from hotmail.com (f115.law15.hotmail.com [64.4.23.115]) by postgresql.org (Postfix) with ESMTP id C76A0476E66 for ; Fri, 20 Sep 2002 10:29:35 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 20 Sep 2002 07:28:26 -0700 Received: from 205.188.209.7 by lw15fd.law15.hotmail.msn.com with HTTP; Fri, 20 Sep 2002 14:28:26 GMT X-Originating-IP: [205.188.209.7] From: "Warren Massengill" To: hierophant@pcisys.net Cc: pgsql-php@postgresql.org Subject: Re: form response Date: Fri, 20 Sep 2002 09:28:26 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 20 Sep 2002 14:28:26.0965 (UTC) FILETIME=[FBCAE050:01C260B1] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/46 X-Sequence-Number: 1501 >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. Thanks, Warren > >Keary Suska >Esoteritech, Inc. >"Leveraging Open Source for a better Internet" > > >---------------------------(end of broadcast)-------------------------- _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com From cmr@shell.gis.net Fri Sep 20 22:43:40 2002 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 From hierophant@pcisys.net Sun Sep 22 06:10:34 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 48CF4475F66 for ; Sun, 22 Sep 2002 02:10:34 -0400 (EDT) Received: from krusty.pcisys.net (krusty.pcisys.net [216.229.32.178]) by postgresql.org (Postfix) with ESMTP id 60EBC475F5F for ; Sun, 22 Sep 2002 02:10:33 -0400 (EDT) Received: from [216.229.45.65] (moe.rbe45-65.cos.pcisys.net [216.229.45.65]) by krusty.pcisys.net (8.12.5/8.12.5) with ESMTP id g8M6AVhN025330 for ; Sun, 22 Sep 2002 00:10:32 -0600 (MDT) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Sun, 22 Sep 2002 00:10:32 -0600 Subject: Re: form response From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/48 X-Sequence-Number: 1503 on 9/20/02 8:28 AM, warrenmassengill@hotmail.com purportedly said: > > AddType application/x-httpd-php .php .php4 .php3 .phtml > AddType application/x-httpd-php-source .phps > How about removing the IfModule? Also, you should check to make sure that the PHP module is where the conf thinks it is, and remove the duplicate LoadModule (keeping whichever is accurate) from: > > LoadModule php4_module modules/libphp4.so > > LoadModule php_module modules/mod_php.so If they both exist, there is possibly a conflict. Only PHP3 used "mod_php.so", IIRC. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"