Re: [PHP] Some undefined function errors - Mailing list pgsql-general

From Ashley Sheridan
Subject Re: [PHP] Some undefined function errors
Date
Msg-id 1274372787.2202.136.camel@localhost
Whole thread Raw
In response to Re: [PHP] Some undefined function errors  (Giancarlo Boaron <gboaron@yahoo.com.br>)
Responses Re: [PHP] Some undefined function errors  (Ketema Harris <ketema@ketema.net>)
List pgsql-general
On Thu, 2010-05-20 at 09:21 -0700, Giancarlo Boaron wrote:
Hi Jim.

I think it depends on each server configuration but I checked in my server and I don't have the 'pgsql.so' and 'psql.ini' files and neither the 'www' directory.

My Apache version is 2.2.15 and my root directory is /usr/local/apache2/htdocs.

Thank you.


--- Em qui, 20/5/10, Jim Lucas <lists@cmsws.com> escreveu:

> De: Jim Lucas <lists@cmsws.com>
> Assunto: Re: [PHP] Some undefined function errors
> Para: "Giancarlo Boaron" <gboaron@yahoo.com.br>
> Cc: pgsql-general@postgresql.org, php-general@lists.php.net, pgsql-novice@postgresql.org
> Data: Quinta-feira, 20 de Maio de 2010, 13:04
> Giancarlo Boaron wrote:
> > Hi all.
> > 
> > Recently, I wrote an email about the problem I was
> having with some Postgres functions that when those
> functions were called, I received the following error: "Call
> to undefined function <function_name>".
> > 
> > After some answers, I decided to rebuild a brand new
> linux virtual machine with Apache + PHP + Postgres, but I
> still get this annoying error messege with some functions
> like pg_prepare() and pg_escape_string().
> > 
> > I compiled Postgres with --without-readline option.
> > I compiled PHP with
> --with-apxs2=/usr/local/apache2/bin/apxs and
> --with-pgsql=/usr/local/pgsql/
> > 
> > And the compilation process has no errors.
> > 
> > What am I doing wrong? Do I have to change something
> in php_config.h file? If so, what do I have to change?
> > 
> > Thank you.
> > 
> > 
> >       
> > 
> 
> Depending on what version of apache you are running, you
> need to make sure that
> you are loading the pgsql.so file or have the psql.ini file
> in your
> /var/www/conf/php5/ directory.
> 
> This way it knows to load pg.
> 
> -- 
> Jim Lucas
> 
>    "Some men are born to greatness, some
> achieve greatness,
>        and some have greatness
> thrust upon them."
> 
> Twelfth Night, Act II, Scene V
>     by William Shakespeare
> 

     


I've generally found these sorts of things to be in /etc/php, /etc/php5 or something similar. Within /etc you should see directories for both Apache and PHP. If you have shell access to the machine, try calling a whereis command, which might give you a better idea of where things are kept in your system.

Thanks,
Ash
http://www.ashleysheridan.co.uk


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How to lose transaction history (xmin values, WAL, etc.)?
Next
From: Jim Lucas
Date:
Subject: Re: [PHP] Some undefined function errors