<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
it seems we have lack in the documentation, thank you for reporting
it. We are going to improve the documentation, however in the
meantime following simple how to would probably help.<br>
We assume you have followed
<a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration">https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a>
and <a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/MySQL">https://wiki.evolveum.com/display/midPoint/MySQL</a><br>
<br>
First of all you should shutdown your tomcat (if it is in running
state).<br>
<br>
This guide is for Windows environment, but it is very similar for
Linux.<br>
<br>
1. Check ${midpoint-home}/config.xml, where MySQL (H2 has to be
commented out) repository configuration is following:<br>
<repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<embedded>false</embedded><br>
<driverClassName>com.mysql.jdbc.Driver</driverClassName><br>
<jdbcUsername>midpoint</jdbcUsername><br>
<jdbcPassword>password</jdbcPassword><br>
<jdbcUrl>jdbc:mysql://localhost:3306/midpoint</jdbcUrl><br>
<hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect><br>
<hibernateHbm2ddl>validate</hibernateHbm2ddl><br>
</repository><br>
<br>
Please update the property values according to your environment.<br>
<br>
2. On classpath either in deployed midpoint
webapps/midPoint/WEB-INF/lib or in apache-tomcat/lib proper MySQL
driver shall be placed. In my case:
mysql-connector-java-5.1.30-bin.jar<br>
If you are missing it, please, follow the instruction in our wiki
to download and copy it.<br>
<br>
3. Check catalina.bat in apache-tomcat/bin to point to correct
midpoint home location (Please set your own path):<br>
set JAVA_OPTS=%JAVA_OPTS% -Dmidpoint.home=c:/midpoint_3_Node2
-XX:MaxPermSize=1024m<br>
<br>
4. In MySQL (I am using workbench) create midpoint database:<br>
<br>
CREATE DATABASE IF NOT EXISTS midpoint CHARACTER SET utf8
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin DEFAULT COLLATE
utf8_bin;<br>
CREATE USER 'midpoint'@'localhost' IDENTIFIED BY 'password';<br>
GRANT ALL on midpoint.* TO 'midpoint'@'localhost';<br>
use midpoint;<br>
<br>
and all the DB objects (tables) that are in the midpoint mysql
script.<br>
<br>
...<br>
CREATE TABLE ...<br>
...<br>
<br>
Use proper sql script based on the distribution your are using
either stable or snapshot:<br>
For stable release check:<br>
- the latest midpoint
<a class="moz-txt-link-freetext" href="http://www.evolveum.com/downloads/midpoint/3.0/">http://www.evolveum.com/downloads/midpoint/3.0/</a><br>
- and download midpoint-3.0-dist.zip<br>
- Execute MySQL database script located in:
*\midpoint-3.0-dist.zip\config\sql\midpoint\3.0\mysql\mysql-3.0<br>
For snapshot check:<br>
- the latest commit number on
<a class="moz-txt-link-freetext" href="https://bamboo.evolveum.com/browse/MID-TRUNK/latestSuccessful">https://bamboo.evolveum.com/browse/MID-TRUNK/latestSuccessful</a><br>
- and download it via <a class="moz-txt-link-freetext" href="http://athena.evolveum.com/builds/master/">http://athena.evolveum.com/builds/master/</a>
where .zip file should be selected (midpoint-3.1-SNAPSHOT-dist.zip).<br>
- Execute MySQL database script located in:
*\midpoint-3.1-SNAPSHOT-dist.zip\config\sql\midpoint\3.0\mysql\mysql-3.0<br>
<br>
5. Start tomcat (Windows) apache-tomcat\bin\startup.bat (for Linux
apache-tomcat\bin\startup.sh).<br>
6. Open browser <a class="moz-txt-link-freetext" href="http://localhost:8080/midpoint/admin/">http://localhost:8080/midpoint/admin/</a>
Login:administrator Pass:5ecr3t<br>
7. Create new user in midpoint.<br>
8. Check in MySQL table m_user where new user should be created:
select * from m_user;<br>
<br>
I hope this will help you.<br>
<br>
regards,<br>
Martin Devecka<br>
<br>
<div class="moz-cite-prefix">Dňa 12.8.2014 18:00 Sai Chandra wrote /
napísal(a):<br>
</div>
<blockquote cite="mid:1407859245800.62937@ilantus.com" type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; }--></style>
<p>Hi Team,<br>
</p>
<p><br>
</p>
<p>Can someone give me a breif idea how can i change the h2
database to my sql database.I have followed the steps mentioned
in the Wiki evoleum,but it didnt help me.I have created a user
and role in the midpoint but the data is not getting updated in
the MYSQL DB,and also i have not found any errors in the logs.A
quick response is highly appreciable.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>Thanks<br>
</p>
<p>Saichandra<br>
</p>
This message contains information that may be privileged or
confidential and is the property of ILANTUS Technologies. It is
intended only for the person to whom it is addressed. If you are
not the intended recipient, you are not authorized to read, print,
retain, copy, disseminate, distribute, or use this message or any
part thereof. If you receive this message in error, please notify
the sender immediately and delete all copies of this message.
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint-dev@lists.evolveum.com">midPoint-dev@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint-dev">http://lists.evolveum.com/mailman/listinfo/midpoint-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>