Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 19 Aug 2004 11:57:33 -0400
From:      Rail mail <railmail@gmail.com>
To:        Randy Grafton <rgrafton@indatacorp.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: php postgres issues
Message-ID:  <c35bdefa040819085739c8e5df@mail.gmail.com>
In-Reply-To: <20040818201827.18923.qmail@mail.indatacorp.com>
References:  <c35bdefa040818094562fc2b74@mail.gmail.com> <20040818201827.18923.qmail@mail.indatacorp.com>

next in thread | previous in thread | raw e-mail | index | archive | help
is it a lost cause to: 

/usr/ports/lang/php4-extensions
make config (choose pgsql support)
apache restart
but still no support for postgres in php

perhaps there is some extra configuration I am missing

I changed my php.ini to incudle pgsql.so
http.config is set up to add the php module

users pages run php, but not the postgres API

my method for installing everything, in short, was:
make install apache13 port
make install mod_php4 port
(posgres already there)
apache rc script restart
(recently)
make config php4-extensions
make install php4-extensions
apache rc script restart
still no pg api ;(

thanks for any help
R.

On Wed, 18 Aug 2004 13:18:27 -0700, Randy Grafton
<rgrafton@indatacorp.com> wrote:
> I'm sorry to see you're having so much trouble. I've been using the
> apache-php-postgresql for some time now and wanted to compliment you on your
> choice as well as offer some help.
> 
> First, I would definitely recommend that you do everything, (or as much as
> you can) through the ports.
> Second, I strongly suggest that you start with a minimal installation. The
> packages are a great place to start for beginners but the ports are much
> more robust, flexible and CURRENT. The minimal install is available as a
> choice when performing an install.
> 
> Assuming that you have done a minimal install and therefore clearing any
> possible conflicts with other possibly outdated packages install the
> following items in the listed order:
> 
> 1. Apache. Your choice of version though I've heard that PHP may not be
> fully ready for the threading in Apache2. I've not experienced any problems
> with Apache2 and PHP5 or PHP4, so this is just a FYI.
> cd /usr/ports/www/apache13 or cd /usr/ports/www/apache2 and do 'make install
> clean'.
> 
> 2. PostgreSQL. Straight forward install here.
> cd /usr/ports/database/postgresql73 and do 'make install clean'
> I'm assuming that you aware of the requirement to do initdb as pgsql to
> initialize the databases after installation from the ports.
> 
> 3. PHP. If your curious about PHP5 then the steps get a little different and
> I list those next. As for PHP4 just cd /usr/ports/www/mod_php4 and do '
> make install clean'. The last time I ran this, and every time before, I was
> presented with a menu to select the options for PHP such as PostgreSQL, GD,
> PDFLib..., so you don't have to worry about command line defines.
> 
> PHP5, here you'll goto /usr/ports/lang/php5-extensions and do a 'make
> install clean'. Again the menu will pop up with php extension choices as
> stated above. Once this is done goto /usr/ports/www/mod_php5 and do 'make
> install clean'.
> 
> Obviouosly the above steps have been completed goto
> /usr/local/etc/apache/httpd.conf and make sure that you have the LoadModule
> and AddType lines in there for php.  Then goto /usr/local/etc/rc.d and run
> the apache and postgresql startup scripts with the 'start' command line
> option.
> 
> Let me know if you need more detail.
> 
>  -Randy
> 
> 
> 
> Rail mail writes:
> 
> > I am having issues with getting postgress extensions for php4
> >
> > do you have to configure it via ports/compiling or can you get away
> > with with just pkg_dd -r
> >
> > Iv'e tried
> >
> > pkg_add -r apache
> > pkg_add -r mod_php4
> >
> > and the ports way
> >
> > cd /usr/ports/www/mod_php4
> > make
> > cd work/php-4.3.8
> > ./configure --with-pgsql
> > cd ../../
> > make install
> >
> > and variations of that
> > I also thought that I might have wanted something from
> > lang/php4-extensions
> > make config
> > //choose pgsql
> > make install
> >
> > I havn't seemed to have any luck
> >
> > the ol sys admin already set up httpd.conf
> >
> > I was mucking around with php.ini trying to get it to use pgsql.so
> >
> > what is the best direction to take
> > I'd like to stick to packages or ports
> > I found tutorials on how to do it with rpms or tar.gz and do it by
> > hand, but freebsd has set up a nice system with ports and packages and
> > I would like to stick to that if I can
> >
> > thanks for any help
> > _______________________________________________
> > freebsd-questions@freebsd.org mailing list
> > http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
> 
>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c35bdefa040819085739c8e5df>