pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stuart <sfbarbee@yahoo.com>
To: chris smith <dmagick@gmail.com>
Cc: pgsql-php@postgresql.org, "Horacio Degiorgi" <horaciod@gmail.com>
Subject: Re: SOLVED Apache 2.2 w/ PHP 5.1.2 and PostGreSQL 8.1
Date: Tue, 7 Mar 2006 14:56:12 -0500
Message-ID: <200603071456.12586.sfbarbee@yahoo.com> (raw)
In-Reply-To: <3c1395330603042225x54336003rded9dce3d74df80c@mail.gmail.com>
References: <200603042021.32418.sfbarbee@yahoo.com>
	<3c1395330603042225x54336003rded9dce3d74df80c@mail.gmail.com>

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 <sfbarbee@yahoo.com> 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/



Message-ID: <200603071456.12586.sfbarbee@yahoo.com>
Permalink:  ../200603071456.12586.sfbarbee@yahoo.com/
Also on:    postgresql.org/message-id/200603071456.12586.sfbarbee@yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: sfbarbee@yahoo.com, dmagick@gmail.com, horaciod@gmail.com
  Subject: Re: SOLVED Apache 2.2 w/ PHP 5.1.2 and PostGreSQL 8.1
  In-Reply-To: <200603071456.12586.sfbarbee@yahoo.com>
  References: <200603042021.32418.sfbarbee@yahoo.com> <3c1395330603042225x54336003rded9dce3d74df80c@mail.gmail.com> <200603071456.12586.sfbarbee@yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox