From owner-freebsd-isp@FreeBSD.ORG  Thu Apr  6 06:50:50 2006
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
X-Original-To: freebsd-isp@freebsd.org
Delivered-To: freebsd-isp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2ECFC16A401
	for <freebsd-isp@freebsd.org>; Thu,  6 Apr 2006 06:50:50 +0000 (UTC)
	(envelope-from kwoody@citytel.net)
Received: from mail.citytel.net (mail.citytel.net [209.145.111.46])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C3F9443D46
	for <freebsd-isp@freebsd.org>; Thu,  6 Apr 2006 06:50:49 +0000 (GMT)
	(envelope-from kwoody@citytel.net)
Received: from pop.citytel.net (pop.citytel.net [204.244.98.50])
	by mail.citytel.net (Postfix) with ESMTP id 1593E67EED
	for <freebsd-isp@freebsd.org>; Wed,  5 Apr 2006 23:50:48 -0700 (PDT)
Date: Wed, 5 Apr 2006 23:50:48 -0700 (PDT)
From: Keith Woodworth <kwoody@citytel.net>
To: freebsd-isp@freebsd.org
Message-ID: <20060405233920.N88219@pop.citytel.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Subject: Mysql5/PHP5 installed from ports on FBSD 6
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 06 Apr 2006 06:50:50 -0000


Playing around with a new machine, installed FBSD 6 and decided to try the
latest PHP5 and MySQL5 in the ports tree. Normally using PHP4 something
under apache 1.3.29 for ages now.

Did a portsnap to get the latest port tree.

Built from ports: apache 2.0.55, then mysql 5.0.19 and started it then
built php 5.1.2 and installed the php5 extensions for mysql.

Everything starts up ok, hit the server and do a phpinfo() ok things look
like they went ok, scroll down and see for the mysql settings:

Active Persistent Links 	0
Active Links 	0
Client API version 	5.0.19
MYSQL_MODULE_TYPE 	no value
MYSQL_SOCKET 	/tmp/mysql.sock
MYSQL_INCLUDE 	no value
MYSQL_LIBS 	no value

oh thats not good, seeing the INCLUDE and LIBS with 'no value'. So copy
over a small test db and some php scripts to the new server, all I get
output is 'error' when doing a sql query via php...nothing in
httpd-error.log like my other php4/apache1.3 machine either, so I dont
know how its failing.

Did I miss a --with-mysql somewhere while doing php?

Anyone have an idea here of what to try next?

Thanks.