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

[Mark J. Norton]

|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 
> [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
>>
>>
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email tosakai-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/c6e0ff2b/attachment.html