Return-Path: 
 <roller-user-return-1101-apmail-incubator-roller-user-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-roller-user-archive@www.apache.org
Received: (qmail 88655 invoked from network); 6 Jul 2006 07:14:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 6 Jul 2006 07:14:38 -0000
Received: (qmail 557 invoked by uid 500); 6 Jul 2006 07:14:38 -0000
Delivered-To: apmail-incubator-roller-user-archive@incubator.apache.org
Received: (qmail 528 invoked by uid 500); 6 Jul 2006 07:14:37 -0000
Mailing-List: contact roller-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:roller-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:roller-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:roller-user@incubator.apache.org>
List-Id: <roller-user.incubator.apache.org>
Reply-To: roller-user@incubator.apache.org
Delivered-To: mailing list roller-user@incubator.apache.org
Delivered-To: moderator for roller-user@incubator.apache.org
Received: (qmail 24655 invoked by uid 99); 6 Jul 2006 05:18:22 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <44AC9D05.7000604@cc.cahillfamily.com>
Date: Thu, 06 Jul 2006 01:17:57 -0400
From: "Conor P. Cahill" <conor@cc.cahillfamily.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: roller-user@incubator.apache.org
Subject: MySQL Database connector problems....
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


Just thought I would share this...

OS: Fedora Core 5 -- updated with all current patches, fairly new install.
Tomcat: 5.5.15
MySQL: 5.0.22
JVM: 1.4.2 (gij 4.1.1) - out of the box Fedora install -- not Sun JDK

After following the roller installation directions very carefully, I was
unable to get roller started because of a problem getting the DataSource
working.

After much debugging (to a relative Tomcat newbie) and reading detailed
debug logs and googling all over the place, the problem turned out to be
related to the factory used to instantiate the DataSource.

The error message in the roller log was:

    RollerContext:upgradeDatabaseIfNeeded - Unable to access DataSource
    javax.naming.NamingException: Cannot create resource instance

And similar output (cannot create resource instance) appeared in the tomcat
logs along with what looked like a class lookup for the ResourceFactory.

I also tried the tomcat 5.5 MySQL tutorial steps and also had what looked
like the exact same problem.  

Further googling led to a note for an older version of Tomcat which defined
a factory in the Resource (as a Parameter -- which is the pre-5.5 way). 

So,  I added the attribute:

    factory="org.apache.commons.dbcp.BasicDataSourceFactory"

to the <Resource> element, and things began working.

Same for the tutorial TestDB.

Conor