From owner-freebsd-questions@FreeBSD.ORG Tue Aug 29 07:03:54 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2C8D516A4DA for ; Tue, 29 Aug 2006 07:03:54 +0000 (UTC) (envelope-from omer@omeriqbal.com) Received: from smtp105.biz.mail.re2.yahoo.com (smtp105.biz.mail.re2.yahoo.com [206.190.52.174]) by mx1.FreeBSD.org (Postfix) with SMTP id B4C5343D46 for ; Tue, 29 Aug 2006 07:03:53 +0000 (GMT) (envelope-from omer@omeriqbal.com) Received: (qmail 7617 invoked from network); 29 Aug 2006 07:03:53 -0000 Received: from unknown (HELO rakaposhi) (omer@omeriqbal.com@203.81.221.218 with login) by smtp105.biz.mail.re2.yahoo.com with SMTP; 29 Aug 2006 07:03:50 -0000 From: "Muhammad Omer Iqbal" To: Date: Tue, 29 Aug 2006 00:03:49 -0700 Message-ID: <000001c6cb39$4a2d1240$dadd51cb@rakaposhi> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcbKMA/c4CqPFfwoRNW4OMWT2EOCWgApWUEw In-Reply-To: <20060827190247.BA25.GERARD@seibercom.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Subject: RE: PHP5 and MySQL X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Aug 2006 07:03:54 -0000 So it seems that my ports collectionwas indeed out of date, even though I installed FreeBSD 6.1 only two weeks back. Lesson learnt: always update ports collection after installing FreeBSD. I am doing MySQL 5.0 instead of 5.1, I do not want a beta release, and I am comparing and doing an analysis against a propreitary DB. I have used MySQL in the past, and believe it is a better choice for our case. Thanks for all the help, esp Gerard, Matthew & fbsd. I am going to try and build/install everything. If I run into problems again and I run out of everything, I will come back here. Thanks folks! Best Wishes, Omer -----Original Message----- From: Gerard Seibert [mailto:gerard@seibercom.net] Sent: Sunday, August 27, 2006 4:18 PM To: Muhammad Omer Iqbal Subject: Re: PHP5 and MySQL It certainly sounds like you have an old version of the ports tree installed. They this and see if it corrects things. Have you ever run 'portsnap'? If not, now is a good time to start. As root, run the following: portsnap fetch portsnap extract portsnap update The extract command will take awhile, but it only has to be run once. After this, anytime you want to update the ports tree you would simply run: portsnap fetch update The three commands I gave you will rebuild build your ports tree with the latest updates. Now, ,migrate to /usr/ports/databases/mysql51-server and run: make install && make clean If it complains about any other version being installed you will have to navigate to that directory and run make deinstall to remove it manually. Then return and run the above command again/ Next, navigate to the /usr/ports/lang/php5 directory and run make config Make sure that the "Build Apache Module" is checked Leave the others at there default settings. Make sure you do 'tab' to OK and hit return to save the settings. Now, enter: make install && make clean When finished, everything should be running correctly. If you have not done so already, you must place: mysql_enable="YES" in the /etc/rc.conf file. Now reboot the system and all should be well. Ciao! -- Gerard Seibert gerard@seibercom.net