mysql_install

[Pat Lashley]

--On Tuesday, August 26, 2003 21:06:13 -0600 Greg Magnusson 
<glm at cyborgspiders.com> wrote:

> re:  ports system
>
> ...
>
>    My current intention is to create a simplified installation procedure
> for FreeBSD - MySQL - Apache and PHP.  I have attempted 42 installations
> to date without success.  I have had FreeBSD and Apache working, but I
> have yet to have MySQL working standalone.....    Is there a port that
> installs Apache-PHP and MySQL?
>    Is there an easy way to install the above system with libmcrypt, open
> + mod_ssl?    I have been using the pkg_add system for other
> applications, and it is a nice system.  What I have been dreaming about
> is a simplified system of installing a FreeBSD-Apache-PHP-MySQL server.
> If this port exists, please advise.  I am ready to hear about an easy way
> of doing this.

This is really more of a question for -ports...

The simple answer is, yes, the ports system can do this easily.
You may have to set some make variables to get the combination
that you want though.

The PHP port (when run interactively) normally brings up a menu
of the various options.  The default choices are controlled by
/usr/ports/lang/php4/scripts/php4_options.  You can copy that
file into the homedir of the user you are building the port as
(probably root); and modify it to set the choices you like.

One of the many advantages of using the portupgrade port instead
of 'make install' in the individual ports is that you can also set
additional per-port make options in the /usr/local/etc/pkgtools.conf
file.  Check each port's Makefile for available knobs.

With those in place, the ports dependancy handling works pretty
well to build everything and set up minimal default configuration.

If you want similar installations on multiple systems, 'portinstall
--recursive --upward-recursive --package ...' will build binary
packages with your options.  You'll probably also want to make a
set of config file templates with your site's customizations.

I have never had the slightest problem installing mysql from a port.
(Note that after a port-based install, you will still have to set
a mysql root-user password if you want to protect your database.)



--Pat