[Building Sakai] Basic LTI startup errors

[Charles Severance]

If autoddl is not on - you will see these messages.  

When the LTI service starts it looks at the current table structure and decides what it needs to change to make it what it wants.  If autoddl is on - it just does the ALTER statements and gives you an INFO - if autoddl is off it tells you what it would like you to do in the form of an ERROR to call your attention to it.

Take a look at the release notes for 2.1.0

https://confluence.sakaiproject.org/display/LTI/LTI+-+Release+2.1.0+Notes

There are even conversion scripts.  When you go to 2.1.1 there is also a little conversion as well:

https://confluence.sakaiproject.org/display/LTI/LTI+-+Release+2.1.1+Notes

/Chuck



On Aug 28, 2013, at 4:33 PM, George Pipkin <gpp8p at Virginia.EDU> wrote:

> Hi -
> 
>    I just installed Basic LTI v2.1.0, and everything looks like it 
> works except
> we're seeing this in the logs upon startup:
> 
> 2013-08-28 10:00:30,970 ERROR localhost-startStop-1 
> org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> ALTER TABLE lti_mapping MODIFY     matchpattern VARCHAR(255)
> 2013-08-28 10:00:30,970 ERROR localhost-startStop-1 
> org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> ALTER TABLE lti_mapping MODIFY     launch VARCHAR(255)
> 2013-08-28 10:00:30,970 ERROR localhost-startStop-1 
> org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> ALTER TABLE lti_mapping MODIFY     note VARCHAR(255)
> 2013-08-28 10:00:30,973 ERROR localhost-startStop-1 
> org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> ALTER TABLE lti_content MODIFY     SITE_ID VARCHAR(99)
> 2013-08-28 10:00:30,973 ERROR localhost-startStop-1 
> org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> ALTER TABLE lti_content MODIFY     title VARCHAR(255)
> /org.sakaiproject.lti.impl.DBLTIService - SQL Needed:
> 
> 
> At first I thought this might be an instance of auto_ddl not being on at 
> least for one startup, but I see it
> on test servers where we definitely did run it with auto_ddl on at least 
> once, and BLTI-127 added an error
> message for this situation.  So I'm wondering where this comes from ?  
> We did have a previous version
> of BLTI on these servers - is it trying to modify the database to meet 
> current release requirements and failing
> to do so ?  The tool looks like it is running fine.
> 
>                        - George Pipkin
>                           U.Va.
> _______________________________________________
> 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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130828/2f5f45ea/attachment.html