X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4D3139DCC7C for ; Tue, 7 Mar 2006 15:56:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15872-03 for ; Tue, 7 Mar 2006 15:56:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp110.plus.mail.re2.yahoo.com (smtp110.plus.mail.re2.yahoo.com [206.190.53.35]) by postgresql.org (Postfix) with SMTP id 5573A9DCBD5 for ; Tue, 7 Mar 2006 15:56:10 -0400 (AST) Received: (qmail 77715 invoked from network); 7 Mar 2006 19:56:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:From:Reply-To:To:Subject:Date:User-Agent:Cc:References:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id; b=4GNETKs97VfTZ7ZKV79g02z+KT354D8ZecvzfgRrPcV1XwZPNczPoshKU0NoqUddzaIGX2Xo7abY1owaYsFnNWs4AOUJ4GST97PcVwV734WTgiTgMzrs6Xs1rCeXo8ubLR1APpduA7vAnMqbT6XMQ/lOg6mj1qqiRYqS2022ohk= ; Received: from unknown (HELO ?192.168.0.10?) (sfbarbee@71.70.221.255 with plain) by smtp110.plus.mail.re2.yahoo.com with SMTP; 7 Mar 2006 19:56:10 -0000 From: Stuart Reply-To: sfbarbee@yahoo.com To: "chris smith" Subject: Re: SOLVED Apache 2.2 w/ PHP 5.1.2 and PostGreSQL 8.1 Date: Tue, 7 Mar 2006 14:56:12 -0500 User-Agent: KMail/1.9.1 Cc: pgsql-php@postgresql.org, "Horacio Degiorgi" References: <200603042021.32418.sfbarbee@yahoo.com> <3c1395330603042225x54336003rded9dce3d74df80c@mail.gmail.com> In-Reply-To: <3c1395330603042225x54336003rded9dce3d74df80c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603071456.12586.sfbarbee@yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/5 X-Sequence-Number: 3455 Folks, After looking through the log files, I found that Novell's Apparmor (using the SubDomain package) was rejecting Apache's requests to access the directory where php stores its shared modules. These errors showed up in /var/log/messages, but not in the php or apache log. kernel: SubDomain: REJECTING r access to /etc/php5/conf.d (httpd2-prefork(7576) profile /usr/sbin/httpd2-prefork active /usr/sbin/httpd2-prefork) ... kernel: SubDomain: REJECTING r access to /usr/lib64/php5/extensions/pgsql.so (httpd2-prefork(10857) profile /usr/sbin/httpd2-prefork active /usr/sbin/httpd2-prefork) ... kernel: SubDomain: REJECTING w access to /tmp/.s.PGSQL.5432 (httpd2-prefork(11309) profile /usr/sbin/httpd2-prefork active /usr/sbin/httpd2-prefork) Once I authorized the application to access those directories and files, all worked well -- sort of, but that's another problem. Thanks for the input, Stuart On Sunday 05 March 2006 01:25, chris smith wrote: > On 3/5/06, Stuart wrote: > > Folks, > > > > I recently upgraded to Apache 2.2 w/ PHP 5.1.2 to connect to my > > PostGreSQL 8.1 databases on a SuSE 10.0 system. I used the rpm's > > provided by SuSE to install the Apache and PHP packages . Apache works > > fine and phpinfo() shows all the normal info except the section on > > additional modules is empty. I am not sure if this is normal. > > > > I get the following error and cannot figure out why pgsql module is not > > loading. > > > > PHP Fatal error: Call to undefined function pg_connect() > > That means php doesn't know what pg_connect is. > > See if you need to install a php-pgsql rpm, then restart apache (it > should show "postgresql" in the phpinfo page now). > > -- > Postgresql & php tutorials > http://www.designmagick.com/