Uploaded image for project: 'Magnolia'
  1. Magnolia
  2. MAGNOLIA-2279

Installation Magnolia EE version 3.5.8 with MySQL database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not an issue
    • Major
    • None
    • 3.5.8
    • None
    • None
    • jdk-1.6.0.3p4, tomcat-5.5.25, mysql-server-5.0.51a, magnolia-enterprise-webapp-3.5.8.war

    Description

      I am trying to install magnolia EE with mysql repository according to http://wiki.magnolia.info/display/WIKI/MySQL+Persistence
      The installer is working until: 139 tasks have been executed, for a total of 147 tasks.
      The message is: Could not perform installation: javax.jcr.RepositoryException: /: unable to update item.: 439ce306-2aac-47d0-9d3a-e45e684fd0bb: 439ce306-2aac-47d0-9d3a-e45e684fd0bb
      On the installer main page three modules are remaining for installation: Magnolia Workflow Module (version 3.5.8), Enterprise Edition (version 3.5.8), Magnolia Webapp Module (version 3.5.8)

      Here ist the magnolia.properties file:

      #--------------------------------------------

      1. Here we define some properties not
      2. configured in the config repository.
      3. They are used in common before the initialization
      4. of the repositories.
        #
      5. WARNING: on Windows systems, either use the /
      6. to separate path elements, or escape the \ with
      7. another \, i.e C:\\magnolia\\data
        repositories
      8. or c:/magnolia/data/repositories
        #--------------------------------------------
        magnolia.cache.startdir=cache
        magnolia.upload.tmpdir=tmp
        magnolia.exchange.history=history
        magnolia.repositories.config=WEB-INF/config/default/repositories.xml
        magnolia.repositories.home=repositories
        magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml

      log4j.config=WEB-INF/config/default/log4j.xml

      1. @deprecated since 3.5.4 - not needed anymore (was used for log4j config)
        magnolia.root.sysproperty=magnolia.root
      1. The directories in which the bootstrap files are searched
        magnolia.bootstrap.dir=WEB-INF/bootstrap/author WEB-INF/bootstrap/common
      1. This is only used for the initial installation afterward the configuration in the config repository is used
      2. The value is saved in /server/admin
        magnolia.bootstrap.authorInstance=true
      1. Some modules contain optional sample content. They will check this property to decide if they should install
      2. the sample data
        magnolia.bootstrap.samples=true
      1. Switch to false to enahnce the performance of the javascript generation and similar
        magnolia.develop=true

      #--------------------------------------------

      1. Repository connection
        #--------------------------------------------
        magnolia.connection.jcr.userId = admin
        magnolia.connection.jcr.password = admin

      #--------------------------------------------

      1. Server properties
      2. - Do not change server id after registering repository
        #--------------------------------------------
      3. @deprecated since 3.5.4 - not used
        magnolia.server.id = author
      1. Set it to true if bootstrapping/update should be performed automatically
        magnolia.update.auto=false

      Here is the jackrabbit-mysql-search.xml file:
      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.2//EN" "http://jackrabbit.apache.org/dtd/repository-1.2.dtd">
      <Repository>
      <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="${rep.home}/repository" />
      </FileSystem>
      <Security appName="Jackrabbit">
      <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager>
      <LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule">
      <param name="anonymousId" value="anonymous" />
      </LoginModule>
      </Security>
      <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
      <Workspace name="default">
      <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="${wsp.home}/default" />
      </FileSystem>
      <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
      <param name="driver" value="com.mysql.jdbc.Driver" />
      <param name="url" value="jdbc:mysql://127.0.0.5:3306/magnolia?autoReconnect=true" />
      <param name="schema" value="mysql" /><!-- warning, this is not the schema name, it's the db type -->
      <param name="user" value="magnolia" />
      <param name="password" value="SebPhisi." />
      <param name="schemaObjectPrefix" value="version_" />
      <param name="externalBLOBs" value="true" />
      </PersistenceManager>
      <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
      <param name="path" value="${wsp.home}/index" />
      <param name="useCompoundFile" value="true" />
      <param name="minMergeDocs" value="100" />
      <param name="volatileIdleTime" value="3" />
      <param name="maxMergeDocs" value="100000" />
      <param name="mergeFactor" value="10" />
      <param name="maxFieldLength" value="10000" />
      <param name="bufferSize" value="10" />
      <param name="cacheSize" value="1000" />
      <param name="forceConsistencyCheck" value="false" />
      <param name="autoRepair" value="true" />
      <param name="analyzer" value="org.apache.lucene.analysis.standard.StandardAnalyzer" />
      <param name="queryClass" value="org.apache.jackrabbit.core.query.QueryImpl" />
      <param name="respectDocumentOrder" value="true" />
      <param name="resultFetchSize" value="2147483647" />
      <param name="extractorPoolSize" value="3" />
      <param name="extractorTimeout" value="100" />
      <param name="extractorBackLogSize" value="100" />
      <param name="textFilterClasses"
      value="org.apache.jackrabbit.extractor.MsWordTextExtractor,
      org.apache.jackrabbit.extractor.MsExcelTextExtractor,
      org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
      org.apache.jackrabbit.extractor.PdfTextExtractor,
      org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,
      org.apache.jackrabbit.extractor.RTFTextExtractor,
      org.apache.jackrabbit.extractor.HTMLTextExtractor,
      org.apache.jackrabbit.extractor.PlainTextExtractor,
      org.apache.jackrabbit.extractor.XMLTextExtractor" />
      </SearchIndex>
      </Workspace>
      <Versioning rootPath="${rep.home}/version">
      <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="${rep.home}/workspaces/version" />
      </FileSystem>
      <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
      <param name="driver" value="com.mysql.jdbc.Driver" />
      <param name="url" value="jdbc:mysql://127.0.0.5:3306/magnolia?autoReconnect=true" />
      <param name="schema" value="mysql" /><!-- warning, this is not the schema name, it's the db type -->
      <param name="user" value="magnolia" />
      <param name="password" value="SebPhisi." />
      <param name="schemaObjectPrefix" value="version_" />
      <param name="externalBLOBs" value="true" />
      </PersistenceManager>
      </Versioning>
      </Repository>

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              kraft Boris Kraft
              izb-isp-team Thomas Sperger
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Checklists

                  Bug DoR
                  Task DoD