As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
rg.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G enericJDBCException: Cannot open connection org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception. GenericJDBCException: Cannot open connection org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException (SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager .java:420) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager. java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java: 57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290 ) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi n(HibernateTransactionManager.java:520) at org.springframework.transaction.support.AbstractPlatformTransactionMa nager.getTransaction(AbstractPlatformTransactionManager.java:282) at org.springframework.transaction.interceptor.TransactionAspectSupport. createTransactionIfNecessary(TransactionAspectSupport.java:225) at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(Spring AwareUserTransaction.java:356) at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr ansactionUtil.java:175) at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio n(TransactionUtil.java:82) at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap( DictionaryRepositoryBootstrap.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.createBean(AbstractAutowireCapableBeanFactory.java:363) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory. preInstantiateSingletons(DefaultListableBeanFactory.java:275) at org.springframework.context.support.AbstractApplicationContext.refres h(AbstractApplicationContext.java:320) at org.springframework.web.context.support.AbstractRefreshableWebApplica tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.springframework.web.context.ContextLoader.createWebApplicationCon text(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationConte xt(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitiali zed(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContex t.java:3763) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 211) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase .java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73 9) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698 ) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472 ) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl eSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442 ) at org.apache.catalina.core.StandardService.start(StandardService.java:4 50) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (Access denied for user 'alfresco'@'localhost' (using password: Y ES)) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:540) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider. getConnection(LocalDataSourceConnectionProvider.java:80) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager .java:417) … 50 more Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :266) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) … 53 more 12:25:33,097 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envo i de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de class e d'Úcoute (listener) org.alfresco.web.app.ContextListener org.springframework.beans.factory.BeanCreationException: Error creating bean wit h name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/ core-services-context.xml]: Initialization of bean failed; nested exception is o rg.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G enericJDBCException: Cannot open connection org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception. GenericJDBCException: Cannot open connection org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException (SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager .java:420) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager. java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java: 57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290 ) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi n(HibernateTransactionManager.java:520) at org.springframework.transaction.support.AbstractPlatformTransactionMa nager.getTransaction(AbstractPlatformTransactionManager.java:282) at org.springframework.transaction.interceptor.TransactionAspectSupport. createTransactionIfNecessary(TransactionAspectSupport.java:225) at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(Spring AwareUserTransaction.java:356) at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr ansactionUtil.java:175) at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio n(TransactionUtil.java:82) at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap( DictionaryRepositoryBootstrap.java:134) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063) at org.springframework.beans.factory.support.AbstractAutowireCapableBean Factory.createBean(AbstractAutowireCapableBeanFactory.java:363) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory. preInstantiateSingletons(DefaultListableBeanFactory.java:275) at org.springframework.context.support.AbstractApplicationContext.refres h(AbstractApplicationContext.java:320) at org.springframework.web.context.support.AbstractRefreshableWebApplica tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.springframework.web.context.ContextLoader.createWebApplicationCon text(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationConte xt(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitiali zed(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContex t.java:3763) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 211) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase .java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73 9) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698 ) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472 ) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl eSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442 ) at org.apache.catalina.core.StandardService.start(StandardService.java:4 50) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (Access denied for user 'alfresco'@'localhost' (using password: Y ES)) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:540) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider. getConnection(LocalDataSourceConnectionProvider.java:80) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager .java:417) … 50 more Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :266) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) … 53 more 16 juil. 2007 12:25:33 org.apache.catalina.core.StandardContext start GRAVE: Error listenerStart 16 juil. 2007 12:25:33 org.apache.catalina.core.StandardContext start GRAVE: Erreur de dÚmarrage du contexte [/alfresco] suite aux erreurs prÚcÚdentes 16 juil. 2007 12:25:34 org.apache.coyote.http11.Http11BaseProtocol start INFO: DÚmarrage de Coyote HTTP/1.1 sur http-8080 16 juil. 2007 12:25:34 org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 16 juil. 2007 12:25:34 org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/62 config=null 16 juil. 2007 12:25:34 org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource 16 juil. 2007 12:25:34 org.apache.catalina.startup.Catalina start INFO: Server startup in 20558 ms
drop database alfresco; revoke all privileges, grant option from 'alfresco'@'localhost'; drop user 'alfresco'@'localhost';
create database alfresco; grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option; grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
