OpenKM 6.2 MySQL Datastore

[Superpan]

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.

[techexpress]

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

[Superpan]

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.