Longwell 1.1: How do I get Longwell-Tomcat-Sesame-MySQL-interaction working? - Take 2

From: Patrik Holmer <NNTP.psbh_at_telia.com>
Date: Mon, 2 Jan 2006 16:43:00 +0100

This thread has been ignored for three weeks so I'll give it a final try, as
follows:

Having tried to get Longwell 1.1 'art-public' - and other bundles - working
with a MySQL-database repository, initializing the Longwell-app. on Apache
Tomcat, it fails with an error stating; 'no class definition was found'. So,
what's missing?

My platform setup:

A. On Linux-Ubuntu 5.10 and Microsoft Windows XP 5.1
A1. MySQL 4.1.12 - 'rdbmsrdfdb'; with GRANT ALL for users sesame and
testuser
A2. Sesame 1.1 - 'rdbms-rdf-db'; using sesame and testuser
A3. Apache Tomcat 4.1.31 - with a fully working sesame and whatever I throw
on it, except Longwell
A4. Sun's Java J2SDK1.4.2_04 - a binary install for each OS-platform

B. On Linux-Slackware 10.x, Linux-Ubuntu 5.10 and Microsoft Windows XP 5.1
B1. MySQL 4.1.12 - 'rdbmsrdfdb'; with GRANT ALL for users sesame and
testuser
B2. Sesame 1.2.3 - 'rdbms-rdf-db'; using sesame and testuser
B3. Apache Tomcat 5.5.12 - with a fully working sesame and whatever I throw
on it, except Longwell
B4. Sun's JDK1.5.0_05 - a binary install for each OS-platform

My configuration setup:

C. In Longwell 1.1 and Apache Tomcat 4.1.31 or 5.5.12
C1. Created and ran a new longwell.bat or longwell.sh, only consisting of
code exporting/setting the Java PATH, CP/CLASSPATH and JAVA_HOME to the
appropiate Sun Java SDK/JDK-version -> OK
C2. Ran ./build.sh clean-webapp or build.sh clean-webapp -> OK
C3. Edited and saved a selected bundle data.properties-file -> OK
        C3a. Every row commented out (#) except the following file rows
        C3b. Repository.type = sesame
        C3c. queryType = SesameRDQLModel
        C3d. sesame.uri = http://localhost:8080/sesame/
        C3e. Sesame.user = testuser
        C3f. Sesame.password = opensesame
C4. Placed the Sesame 1.1 or 1.2.3 sesame.jar in the lib/repositories
directory/folder
C5. Ran the ./build.sh or build.bat, choosing a bundle - as art-public -> OK
C6. Ran 'jar cvf longwell.war *.*' in a XP DOS-box or the comparable in
Linux -> OK
C7. Started the Apache Tomcat-version -> OK
C8. Loaded the created 'longwell.war' to Tomcat's webapps through the Tomcat
Manager -> OK
C9. Restarted the Apache Tomcat-version -> not OK in 4.1.31 -
timeout/init()-error , OK in 5.5.12

My experience of Longwell 1.1 in Apache Tomcat 5.5.12

D1. Entered http://localhost:8080/longwell - in Mozilla Firefox or MS
Explorer
D2. Viewed the Longwell Congrats index.html page
D3. Selected the link http://localhost:8080/longwell/longwell in the
Longwell Congrats index.html page
D4. Grumped over the always displayed Apache Tomcat init()-error
'java.lang.NoClassDef Found', having some kind of path failure in
com.hp.hpl.jena (?) as follows:

<!--
exception

javax.servlet.ServletException: Servlet.init() for servlet Longwell threw
exception
        
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
        
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
831)
        
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:652)
        
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
        java.lang.Thread.run(Thread.java:595)


root cause

java.lang.NoClassDefFoundError: org/apache/xerces/util/XMLChar
        
com.hp.hpl.jena.shared.impl.PrefixMappingImpl.checkLegal(PrefixMappingImpl.j
ava:117)
        
com.hp.hpl.jena.shared.impl.PrefixMappingImpl.setNsPrefix(PrefixMappingImpl.
java:39)
        
com.hp.hpl.jena.rdf.model.impl.ModelCom.setNsPrefix(ModelCom.java:837)
        com.hp.hpl.jena.n3.N3toRDF.setPrefixMapping(N3toRDF.java:368)
        com.hp.hpl.jena.n3.N3toRDF.directive(N3toRDF.java:109)
        com.hp.hpl.jena.n3.N3AntlrParser.directive(N3AntlrParser.java:78)
        
com.hp.hpl.jena.n3.N3AntlrParser.n3Directive0(N3AntlrParser.java:227)
        com.hp.hpl.jena.n3.N3AntlrParser.n3Directive(N3AntlrParser.java:193)
        com.hp.hpl.jena.n3.N3AntlrParser.document(N3AntlrParser.java:140)
        com.hp.hpl.jena.n3.N3Parser.parse(N3Parser.java:61)
        com.hp.hpl.jena.n3.N3JenaReader.read(N3JenaReader.java:94)
        com.hp.hpl.jena.n3.N3JenaReader.read(N3JenaReader.java:85)
        com.hp.hpl.jena.rdf.model.impl.ModelCom.read(ModelCom.java:206)
        edu.mit.simile.RDFBrowser.readModel(RDFBrowser.java:116)
        edu.mit.simile.longwell.Longwell.configure(Longwell.java:69)
        edu.mit.simile.longwell.Longwell.init(Longwell.java:138)
        
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
        
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
831)
        
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:652)
        
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
        java.lang.Thread.run(Thread.java:595)
-->

So, what wrong? Having no time to go through the Longwell-code myself, has
anyone experienced this error or more importantly; has anyone out there a
fully working 'Longwell/Apache Tomcat/Sesame/MySQL'-setup? I really don't
want to use anything else but the Sesame repository.

Oh, by the way. The binary Longwell-1.1.zip seems to have a non-working
build-configuration - it crashes when run. The longwell-1.1.tar.gz seems to
be OK though.

// Patrik

-----Ursprungligt meddelande-----
Från: Patrik Holmer [mailto:NNTP.psbh_at_telia.com]
Skickat: måndag den 12 december 2005 21:01
Till: general_at_simile.mit.edu
Ämne: SEMANTIC BANK->LONGWELL: How do I get Longwell-MySQL interaction
working?

Anyone with ideas or instruction on how to get one of the Longwell 1.1
default bundles talking through Sesame 1.2.3 to a MYSQL-database on a LAMP
Server?

Right-up to executing the command ./longwell.sh, everything including the
Longwellian ./build.sh, seems to be running cleanly. Instructions seems
somewhat sparse when Googling.

// Patrik

-----Ursprungligt meddelande-----
Från: David Huynh [mailto:dfhuynh_at_csail.mit.edu]
Skickat: söndag den 23 oktober 2005 21:10
Till: general_at_simile.mit.edu
Ämne: Re: SEMANTIC BANK: How do I get Semantic Bank MySQL-interaction
working?

Patrik,

I haven't run that configuration for a while now, but I remember it wasn't
too hard. You should start MySQL running as a service, create a database of
some name, and enter that name into the properties file.

To simplify the matter, perhaps you can try getting Longwell2 to run on
MySQL before getting Semantic Bank to run on MySQL.

David


Patrik Holmer wrote:

> Anyone with instructions on how to get the
> Semantic-Bank-2.1.1 working, using the Triple Store MySQLConnector in
> semantic-bank.properties?
>
> // Patrik
>
Received on Mon Jan 02 2006 - 15:35:43 EST

This archive was generated by hypermail 2.3.0 : Thu Aug 09 2012 - 16:39:18 EDT