topic Context initialization failed in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/214965#M168095 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>my alfresco is running,but when I change the database to Mysql it stop working and giving the following error</SPAN><BR /><BR /><SPAN>10:07:31,537 INFO&nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs</SPAN><BR /><SPAN>10:07:31,553 INFO&nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 772.13904ms)</SPAN><BR /><SPAN>10:08:32,800 INFO&nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs</SPAN><BR /><SPAN>10:08:32,800 INFO&nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 61225.14ms)</SPAN><BR /><SPAN>10:08:33,014 INFO&nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework</SPAN><BR /><SPAN>10:08:38,927 INFO&nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework</SPAN><BR /><SPAN>10:09:19,758 INFO&nbsp; [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]</SPAN><BR /><SPAN>10:09:54,136 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:415)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1467)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:516)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:578)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:623)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure</SPAN><BR /><BR /><SPAN>Last packet sent to the server was 1 ms ago.)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 48 more</SPAN><BR /><SPAN>Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</SPAN><BR /><BR /><SPAN>Last packet sent to the server was 1 ms ago.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:539)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedConstructorAccessor69.newInstance(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:539)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 51 more</SPAN><BR /><SPAN>Caused by: java.net.ConnectException: Connection refused</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.PlainSocketImpl.socketConnect(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:316)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:177)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:164)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:380)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.Socket.connect(Socket.java:569)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.Socket.connect(Socket.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.Socket.&lt;init&gt;(Socket.java:416)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.net.Socket.&lt;init&gt;(Socket.java:232)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 63 more</SPAN><BR /><BR /><SPAN> Any one is there who help me out form this problem,even I'm using mysql-connector-java-5.1.6-bin.jar </SPAN><BR /><SPAN>thank's </SPAN><BR /><SPAN>sunil</SPAN></BODY></HTML> Sat, 04 Jul 2009 07:25:42 GMT sunil_aly4u 2009-07-04T07:25:42Z Context initialization failed https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/214965#M168095 Hi, my alfresco is running,but when I change the database to Mysql it stop working and giving the following error10:07:31,537 INFO&nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs10:07:31,553 INFO&nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Init Sat, 04 Jul 2009 07:25:42 GMT https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/214965#M168095 sunil_aly4u 2009-07-04T07:25:42Z Re: Context initialization failed https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/214966#M168096 <HTML><HEAD></HEAD><BODY><PRE class="language-none line-numbers"><CODE>Caused by: java.net.ConnectException: Connection refused<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>Make sure MySQL is actually running and there's no firewall blocking the connection.</SPAN><BR /><BR /><SPAN>Mike</SPAN></BODY></HTML> Sat, 04 Jul 2009 08:57:05 GMT https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/214966#M168096 mikeh 2009-07-04T08:57:05Z