You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Erik Langenbach <EL...@desknetinc.com> on 2001/05/31 15:52:00 UTC
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
RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC
Posted by 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
Re: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC
Posted by Remy Maucherat <re...@apache.org>.
> Maybe not in the faq, but I had to delete servlet.jar from the WEBINF/lib
> folder of slide as mentioned in a previous article.
I checked the binaries, and I packaged servlet.jar from the 2.2 servlet API
in the 1.0.10 binaries. So with Catalina, you'll get a classcast ("is not a
servlet" message) unless you delete servlet.jar from /WEB-INF/lib.
I just finished cleaning up the distribution, so I think I will release new
binaries to solve this problem.
Remy
RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC
Posted by dom <do...@sisna.com>.
Maybe not in the faq, but I had to delete servlet.jar from the WEBINF/lib
folder of slide as mentioned in a previous article. Also, in the
configuration for the domain.xml file, from a previous post
"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>"
These are the things I changed.
Dominic
-----Original Message-----
From: Peter Hawkins [mailto:peter@globalvision.com.au]
Sent: Thursday, June 14, 2001 11:34 PM
To: slide-user@jakarta.apache.org; dom@sisna.com
Subject: RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+
via JDBC
Hmmm I'm not actually aware of any errors in the FAQ - I don't recall any
having been reported to me that aren't already fixed. It's out of date in
some sections and I've got a full board of updates because of the work done
by Remy in adding the Catalina bundle, but so far as I know the MySQL
section is correct... What changes did you make?
Peter
-----Original Message-----
From: dom [mailto:dom@sisna.com]
Sent: Friday, 15 June 2001 2:10 PM
To: slide-user@jakarta.apache.org
Subject: RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+
via JDBC
I am using jakarta-tomcat-4.0-b5 and slide-1.0.10. I configured slide for
using mySql using the faq and correcting some of the errors from the faq as
previously mentioned but I still can't get the combination to work. I am
getting the following errors!
Please respond
-----------------------------------
Starting service Tomcat-Standalone
Apache Tomcat/4.0-b5
14 Jun 2001 22:04:19 - INFO - Initializing Domain
14 Jun 2001 22:04:19 - INFO - Domain configuration :
{org.apache.slide.security=true}
14 Jun 2001 22:04:19 - INFO - Initializing namespace : webdav
14 Jun 2001 22:04:19 - INFO - Loading namespace definition
14 Jun 2001 22:04:20 - INFO - Registering Store memory of class class
org.apache.slide.store.S
andardStore with parameters {} on scope /
14 Jun 2001 22:04:20 - INFO - Initializing Store
memory(org.apache.slide.store.StandardStore)
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav parameters
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav base data
WARNING: No active transaction
14 Jun 2001 22:04:21 - INFO - Namespace base configuration was already done
before
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at
/actions
at
slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
e.java:
53)
at
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:169)
at
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1
031)
at
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceC
onfig.j
va:589)
at
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:721)
at org.apache.slide.common.Domain.initNamespace(Domain.java:651)
at org.apache.slide.common.Domain.init(Domain.java:308)
at org.apache.slide.common.Domain.init(Domain.java:255)
at org.apache.slide.common.Domain.init(Domain.java:220)
at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:293)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:833)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3277)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:413)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:641)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:
55)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:278)
at
org.apache.catalina.core.StandardService.start(StandardService.java:353)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
at org.apache.catalina.startup.Catalina.start(Catalina.java:725)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:647)
at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:196)
Starting service Tomcat-Apache
Apache Tomcat/4.0-b5
RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC
Posted by Peter Hawkins <pe...@globalvision.com.au>.
Hmmm I'm not actually aware of any errors in the FAQ - I don't recall any
having been reported to me that aren't already fixed. It's out of date in
some sections and I've got a full board of updates because of the work done
by Remy in adding the Catalina bundle, but so far as I know the MySQL
section is correct... What changes did you make?
Peter
-----Original Message-----
From: dom [mailto:dom@sisna.com]
Sent: Friday, 15 June 2001 2:10 PM
To: slide-user@jakarta.apache.org
Subject: RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+
via JDBC
I am using jakarta-tomcat-4.0-b5 and slide-1.0.10. I configured slide for
using mySql using the faq and correcting some of the errors from the faq as
previously mentioned but I still can't get the combination to work. I am
getting the following errors!
Please respond
-----------------------------------
Starting service Tomcat-Standalone
Apache Tomcat/4.0-b5
14 Jun 2001 22:04:19 - INFO - Initializing Domain
14 Jun 2001 22:04:19 - INFO - Domain configuration :
{org.apache.slide.security=true}
14 Jun 2001 22:04:19 - INFO - Initializing namespace : webdav
14 Jun 2001 22:04:19 - INFO - Loading namespace definition
14 Jun 2001 22:04:20 - INFO - Registering Store memory of class class
org.apache.slide.store.S
andardStore with parameters {} on scope /
14 Jun 2001 22:04:20 - INFO - Initializing Store
memory(org.apache.slide.store.StandardStore)
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav parameters
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav base data
WARNING: No active transaction
14 Jun 2001 22:04:21 - INFO - Namespace base configuration was already done
before
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at
/actions
at
slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
e.java:
53)
at
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:169)
at
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1
031)
at
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceC
onfig.j
va:589)
at
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:721)
at org.apache.slide.common.Domain.initNamespace(Domain.java:651)
at org.apache.slide.common.Domain.init(Domain.java:308)
at org.apache.slide.common.Domain.init(Domain.java:255)
at org.apache.slide.common.Domain.init(Domain.java:220)
at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:293)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:833)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3277)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:413)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:641)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:
55)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:278)
at
org.apache.catalina.core.StandardService.start(StandardService.java:353)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
at org.apache.catalina.startup.Catalina.start(Catalina.java:725)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:647)
at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:196)
Starting service Tomcat-Apache
Apache Tomcat/4.0-b5
RE: FAQ Issues: Configuring Slide (v1.0.10) to use mysql v3.23+ via JDBC
Posted by dom <do...@sisna.com>.
I am using jakarta-tomcat-4.0-b5 and slide-1.0.10. I configured slide for
using mySql using the faq and correcting some of the errors from the faq as
previously mentioned but I still can't get the combination to work. I am
getting the following errors!
Please respond
-----------------------------------
Starting service Tomcat-Standalone
Apache Tomcat/4.0-b5
14 Jun 2001 22:04:19 - INFO - Initializing Domain
14 Jun 2001 22:04:19 - INFO - Domain configuration :
{org.apache.slide.security=true}
14 Jun 2001 22:04:19 - INFO - Initializing namespace : webdav
14 Jun 2001 22:04:19 - INFO - Loading namespace definition
14 Jun 2001 22:04:20 - INFO - Registering Store memory of class class
org.apache.slide.store.S
andardStore with parameters {} on scope /
14 Jun 2001 22:04:20 - INFO - Initializing Store
memory(org.apache.slide.store.StandardStore)
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav parameters
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav base data
WARNING: No active transaction
14 Jun 2001 22:04:21 - INFO - Namespace base configuration was already done
before
14 Jun 2001 22:04:21 - INFO - Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at
/actions
at
slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStor
e.java:
53)
at
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:169)
at
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1
031)
at
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceC
onfig.j
va:589)
at
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:721)
at org.apache.slide.common.Domain.initNamespace(Domain.java:651)
at org.apache.slide.common.Domain.init(Domain.java:308)
at org.apache.slide.common.Domain.init(Domain.java:255)
at org.apache.slide.common.Domain.init(Domain.java:220)
at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:293)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:833)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3277)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:413)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:641)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:
55)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:278)
at
org.apache.catalina.core.StandardService.start(StandardService.java:353)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
at org.apache.catalina.startup.Catalina.start(Catalina.java:725)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:647)
at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:196)
Starting service Tomcat-Apache
Apache Tomcat/4.0-b5