07-26-2007 03:41 PM
Locate the distribution's extension configuration files and samples (here) and remove the .sample extensions:
* <extensionRoot>/alfresco/extension/custom-repository-context.xml.sample
o This ensures that the properties overrides from the files below are pulled into the server.
* <extensionRoot>/alfresco/extension/custom-repository.properties.sample
o Choose a root location for the storage of content binaries and index files.
o Adjust properties here to change the database connection details.
o Pay attention to the choice of JDBC driver used with each connection type.
* <extensionRoot>/alfresco/extension/custom-hibernate-dialect.properties.sample
o Choose a Hibernate schema most appropriate to your database (Hibernate Dialects).
<!– overriding to point to custom properties –>
<bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="ignoreUnresolvablePlaceholders">
<value>true</value>
</property>
<property name="locations">
<list>
<value>classpath:alfresco/repository.properties</value>
<value>classpath:alfresco/version.properties</value>
<value>classpath:alfresco/domain/transaction.properties</value>
<!– Override basic repository properties –>
<value>classpath:alfresco/extension/custom-repository.properties</value>
</list>
</property>
</bean>
dir.root=/srv/alfresco/data
(The place I want to store the data on my server)db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco
(I put the MySQL driver into <TOMCAT_HOME>/common/lib. The driver jar is mysql-connector-java-5.0.7-bin.jar)hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
11:35:48,427 WARN [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
11:35:49,593 WARN [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
11:35:51,856 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:35:52,429 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
11:35:53,821 WARN [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco 'dir.root' property is set to a relative path './alf_data'. 'dir.root' should be overridden to point to a specific folder.
11:35:53,821 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: ./alf_data
11:35:53,886 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 5 stores.
11:35:53,887 INFO [org.alfresco.repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
11:35:53,887 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
11:35:53,887 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
11:35:53,891 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
…
…
(The rest was ommited as I didn't consider important to post all the stack trace)07-30-2007 11:06 AM
07-30-2007 08:54 PM
index.recovery.mode=VALIDATE
to:index.recovery.mode=FULL
directly in the repository.properties file.CONTENT INTEGRITY ERROR: Indexes not found for 5 stores.
but I'm still getting the next messages, including ERROR's:17:59:57,050 WARN [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
17:59:58,161 WARN [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
18:00:00,234 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
18:00:01,210 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
18:00:03,182 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 16 transactions.
18:00:03,224 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 10 % complete.
18:00:03,238 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 20 % complete.
18:00:04,160 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 30 % complete.
18:00:04,270 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 40 % complete.
18:00:04,288 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 50 % complete.
18:00:04,335 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 60 % complete.
18:00:04,352 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 70 % complete.
18:00:04,364 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 80 % complete.
18:00:04,382 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 90 % complete.
18:00:04,393 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 100 % complete.
18:00:04,402 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
18:00:19,553 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/alfresco/data
18:00:19,564 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
18:00:19,564 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
18:00:19,568 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:788)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:473)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
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:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
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:585)
As you can note I changed the root.dir variable directly in the repository.properties located in WEB-INF/classes/alfresco/ to point to the same location I indicated in the custom-repository.properties file. (/srv/alfresco/data)07-31-2007 10:39 AM
07-31-2007 11:10 AM
No changes were made to the schema.You did everything fine, except that you didn't actually drop and recreate the database. Hence the server found an existing schema and failed to match that up to the associated indexes and content stores.
07-31-2007 07:20 PM
08-02-2007 04:42 PM
08-03-2007 04:59 AM
08-03-2007 10:09 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.