From owner-freebsd-questions@FreeBSD.ORG Sun Aug 27 17:01:58 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 7D9B216A62A for ; Sun, 27 Aug 2006 17:01:58 +0000 (UTC) (envelope-from omer@omeriqbal.com) Received: from smtp101.biz.mail.re2.yahoo.com (smtp101.biz.mail.re2.yahoo.com [68.142.229.215]) by mx1.FreeBSD.org (Postfix) with SMTP id 83D5C460FD for ; Sun, 27 Aug 2006 16:48:26 +0000 (GMT) (envelope-from omer@omeriqbal.com) Received: (qmail 11835 invoked from network); 27 Aug 2006 16:48:22 -0000 Received: from unknown (HELO rakaposhi) (omer@omeriqbal.com@203.81.220.191 with login) by smtp101.biz.mail.re2.yahoo.com with SMTP; 27 Aug 2006 16:48:22 -0000 From: "Muhammad Omer Iqbal" To: "'Matthew Seaman'" Date: Sun, 27 Aug 2006 09:48:19 -0700 Message-ID: <000901c6c9f8$9bd52f70$0202a8c0@rakaposhi> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Thread-Index: AcbJ6tr6T6tlDVqmSJqmRZ7BQ8QwDAADQhyw In-Reply-To: <44F1A873.1070906@infracaninophile.co.uk> Cc: freebsd-questions@freebsd.org 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: Sun, 27 Aug 2006 17:01:58 -0000 Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext in PHP5 directory with DEFAULT_MYSQL_VER=50, but to no avail. -----Original Message----- From: Matthew Seaman [mailto:m.seaman@infracaninophile.co.uk] Sent: Sunday, August 27, 2006 7:13 AM To: Muhammad Omer Iqbal Cc: freebsd-questions@freebsd.org Subject: Re: PHP5 and MySQL >Muhammad Omer Iqbal wrote: >> Looking through phpinfo, I do not find mysql or mysqli installed, >> even though I have enabled, remade and reinstalled both MySQL and >> PHP5. In fact, I think that my PHP5 is no longer remade, it just >> reconfigures it and reinstalls it because the build date shows as Aug >> 22 even though I did it today and my server date shows as Aug 27. I >> installed both of these using the ports collection, but then I had to >> manually download MySQL because of versioning issues, and untar and >> install it The PHP5 port has been divided into a fairly large number of modules. To add MySQL support within PHP5, simply install the databases/php5-mysql port. (Or php5-mysqli, but only if you're running mysql-4.1.x) Note that php5-mysql will cause one of the mysql-client ports to be installed as a dependency -- unless you install one of the other versions before hand, that will get you the mysql 5.0.x client. You will still need to install one of the mysql server ports, unless your DB is physically hosted on a different machine. Oh -- and the other trap for newbies is that you need to 'make config' in the lang/php5 port and make sure the 'Apache' box is checked before you'll get the Apache PHP5 module built and installed. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW