topic Alfresco não conecta ao MySQL (embutido) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-n%C3%A3o-conecta-ao-mysql-embutido/m-p/77950#M51655 <HTML><HEAD></HEAD><BODY><SPAN>Boa pessoal,</SPAN><BR /><BR /><SPAN>Estou tendo o seguinte problema em uma maquina XP que uso para o Afresco a um ano e pouco, por isso estou mesmo precisando de ajuda.</SPAN><BR /><SPAN>quando tendo arrancar o alfresco tenho o seguinte erro:</SPAN><BR /><BR /><BR /><SPAN>00:00:01,660 ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector error</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection</SPAN><BR /><SPAN>at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)</SPAN><BR /><SPAN>at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)</SPAN><BR /><SPAN>at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)</SPAN><BR /><SPAN>at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)</SPAN><BR /><SPAN>at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)</SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)</SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)</SPAN><BR /><SPAN>at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:406)</SPAN><BR /><SPAN>at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:315)</SPAN><BR /><SPAN>at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:233)</SPAN><BR /><SPAN>at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:351)</SPAN><BR /><SPAN>at org.alfresco.repo.avm.OrphanReaper.execute(OrphanReaper.java:58)</SPAN><BR /><SPAN>at org.alfresco.repo.avm.OrphanReaperJob.execute(OrphanReaperJob.java:44)</SPAN><BR /><SPAN>at org.quartz.core.JobRunShell.run(JobRunShell.java:202)</SPAN><BR /><SPAN>at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)</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 0 ms ago.</SPAN><BR /><SPAN>at sun.reflect.GeneratedConstructorAccessor1017.newInstance(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)</SPAN><BR /><SPAN>at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)</SPAN><BR /><SPAN>at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)</SPAN><BR /><SPAN>at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)</SPAN><BR /><SPAN>at sun.reflect.GeneratedConstructorAccessor1018.newInstance(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)</SPAN><BR /><SPAN>at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)</SPAN><BR /><SPAN>at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)</SPAN><BR /><SPAN>at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)</SPAN><BR /><SPAN>at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)</SPAN><BR /><SPAN>at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)</SPAN><BR /><SPAN>at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)</SPAN><BR /><SPAN>… 16 more</SPAN><BR /><SPAN>Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</SPAN><BR /><BR /><SPAN>no forum em EN, disseram que é falta de conexão com o MySQL. e já verifiquei a configuração do alfresco-global.properties e esta tudo como devia, se entro no para o mysql (c:alfresco…mysql.exe) consigo entrar com o user alfresco, vejo a base de dados alfresco e a tabela tambem.</SPAN><BR /><BR /><SPAN>queria saber se posso instalar o MySQL 5.1.xxx na minha maquina e passar a usar este como a BD, e como passar a base de dados do alfresco e as tabelas do MySQL embutido para esta nova instalação.</SPAN><BR /><BR /><SPAN>Cumprimentos.</SPAN></BODY></HTML> Sun, 14 Nov 2010 22:56:39 GMT squad 2010-11-14T22:56:39Z Alfresco não conecta ao MySQL (embutido) https://connect.hyland.com/t5/alfresco-archive/alfresco-n%C3%A3o-conecta-ao-mysql-embutido/m-p/77950#M51655 Boa pessoal,Estou tendo o seguinte problema em uma maquina XP que uso para o Afresco a um ano e pouco, por isso estou mesmo precisando de ajuda.quando tendo arrancar o alfresco tenho o seguinte erro:00:00:01,660 ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector errororg.springframework.tr Sun, 14 Nov 2010 22:56:39 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-n%C3%A3o-conecta-ao-mysql-embutido/m-p/77950#M51655 squad 2010-11-14T22:56:39Z Re: Alfresco não conecta ao MySQL (embutido) https://connect.hyland.com/t5/alfresco-archive/alfresco-n%C3%A3o-conecta-ao-mysql-embutido/m-p/77951#M51656 <HTML><HEAD></HEAD><BODY><SPAN>Nao ha solucao ou nao fui claro.</SPAN><BR /><SPAN>por favor me ajudem, ainda estou com o mesmo problema e o post e de 15 de Novembro.</SPAN></BODY></HTML> Wed, 01 Dec 2010 03:26:48 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-n%C3%A3o-conecta-ao-mysql-embutido/m-p/77951#M51656 squad 2010-12-01T03:26:48Z