From owner-freebsd-database@FreeBSD.ORG Tue Aug 26 20:33:10 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 458F016A4BF for ; Tue, 26 Aug 2003 20:33:10 -0700 (PDT) Received: from gate.volant.org (gate.volant.org [207.111.218.246]) by mx1.FreeBSD.org (Postfix) with ESMTP id 98D3F43FE5 for ; Tue, 26 Aug 2003 20:33:09 -0700 (PDT) (envelope-from patl+freebsd@volant.org) Received: from 64-144-229-193.client.dsl.net ([64.144.229.193] helo=[192.168.0.13]) by gate.volant.org with asmtp (TLSv1:DES-CBC3-SHA:168) (Exim 3.33 #1) id 19rr3M-000IdZ-00; Tue, 26 Aug 2003 20:33:00 -0700 Date: Tue, 26 Aug 2003 20:32:54 -0700 From: Pat Lashley To: Greg Magnusson , john@day-light.com Message-ID: <2097560000.1061955174@mccaffrey.phoenix.volant.org> In-Reply-To: <5.2.1.1.0.20030826203828.00a24470@mail.sasknow.com> References: <5.2.1.1.0.20030826000201.00a1b870@mail.sasknow.com> <5.2.1.1.0.20030826203828.00a24470@mail.sasknow.com> X-Mailer: Mulberry/3.1.0b4 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline cc: freebsd-database@freebsd.org Subject: RE: mysql_install X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Aug 2003 03:33:10 -0000 --On Tuesday, August 26, 2003 21:06:13 -0600 Greg Magnusson 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