<div dir="ltr">
<div>Hello Fabian,</div><div><br></div><div>I have followed your instructions and i was able to export all the objects. <br></div><div>Now i'm running on mP3.8.</div><div><br></div><div>Thanks for sharing your solution.</div><div>Nico Pätzelt</div>
</div><br><div class="gmail_quote"><div dir="ltr">Am Di., 13. Nov. 2018 um 15:42 Uhr schrieb Fabian Bosch <<a href="mailto:fabian.bosch@daasi.de">fabian.bosch@daasi.de</a>>:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hi
</p>
<p>it has been a while but I had the same setup and error while upgrading.
</p>
<p>As far as I remember this did the trick:</p>
<ul>
<li>setup a new DB (the schemas aren't compatible)</li>
<li>download jdbc-driver and save to any location (to explicitly name it for ninja-tool)
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><a class="m_5698800147591534743moz-txt-link-freetext" href="https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar" target="_blank">https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar</a>
</pre></li>
<li><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">use ninja-3.2.7.jar out of midpoint-3.8's sources to export the 3.2.7-Objects</p></li>
<ul>
<li><pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja-3.7.2.jar -m /opt/midpoint/midpoint-3.7.2-home -U 'jdbc:mariadb://localhost:3306/midpoint' -u 'midpoint' -p '<pw>' export -O midpoint-pre-v3_8.zip -z -l 4`
</pre></li>
</ul>
</ul>
<ul>
<li>start your new mP3.8-Instance with new DB (use provided sql-script for initial db-setup like in any new installation beforehand)</li>
</ul>
<ul>
<li>then import the Objects using ninja.jar out of midpoint 3.8's sources<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
</p></li>
<ul>
<li><pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja.jar -m /opt/midpoint/midpoint-3.7-home -U 'jdbc:mariadb://localhost:3306/midpoint38' -u 'midpoint' -p '<pw>' import -i midpoint-pre-v3_8.zip -z -l 4`
</pre></li>
</ul>
</ul>
<p>
</p>
<p>good luck!</p>
<p>Fabian</p>
<p>
</p>
<div class="m_5698800147591534743moz-cite-prefix">Am 13.11.18 um 15:14 schrieb Nico:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hello everyone,</div>
<div><br>
</div>
<div>i am trying to update an existing midpoint
instance 3.7.2 with mariaDB to 3.8.</div>
<div><br>
</div>
<div>My installation path is:
/opt/idm/midpoint-3.7.2/ <br>
</div>
<div>And my MIDPOINT_HOME is:
/opt/idm/midpoint-3.7.2/var</div>
<div>Java 1.8.0.191 is installed</div>
<div><br>
</div>
<div>config.xml looks like:</div>
<div> <repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<database>mariadb</database><br>
<jdbcUsername>midpoint</jdbcUsername><br>
<jdbcPassword>PASSWORD</jdbcPassword><br>
<jdbcUrl>jdbc:mariadb://HOST:3306/midpoint?characterEncoding=utf8</jdbcUrl><br>
</repository><br>
</div>
<div><br>
</div>
<div>Command: /opt/idm/midpoint/bin/ninja.sh -v
count</div>
<div>(Like said in the upgrade documentation step
1.c)</div>
<div><br>
</div>
<div>The Error says:</div>
<div>2018-11-13 14:58:09,518 [main] INFO (SYSOUT):
Initializing repository using midpoint home<br>
Unexpected exception occurred (class
org.springframework.beans.factory.UnsatisfiedDependencyException),
reason: Error creating bean with name
'repositoryService': Unsatisfied dependency
expressed through field 'sequenceHelper'; nested
exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'sequenceHelper':
Unsatisfied dependency expressed through field
'objectUpdater'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'objectUpdater':
Unsatisfied dependency expressed through field
'closureManager'; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'orgClosureManager':
Invocation of init method failed; nested exception
is org.hibernate.TransactionException: Transaction
not successfully started<br>
Exception stack trace:<br>
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'repositoryService':
Unsatisfied dependency expressed through field
'sequenceHelper'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'sequenceHelper':
Unsatisfied dependency expressed through field
'objectUpdater'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'objectUpdater':
Unsatisfied dependency expressed through field
'closureManager'; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'orgClosureManager':
Invocation of init method failed; nested exception
is org.hibernate.TransactionException: Transaction
not successfully started<br>
...</div>
<div>...</div>
<div>...</div>
<div>Caused by: org.hibernate.TransactionException:
Transaction not successfully started<br>
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:202)<br>
...</div>
<div><br>
</div>
<div>
I enabled the sql query log. But there is not one
SQL which is getting executed.
</div>
<div>Has someone managed to upgrade from 3.7.2 with
mariaDB? Or had someone the same problem?</div>
<div><br>
</div>
<div>Kind Regards</div>
<div>Nico Pätzelt<br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="m_5698800147591534743mimeAttachmentHeader"></fieldset>
<pre class="m_5698800147591534743moz-quote-pre">_______________________________________________
midPoint mailing list
<a class="m_5698800147591534743moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a class="m_5698800147591534743moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre class="m_5698800147591534743moz-signature" cols="72">--
--
Fabian Bosch, Solutions-Engineer
DAASI International GmbH
Europaplatz 3
D-72072 Tübingen
Germany
phone: +49 7071 407109-0
fax: +49 7071 407109-9
email: <a class="m_5698800147591534743moz-txt-link-abbreviated" href="mailto:fabian.bosch@daasi.de" target="_blank">fabian.bosch@daasi.de</a>
web: <a class="m_5698800147591534743moz-txt-link-abbreviated" href="http://www.daasi.de" target="_blank">www.daasi.de</a>
Sitz der Gesellschaft: Tübingen
Registergericht: Amtsgericht Stuttgart, HRB 382175
Geschäftsleitung: Peter Gietz</pre>
</div>
</blockquote></div>