Alfresco 2.0 with MySQL on linux

[atariq]

Hi,

I've tried to look around the wiki and forums for instructions on how to setup Alfresco 2.0 with MySQL and after following the few points here and there that I could find (mainly from the readme_mysql file within the installation), I'm still having trouble setting it up. Apologies if this has already been answered before.

I am running:

- CentOS 4.5
- Mysql Ver 14.7 Distrib 4.1.20
- Alfresco Community 2.0

This is what my alfresco.log file looks like:

02:32:57,426 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer
] ImageMagickContentTransformer not available: Failed to execute command: convert /opt/alfresco/tomc
at/temp/Alfresco/ImageMagickContentTransformer_init_source_50339.gif  /opt/alfresco/tomcat/temp/Alfr
esco/ImageMagickContentTransformer_init_target_50340.png
02:33:02,829 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI re
gistry - creating new one
02:33:11,703 WARN  [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could n
ot be established.
02:33:32,110 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(Simple
ApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractAppli
cationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
        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:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
        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:709)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        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:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:228)
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:142)
        at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:16
7)
        at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQue
ry.java:258)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:129)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:99)
        at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:65)
        at org.apache.lucene.search.Hits.<init>(Hits.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:36)
        at org.alfresco.repo.search.impl.lucene.LuceneSearcherImpl2.query(LuceneSearcherImpl2.java:2
67)
        at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(Importer
Component.java:1018)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:738)
        at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:353)
        at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:219)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)

… 33 more
02:33:32,144 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excep
tion sending context initialized event to listener instance of class org.springframework.web.context
.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(Simple
ApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractAppli
cationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
        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:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

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:709)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        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:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:228)
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:142)
        at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:16
7)
        at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQue
ry.java:258)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:129)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:99)
        at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:65)
        at org.apache.lucene.search.Hits.<init>(Hits.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:36)
        at org.alfresco.repo.search.impl.lucene.LuceneSearcherImpl2.query(LuceneSearcherImpl2.java:2
67)
        at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(Importer
Component.java:1018)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:738)
        at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:353)
        at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:219)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)
        … 33 more

02:33:32,150 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excep
tion sending context initialized event to listener instance of class org.alfresco.web.app.ContextLis
tener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(Simple
ApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractAppli
cationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
        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:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
        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:709)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        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:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:228)
        at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:142)
        at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:16
7)
        at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQue
ry.java:258)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:129)
        at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:99)
        at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:65)
        at org.apache.lucene.search.Hits.<init>(Hits.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:44)
        at org.apache.lucene.search.Searcher.search(Searcher.java:36)
        at org.alfresco.repo.search.impl.lucene.LuceneSearcherImpl2.query(LuceneSearcherImpl2.java:2
67)
        at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(Importer
Component.java:1018)
        at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:738)
        at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:353)
        at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:219)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)
… 33 more

Note that I have followed the instructions as per the readme_mysql.txt file found within the /opt/alfresco install directory. i.e. I've deleted the three files that the instructions mention and I've run the db_setup.sql script as well. I've logged into mysql through the command line and can see that an alfresco DB has been created, albeit without any tables (is this normal?).

I'm afraid I'm a little lost on what to do next. Any help at all would be much appreciated!

Thanks in advance.

[makoildha]

search forums for 'More than one root node in index' to solve your problem

[orion]

Hello,

Do you install the Mysql Java Connector?

- If not you can download from http://www.mysql.com and after unzip the file, copy the .jar file into lib folder of webinf into alfresco folder.

I hope this help…

[kevinr]

When starting again with MySQL DB, you also need to delete the alf_data directory (probably in tomcat/bin/alf_data). If you want to keep your data, login as the admin user and perform a Full Export from the Admin Console, then follow these instructions to bootstrap with the full export file: http://wiki.alfresco.com/wiki/Export_and_Import#Bootstrap_destination_Repository_from_ACP_files_expo...

Thanks,

Kevin

[finner]

Hi,
As Kevin has said, delete your alf_dir directory AND delete the database in mysql.
Run the db_setup.sql to create the database again(no tables will created) . And then start up the server.


Finner

[atariq]

Hey, guys.

Sorry for bumping an old thread, but I had chosen to wait till the 2.1 community release to try this out.

I'm glad to report that it worked like a charm and now I've got MySQL running, too!

Thanks for your help everyone!