RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC

[Peter Hawkins <pe...@globalvision.com.au>]

Thanks for this. I will address it when I have time

Peter

-----Original Message-----
From: Erik Langenbach [mailto:ELangenbach@desknetinc.com]
Sent: Thursday, 31 May 2001 11:52 PM
To: slide-user@jakarta.apache.org
Subject: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via
JDBC


I've been setting up the following configuration on Windows 2000:
- Slide v1.0.10 (jakarta-slide-1.0.10.zip)
- Tomcat v4.0-b5 (jakarta-tomcat-4.0-b5.zip)
- MySQL v3.23.38-max-nt

I've noticed the following minor problems with the FAQ instructions titled
"Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC" located at
http://faq.globalvision.com.au/fom-serve/cache/18.html.

First, the schema does not define the needed "revisionnumber" column in the
"permissions" table.  Instead of using:

create table permissions(object blob, subject blob, action blob, inheritable
int, negative int);

use

create table permissions(object blob, revisionnumber varchar(20), subject
blob, action blob, inheritable int,  negative int);

*note: this is the same issue mentioned in Mark Papiani's "slide 1.0.10 -
different DB schema: Column count doesn't match value count at row 1" thread

Second, there are some minor issues with the proposed <definition> section:
- All XML tags begin with "< " or "</ ", which are both illegal.  They must
instead by "<" and "</", respectively.
- The end tag of the first defined parameter is incorrectly written as "</p
arameter>".  It should be "</parameter>"
- The classname attribute values used in both the <nodestore> and
<contentstore> elements incorrectly begin with "slidestore.mysql".  Instead,
they should begin with
"slidestore.reference".

Erik Langenbach