Re: mySQL installation

Subject: Re: mySQL installation
From: Chuq Von Rospach (chuqui@plaidworks.com)
Date: Mon Sep 11 2000 - 23:29:29 MDT

At 11:33 PM -0500 9/11/00, Gawain Reifsnyder wrote:
>Now I'm moving on to php. Gulp.
>
>I'd like to install it as an apache module, and I'm scouring the
>docs and coming up with some questions...

Make sure you install the current release (4.0.2, I think). anything
older than about a week has a bug that prevents it from compiling on
PPC machines. Which is why some of us go directly to the sources and
not source RPM's -- because we track the release, not when someone
gets the RPM packaged...

> I've just downloaded 4.0.2 but haven't installed it yet. I read in
>an earlier post that YDL doesn't come with a version of php that can
>recognize mySQL.

simple: configure --with-mysql

>If I upgrade, do I have to download and recompile and reconfigure
>apache too, or can I install it over my existing php3 installation?

I *think* you can install over. you might need to tweak httpd.conf. I
went and rebuilt the entire beast from scratch using DSO's for
mod_perl and php, and once I got it working, it made life easier, but
getting the first version of everything running right can be fun.

basically, I create an apache/ subdir in /usr/local/src, and put
apache, mod_perl (1.24) and php (4.0.2) in there.

I configure apache with:

./configure --prefix=/home/httpd --sbindir=/usr/sbin \
         --libexecdir=/usr/lib/apache \
         --runtimedir=/var/run --cgidir=/home/httpd/cgi-bin \
         --htdocsdir=/home/httpd/html --logfiledir=/var/log/httpd \
         --enable-module=most --enable-shared=max \
         --enable-suexec --suexec-caller=1025 --suexec-uidmin=1 \
         --suexec-gidmin=1

(your mileage WILL VARY!)

mod_perl with:

perl Makefile.PL \
     USE_APXS=1 \
     WITH_APXS=/usr/sbin/apxs \
     EVERYTHING=1

and php with:

./configure --with-mysql --with-apxs=/usr/sbin/apxs

(you might need to point it at mysql, too, the way I did apxs)

then you run makes and make installs all over the place, and
eventually, it all works.

wee hope... 

-- 
Chuq Von Rospach - Plaidworks Consulting (mailto:chuqui@plaidworks.com)
Apple Mail List Gnome (mailto:chuq@apple.com)

And they sit at the bar and put bread in my jar
and say 'Man, what are you doing here?'"

This archive was generated by hypermail 2a24 : Mon Sep 11 2000 - 23:35:12 MDT