From owner-freebsd-questions@FreeBSD.ORG Thu Jan 29 21:45:50 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 F05C416A4CE for ; Thu, 29 Jan 2004 21:45:50 -0800 (PST) Received: from pd4mo3so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 58A9C43D45 for ; Thu, 29 Jan 2004 21:45:49 -0800 (PST) (envelope-from aardvark@saintaardvarkthecarpeted.com) Received: from pd2mr1so.prod.shaw.ca (pd2mr1so-ser.prod.shaw.ca [10.0.141.110])2003))freebsd-questions@freebsd.org; Thu, 29 Jan 2004 22:40:27 -0700 (MST) Received: from pn2ml8so.prod.shaw.ca (pn2ml8so-qfe0.prod.shaw.ca [10.0.121.152]) by l-daemon (iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003)) with ESMTP id <0HSA00EF9FRFHN@l-daemon> for freebsd-questions@freebsd.org; Thu, 29 Jan 2004 22:40:27 -0700 (MST) Received: from francisco.saintaardvarkthecarpeted.com (h24-87-202-31.vc.shawcable.net [24.87.202.31]) by l-daemon (iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003)) with ESMTP id <0HSA00C39FRF7X@l-daemon> for freebsd-questions@freebsd.org; Thu, 29 Jan 2004 22:40:27 -0700 (MST) Received: from hardesty.hardesty.saintaardvarkthecarpeted.com ([192.168.23.1]) by francisco.saintaardvarkthecarpeted.com (8.12.9/8.12.9) with ESMTP id i0U5uBJC041143; Thu, 29 Jan 2004 21:56:11 -0800 Received: from aardvark by hardesty.hardesty.saintaardvarkthecarpeted.com with local (Exim 3.36 #1 (Debian)) id 1AmRLp-0001od-00; Thu, 29 Jan 2004 21:37:57 -0800 Date: Thu, 29 Jan 2004 21:37:57 -0800 From: Saint Aardvark the Carpeted In-reply-to: <200401292328.20454.ecrist@adtechintegrated.com> Sender: Debian User To: Eric F Crist Message-id: <20040130053757.GW3224@hardesty.saintaardvarkthecarpeted.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline User-Agent: Mutt/1.5.4i References: <200401292328.20454.ecrist@adtechintegrated.com> cc: freebsd-questions@freebsd.org Subject: Re: MySQL 4.x questions... 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: Fri, 30 Jan 2004 05:45:51 -0000 Eric F Crist disturbed my sleep to write: Content-Description: signed data > I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB > bulletin board system. For the life of me, I can't get a database setup for > either of them to use. Both users groups tell me that there's a mysql > problem with configuration. Here are the errors: Hm...if I had to guess, I'd say that either MySQL isn't running, or phpBB/PostNuke haven't been configured correctly. Try "ps auxw | grep mysql" and make sure it's running. If not, the start script should be /usr/local/etc/rc.d/mysql.sh (I think). Try connecting to it using the mysql client and the MySQL user name and password you've set up for your programs: $ mysql -u [MySQL user name] -p [database name] Password: ***** Finally, check the configuration for your programs and MySQL. Is phpBB trying to connect via TCP/IP? If so, is MySQL set up to listen via TCP/IP, or is it only on a file socket? What about basics like the user name and password? Hope that helps...let me know how it turns out. Hugh -- Saint Aardvark the Carpeted aardvark@saintaardvarkthecarpeted.com Because the plural of Anecdote is Myth.