linux installation -> java & sql errors

[hemhay]

Hi,

I just did a fresh install of Alfresco on my Linux Ubuntu 8.10 following these lines.

Just after this, when running alfresco :

18:45:28,069 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]18:45:40,861 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.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 connectionCaused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionCaused 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:291)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)   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:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)   at org.apache.catalina.core.StandardService.start(StandardService.java:448)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)   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:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.)   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: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)   at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)   at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)   at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)   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 moreCaused by: java.sql.SQLException: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   … 65 moreCaused by: java.sql.SQLException: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)   … 62 moreCaused by: ERROR XBM0J: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)   at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)   at java.security.AccessController.doPrivileged(Native Method)   at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)   at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)   … 62 more18:45:40,872 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.springframework.web.context.ContextLoaderListenerorg.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 connectionCaused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionCaused 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:291)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)   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:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)   at org.apache.catalina.core.StandardService.start(StandardService.java:448)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)   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:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.)   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: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)   at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)   at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)   at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)   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 moreCaused by: java.sql.SQLException: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   … 65 moreCaused by: java.sql.SQLException: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)   … 62 moreCaused by: ERROR XBM0J: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)   at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)   at java.security.AccessController.doPrivileged(Native Method)   at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)   at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)   … 62 more18:45:40,876 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.alfresco.web.app.ContextListenerorg.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 connectionCaused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionCaused 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:291)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)   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:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)   at org.apache.catalina.core.StandardService.start(StandardService.java:448)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)   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:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.)   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: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)   at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)   at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)   at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)   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 moreCaused by: java.sql.SQLException: Failed to create database '/opt/Alfresco/alf_data/derby_data/alfresco', see the next exception for details.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   … 65 moreCaused by: java.sql.SQLException: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)   at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)   … 62 moreCaused by: ERROR XBM0J: Directory /opt/Alfresco/alf_data/derby_data/alfresco already exists.   at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)   at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)   at java.security.AccessController.doPrivileged(Native Method)   at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)   at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)   at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)   … 62 more18:45:51,302 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework18:45:55,786 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 21 Web Scripts (+0 failed), 23 URLs18:45:55,789 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 291.2814ms)18:45:56,912 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 134 Web Scripts (+0 failed), 136 URLs18:45:56,912 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 1115.7871ms)18:45:57,059 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework18:51:18,356 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]18:51:40,255 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.DerbyDialect.18:51:40,268 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Alfresco is using the Apache Derby default database. Please only use this while evaluating Alfresco, it is NOT recommended for production or deployment!18:51:41,064 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.DerbyDialect-27523.sql (Generated).18:51:58,104 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.DerbyDialect-27524.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-2.2-MappedFKIndexes.sql).18:51:58,297 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.DerbyDialect-27525.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.DerbyDialect/AlfrescoPostCreate-2.2-Extra.sql).18:51:58,581 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.DerbyDialect-27526.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.DerbyDialect/post-create-indexes-04.sql).18:51:58,759 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.DerbyDialect-27527.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.DerbyDialect/create-activities-extras.sql).18:51:59,252 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-All_Statements-27528.sql.18:53:08,890 ERROR [org.alfresco.util.exec.RuntimeExecBootstrapBean] Bootstrap command failed: Execution result:    os:         Linux   command:    "/opt/Alfresco/program/soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:////opt/Alfresco" -nologo -headless -nofirststartwizard -nocrashrep -norestore   succeeded:  false   exit code:  2   out:           err:        Cannot run program ""/opt/Alfresco/program/soffice"": java.io.IOException: error=2, No such file or directory18:53:11,027 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/Alfresco/alf_data18:53:11,120 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …18:53:12,655 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.wcmFolders' (Ensures the existance of the WCM specific 'Web Projects' and 'Web Forms' folders.).18:53:12,963 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] === Applied patch                 === ID: patch.wcmFoldersRESULT: The Web Projects folder was successfully created: workspace://SpacesStore/b1233cb6-9a2c-4cd1-b473-5b6a4daf5456The Web Forms folder was successfully created: workspace://SpacesStore/b1233cb6-9a2c-4cd1-b473-5b6a4daf5456=====================================18:53:12,968 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).18:53:18,315 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP18:53:18,316 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)18:53:19,104 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.18:53:19,291 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_10-b33; maximum heap size 506,313MB18:53:19,292 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (c 1342) schema 1000 - Installed version 3.0.0 (c 1342) schema 100018:53:20,117 WARN  [org.alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)18:53:55,077 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework18:54:02,905 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 21 Web Scripts (+0 failed), 23 URLs18:54:02,907 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 864.69556ms)18:54:03,944 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 134 Web Scripts (+0 failed), 136 URLs18:54:03,945 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 1028.5127ms)18:54:04,072 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

There are many errors as you can see. I found many posts on this forum talking about mysql. But the thing is, nothing is mentioned about mysql on the wiki I followed.

Can you please show me the way ?

Thanks a lot

[hemhay]

Nope,  same thing…

[mikeh]

That's very strange; which browser is giving you that error?

Can you see the Tomcat default page at all at http://localhost:8080/ ? If not, I'd check for any proxy settings or local firewall rules that might be preventing a connection to that port.

Thanks,
Mike

[hemhay]

Well, localhost:8080 gives :

