From owner-freebsd-questions@FreeBSD.ORG Thu Oct 14 10:37:25 2004 Return-Path: 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 677B816A4CE for ; Thu, 14 Oct 2004 10:37:25 +0000 (GMT) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id BD28A43D60 for ; Thu, 14 Oct 2004 10:37:23 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1])i9EAbCwv099516 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 14 Oct 2004 11:37:12 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)i9EAbCvC099515; Thu, 14 Oct 2004 11:37:12 +0100 (BST) (envelope-from matthew) Date: Thu, 14 Oct 2004 11:37:12 +0100 From: Matthew Seaman To: David Banning Message-ID: <20041014103712.GA99364@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , David Banning , questions@freebsd.org References: <20041014091251.GA60576@skytrackercanada.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="J/dobhs11T7y2rNN" Content-Disposition: inline In-Reply-To: <20041014091251.GA60576@skytrackercanada.com> User-Agent: Mutt/1.4.2.1i X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-1.5.6 (smtp.infracaninophile.co.uk [IPv6:::1]); Thu, 14 Oct 2004 11:37:13 +0100 (BST) X-Virus-Scanned: clamd / ClamAV version devel-20040904, clamav-milter version 0.75l on smtp.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED autolearn=ham version=3.0.0 X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on happy-idiot-talk.infracaninophile.co.uk cc: questions@freebsd.org Subject: Re: configuring php to work with mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 14 Oct 2004 10:37:25 -0000 --J/dobhs11T7y2rNN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Oct 14, 2004 at 05:12:51AM -0400, David Banning wrote: > I am having to reinstall my php and apache 1.3. I installed apache13 > straight from the ports with no options, and then I installed > php4_mysql from the ports also. php is running but it does not > connect to mysql.=20 >=20 > In looking at phpinfo() I notice the configuration options; >=20 > './configure' '--enable-versioning' '--enable-memory-limit' '--with-layou= t=3DGNU' '--with-config-file-scan-dir=3D/usr/local/etc/php' '--disable-all'= '--with-regex=3Dphp' '--with-apxs=3D/usr/local/sbin/apxs' '--prefix=3D/usr= /local' 'i386-portbld-freebsd4.8'=20 >=20 > don't seem to have any reference to mysql. Stange, considering that > the port, specifically is entitled "php4_mysql". To get the most minor nit out of the way first: the port is called php4-mysql. And, no you won't see MySQL amongst the configuration options for the base PHP executable. That's because nowadays the MySQL support is built completely separately as a loadable module. You should have read the 20040719 entry in /usr/ports/UPDATING where this is explained. Try running: % php -m which will tell you about all of the loadable modules you've got available. Look more closely at the phpinfo() output -- there should be a whole section on MySQL later on. If that isn't there, then you need to pay some attention to your /usr/local/etc/php.ini file: if you use the default one provided by the lang/php4 port, everything should just work. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way PGP: http://www.infracaninophile.co.uk/pgpkey Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK --J/dobhs11T7y2rNN Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (FreeBSD) iD8DBQFBblbYiD657aJF7eIRAjN5AKCfxWj16WvLJZXaLZXtZlqzbeojwACffNC7 0KEPFwc0+6bJhTBO1v3ngIY= =PoAe -----END PGP SIGNATURE----- --J/dobhs11T7y2rNN--