i have read up on the subject of mysql and JDBC.
i have had a go at connecting a mysqlDB with OpenKM but i have not been succesfull. mybe you could look at what i have done and point out what i have not done correcly.
my config:
- i have installed mysql in C:\\EasyPHP 2.0b1\\mysql
- i have made a db called test in C:\\EasyPHP 2.0b1\\mysql\\data\\test
i have used the installation guide as an example.
here is what i have changed in the repository.xml file
<code>
<?xml version=\"1.0\"?>
<Repository>
<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\"/>
</FileSystem>
<Security appName=\"Jackrabbit\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\"/>
<!-- <AccessManager class=\"org.apache.jackrabbit.core.security.SimpleAccessManager\"/> -->
</Security>
<Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\" />
<Workspace name=\"${wsp.name}\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.mysql.jdbc.Driver\"/>
<param name=\"url\" value=\"jdbc:mysql://localhost:3306/mysql/test\"/>
<param name=\"schema\" value=\"mysql\"/>
<param name=\"schemaObjectPrefix\" value=\"rep_\"/>
<param name=\"user\" value=\"root\"/>
<param name=\"password\" value=\"1234\"/>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager\">
<param name=\"url\" value=\"jdbc:derby:${wsp.home}/db;create=true\"/>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"/>
</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=\"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=\"textFilterClasses\" value=\"
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.MsWordTextExtractor,
org.apache.jackrabbit.extractor.PdfTextExtractor,
org.apache.jackrabbit.extractor.HTMLTextExtractor,
org.apache.jackrabbit.extractor.XMLTextExtractor,
org.apache.jackrabbit.extractor.RTFTextExtractor,
org.apache.jackrabbit.extractor.OpenOfficeTextExtractor\" />
</SearchIndex>
</Workspace>
<Versioning rootPath=\"${rep.home}/version\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.mysql.jdbc.Driver\"/>
<param name=\"url\" value=\"jdbc:mysql://localhost:3306/mysql/test\"/>
<param name=\"schema\" value=\"mysql\"/>
<param name=\"schemaObjectPrefix\" value=\"rep_\"/>
<param name=\"user\" value=\"root\"/>
<param name=\"password\" value=\"1234\"/>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager\">
<param name=\"url\" value=\"jdbc:derby:${rep.home}/version/db;create=true\"/>
<param name=\"schemaObjectPrefix\" value=\"version_\"/>
</PersistenceManager>
</Versioning>
</Repository>
</code>