Open Source Document Management System | OpenKM

PostPosted:**Mon Mar 11, 2013 3:30 pm**

Sorry to dig up this old thread but I have a question regarding MySQL:
If there are 2 instances of MySQl running on the same machine (windows xp) then apart from

hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
and
repository.datastore.backend=db

how OpenKM knows which instance of MySQL it is talking to?

Thank you in advance.

PostPosted:**Mon Mar 11, 2013 5:49 pm**

If you have two instances of MySql, I think you need to use 2 differents TCP/IP Port
3306 and 3307 for example so you need to insert the good one in /opt/okmpro/tomcat/conf/server.xml

Code: Select all

<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
          maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
          username="openkm" password="*bigsecret*" driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:3306/okmdb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>

Have a nice day

PostPosted:**Wed Mar 13, 2013 9:57 am**

Thank you for the response! I had forgotten this configuration in the server.xml. I will write the correct port in there.
Thanks again!
Keep on the good job guys.

Open Source Document Management System | OpenKM

OpenKM 6.2 MySQL Datastore

Re: OpenKM 6.2 MySQL Datastore

Re: OpenKM 6.2 MySQL Datastore

Re: OpenKM 6.2 MySQL Datastore