From owner-freebsd-isp@FreeBSD.ORG Thu Apr 6 07:53:19 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 17FAF16A41F for ; Thu, 6 Apr 2006 07:53:19 +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 CEFDA43D45 for ; Thu, 6 Apr 2006 07:53:18 +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 44E7067EB6; Thu, 6 Apr 2006 00:53:18 -0700 (PDT) Date: Thu, 6 Apr 2006 00:53:18 -0700 (PDT) From: Keith Woodworth To: Riemer Palstra In-Reply-To: <20060406072349.GA25401@rb1.palstra.com> Message-ID: <20060406004108.K89897@pop.citytel.net> References: <20060405233920.N88219@pop.citytel.net> <20060406072349.GA25401@rb1.palstra.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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:53:19 -0000 On Thu, 6 Apr 2006, Riemer Palstra wrote: |->On Wed, Apr 05, 2006 at 11:50:48PM -0700, Keith Woodworth wrote: |-> |->> 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? Really? having no value above is ok? yes mysql is still running and the socket is still in /tmp. I did init the database - mysql_install_db, change the perms/ownership as mysql was not starting and a quick google showed me that problem. Didnt set the root yet...shortcutting things now as Ive been staring at php and perl all day and starting to get tired. |->> 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. Created the directory under /var/db/mysql, copied over the 3 files that make that database up. Login to mysql and the database is there, show tables shows the table and a select * from gives me the data that I know is there. And yes 'error' is the only thing that gets output to the browser when the php script gets hit. I know its not great. I think I need to look at mysql more as I did things a bit quick and dirty here. Thanks.