On Tue, 2003-11-18 at 18:28, Barry C.Hawkins wrote:
> On Nov 18, 2003, at 5:07 PM, Bengt Hammarlin wrote:
>
> > This is getting interesting. It has mysql libraries installed, I must
> > be
> > dreaming...
> > Any idea?
> >
> > Bengt
> >
> > On Tue, 2003-11-18 at 15:04, Barry C.Hawkins wrote:
> >> On Nov 18, 2003, at 2:51 PM, Bengt Hammarlin wrote:
> >>
> >>> Thanx Barry,
> >>> but, that did not help at all. The pg_pconnect() function is still
> >>> undefined.
> >>>
> >>> Bengt
> >>>
> >>> On Mon, 2003-11-17 at 14:40, Barry C.Hawkins wrote:
> >>>> On Nov 16, 2003, at 8:51 PM, Bengt Hammarlin wrote:
> >>>>
> >>>>> This is what I do:
> >>>>>
> >>>>> cd httpd-2.0.48/ (apache)
> >>>>> configure
> >>>>> make
> >>>>> cd ../postgresql-7.3.4/
> >>>>> configure
> >>>>> make
> >>>>> make install
> >>>>> cd ../php-4.3.4/
> >>>>> ./configure --with-apxs2=/usr/local/apache2/bin/apxs
> >>>>> --with-postgres
> >>>>> make
> >>>>> make install
> >>>>> libtool --finish {path}/php-4.3.4/libs
> >>>>>
> >>>>> Then I tar up /usr/local/apache2 and copy to my target machine that
> >>>>> does
> >>>>> not have compilers and stuff.
> >>>>> for good measure i toss in /usr/local/postgres as well
> >>>>>
> >>>>> When trying my page (that works well in a install-from-an-old-RH-CD
> >>>>> environment) I get
> >>>>> Fatal error: Call to undefined function: pg_pconnect() in
> >>>>> {other-path}/connect_db.php on line
> >>>>>
> >>>>> I would very much appreciate some good advice.
> >>>>>
> >>>>> Bengt Hammarlin
> >>>>>
> >>>>>
> >>>>>
> >>>> Bengt,
> >>>> It looks like you might not have the PostgreSQL configure switch
> >>>> correct. If you issue:
> >>>>
> >>>> $>./configure --help > phpConfigOptions.txt
> >>>>
> >>>> and search through the text of that file that is produced, you will
> >>>> find:
> >>>>
> >>>> --with-pgsql[=DIR] Include PostgreSQL support. DIR is the
> >>>> PostgreSQL
> >>>> base install directory, defaults to
> >>>> /usr/local/pgsql.
> >>>>
> >>>> I used that and my PostgeSQL support is working.
> >>>>
> >>>> Best wishes,
> >>>
> >> Bengt,
> >> Have you tried looking at the results of phpinfo() to see if the
> >> library information matches up with you PostgreSQL installation?
> >> Maybe
> >> that would provide some info.
> >>
> >> Regards,
> >> --
> >> Barry C. Hawkins
> >> All Things Computed
> >> site: www.allthingscomputed.com
> >> weblog: www.yepthatsme.com
> >>
> >>
> >
> >
> >
> >
>
> What distro and version of Linux are you running?
I am running Mandrake 9.0
>
> Are you able to connect to PostgreSQL with the psql utility?
>
> I believe that specifying --with-pgsql without the =[DIR] (defaults to
> /usr/local/pgsql) causes PHP to use its included client libraries for
> PostgreSQL similar to MySQL, but I am not certain of that.
I tried with and without specifying [DIR] with no difference whatsoever
Thanx a bunch for trying to help me figure this out
Bengt
