Re: SOLVED Apache 2.2 w/ PHP 5.1.2 and PostGreSQL 8.1

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(at)yahoo(dot)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/