Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagehtml/xml
linenumberstrue
<configuration>
  <midpoint>
    <repository>
      <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
      <database>mysql</database>
      <jdbcUsername>midpoint</jdbcUsername>
      <jdbcPassword>password</jdbcPassword>
      <jdbcUrl>jdbc:mysql://localhost:3306/midpoint?characterEncoding=utf8&amp;disableMariaDbDriver</jdbcUrl>
    </repository>
  </midpoint>
</configuration>

Please check  also */apache-tomcat/bin/catalina.bat to point to correct midpoint home location (please set your own path):

set JAVA_OPTS=%JAVA_OPTS% -Dmidpoint.home=c:/midpoint_3_Node2 -XX:MaxPermSize=1024mNote that any & in URL must be escaped (replaced by &amp;) as is customary in XML.

Driver

Driver is not bundled due to licencing issues. Download MySQL JDBC Driver and insert driver (for instance mysql-connector-java-58.10.30-bin21.jar) on classpath either in deployed midpoint */webapps/midPoint/WEB-INF/lib or in */apache-tomcat/lib

You can also download the driver JAR from Maven repository: https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.21/mysql-connector-java-8.0.21.jar

Database create

Code Block
languagesql
linenumberstrue
CREATE DATABASE midpoint CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin DEFAULT COLLATE utf8_bin;
CREATE USER 'midpoint'@'localhost' IDENTIFIED BY 'password';
GRANT ALL on midpoint.* TO 'midpoint'@'localhost';
use midpoint;

...