From owner-freebsd-questions@FreeBSD.ORG  Fri Jan 30 05:59:05 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 30F6816A4CE
	for <freebsd-questions@freebsd.org>;
	Fri, 30 Jan 2004 05:59:05 -0800 (PST)
Received: from dyer.circlesquared.com
	(host217-45-219-83.in-addr.btopenworld.com [217.45.219.83])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B80EB43D1D
	for <freebsd-questions@freebsd.org>;
	Fri, 30 Jan 2004 05:59:02 -0800 (PST)
	(envelope-from peter@circlesquared.com)
Received: from circlesquared.com (localhost.petanna.net [127.0.0.1])
	i0UDv2Bk001229;	Fri, 30 Jan 2004 13:57:12 GMT
	(envelope-from peter@circlesquared.com)
Message-ID: <401A62AE.8060901@circlesquared.com>
Date: Fri, 30 Jan 2004 13:57:02 +0000
From: Peter Risdon <peter@circlesquared.com>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5b) Gecko/20031102
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: ecrist@adtechintegrated.com
References: <200401292328.20454.ecrist@adtechintegrated.com>
	<401A5A03.6080908@circlesquared.com>
	<200401300726.57568.ecrist@adtechintegrated.com>
In-Reply-To: <200401300726.57568.ecrist@adtechintegrated.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 30 Jan 2004 13:59:05 -0000

Eric F Crist wrote:

>Thanks for all your help with this problem.  Both apps seemed to have 
>successfully installed now, but they both have errors.  PostNuke keeps 
>telling me it's 'Failed to Initialize' and I can't get away from the phpBB 
>install script, no matter where I go.  I can try to trouble shoot these on my 
>own, though.
>
>Have a good day!
>
>  
>
I'd have thought both these errors might stem from a problem writing (as 
opposed to connecting) to the relevant databases. Are the schema 
installed? It's helpful to check what is actually happening to the 
tables if there are any, and there should be.

#mysqlshow -u username -p databasename

will show the tables, if there are any...

#mysql -u username -p databasename
mysql> select * from tablename\G

will show what is in the tables. If this isn't changing during 
initialisation/install then there's probably a permissions prob. You can 
check permissions as follows (assuming there is a root password):

mysql -u root -p mysql
mysql> select * from db\G

Your output should include a block like this:

*************************** 1. row ***************************
                 Host: localhost
                   Db: databasename
                 User: username
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
           Grant_priv: N
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y



PWR.