• MYSQL configuration

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #34  by peter
 
i am beginning to realy like openKM and thank god for this forum!

after setting up openKM and getting it to work now i would like to make it work on top of a database. i would like to work with mysql eventhough mssql server would do as well.

as stated in other parts of the forum i am a newbe at this and could use some help configuring OpenKM to use mysql.

what i have done so far:
- downloaded and installed easyphp(apache,mysql,phpmyadmin).
- read all the manuals of OpenKM.

any suggestions where i go from here will be very much appriciated and rewarded with some kind words ;)

thanx,
Peter
 #36  by pavila
 
There is good support for MySQL. Actually we are working in a better documentation and it is being deployed at the new wiki located at Support > Documentation. Meanwhile, the old PDF documentation hosted at SourceForge is a good reference.
 #38  by peter
 
hi thanx for the reply!

i have been trying to connect a mysql database to openkm for the last 2 hours and i am no closer to completing this. i have read the documentation and to be hounest i do not understand the explanation. i do not believe that the explanation is bad but that i just know to little about mysql and openkm and how to connect.

if anybody has the time or desire i realy would appreciate some help on the matter.

thanx in advance,
Peter
 #39  by jllort
 
Remember something about repository.xml, that indicates at firstime where is the repository created, you must not start jboss since repository.xml is changed.

If you started jboss before to change repository.xml, must remove \"repository\" directory, change repository.xml to appoint database and startup jboss.
 #42  by peter
 
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>
 #45  by pavila
 
You are only storing FileSystem in database. You can also store PersistenceManager in database. The XML seems to be ok, what is the error? Perhaps the connection url should be \"jdbc:mysql://localhost:3306/test\"?
 #46  by pavila
 
Also is a good practice to haver different \"schemaObjectPrefix\" for each FileSystem definition.
 #47  by jllort
 
Remember too, that mysql driver, jar file, must be copied on server/default/lib before starting jboss

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.