[Building Sakai] Sakai SCORM Player errors with 2.8.1 - DB table/index creation errors; test build failure
Gast, Cynthia (cmw6s)
cmw6s at eservices.virginia.edu
Thu Aug 2 12:50:22 PDT 2012
I created the following SCORM Player JIRAs:
See Edia JIRA: https://jira.sakaiproject.org/browse/SCO
* https://jira.sakaiproject.org/browse/SCO-85
* sakai-scorm fails to build due to 'testSimple' test failure
* https://jira.sakaiproject.org/browse/SCO-86
* Database errors creating SCORM_ELEMENT_T table
* https://jira.sakaiproject.org/browse/SCO-87
* PermissionException during first tomcat restart
Cynthia Gast
University of Virginia, Sakai development team
cmw6s at virginia.edu
________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Gast, Cynthia (cmw6s) [cmw6s at eservices.virginia.edu]
Sent: Thursday, August 02, 2012 12:45 PM
To: Mark J. Norton
Cc: Sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] Sakai SCORM Player errors with 2.8.1 - DB table/index creation errors; test build failure
Hi Mark :-)
I appreciate your comments and interest in helping with this. I'm hoping someone at Edia also sees my mail, since, as you noted, this seems to be their project now. I've now found their JIRA (https://jira.sakaiproject.org/browse/SCO), so I will also open these problems as issues with them.
I should have made it clear in my first email, but I already followed the installation instructions found at https://confluence.sakaiproject.org/display/SCORMPLAYER/Sakai+SCORM+player+installation+guide (see my previous email) :-) The problems I noted in my first email are based on following these instructions.
Thanks much,
Cindy
________________________________
From: Mark J. Norton [markjnorton at earthlink.net]
Sent: Thursday, August 02, 2012 11:43 AM
To: Gast, Cynthia (cmw6s)
Cc: Sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] Sakai SCORM Player errors with 2.8.1 - DB table/index creation errors; test build failure
SCORM.2004.3ED.RTE is the player originally done by UC Davis and has been updated by Edia since. Wicket is an UI framework used by the SCORM player. Some information on the Edia player at https://confluence.sakaiproject.org/display/SCORMPLAYER/Edia+Player+Integration
There are also installation instructions at https://confluence.sakaiproject.org/display/FRA/Installation+Player+Scorm+EDIA, unfortunately in French. Still, you might be able to puzzle it out.
If you continue to have problems, post them to the sakai-dev list. I or someone else will help. You might also contact Edia. Check out http://sakai.edia.nl/?page_id=946
I worked on the SCORM player in the past, but Edia has taken the lead since.
- Mark
On 8/2/2012 11:26 AM, Gast, Cynthia (cmw6s) wrote:
Hello Mark:
We were pointed to these installation instructions about the Sakai SCORM Player: https://confluence.sakaiproject.org/display/SCORMPLAYER/Sakai+SCORM+player+installation+guide
They direct us to get two projects:
-- https://source.sakaiproject.org/contrib/edia/sakai-wicket-for-scorm/ (checkout as sakai-wicket)
-- https://source.sakaiproject.org/contrib/scorm/SCORM.2004.3ED.RTE/ (checkout as sakai-scorm)
Thanks,
Cindy
________________________________
From: sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org> [sakai-dev-bounces at collab.sakaiproject.org<mailto:sakai-dev-bounces at collab.sakaiproject.org>] on behalf of Mark J. Norton [markjnorton at earthlink.net<mailto:markjnorton at earthlink.net>]
Sent: Thursday, August 02, 2012 11:10 AM
To: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: Re: [Building Sakai] Sakai SCORM Player errors with 2.8.1 - DB table/index creation errors; test build failure
Which contrib project is that? I don't see it under https://source.sakaiproject.org/contrib/scorm/
In general, most Sakai SCORM players are not up to date.
- Mark
On 8/2/2012 11:03 AM, Gast, Cynthia (cmw6s) wrote:
Hello:
The University of Virginia is interested in adding the contrib project "Sakai SCORM Player" to our 2.8.1 Sakai installation, using MySQL for the database. After following the Sakai SCORM Player's installation instructions, I've run into three issues.
1) sakai-scorm project fails to build due to a test failure (testSimple(org.sakaiproject.scorm.dao.hibernate.DataManagerDaoImplTest)) in "sakai-scorm-model-impl"
-- I rebuilt with tests disabled, for now, to continue
2) I see DB Errors when restarting tomcat. The initial DB Error follows, and others occur because this SCORM_ELEMENT_T table was not created.
2a) First DB Error:
WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create table SCORM_ELEMENT_T (ELEMENT_ID bigint not null auto_increment, CLASS_TYPE varchar(255) not null, DESCRIPTION bigint, PARENT bigint, VALUE varchar(65535), IS_INITIALIZED bit, TRUNC_SPM bit, ELEMENT_DM bigint, NAVIGATION_DM bigint, BINDING varchar(255), IS_RANDOMIZED bit, DM_COUNT integer, primary key (ELEMENT_ID)) ENGINE=InnoDB
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column length too big for column 'VALUE' (max = 21845); use BLOB or TEXT instead
3) Another error seen in the tomcat startup log:
WARN main org.sakaiproject.scorm.service.sakai.impl.SakaiResourceService - Couldn't configure scorm root colection.
org.sakaiproject.exception.PermissionException user=null lock=content.revise.any resource=/content/private/scorm/
at org.sakaiproject.content.impl.BaseContentService.editCollection(BaseContentService.java:4219)
at org.sakaiproject.scorm.service.sakai.impl.SakaiResourceService.init(SakaiResourceService.java:352)
Are these known issues, perhaps documented somewhere that I missed? Appreciate patches or pointers on how to proceed.
Here is what I did to reach this point:
I exported the source for both "contrib/edia/sakai-wicket-for-scorm/" (creating sakai-wicket project) and "contrib/scorm/SCORM.2004.3ED.RTE/" (creating sakai-scorm project). I followed the installation instructions with the following exception: instead of getting the source from 'trunk' branch, I acquired the following tagged versions (which appear to be the latest code from trunk).
sakai-wicket: 3.0.0 tag
sakai-scorm: 3.0.2 tag
Changed version number information to match ours. Built sakai-wicket first (mvn clean install), then sakai-scorm (mvn clean install sakai:deploy -Dmaven.test.skip=true). Restarted tomcat.
Thanks very much for any guidance on these issues.
Cynthia Gast
(formerly, Cynthia Walters)
University of Virginia, Sakai development team
cmw6s at virginia.edu<mailto:cmw6s at virginia.edu>
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120802/dbe6063a/attachment.html
More information about the sakai-dev
mailing list