<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 class="h5"><br>
<br>
<div>On 06/04/2016 09:03 PM,
<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"></a><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">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>