From owner-freebsd-isp@FreeBSD.ORG Thu Apr 6 07:23:51 2006 Return-Path: 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 D10F916A41F for ; Thu, 6 Apr 2006 07:23:51 +0000 (UTC) (envelope-from riemer@palstra.com) Received: from palstra.com (palstra.com [82.201.5.23]) by mx1.FreeBSD.org (Postfix) with ESMTP id 78CD743D45 for ; Thu, 6 Apr 2006 07:23:51 +0000 (GMT) (envelope-from riemer@palstra.com) Received: from riemer by palstra.com with local (Exim 4.60 (FreeBSD)) (envelope-from ) id 1FROqM-0006jR-2o; Thu, 06 Apr 2006 09:23:50 +0200 Date: Thu, 6 Apr 2006 09:23:50 +0200 From: Riemer Palstra To: Keith Woodworth Message-ID: <20060406072349.GA25401@rb1.palstra.com> References: <20060405233920.N88219@pop.citytel.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060405233920.N88219@pop.citytel.net> User-Agent: Mutt/1.4.2.1i Cc: freebsd-isp@freebsd.org Subject: Re: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Apr 2006 07:23:51 -0000 On Wed, Apr 05, 2006 at 11:50:48PM -0700, Keith Woodworth wrote: > 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. Sounds good. > 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 Nothing out of the ordinary in this output. Is MySQL still running and is the socket still there? Also, did you initialize the MySQL database and set a root password? > 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. By copying over a test db, do you mean importing an SQL dump, or did you just copy over some files? Also, are the privileges on the test database right and does it show up when you do a SHOW DATABASES; ? And 'error' is the only thing the script spits out? That's a bit hard for diagnostics, IMHO. -- Riemer Palstra Amsterdam, The Netherlands riemer@palstra.com http://www.palstra.com/