topic Re: Error: Failed to create store root.. in Alfresco Archive

Error: Failed to create store root..

pcano — Mon, 22 Dec 2008 09:48:56 GMT

Hola, acabo de instalar Alfresco Enterprise 3.0 sobre SLES 10 mediante Alfresco WAR pero no consigo arrancarlo..Arranco tomcat pero al poco tiempo se para y no consigo acceder a la web. En el fichero de log de tomcat encuentro siempre este error:Caused by: org.springframework.beans.factory.BeanCreat

Re: Error: Failed to create store root..

pjcaracuel_2349 — Fri, 26 Dec 2008 07:21:23 GMT

Buenas,

Lo primero de todo yo revisaria que en el fichero custom-hibernate-dialect.properties esta correctamente configurado para tu bbdd. Luego si esta bien, podrias postear el contenido del fichero custom-repository.properties y ver si se te ha pasado algo?

Gracias

Re: Error: Failed to create store root..

pcano — Fri, 26 Dec 2008 11:11:43 GMT

En el fichero custom-hibernate-dialect.properties y la única línea que está descomentada es la de mysql, que es la base de datos que estoy utilizando. Por otra parte el fichero custom-repository.properties está configurado como sigue:

#
# Sample custom content and index data location
#
dir.root=/opt/alfresco/alf_data

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

#
# Activate index tracking and recovery
#
#index.tracking.cronExpression=0/5 * * * * ?
#index.recovery.mode=AUTO

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed. After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# Derby connection
#
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:/opt/alfresco/alf_data/derby_data/alfresco;create=true

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbcracle:thin:@localhost:1521:alfresco
#
# SQLServer connection (note you must enable TCP protocol on fixed port 1433)
#
#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#db.url=jdbc:sqlserver://localhost:1433;databaseName=alfresco

# The well known RMI registry port is defined in the alfresco-shared.properties file
# alfresco.rmi.services.port=50500
#
# RMI service ports for the individual services.
# These six services are available remotely.
#
# Assign individual ports for each service for best performance
# or run several services on the same port. You can even run everything on 50500 if needed.
#
# Select 0 to use a random unused port.
#
#avm.rmi.service.port=50501
#avmsync.rmi.service.port=50502
#attribute.rmi.service.port=50503
#authentication.rmi.service.port=50504
#repo.rmi.service.port=50505
#action.rmi.service.port=50506

Re: Error: Failed to create store root..

pjcaracuel_2349 — Fri, 26 Dec 2008 11:17:32 GMT

Hola,

Perfecto, aparentemente la configuracion esta bien. Si existe y es correcta la ruta /opt/alfresco/alf_data en tu sistema de ficheros,podrias comprobar que el usuario que inicia alfresco tiene permisos de escritura en dicho directorio?, si los tiene yo probaria lo siguiente:

1.- Borrado de todo el contenido que puedas tener dentro del directorio alf_data

2.- Borrado y recreacion del esquema de alfresco:
$alfresco_home/extras/databases/mysql/db_remove.sql

$alfresco_home/extras/databases/mysql/db_setup.sql

Y a continuacion iniciaria de nuevo alfresco , si con esto no te arranca bien, podias poner el log resultante?

Saludos

Re: Error: Failed to create store root..

pcano — Fri, 26 Dec 2008 12:29:00 GMT

Hola, ahora ya no se para tomcat, pero sigue sin funcionar, el problema ahora parece que es el acceso a base de datos, pero he comprobado desde la máquina a acceder con el usuario alfresco y no hay problema..

este es el contenido de alfresco.log:

13:27:48,527 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
   os:         Linux
   command:    [convert, /srv/www/tomcat5/base/temp/Alfresco/ImageMagickContentTransformer_init_source_489842922772637124.gif, /srv/www/tomcat5/base/temp/Alfresco/ImageMagickContentTransformer_init_target_5081859529191566398.png]
   succeeded: false
   exit code: 1
   out:
   err:        java.io.IOException: convert: not found
13:27:50,091 INFO [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
13:28:04,424 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
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
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at 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:380)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)
        ….Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
        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)
        … 49 more
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)

Re: Error: Failed to create store root..

pjcaracuel_2349 — Fri, 26 Dec 2008 12:35:08 GMT

Buenas,

yo comprobaria que tienes instalado el conector mysql-connector-java-5.1.0-bin.jar en el directorio lib del tomcat,

Saludos

Re: Error: Failed to create store root..

pcano — Fri, 26 Dec 2008 16:41:37 GMT

He instalado mysql-connector-java-5.1.7.tar y he copiado el jar en el directorio lib de tomcat, pero ahora vuelve a darme de nuevo el problema de failed to create store root… la carpeta alf_data puede estar en cualquier directorio? yo ahora mismo la tengo configurada apuntando a /opt/alfresco/alf_data pero también he visto que existe en el directorio de tomcat.. de todos modos al ser una instalación nueva en ambos sitios los directorios que contiene están vacíos.

17:17:54,595 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneFullTextSearchIndexer' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'mlAwareNodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlAwareNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'mtAwareNodeService' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtAwareNodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dbNodeServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'avmNodeService' while setting bean property 'avmNodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'avmService' while setting bean property 'avmService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmService' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'avmServiceBase' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmServiceBase' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'avmRepository' while setting bean property 'avmRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmRepository' defined in class path resource [alfresco/avm-services-context.xml]: Cannot resolve reference to bean 'fileContentStore' while setting bean property 'contentStore'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'fileContentStore' defined in class path resource [alfresco/content-services-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.repo.content.filestore.FileContentStore]: Constructor threw exception; nested exception is org.alfresco.service.cmr.repository.ContentIOException: Failed to create store root: ./alf_data/contentstore

Re: Error: Failed to create store root..

pjcaracuel_2349 — Wed, 07 Jan 2009 13:32:03 GMT

Buenas,

Siento haber dejado el post a medias pero estuve de vacaciones, ¿has conseguido resolver ya la incidencia?

Saludos