OSPORTFOLIO install troubles: any java/tomcat gurus familiar with this on debian?
osportfolio.org looks like a neat setup, so we thought we'd
give it a whirl... but we can't find the cliffs notes on
getting java up and running. apt-cache search java brings
up a BUNCH of stuff and we don't know one from another.
from instrux at
http://wiki.osportfolio.org/confluence/display/Technical/Quick+start+guide:
$ wget http://theospi.org/releases/2.0.1/osp-2.0.1.zip
$ unzip o*zip
$ elinks http://dev.mysql.com/downloads/connector/j/3.1.html
<download connector>
$ gunzip m*gz
$ ls -F
mysql-connector-java-3.1.11/ mysql-connector-java-3.1.11.tar
osp-2.0.1/ osp-2.0.1.zip
$ cp mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar
osp-2.0.1/jakarta-tomcat-5.0.28/common/lib/
maybe jamvm is what we need? maybe not?
# apt-get install jamvm
$ cd osp*/
$ chmod +x *.sh
$ export JAVA_HOME=/usr
$ ./install.sh > install.out
$ ./clean.sh
JAVA_HOME: /usr
ANT_HOME: /home/will/osp-2.0.1/apache-ant
new path:
/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/home/will/osp-2.0.1/apache-ant/bin
Unable to locate tools.jar. Expected to find it in /usr/lib/tools.jar
[snip]
# ln -s /usr/share/java/cp-tools.jar /usr/lib/tools.jar
[snot in the dark, that, to no avail]
is there a package or two that we still need to apt-get? anyone
who could point us to the right docs, many thanks!
==========
here's the full transcript from ./clean.sh:
# ./clean.sh
JAVA_HOME: /usr
ANT_HOME: /home/will/osp-2.0.1/apache-ant
new path:
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/bin/X11:/home/will/osp-2.0.1/apache-ant/bin
Buildfile: manage_osp.xml
prepare:
[echo] sakai.install.path=/home/will/osp-2.0.1/usr_local_sakai
[echo]
repository.path=/home/will/osp-2.0.1//usr_local_sakai//repository
[echo] serverUrl=http://localhost:8080
[echo] sql.vendor=mysql
[echo] sql.driver=com.mysql.jdbc.Driver
[echo]
sql.connect=jdbc:mysql://127.0.0.1:3306/osp?useUnicode=true&characterEncoding=UTF-8
[echo] sql.user=ospuser
clean:
[input] All data is going to be deleted from your osp database and
your repository, continue ?(y,n)
y
prepare:
[echo] sakai.install.path=/home/will/osp-2.0.1/usr_local_sakai
[echo]
repository.path=/home/will/osp-2.0.1//usr_local_sakai//repository
[echo] serverUrl=http://localhost:8080
[echo] sql.vendor=mysql
[echo] sql.driver=com.mysql.jdbc.Driver
[echo]
sql.connect=jdbc:mysql://127.0.0.1:3306/osp?useUnicode=true&characterEncoding=UTF-8
[echo] sql.user=ospuser
create-mysql-db:
[copy] Copying 1 file to /home/will/osp-2.0.1/conf
[sql] Executing file: /home/will/osp-2.0.1/conf/create_db_mysql.sql
[sql] 14 of 14 SQL statements executed successfully
prepare:
[echo] sakai.install.path=/home/will/osp-2.0.1/usr_local_sakai
[echo]
repository.path=/home/will/osp-2.0.1//usr_local_sakai//repository
[echo] serverUrl=http://localhost:8080
[echo] sql.vendor=mysql
[echo] sql.driver=com.mysql.jdbc.Driver
[echo]
sql.connect=jdbc:mysql://127.0.0.1:3306/osp?useUnicode=true&characterEncoding=UTF-8
[echo] sql.user=ospuser
rebuild-sakai-db:
[sql] Executing file:
/home/will/osp-2.0.1/usr_local_sakai/confdb/db/mysql/all.sql
[sql] Failed to execute: UPDATE SAKAI_SITE SET
MODIFIEDON='20030624121053597' WHERE SITE_ID = '!error'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'MODIFIEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
CREATEDON='20030624041508851' WHERE SITE_ID = '!error'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'CREATEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
MODIFIEDON='20030624121053597' WHERE SITE_ID = '!urlError'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'MODIFIEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
CREATEDON='20030624041508851' WHERE SITE_ID = '!urlError'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'CREATEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
MODIFIEDON='20031126034522061' WHERE SITE_ID = '!gateway'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'MODIFIEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
MODIFIEDON='20030624121053597' WHERE SITE_ID = '!worksite'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'MODIFIEDON' at row 1
[sql] Failed to execute: UPDATE SAKAI_SITE SET
CREATEDON='20030624041508851' WHERE SITE_ID = '!worksite'
[sql] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of
range value adjusted for column 'CREATEDON' at row 1
[sql] 800 of 807 SQL statements executed successfully
rebuild-osp-db:
[echo] saved sql to:
/home/will/osp-2.0.1/usr_local_sakai/confdb/db/mysql/osp.sql
[delete] Deleting: /home/will/osp-2.0.1/conf/hibernate.properties
rebuild-db:
prepare:
[echo] sakai.install.path=/home/will/osp-2.0.1/usr_local_sakai
[echo]
repository.path=/home/will/osp-2.0.1//usr_local_sakai//repository
[echo] serverUrl=http://localhost:8080
[echo] sql.vendor=mysql
[echo] sql.driver=com.mysql.jdbc.Driver
[echo]
sql.connect=jdbc:mysql://127.0.0.1:3306/osp?useUnicode=true&characterEncoding=UTF-8
[echo] sql.user=ospuser
sakai-admin-bootstrap:
[add-site-tool] java.lang.RuntimeException: problem loading
ApplicationContext: Error registering bean with name 'fileValidator'
defined in class path
resource [repository-config.xml]: Unexpected element or type mismatch:
expected single node of class gnu.xml.dom.DomText to be of type Text:
found gnu.xml.dom.DomElement[value]
[add-site-tool] at
org.theospi.utils.ioc.ApplicationContextFactory.createContext
(ApplicationContextFactory.java:49)
[add-site-tool] at
org.theospi.portfolio.admin.AbstractAdminMatchingTask.initialize
(AbstractAdminMatchingTask.java:59)
[add-site-tool] at
org.theospi.portfolio.admin.SakaiComponentTask.initialize
(SakaiComponentTask.java:106)
[add-site-tool] at
org.theospi.portfolio.admin.SakaiComponentTask.execute
(SakaiComponentTask.java:84)
[add-site-tool] at org.apache.tools.ant.UnknownElement.execute
(UnknownElement.java:275)
[add-site-tool] at org.apache.tools.ant.Task.perform (Task.java:364)
[add-site-tool] at org.apache.tools.ant.Target.execute (Target.java:341)
[add-site-tool] at org.apache.tools.ant.Target.performTasks
(Target.java:369)
[add-site-tool] at org.apache.tools.ant.Project.executeTarget
(Project.java:1214)
[add-site-tool] at org.apache.tools.ant.taskdefs.Ant.execute
(Ant.java:386)
[add-site-tool] at org.apache.tools.ant.taskdefs.CallTarget.execute
(CallTarget.java:106)
[add-site-tool] at org.apache.tools.ant.UnknownElement.execute
(UnknownElement.java:275)
[add-site-tool] at org.apache.tools.ant.Task.perform (Task.java:364)
[add-site-tool] at org.apache.tools.ant.Target.execute (Target.java:341)
[add-site-tool] at org.apache.tools.ant.Target.performTasks
(Target.java:369)
[add-site-tool] at org.apache.tools.ant.Project.executeTarget
(Project.java:1214)
[add-site-tool] at org.apache.tools.ant.Project.executeTargets
(Project.java:1062)
[add-site-tool] at org.apache.tools.ant.Main.runBuild (Main.java:673)
[add-site-tool] at org.apache.tools.ant.Main.startAnt (Main.java:188)
[add-site-tool] at org.apache.tools.ant.launch.Launcher.run
(Launcher.java:196)
[add-site-tool] at org.apache.tools.ant.launch.Launcher.main
(Launcher.java:55)
[add-site-tool] Caused by:
org.springframework.beans.factory.BeanDefinitionStoreException: Error
registering bean with name 'fileValidator' defined in
class path resource [repository-config.xml]: Unexpected element or
type mismatch: expected single node of class gnu.xml.dom.DomText to be
of type Text: found gnu.xml.dom.DomElement[value]
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.getTextValue
(DefaultXmlBeanDefinitionParser.java:553)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parsePropertySubelement
(DefaultXmlBeanDefinitionParser.java:465)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.getPropertyValue
(DefaultXmlBeanDefinitionParser.java:414)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parsePropertyElement
(DefaultXmlBeanDefinitionParser.java:386)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.getPropertyValueSubElements
(DefaultXmlBeanDefinitionParser.java:334)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinition
(DefaultXmlBeanDefinitionParser.java:238)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.loadBeanDefinition
(DefaultXmlBeanDefinitionParser.java:200)
[add-site-tool] at
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.registerBeanDefinitions
(DefaultXmlBeanDefinitionParser.java:152)
[add-site-tool] at
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions
(XmlBeanDefinitionReader.java:161)
[add-site-tool] at
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions
(XmlBeanDefinitionReader.java:127)
[add-site-tool] at
org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions
(AbstractXmlApplicationContext.java:123)
[add-site-tool] at
org.springframework.context.support.AbstractXmlApplicationContext.refreshBeanFactory
(AbstractXmlApplicationContext.java:65)
[add-site-tool] at
org.springframework.context.support.AbstractApplicationContext.refresh
(AbstractApplicationContext.java:232)
[add-site-tool] at
org.springframework.context.support.ClassPathXmlApplicationContext.<init>
(ClassPathXmlApplicationContext.java:68)
[add-site-tool] at
org.theospi.utils.ioc.ApplicationContextFactory.createContext
(ApplicationContextFactory.java:47)
[add-site-tool] ...20 more
BUILD FAILED
/home/will/osp-2.0.1/conf/manage_osp.xml:100: The following error
occurred while executing this line:
/home/will/osp-2.0.1/conf/manage_osp.xml:120:
java.lang.RuntimeException: problem loading ApplicationContext: Error
registering bean with name 'fileValidator' defined in class path
resource [repository-config.xml]: Unexpected element or type mismatch:
expected single node of class gnu.xml.dom.DomText to be of type Text:
found gnu.xml.dom.DomElement[value]
Total time: 1 minute 30 seconds
the mysql errors are merely reflecting being unable to update
timestamps, no big deal. the java errors, tho, are a big deal,
and we don't grok that language. :(
Reply to: