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

Mark J. Norton markjnorton at earthlink.net
Thu Aug 2 09:59:44 PDT 2012 

Have you configured your Sakai instance to store content in files or the 
database?  If the later, you might have problems.

- Mark

On 8/2/2012 12:45 PM, Gast, Cynthia (cmw6s) wrote:
> 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 
>> [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/eadb873c/attachment.html

More information about the sakai-dev mailing list