Motion 3.2.9 Running [1] Threads
All

Is this normal ?

[hemhay]

I've rebooted and restarted alfresco. Here is the new message I got :

(..)
18:45:52,423 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
18:45:52,423 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
18:45:53,268 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
(…)

Where could I fix this wrong domain name ?

[mikeh]

Have a look on the wiki here: http://wiki.alfresco.com/wiki/File_Server_Configuration#SMB.2FCIFS_Server_Configuration

Thanks,
Mike

[hemhay]

Thank you very much. However I have to admit I'm lost.

I checked, my domain name do is WORKGROUP :

$ cat /etc/samba/smb.conf | grep workgroup# Change this to the workgroup/NT-domain name your Samba server will part of   workgroup = WORKGROUP‍‍‍‍‍

Then I don't know what to change in file-servers-custom.xml .

I would be very grateful if you could throw light on it…
Thanks again, many times.

———–
file-servers-custom.xml : ("<" and ">" have been replaced by "[" and "]" so that I can post this message.

[alfresco-config area="file-servers"][!– To override the default Alfresco filesystem use replace="true", to –][!– add additional filesystems remove the replace="true" attribute  –][config evaluator="string-compare" condition="Filesystems" replace="true"][filesystems][filesystem name="Alfresco"][store]workspace://SpacesStore[/store][rootPath]/app:company_home[/rootPath][!– Add a URL file to each folder that links back to the web client –][urlFile][filename]__Alfresco.url[/filename][webpath]http://${localname}:8080/alfresco/[/webpath][/urlFile][!– Mark locked files as offline –][offlineFiles/][!– Desktop actions –][desktopActions][global][path]alfresco/desktop/Alfresco.exe[/path][webpath]http://${localname}:8080/alfresco/[/webpath][/global][action][class]org.alfresco.filesys.repo.desk.CheckInOutDesktopAction[/class][name]CheckInOut[/name][filename]__CheckInOut.exe[/filename][/action][action][class]org.alfresco.filesys.repo.desk.JavaScriptDesktopAction[/class][name]JavaScriptURL[/name][filename]__ShowDetails.exe[/filename][script]alfresco/desktop/showDetails.js[/script][attributes]anyFiles[/attributes][preprocess]copyToTarget[/preprocess][/action][/desktopActions][!–[accessControl default="Write"][user name="admin" access="Write"/][address subnet="90.1.0.0" mask="255.255.0.0" access="Write"/][/accessControl]–][/filesystem]               [!– AVM virtualization view of all stores/versions for WCM –][avmfilesystem name="AVM"][virtualView/][/avmfilesystem]        [/filesystems][/config][/alfresco-config]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[dmkhn]

There's a bug in the start-up command that ships with the code. You need to remove the double-quotes from around the /opt/Alfresco/program/soffice part of openoffice-startup-context.xml

Thanks,
Mike

I removed double-quotes, and now my log looks like this:

00:17:35,208 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.00:17:35,212 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_06-b02; maximum heap size 493,063MB00:17:35,212 WARN  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - WARNING - maximum heap size 493,063MB is less than recommended 512MB00:17:35,213 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (b 1164) schema 131 - Installed version 3.0.0 (b 1164) schema 13100:17:35,592 WARN  [org.alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)00:18:31,602 INFO  [org.alfresco.util.OpenOfficeConnectionTester] The OpenOffice connection was re-established.‍‍‍‍‍‍‍‍

First - where I can change "maximum heap size" to nesessery 512 Mb
Second - as I se in last quoted raw of log - Alfresco got connection to Open Office. And - how can I sure that all is OK? Which function of Alfresco don't work if OO not started? Is it posible online edition of OO documents?

[mikeh]

First - where I can change "maximum heap size" to nesessery 512 Mb

export JAVA_OPTS='-Xms128m -Xmx1024m -XX:MaxPermSize=128m -server'‍

Second - as I se in last quoted raw of log - Alfresco got connection to Open Office. And - how can I sure that all is OK? Which function of Alfresco don't work if OO not started? Is it posible online edition of OO documents?

Try transforming a Microsoft Word document to PDF.

Thanks,
Mike

[dmkhn]

First - where I can change "maximum heap size" to nesessery 512 Mb

export JAVA_OPTS='-Xms128m -Xmx1024m -XX:MaxPermSize=128m -server'‍

Thanks! I found this string in file alfresco.sh and change it. But in my file was

-Xms128m -Xmx512m‍

Is it nessesery to change second value from 512 to 1024M like it's in your code?

Second - as I se in last quoted raw of log - Alfresco got connection to Open Office. And - how can I sure that all is OK? Which function of Alfresco don't work if OO not started? Is it posible online edition of OO documents?

Try transforming a Microsoft Word document to PDF.
Thanks,
Mike

How (transform)? I don't see ahy menu or something else for that…

[mikeh]

Is it nessesery to change second value from 512 to 1024M like it's in your code?

Yes, that should do it.

How (transform)? I don't see ahy menu or something else for that…

normally this would be done as part of an automatic action, or one-click via the Office add-in for example. But manually…
- Go to the Details page for an uploaded Word doc, then choose "Run Action".
- Choose "Transform and copy content…" then "Set Values and Add" and choose a space for the PDF.

Thanks,
Mike