AnsweredAssumed Answered

Changed repository to MySQL & didn't work

Question asked by ricter on Oct 9, 2008
Latest reply on Oct 10, 2008 by ricter
I've installed succesfully (at least this is what I think) Alfresco on a Centos 4. Changed the default port to 8081 and after a few problems got it working. Then I wanted to change Derby to MySQL and followed the instructions that I found:
Locate the distribution's extension configuration files and samples (here) and remove the .sample extensions:

    * <extensionRoot>/alfresco/extension/custom-repository-context.xml.sample
          o This ensures that the properties overrides from the files below are pulled into the server.
    * <extensionRoot>/alfresco/extension/custom-repository.properties.sample
          o Choose a root location for the storage of content binaries and index files.
          o Adjust properties here to change the database connection details.
          o Pay attention to the choice of JDBC driver used with each connection type.
    * <extensionRoot>/alfresco/extension/custom-hibernate-dialect.properties.sample
          o Choose a Hibernate schema most appropriate to your database (Hibernate Dialects).
And when I start Alfresco again I got this in the alfresco.log

16:08:04,336 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]                                                                                                                               
16:08:09,643 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed                                                 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml   
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                            
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                           
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                            
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                   
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                           
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                     
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                       
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                               
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                     
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                             
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)                                                       
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)                                                               
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                    
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                            
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)                                               
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)                                                                 
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)                                                                    
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)                                                                 
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)                                                                
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)                                                              
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)                                                                
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)                                                                         
        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:597)                                                                                      
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                       
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                        
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                  
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)                                                                      
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)                                            
        … 57 more                                                                                                                              
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                     
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)                                                            
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)                                                                    
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)                                                                   
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)                                                                      
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)                                                                      
        … 58 more                                                                                                                              
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                   
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)                                                         
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)                                                          
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)                                       
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)                                                            
        … 62 more                                                                                                                              
16:08:09,665 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener                                                         
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml   
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                            
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                           
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                            
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                   
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                           
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                     
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                       
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                               
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                     
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                             
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)                                                       
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)                                                               
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                    
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                            
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)                                               
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)                                                                 
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)                                                                    
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)                                                                 
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)                                                                
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)                                                              
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)                                                                
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)                                                                         
        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:597)                                                                                      
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                       
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                        
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                  
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)                                                                      
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)                                            
        … 57 more                                                                                                                              
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                     
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)                                                            
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)                                                                    
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)                                                                   
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)                                                                      
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)                                                                      
        … 58 more                                                                                                                              
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                   
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)                                                         
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)                                                          
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)                                       
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)                                                            
        … 62 more                                                                                                                              
16:08:09,668 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.alfresco.web.app.ContextListener                                                                          
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                               
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml   
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                            
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                           
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                            
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                   
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                           
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                     
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                       
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                               
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                     
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                             
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)                                                       
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)                                                               
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)                                                                 
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                    
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)
        … 57 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
        … 58 more
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
        … 62 more
16:08:15,867 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
If I connect to MySQL I got this
mysql -u alfresco -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 463
Server version: 5.0.66a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use alfresco
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+——————–+
| Tables_in_alfresco |
+——————–+
| JBPM_ACTION        |
| JBPM_BYTEARRAY     |
| alf_bootstrap_lock |
+——————–+
3 rows in set (0.00 sec)
I've typed:
ll alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml
-rw-r–r–  1 root root 4209 sep  9 15:55 alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml
And got this in custom-hibernate-dialect.properties


#
# MySQL dialect (default)
#
mysql#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

What could it be the reason for this?

Outcomes