[Building Sakai] Switching from HSQLDB to MySQL
Anthony Whyte
arwhyte at umich.edu
Wed Apr 28 11:37:13 PDT 2010
Try downgrading Tomcat from 5.5.29 to 5.5.26 or 5.5.28
http://archive.apache.org/dist/tomcat/tomcat-5/
I create a $CATALINA_HOME/bin/setenv.sh to manage JVM settings.
If running 5.5.26 (and Java 1.5):
setenv.sh
# CM demo data
export JAVA_OPTS='-server -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=196m -XX:NewSize=192m -XX:MaxNewSize=384m -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Djava.awt.headless=true -Dsakai.demo=true'
# Internationalization (Portuguese)
#export JAVA_OPTS='-server -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=196m -XX:NewSize=192m -XX:MaxNewSize=384m -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Djava.awt.headless=true -Dsakai.demo=true -Duser.language=pt -Duser.region=PT'
If running 5.5.28 (and Java 1.6):
setenv.sh
# Default
# 20091101 added -Djava.awt.headless=true -Dsakai.demo=true
# 20091201 added -Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false for JSF/Tomcat 5.5.28 compatibility issues
# 20100120 added -Dsun.lang.ClassLoader.allowArraySyntax=true for JSF/Java 1.6 compatibility issues
# 20100121 MaxPermSize increased from 196m to 256m for Java 1.6
# 20100121 MaxPermSize increased from 256m to 512m for Java 1.6
# 20100218 Added -Dhttp.agent=Sakai for resolving Google RSS feeds with the News tool.
# CM demo data
export JAVA_OPTS='-server -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=512m -XX:NewSize=192m -XX:MaxNewSize=384m -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Djava.awt.headless=true -Dhttp.agent=Sakai -Dsakai.demo=true -Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false -Dsun.lang.ClassLoader.allowArraySyntax=true'
# Internationalization (Portuguese)
#export JAVA_OPTS='-server -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=512m -XX:NewSize=192m -XX:MaxNewSize=384m -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Djava.awt.headless=true -Dhttp.agent=Sakai -Dsakai.demo=true -Duser.language=pt -Duser.region=PT -Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false -Dsun.lang.ClassLoader.allowArraySyntax=true'
Cheers,
Anthony
On Apr 28, 2010, at 1:40 PM, Matthew Sharrer wrote:
> I understand. I think I may try another build with your suggested Maven version.
>
> I really appreciate the help.
>
> Here's a snippet of the catalina.out:
>
> 2010-04-28 10:57:02,307 INFO main org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/servlets-examples] - ContextListener: contextDestroyed()
>
> 2010-04-28 10:57:02,532 INFO main org.sakaiproject.jsf.util.JsfTool - destroy
> 2010-04-28 10:57:02,545 INFO main org.sakaiproject.jsf.util.JsfTool - destroy
> 2010-04-28 10:57:15,644 INFO main org.sakaiproject.jsf.util.JsfTool - destroy
>
> 2010-04-28 10:57:15,759 INFO main org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/sakai-gradebook-testservice] - Closing Spring root WebApplicationContext
> 2010-04-28 10:57:15,763 INFO main org.sakaiproject.util.ContextLoaderListener - Destroying Components in sakai-gradebook-service-test
>
> 2010-04-28 10:57:24,278 INFO main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Updating database schema for Hibernate SessionFactory
> 2010-04-28 10:57:52,233 INFO main org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/sakai-site-manage-participant-helper] - Closing Spring root WebApplicationContext
>
> 2010-04-28 10:58:13,874 INFO main org.sakaiproject.util.ContextLoaderListener - Destroying Components in sakai-site-manage-participant-helper
> 2010-04-28 10:59:27,772 INFO main org.sakaiproject.james.JamesServlet - destroy()
>
> 2010-04-28 10:59:30,426 INFO main org.sakaiproject.jsf.util.JsfTool - destroy
> 2010-04-28 10:59:35,770 INFO main org.sakaiproject.entity.impl.EntityManagerComponent - init()
> 2010-04-28 10:59:35,945 INFO main org.sakaiproject.authz.impl.FunctionManagerComponent - init()
>
> 2010-04-28 10:59:35,946 INFO main org.sakaiproject.user.impl.BasePreferencesService - init()
> 2010-04-28 10:59:35,946 INFO main org.sakaiproject.user.impl.DbPreferencesService - init(): table: SAKAI_PREFERENCES locks-in-db: false
>
> 2010-04-28 10:59:36,692 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - init
> 2010-04-28 10:59:37,401 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl$1) prefix (describe) with 1 capabilities
>
> 2010-04-28 10:59:37,407 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl$2) prefix (batch) with 1 capabilities
>
> 2010-04-28 10:59:37,712 INFO main org.sakaiproject.event.impl.BaseEventTrackingService - org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$6dad1d13 at 618821.init()
> 2010-04-28 10:59:37,722 INFO main org.sakaiproject.event.impl.ClusterEventTracking - org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$6dad1d13 at 618821.init() - period: 5 batch: true checkDb: true
>
> 2010-04-28 10:59:38,809 INFO main org.sakaiproject.tool.impl.ToolComponent - init(): hidden tools: sakai.mailtool sakai.presentation
> 2010-04-28 10:59:39,732 INFO main org.sakaiproject.memory.impl.BasicMemoryService - init()
>
> 2010-04-28 10:59:39,923 INFO main org.sakaiproject.event.impl.UsageSessionServiceAdaptor - init()
> 2010-04-28 10:59:40,540 INFO main org.sakaiproject.id.impl.UuidV4IdComponent - init()
> 2010-04-28 10:59:40,582 INFO main org.sakaiproject.time.api.TimeService - init()
>
> 2010-04-28 10:59:42,642 INFO main org.sakaiproject.email.impl.BasicEmailService - init(): smtp: some.smtp.org bounces to: postmaster at localhost maxRecipients: 100 testMode: false
>
> 2010-04-28 10:59:44,358 INFO main org.sakaiproject.coursemanagement.impl.CourseManagementServiceHibernateImpl - Initializing org.sakaiproject.coursemanagement.impl.CourseManagementServiceHibernateImpl
> 2010-04-28 10:59:44,616 INFO main org.sakaiproject.coursemanagement.impl.provider.CourseManagementGroupProvider - initializing org.sakaiproject.coursemanagement.impl.provider.CourseManagementGroupProvider
>
> 2010-04-28 10:59:44,629 INFO main org.sakaiproject.authz.impl.BaseAuthzGroupService - init(): provider: $Proxy6
> 2010-04-28 10:59:45,118 INFO main org.sakaiproject.authz.impl.DbAuthzGroupService - init(): table: SAKAI_REALM external locks: true
>
> INFO: [GenericDao] Could not execute first DDL line, skipping the rest: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'ENTITY_PROPERTIES' already exists
> INFO: [GenericDao] Could not execute first DDL line, skipping the rest: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'ENTITY_TAG_APPLICATIONS' already exists
>
> 2010-04-28 10:59:48,639 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.sakaiproject.authz.api.SecurityService.cache] as Cache [org.sakaiproject.authz.api.SecurityService.cache] Max Elements in Memory [10000] Max Elements on Disk [0] Time to Idle (seconds) [300] Time to Live (seconds) [300] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:51,568 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.sakaiproject.site.impl.SiteCacheImpl.cache] as Cache [org.sakaiproject.site.impl.SiteCacheImpl.cache] Max Elements in Memory [10000] Max Elements on Disk [0] Time to Idle (seconds) [300] Time to Live (seconds) [300] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:51,569 INFO main org.sakaiproject.site.impl.DbSiteService - init(): site table: SAKAI_SITE external locks: true
> 2010-04-28 10:59:52,283 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.sakaiproject.user.api.UserDirectoryService.callCache] as Cache [org.sakaiproject.user.api.UserDirectoryService.callCache] Max Elements in Memory [10000] Max Elements on Disk [0] Time to Idle (seconds) [300] Time to Live (seconds) [300] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:52,285 INFO main org.sakaiproject.user.impl.BaseUserDirectoryService - init(): provider: none separateIdEid: true
> 2010-04-28 10:59:52,285 INFO main org.sakaiproject.user.impl.DbUserService - init(): table: SAKAI_USER external locks: true
>
> 2010-04-28 10:59:52,286 INFO main org.sakaiproject.user.impl.DbUserService - Cache [org.sakaiproject.user.api.UserDirectoryService] Max Elements in Memory [100000] Max Elements on Disk [0] Time to Idle (seconds) [7200] Time to Live (seconds) [7200] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:52,824 INFO main org.sakaiproject.chat2.model.impl.ChatManagerImpl - init()
> 2010-04-28 10:59:52,968 WARN main org.sakaiproject.entitybroker.util.core.AbstractEntityPropertiesService - No properties to load for entity prefix (chat-channel) and basename (chat-channel)
>
> 2010-04-28 10:59:52,970 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.chat2.model.impl.ChatChannelEntityProvider) prefix (chat-channel) with 7 capabilities
>
> 2010-04-28 10:59:52,999 WARN main org.sakaiproject.entitybroker.util.core.AbstractEntityPropertiesService - No properties to load for entity prefix (chat-message) and basename (chat-message)
> 2010-04-28 10:59:53,013 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.chat2.model.impl.ChatMessageEntityProvider) prefix (chat-message) with 9 capabilities
>
> 2010-04-28 10:59:53,453 INFO main org.sakaiproject.component.app.messageforums.MessageForumsTypeManagerImpl - init()
> 2010-04-28 10:59:55,703 INFO main org.sakaiproject.component.app.messageforums.MessageForumsForumManagerImpl - init()
>
> 2010-04-28 10:59:55,791 INFO main org.sakaiproject.component.app.messageforums.AreaManagerImpl - init()
> 2010-04-28 10:59:56,747 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.sakaiproject.alias.api.AliasService.callCache] as Cache [org.sakaiproject.alias.api.AliasService.callCache] Max Elements in Memory [10000] Max Elements on Disk [0] Time to Idle (seconds) [300] Time to Live (seconds) [300] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:56,749 INFO main org.sakaiproject.alias.impl.DbAliasService - init(): table: SAKAI_ALIAS external locks: true checkOld: false
> 2010-04-28 10:59:56,888 INFO main org.sakaiproject.event.impl.BaseNotificationService - org.sakaiproject.event.impl.DbNotificationService$$EnhancerByCGLIB$$65448a08 at 1390efd.init()
>
> 2010-04-28 10:59:56,908 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.sakaiproject.event.api.NotificationService.cache] as Cache [org.sakaiproject.event.api.NotificationService.cache] Max Elements in Memory [10000] Max Elements on Disk [0] Time to Idle (seconds) [300] Time to Live (seconds) [300] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 10:59:56,908 INFO main org.sakaiproject.event.impl.BaseNotificationService - org.sakaiproject.event.impl.DbNotificationService$$EnhancerByCGLIB$$65448a08 at 1390efd.init()
> 2010-04-28 10:59:56,909 INFO main org.sakaiproject.event.impl.DbNotificationService - .init(): table: SAKAI_NOTIFICATION locks-in-db: false
>
> 2010-04-28 10:59:57,026 INFO main org.sakaiproject.content.impl.DbResourceTypeRegistry - init()
> 2010-04-28 10:59:57,044 INFO main org.sakaiproject.content.impl.ResourceTypeRegistryImpl - init()
> 2010-04-28 10:59:57,749 INFO main org.sakaiproject.content.impl.DbContentService -
>
> ====================================================
> ====================================================
> Conversion of the ContentHostingService database tables is complete.
> Using new filesize column
> ====================================================
>
> ====================================================
>
> 2010-04-28 10:59:57,945 INFO main org.sakaiproject.content.impl.DbContentService - Migration of data to the Binary format will be performed by this node
> 2010-04-28 10:59:58,508 INFO main org.sakaiproject.content.impl.BaseContentService - Loaded Storage as org.sakaiproject.content.impl.DbContentService$DbStorage at 1bf00a9 for org.sakaiproject.content.impl.DbContentService at c45f52
>
> 2010-04-28 10:59:58,562 INFO main org.sakaiproject.content.impl.BaseContentService - init(): site quota: 1048576 body path: null volumes:
> 2010-04-28 10:59:59,049 INFO main org.sakaiproject.content.impl.DbContentService - init(): tables: CONTENT_COLLECTION CONTENT_RESOURCE CONTENT_RESOURCE_BODY_BINARY CONTENT_ENTITY_GROUPS locks-in-db: false bodyPath: null storage: org.sakaiproject.content.impl.DbContentService$DbStorage at 1bf00a9
>
> 2010-04-28 10:59:59,052 INFO main org.sakaiproject.component.app.messageforums.MessageForumsMessageManagerImpl - init()
> 2010-04-28 10:59:59,147 INFO main org.sakaiproject.component.app.messageforums.DefaultPermissionsManagerImpl - init()
>
> 2010-04-28 10:59:59,148 INFO main org.sakaiproject.component.app.messageforums.PermissionManagerImpl - init()
> 2010-04-28 10:59:59,361 INFO main org.sakaiproject.component.app.messageforums.MembershipManagerImpl - init()
>
> 2010-04-28 10:59:59,418 INFO main org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl - init()
> 2010-04-28 11:00:00,142 INFO main org.sakaiproject.component.app.messageforums.ui.DiscussionForumManagerImpl - init()
>
> 2010-04-28 11:00:00,182 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumTopicEntityProviderImpl) prefix (forum_topic) with 5 capabilities
>
> 2010-04-28 11:00:00,197 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumEntityProviderImpl) prefix (forum) with 5 capabilities
>
> 2010-04-28 11:00:00,210 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumMessageEntityProviderImpl) prefix (forum_message) with 5 capabilities
>
> 2010-04-28 11:00:02,075 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.tool.assessment.entity.impl.PublishedAssessmentEntityProviderImpl) prefix (sam_pub) with 6 capabilities
>
> 2010-04-28 11:00:02,076 INFO main org.sakaiproject.entitybroker.util.spring.EntityProviderAutoRegistrar - AutoRegistered EntityProvider prefixes : chat-channel : chat-message : forum_topic : forum : forum_message : sam_pub
>
> 2010-04-28 11:00:02,076 INFO main org.sakaiproject.entitybroker.util.spring.EntityProviderAutoRegistrar - init
> 2010-04-28 11:00:02,943 INFO main org.theospi.portfolio.worksite.mgt.impl.WorksiteListGenerator - init()
>
> 2010-04-28 11:00:04,258 INFO main org.theospi.portfolio.guidance.impl.GuidanceEntityProducer - init()
> 2010-04-28 11:00:04,709 INFO main org.theospi.portfolio.style.impl.StyleManagerImpl - init()
> 2010-04-28 11:00:05,797 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
>
> 2010-04-28 11:00:07,263 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
> 2010-04-28 11:00:07,705 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
> 2010-04-28 11:00:07,824 INFO main org.theospi.portfolio.security.model.SakaiDefaultPermsManager - init()
>
> 2010-04-28 11:00:13,401 INFO main org.theospi.portfolio.help.model.DbGlossary - init()
> 2010-04-28 11:00:13,713 INFO main org.theospi.portfolio.help.impl.GlossaryEntityProducer - init()
> 2010-04-28 11:00:14,791 INFO main org.sakaiproject.metaobj.shared.mgt.impl.StructuredArtifactDefinitionManagerImpl - init()
>
> 2010-04-28 11:00:14,832 INFO main org.sakaiproject.metaobj.shared.mgt.impl.StructuredArtifactDefinitionManagerImpl - Updating base Metaobj XSLT files (auto.ddl is on).
> 2010-04-28 11:00:33,989 INFO main org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl - init()
>
> 2010-04-28 11:00:45,991 INFO main org.theospi.portfolio.admin.service.SakaiIntegrationServiceImpl - afterPropertiesSet()
> 2010-04-28 11:00:47,138 INFO main org.theospi.portfolio.matrix.model.impl.MatrixContentEntityProducer - init()
>
> 2010-04-28 11:00:47,228 INFO main org.theospi.portfolio.workflow.impl.WorkflowEntityProducer - init()
> 2010-04-28 11:00:47,623 INFO main org.theospi.portfolio.presentation.model.impl.LayoutEntityProducer - init()
> 2010-04-28 11:00:47,657 INFO main org.theospi.portfolio.presentation.model.impl.PresentationContentEntityProducer - init()
>
> 2010-04-28 11:00:49,142 INFO main org.sakaiproject.memory.impl.BasicMemoryService - Added Cache name [org.theospi.portfolio.wizard.mgt.impl.WizardManagerImpl.cache] as Cache [org.theospi.portfolio.wizard.mgt.impl.WizardManagerImpl.cache] Max Elements in Memory [500] Max Elements on Disk [0] Time to Idle (seconds) [10] Time to Live (seconds) [60] Memory Store Eviction Policy [LRU]
>
> 2010-04-28 11:00:49,152 INFO main org.theospi.portfolio.wizard.mgt.impl.WizardManagerImpl - init()
> 2010-04-28 11:00:49,327 INFO main org.theospi.portfolio.warehouse.osp.wizard.WizardWarehouseTask - init()
> 2010-04-28 11:01:37,861 INFO main org.theospi.portfolio.warehouse.osp.matrix.WizardPageWarehouseTask - init()
>
> 2010-04-28 11:02:23,794 INFO main org.theospi.portfolio.warehouse.osp.presentation.PresentationTemplateWarehouseTask - init()
> 2010-04-28 11:02:23,946 INFO main org.theospi.portfolio.warehouse.osp.presentation.PresentationLayoutWarehouseTask - init()
>
> 2010-04-28 11:02:24,148 INFO main org.theospi.portfolio.warehouse.osp.presentation.PresentationWarehouseTask - init()
> 2010-04-28 11:02:38,446 INFO main org.theospi.portfolio.warehouse.osp.matrix.ScaffoldingWarehouseTask - init()
>
> 2010-04-28 11:02:42,676 INFO main org.theospi.portfolio.warehouse.osp.matrix.MatrixWarehouseTask - init()
> 2010-04-28 11:02:44,331 INFO main org.theospi.portfolio.warehouse.osp.presentation.GuidanceWarehouseTask - init()
>
> 2010-04-28 11:02:45,462 INFO main org.theospi.portfolio.warehouse.osp.common.ReviewItemsWarehouseTask - init()
> 2010-04-28 11:02:47,566 INFO main org.theospi.portfolio.warehouse.osp.style.StyleWarehouseTask - init()
>
> 2010-04-28 11:02:47,656 INFO main org.theospi.portfolio.wizard.impl.WizardEntityProducer - init()
> 2010-04-28 11:02:47,906 INFO main org.sakaiproject.taggable.impl.TaggingManagerImpl - init()
> 2010-04-28 11:02:47,909 INFO main org.theospi.portfolio.wizard.taggable.impl.WizardActivityProducerImpl - init()
>
> 2010-04-28 11:02:48,116 INFO main org.theospi.portfolio.wizard.WizardListGenerator - init()
> 2010-04-28 11:02:48,121 INFO main org.theospi.portfolio.wizard.WizardListGenerator - init()
> 2010-04-28 11:02:48,133 INFO main org.theospi.portfolio.wizard.WizardListGenerator - init()
>
> 2010-04-28 11:02:48,917 INFO main org.sakaiproject.message.impl.BaseMessageService - init(): caching: false
> 2010-04-28 11:02:48,929 INFO main org.sakaiproject.announcement.impl.BaseAnnouncementService - init()
> 2010-04-28 11:02:48,930 INFO main org.sakaiproject.announcement.impl.DbAnnouncementService - init(): tables: ANNOUNCEMENT_CHANNEL ANNOUNCEMENT_MESSAGE locks-in-db: false
>
> 2010-04-28 11:02:49,011 INFO main org.sakaiproject.component.app.scheduler.ScheduledInvocationManagerImpl - init()
> 2010-04-28 11:02:51,475 INFO main org.sakaiproject.archive.impl.ArchiveService2Impl - init(): storage path: /usr/local/apache-tomcat-5.5.29/sakai//archive/
>
> 2010-04-28 11:02:52,275 INFO main org.sakaiproject.assignment.taggable.impl.AssignmentActivityProducerImpl - init()
> 2010-04-28 11:02:52,297 INFO main org.sakaiproject.assignment.impl.BaseAssignmentService - org.sakaiproject.assignment.impl.DbAssignmentService at 7fb878 init()
>
> 2010-04-28 11:02:52,381 INFO main org.sakaiproject.assignment.impl.DbAssignmentService - init: assignments table: ASSIGNMENT_ASSIGNMENT contents table: ASSIGNMENT_CONTENT submissions table: ASSIGNMENT_SUBMISSION locks-in-dbfalse
>
> 2010-04-28 11:02:52,420 INFO main org.sakaiproject.assignment.impl.AssignmentSupplementItemServiceImpl - init()
> 2010-04-28 11:02:53,893 INFO main org.sakaiproject.calendar.impl.BaseCalendarService - init(): caching: false
>
> 2010-04-28 11:02:53,920 INFO main org.sakaiproject.calendar.impl.SAK11204Fix - SAK-11204: Calendar Conversion Complete
> 2010-04-28 11:02:53,920 INFO main org.sakaiproject.calendar.impl.DbCalendarService - init(): tables: CALENDAR_CALENDAR CALENDAR_EVENT locks-in-db: false
>
> 2010-04-28 11:02:54,074 INFO main org.sakaiproject.calendar.impl.BaseExternalCalendarSubscriptionService - init(): enabled: false
> 2010-04-28 11:02:54,116 INFO main org.sakaiproject.chat2.model.impl.ChatDataMigration - init()
>
> 2010-04-28 11:02:54,131 INFO main org.sakaiproject.chat2.model.impl.ChatEntityProducer - init()
> 2010-04-28 11:02:59,834 WARN main org.sakaiproject.search.transaction.impl.TransactionSequenceImpl - Failed to check transaction table, ignore for HSQLDB pre-1.9+ versions. Communications link failure due to underlying exception:
>
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.ConnectException
> MESSAGE: Connection refused
>
> STACKTRACE:
>
> java.net.ConnectException: Connection refused
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367)
>
> at java.net.Socket.connect(Socket.java:524)
> at java.net.Socket.connect(Socket.java:474)
> at java.net.Socket.<init>(Socket.java:371)
> at java.net.Socket.<init>(Socket.java:213)
> at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
>
> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
> at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
>
> at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
>
> at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
> at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> at org.sakaiproject.search.transaction.impl.TransactionSequenceImpl.check(TransactionSequenceImpl.java:88)
>
> at org.sakaiproject.search.transaction.impl.TransactionSequenceImpl.getNextId(TransactionSequenceImpl.java:147)
> at org.sakaiproject.search.indexer.impl.SearchBuilderQueueManager.init(SearchBuilderQueueManager.java:108)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:592)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1240)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1205)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:281)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:131)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:281)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:131)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:281)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:131)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
>
> at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
>
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
> at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
>
>
>
> On Wed, Apr 28, 2010 at 1:20 PM, Anthony Whyte <arwhyte at umich.edu> wrote:
> Just checked the install guide. Yes, the minimum for 2.6 is Maven 2.0.6.
>
> That said, I handle the releases and use Maven extensively. All the senior developers with whom I work use Maven 2.2.1.
>
> Cheers,
>
> Anth
>
> What errors do you find in catalina.out when you try and start up Sakai?
>
>
> On Apr 28, 2010, at 12:56 PM, Matthew Sharrer wrote:
>
>> I was under the impression that most Sakai developers used Maven 2.0.8 or 2.0.9 with sakai 2.6.2
>>
>> On Wed, Apr 28, 2010 at 12:37 PM, Anthony Whyte <arwhyte at umich.edu> wrote:
>> To confirm, your sakai.properties looks like this (with HSQLDB commented out):
>>
>> e.g., for MySQL 5.0
>>
>> # Let Sakai generate database objects on startup.
>> # Default = true.
>> auto.ddl=true
>>
>> # The username and password. Change to match your setup.
>> username at javax.sql.BaseDataSource=sakaiuser
>> password at javax.sql.BaseDataSource=guessme
>>
>> ## MySQL settings - make sure to alter as appropriate
>> vendor at org.sakaiproject.db.api.SqlService=mysql
>> driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
>> hibernate.dialect=org.hibernate.dialect.MySQLDialect
>> url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
>> validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
>> defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
>>
>> Did you put your MySQL connector/j jar in $CATALINA_HOME/common/lib ? Also what version are you using?
>>
>> On a side note, I recommend upgrading your version of Maven to at least 2.0.10 (the minimum we require). I run 2.2.1.
>>
>> Cheers,
>>
>> Anthony
>>
>>
>> On Apr 28, 2010, at 12:04 PM, Matthew Sharrer wrote:
>>
>> > I've built Sakai, and I can get the demo to work running off of memory with HSQLDB.
>> >
>> > This is my environment:
>> > java version "1.5.0_22"
>> > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_22-b03)
>> > Java HotSpot(TM) Client VM (build 1.5.0_22-b03, mixed mode, sharing)
>> >
>> > Apache Tomcat 5.5.29
>> >
>> > Maven version: 2.0.8
>> > Java version: 1.5.0_22
>> > OS name: "linux" version: "2.6.18-164.el5" arch: "i386" Family: "unix"
>> >
>> > I've also set all the needed environment variables.
>> >
>> > The builds went alright, and like I said, I could login to Sakai when I was running off of memory.
>> >
>> > I attempted to switch to MySQL and I'm having no luck. I'm using version 5.0.77. I added a group and user for mysql, and set up environment variables. I was able to start up mysql, and I created the sakai database with the default character set utf8. I then typed the following:
>> > grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword';
>> > grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';
>> > flush privileges;
>> >
>> > I've installed the mysql JDBC driver.
>> >
>> > I created a my.cnf file in /etc:
>> > [mysqld]
>> > default-storage-engine=InnoDB
>> > Innodb_data_home_dir=/usr/local/mysql/data
>> > Innotdb_data_file_path=ibdata1:10M:autoextend
>> > Innodb_flush_log_at_trx_commit=1
>> >
>> > I edited teh sakai.properties file in $CATALINA_HOME/sakai:
>> > username at javax.sql.BaseDataSource=sakaiuser
>> > password at javax.sql.BaseDataSource=sakaipassword
>> >
>> > And I commented out the HSQLDB settings while uncommenting the mysql settings.
>> >
>> > I don't know what else to do. I feel like I followed the configuration instructions, but perhaps I'm missing something.
>> >
>> > If anyone can provide assistance, I'd greatly appreciate it. I can post logs, but I didn't want to post too much information at once.
>> >
>> >
>> >
>> > _______________________________________________
>> > 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/20100428/419e29fc/attachment.html
More information about the sakai-dev
mailing list