[MAGNOLIA-2279] Installation Magnolia EE version 3.5.8 with MySQL database Created: 21/Jul/08  Updated: 21/Jul/08  Resolved: 21/Jul/08

Status: Closed
Project: Magnolia
Component/s: None
Affects Version/s: 3.5.8
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Thomas Sperger Assignee: Boris Kraft
Resolution: Not an issue Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

jdk-1.6.0.3p4, tomcat-5.5.25, mysql-server-5.0.51a, magnolia-enterprise-webapp-3.5.8.war


Attachments: Microsoft Word magnolia-logfiles.rtf    
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:

 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>



 Comments   
Comment by Thomas Sperger [ 21/Jul/08 ]

Here is the corresponding part of magnolia-error.log and magnolia-debug.log

Comment by Magnolia International [ 21/Jul/08 ]

Please report this in the SUPPORT project. You now have appropriate permissions. Please follow guidelines at:
http://documentation.magnolia.info/support.html

Generated at Mon Feb 12 03:35:10 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.