OpenKM 6.2 MySQL Datastore

[okmuser]

Hi,

I have configured OpenKM with MySQL, but still the repository sits on the local disk and not in the MySQL database.

Is there anything else I need to do to configure MySQL datastore (as in 5.1.*) apart from following the WIKI.

Thanks with regards

[jllort]

You should change your OpenKM.cfg parameter to create and remember to change server.xml to binding MySQL sure you have read it http://wiki.openkm.com/index.php/MySQL-OpenKM_6.2 ? or I do not understand correctly and you want to store file into mysql too ? that's not good idea you'll get less performance and you'll need to backup a great size database ... are you sure you have thinking on it ... it's better backup blob files from file disk than backup large databases.

[okmuser]

Hi jllort,

Yes you thought right, I like to store the files in MySQL - this is what I did upto OpenKM 5.1.11.

The database is very small only 2GB, the plus side in this is all I need is the dbdump file from MySQL in a crash event to recover OpenKM.

Performance is not an issue as at most only two users will use at a given time.

Please help me.

Thanks with regards,
OkmUser

[techexpress]

Hi to all

Same pb here , I download the OpenKM 6.2 FROM http://openkm.com/en/download-english.html

I install it without start it, modify the 3 first files (/server.xml and OpenKM.xml and OpenKM.cfg) as see at http://wiki.openkm.com/index.php/MySQL-OpenKM_6.2

OpenKM.xml isn't created before first start

I check log catalina.log , I think in the script Open KM didn't creat table in the database the script default.sql insert some value but it didn't create table

Code: Select all

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'okm_app.OKM_CONFIG' doesn't exist

Any solution ? Lot of admin like My SQL server and for the space at 99 $ for 2 To it's not a problem

[okmuser]

Hi techexpress,

I am not sure whether we have the same problem, because I didn't have any issues with MySQL table creation, everything's working fine.

My requirement is to store the repository in MySQL too, instead on the filesystem.

And also to answer your issue, OpenKM.xml is part of the bundle.

Please check your download and try again.

Cheers,

[techexpress]

Hi !
Yes you're right I use before TRial Version 6.0.1 , if I download the community edition at http://sourceforge.net/projects/openkm/ ... n/download

I can find the openkm.xml, but if I use the trial pro edition , I can find it before starting OpenKM.
Also I try to use OpenKM with new My SQL database from scratch and nothing work.
In your installation , you have already your database created by Open KM 5.1 , in my case I need Open KM 6 complete the database.

I have this message : javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query

and in the log

Code: Select all

INFO  com.openkm.servlet.RepositoryStartupServlet - *** Initialize language detection engine... ***
2012-11-02 22:58:06,734 [pool-2-thread-1] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2012-11-02 22:58:06,734 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - Table 'okm_app.OKM_CONFIG' doesn't exist

[okmuser]

I think you should start a separate thread for your issues.

Cheers,

[techexpress]

Yes thank's and good night !

[pavila]

I'm a bit lost with this thread. I your current problem solved?

[okmuser]

Not really,

My requirement is to store files (BLOB) in MySQL database.

I don't have any issues with running OpenKM 6.2 with MySQL configuration, but files are stored in filesystem rather than in database. How can I move the files to MySQL.

If required I don;t have any issues in importing the repository again (from 5.1.11).

Please help.

Thanks with regards,

[pavila]

Can you reproduce the issue in the last night build from http://integration.openkm.com/6.2/ ?

[okmuser]

Hi pavilla,

Please note that I didn't have any table creation error (apart from some column type mismatch which I have pointed out in http://forum.openkm.com/viewtopic.php?f=3&t=8408)

My requirement is to store the repository in MySQL rather than in filesystem.

Can you please share the configuration to achieve this.

Thanks with regards,
OkmUser

[pavila]

In order to store documents also in database you need to use this configuration property:

Code: Select all

repository.datastore.backend=db

[Superpan]

I have also a configuration for MySQL.. and I want to do the same thing (store the repository in the MySQL database) ..
Does the above work?? If so, where do I write this: repository.datastore.backend=db ?? In which file? OpenKM.cfg??
And finally is it repository.datastore.backend=db or repository.datastore.backend=MySQL ??

Thank you in advance,
Best regards.

[jllort]

This configuration parameter should be set into OpenKM.cfg file.