[Building Sakai] Sakai SCORM Player errors with 2.8.1 - DB table/index creation errors; test build failure

[Gast, Cynthia (cmw6s)]

I should have noted, this install guide also refers to it as the Edia SCORM player.
Thanks,
Cindy

________________________________
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 11:26 AM
To: Mark J. Norton; 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

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 [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Mark J. Norton [markjnorton at earthlink.net]
Sent: Thursday, August 02, 2012 11:10 AM
To: 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/a50a8f51/attachment.html