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

Mon Aug 6 09:27:44 PDT 2012

Hello:

For those interested in this thread, I see that all 3 SCO JIRA issues of interest were addressed this past weekend by Roland Groen.  Thanks very much!

I'll apply the patches for these trunk changes and see how it goes.  I did find a SQL script to drop the SCORM tables from the database: scorm-impl/sql/drop_tables_mysql.sql

Thanks,
Cindy

________________________________________
From: Brian Jones [bjones86 at uwo.ca]
Sent: Friday, August 03, 2012 10:27 AM
To: Gast, Cynthia (cmw6s); '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 Cynthia,

I was testing the Edia SCORM player to see if it was a viable option to use
in our production environment. Due to the bug(s), we decided to abandon this
project.

I reported the issues to Edia through both Jira and direct email, but
nothing has been fixed and nothing was suggested to me.

Cheers,

Brian Jones
Applications Development
Information Technology Services
Support Services Building, Room 4326
Western University
(519) 661-2111 x86969
bjones86 at uwo.ca

-----Original Message-----
From: Gast, Cynthia (cmw6s) [mailto:cmw6s at eservices.virginia.edu]
Sent: Friday, August 03, 2012 10:18 AM
To: Brian Jones; '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

Thank-you, Brian, you are correct.  I linked the two, noting that SCO-86 is
a duplicate of issue SCO-80.

Did you fix this yourself, or receive a suggested fix for it?

Wondering if you, or anyone else, is running this Edia 'Sakai SCORM Player
tool in production with Sakai 2.8?

Thanks,
Cynthia Gast
University of Virginia, Sakai development team cmw6s at virginia.edu

________________________________________
From: Brian Jones [bjones86 at uwo.ca]
Sent: Thursday, August 02, 2012 3:57 PM
To: Gast, Cynthia (cmw6s); '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

https://jira.sakaiproject.org/browse/SCO-86 may also be related to
https://jira.sakaiproject.org/browse/SCO-80 that I filed at the end of May.

Brian Jones
Applications Development
Information Technology Services
Support Services Building, Room 4326
Western University
(519) 661-2111 x86969
bjones86 at uwo.ca

From: sakai-dev-bounces at collab.sakaiproject.org
[mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Gast,
Cynthia (cmw6s)
Sent: Thursday, August 02, 2012 3:50 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

I created the following SCORM Player JIRAs:

See Edia JIRA: https://jira.sakaiproject.org/browse/SCO
. https://jira.sakaiproject.org/browse/SCO-85
o sakai-scorm fails to build due to 'testSimple' test failure .
https://jira.sakaiproject.org/browse/SCO-86
o Database errors creating SCORM_ELEMENT_T table .
https://jira.sakaiproject.org/browse/SCO-87
o 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+i
nstallation+guide  (see my previous email) :-)  The problems I noted in
nstallation+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+Integrat
ion

There are also installation instructions at
https://confluence.sakaiproject.org/display/FRA/Installation+Player+Scorm+ED
IA, 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+i
nstallation+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(BaseContentS
ervice.java:4219)
        at
org.sakaiproject.scorm.service.sakai.impl.SakaiResourceService.init(SakaiRes
ourceService.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 to sakai-dev-unsubscribe at collab.sakaiproject.org
with a subject of "unsubscribe"