Problemas Alfresco labs 3stable mysql ubuntu

no-name — Thu, 22 Jan 2009 17:11:51 GMT

Na pues eso que esque no se que hacer, sigo todos los pasos que ponen en la guia y no hay manera.Bueno me explico, instalo en ubuntu server 8.04.1 el alfresco correctamente sin problemas todo perfecto, excepto que se salta el paso donde eligo la base de datos, no le doy importancia porque en el manu

Re: Problemas Alfresco labs 3stable mysql ubuntu

pjcaracuel_2349 — Thu, 22 Jan 2009 17:15:00 GMT

Buenas,

Prueba esto:

TE haria falta el "mysql-connector-java-5.1.0-bin.jar" en el directorio lib del tomcat ¿Lo tienes correctamente ubicado?

Si no es esto lo que falla, podias poner el contenido de alfresco.log??

Saludos

Re: Problemas Alfresco labs 3stable mysql ubuntu

no-name — Thu, 22 Jan 2009 17:40:32 GMT

18:16:46,299 INFO [org.alfresco.web.site.FrameworkHelper]Successfully Initialized Web Framework
18:16:55,348 INFO [org.alfresco.web.scripts.DeclarativeRegistry]Registered 67 Web Scripts (+0 failed), 71 URLs
18:16:55,352 INFO [org.alfresco.web.scripts.AbstractRuntimeContainer]Initialised Presentation Web Script Container (in 1122.05ms)
18:17:58,603 INFO [org.alfresco.web.scripts.DeclarativeRegistry]Registered 101 Web Scripts (+0 failed), 105 URLs
18:17:58,603 INFO [org.alfresco.web.scripts.AbstractRuntimeContainer]Initialised WebFramework Web Script Container (in 63207.18ms)
18:17:59,104 INFO [org.alfresco.web.site.FrameworkHelper]Successfully Initialized Web Framework
18:19:06,544 ERROR[org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer]ImageMagickContentTransformer not available: Failed to performImageMagick transformation:Execution results: Linuxcommand: [/usr/local/bin/convert,/opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_33880.gif,/opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_33881.png]succeeded: falseexit code: 1out:err: Cannot run program "/usr/local/bin/convert":java.io.IOException: error=2, No such file or directory
18:19:15,898 INFO[org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loadingproperties file from class path resource[alfresco/file-servers.properties]
18:20:00,178 ERROR [org.springframework.web.context.ContextLoader]Context initialization failedorg.springframework.beans.factory.BeanCreationException: Errorcreating bean with name 'luceneIndexBackupComponent' defined in classpath resource [alfresco/core-services-context.xml]: Invocation of initmethod failed; nested exception isorg.springframework.transaction.CannotCreateTransactionException:Could not open Hibernate Session for transaction; nested exception isorg.hibernate.exception.GenericJDBCException: Cannot open connectionCaused by: org.springframework.transaction.CannotCreateTransactionException:Could not open Hibernate Session for transaction; nested exception isorg.hibernate.exception.GenericJDBCException: Cannot open connectionCaused by: org.hibernate.exception.GenericJDBCException: Cannot open connectionat org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:415)at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1467)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.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:3843)at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)at org.apache.catalina.core.StandardService.start(StandardService.java:516)at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)at org.apache.catalina.startup.Catalina.start(Catalina.java:578)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:288)at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot createPoolableConnectionFactory (Access denied for user'alfresco'@'localhost' (using password: YES))at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)… 48 moreCaused by: java.sql.SQLException: Access denied for user'alfresco'@'localhost' (using password: YES)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor.newInstance(Constructor.java:513)at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)… 51 more

Lo e estado mirando y lo que yo e enetndido (desde mi inexperiencia en alfresco) es que no tiene permisos para conectar a la base de datos, pero esque yo le e cambiado el usaurio y la password con la que se tiene que connectar, porque hay pone alfresco@loclahost , pero yo le e dicho que use el usuario root para asi no tener problemas…

Tengo el connecto que se instala por defecto el 5.0.3

Re: Problemas Alfresco labs 3stable mysql ubuntu

pjcaracuel_2349 — Fri, 23 Jan 2009 07:21:59 GMT

Buenas,

A ver, yo revisaria que en el fichero custom-hibernate-dialect.properties tienes descomentado la entrada para mysql.

Luego en el custom-repository.properties que tienes el usuario root y la password con la que quieres hacer la conexion, aunque yo particualrmente lo que haria es dar de alta un usuario "alfresco" en el esquema de la bbdd y usar dicho usuario.

Si hasta aqui toda esta correcto, lo siguiente que haria es borrar la bbdd y la volveria a crear usando los scripts que hay en \extras\databases\mysql

Borraria el contenido del directorio alf_data y volveria a reinicar alfresco. Despues de esto deberia arrancar sin problemas.

Saludos

topic Re: Problemas Alfresco labs 3stable mysql ubuntu in Alfresco Archive

Problemas Alfresco labs 3stable mysql ubuntu

Re: Problemas Alfresco labs 3stable mysql ubuntu

Re: Problemas Alfresco labs 3stable mysql ubuntu

Re: Problemas Alfresco labs 3stable mysql ubuntu