From owner-freebsd-database@FreeBSD.ORG Thu Aug 28 21:08:38 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 71C6616A4BF for ; Thu, 28 Aug 2003 21:08:38 -0700 (PDT) Received: from ren.sasknow.com (ren.sasknow.com [207.195.92.131]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9E50F43FCB for ; Thu, 28 Aug 2003 21:08:37 -0700 (PDT) (envelope-from glm@cyborgspiders.com) Received: from Mom.cyborgspiders.com (hsdbsk206-163-228-51.sasknet.sk.ca [206.163.228.51]) by ren.sasknow.com (8.12.8p1/8.12.8) with ESMTP id h7T48X63053627; Thu, 28 Aug 2003 22:08:34 -0600 (CST) (envelope-from glm@cyborgspiders.com) Message-Id: <5.2.1.1.0.20030828212109.00a3a3f0@mail.sasknow.com> X-Sender: cyborgspiders@mail.sasknow.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Thu, 28 Aug 2003 22:08:13 -0600 To: From: Greg Magnusson In-Reply-To: <009101c36c4d$36c3f780$c905010a@daylight.net> References: <5.2.1.1.0.20030826203828.00a24470@mail.sasknow.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: freebsd-database@freebsd.org cc: patl+freebsd@volant.org Subject: RE: mysql_install-simplified 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: Fri, 29 Aug 2003 04:08:38 -0000 re: freebsd +php + apache-mod_ssl + mysql port install Success. Thank you for making this install easy for me. I read through chapter 4 of the FreeBSD handbook, ran CVsup to the ports collection and followed your install procedure. That is exactly what I was looking for! The graphical choices page for the mcrypt library of the php install is a nice touch. Perhaps you know how complicated this is to configure by hand. One note: Perl 5 needs to be installed previous to MYSQL, at least with FreeBSD 4.7. I suspect the new Perl is with FreeBSD 5+ to make this a non-issue. I have just confired that I have a working Apache_ssl-MySQL-PHP server. It has been a long time coming. Thank you. Greg L. Magnusson glm@cyborgspiders.com At 10:42 PM 8/26/03 -0500, you wrote: >Assuming the following: > >1) you have root control of the box >2) you have correctly installed the 'ports system' >3) you have correctly updated ports via cvsup >4) you are able to properly configure the applications > >Note: the ports system compiles applications from source > code, this is NOT installing pre-compiled binaries > as would be the case with 'pkg_add' > >Follow these steps: 1) cd /usr/ports/languages/perl make make install make clean 2) cd /usr/ports/databases/mysql40-server make make install make clean 3) cd /usr/ports/www/apache13-modssl make make install make clean 4)cd /usr/ports/www/mod_php4 make make install make clean >You would do well to read this: > > http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports-using.html > >-- >John Brooks >john@stlbsd.org > >-----Original Message----- >From: Greg Magnusson [mailto:glm@cyborgspiders.com] >Sent: Tuesday, August 26, 2003 10:06 PM >To: john@day-light.com >Cc: freebsd-database@freebsd.org >Subject: RE: mysql_install > > >re: ports system > >Correct, I have not installed mysql from the FreeBSD ports >system. Currently, I am attempting to use a download from the mysql.org >site that can be burned to a disk. > >http://www.mysql.com/downloads/mysql-3.23.html > >I just noticed that version 4 is stable now, so I am going to try the new >one. > >http://www.mysql.com/downloads/mysql-4.0.html > > 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. > > > >BTW, when installed properly, the 'mysql user' will have a UID of 88 and a > >GID of 88 - it is unlikely that you have achieved that with 'adduser'. > >I choose user id 888. You have made me think that I could use a separate >group. Currently my machine has only one group...default group of #14 I >believe. > >Greg Magnusson >glm@cyborgspiders.com