<div dir="ltr"><div><br></div><div>Hi ivan, no problem users add resources localhost db table. I have a problem mysql db in users creating redmine users list</div><div><br></div><div><br></div><div>idm. log</div><div><br></div><div><br></div><div>2016-06-06 10:50:07,763 [REPOSITORY] [midPointScheduler_Worker-7] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:08,002 [REPOSITORY] [midPointScheduler_Worker-7] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:08,228 [REPOSITORY] [midPointScheduler_Worker-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:08,453 [REPOSITORY] [midPointScheduler_Worker-7] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:08,666 [REPOSITORY] [midPointScheduler_Worker-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:08,891 [REPOSITORY] [midPointScheduler_Worker-7] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:09,080 [REPOSITORY] [midPointScheduler_Worker-7] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:09,081 [REPOSITORY] [midPointScheduler_Worker-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 10:50:09,379 [REPOSITORY] [midPointScheduler_Worker-6] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:07,767 [REPOSITORY] [midPointScheduler_Worker-10] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:07,982 [REPOSITORY] [midPointScheduler_Worker-1] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:08,205 [REPOSITORY] [midPointScheduler_Worker-10] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:08,445 [REPOSITORY] [midPointScheduler_Worker-1] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:08,657 [REPOSITORY] [midPointScheduler_Worker-10] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:08,869 [REPOSITORY] [midPointScheduler_Worker-1] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:05:09,090 [REPOSITORY] [midPointScheduler_Worker-10] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2016-06-06 11:07:03,853 [MODEL] [Thread-19] WARN (com.evolveum.midpoint.model.impl.lens.projector.ReconciliationProcessor): Can't do reconciliation. Account context doesn't contain current version of account.</div><div>2016-06-06 11:07:04,492 [REPOSITORY] [ClusterManagerThread] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>~ </div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-06-06 11:04 GMT+03:00 Ivan Noris <span dir="ltr"><<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Please paste error exception from idm.log.<span class="HOEnZb"><font color="#888888"><br>
<br>
Ivan</font></span><div><div class="h5"><br>
<br>
<div>On 06/06/2016 09:48 AM, mceylan wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Thanks Ivan. I connect midpoint mysql db. add users
mysql db but i add user not creating redmine.
<div><br>
</div>
<div>Can you help me?</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-06-06 10:24 GMT+03:00 Ivan Noris <span dir="ltr"><<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi Merve,<br>
<br>
Ah, so you are trying to connect midPoint to existing
application (redmine) with the DBTable connector, right?<br>
This could work, if:<br>
<br>
1) the existing application is using only one table<br>
2) if you have created technical user to connect using the
connector (as Test connection works for you, you have at
least some permissions)<br>
3) the localhost-dbtable-advanced-sync.xml is a sample for
the database table with fixed columns as created in the
*.sql file(s) in the samples/resources/databasetable
directory. So you need to modify your schema handling to
use correct attributes for your application database
table, not for our samples.<br>
<br>
Specifically it seems that your database has no
"enable/disable" status attribute. In our sample, we have
two configuration elements for enable/disable:<br>
<br>
1) capabilities: defines which database table attribute is
used for enable/disable. In our samples it's
attribute/column named "disabled". If your database table
has different column for this, it must be defined here or
removed the section if your db does not support it.<br>
<capabilities
xmlns:cap=<a href="http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3" target="_blank">"http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3"</a>><br>
<configured><br>
<cap:activation><br>
<cap:status><br>
<cap:attribute><b>ri:disabled</b></cap:attribute><br>
<cap:enableValue></cap:enableValue><br>
<cap:enableValue>false</cap:enableValue><br>
<cap:disableValue>true</cap:disableValue><br>
</cap:status><br>
</cap:activation><br>
</configured><br>
</capabilities><br>
<br>
2) activation/administrativeStatus mapping: defines how
enable/disable in midPoint goes to the databasetable
(outbound) or vice versa (inbound). If your db table does
not support this, remove/comment this mapping:<br>
<br>
<activation><br>
<administrativeStatus><br>
<outbound/><br>
<inbound><br>
<strength>weak</strength><br>
</inbound><br>
</administrativeStatus><br>
</activation><br>
<br>
Best regards,<br>
Ivan
<div>
<div><br>
<br>
<div>On 06/04/2016 09:03 PM, <a href="mailto:mrveceylan@gmail.com" target="_blank"></a><a href="mailto:mrveceylan@gmail.com" target="_blank">mrveceylan@gmail.com</a>
wrote:<br>
</div>
<blockquote type="cite">
<div>I dont now. I want to midpoint connection
redmine<br>
<br>
iPhone'umdan gönderildi</div>
<div><br>
3 Haz 2016 tarihinde 17:58 saatinde, Ivan Noris
<<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>>
şunları yazdı:<br>
<br>
</div>
<blockquote type="cite">
<div> Hi Merve,<br>
<br>
which SQL creation script have you used to
create the MySQL table?<br>
Ivan<br>
<br>
<div>On 06/03/2016 03:40 PM, mceylan wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>Midpoint connection mysql dbtable. I
using file
locolhost-dbtable--advanced-sync.xml<br>
<div>
<div>Midpoint connection succesfull
mysql db.</div>
<div><br>
</div>
<div>Midpoint users add resource
localhost DBTable </div>
<div><br>
</div>
<div>stack tree </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div><span>Couldn't add object. Schema
violation: Schema violation during
processing shadow: shadow: null
(OID:null): DB syntax error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException(Unknown
column '__ENABLE__' in 'field
list')</span></div>
<br>
<div>
<ul style="margin:0px;list-style:none outside none;padding:0px">
<li style="padding:1px 0px;list-style:none outside none;margin:0px;text-overflow:ellipsis;overflow:auto"><br>
</li>
</ul>
</div>
</div>
-- </div>
<div><br>
</div>
<div>can you help me?<br>
<div data-smartmail="gmail_signature">
<div dir="ltr">Merve CEYLAN</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
<a href="http://evolveum.com" target="_blank">evolveum.com</a> <a href="http://evolveum.com/blog/" target="_blank">evolveum.com/blog/</a>
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>midPoint mailing list</span><br>
<span><a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a></span><br>
<span><a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a></span><br>
</div>
</blockquote>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
<a href="http://evolveum.com" target="_blank">evolveum.com</a> <a href="http://evolveum.com/blog/" target="_blank">evolveum.com/blog/</a>
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</div>
</div>
</div>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div data-smartmail="gmail_signature">
<div dir="ltr">Merve CEYLAN</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
<a href="http://evolveum.com" target="_blank">evolveum.com</a> <a href="http://evolveum.com/blog/" target="_blank">evolveum.com/blog/</a>
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</div></div></div>
<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Merve CEYLAN</div></div>
</div>