<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Please paste error exception from idm.log.<br>
<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 06/06/2016 09:48 AM, mceylan wrote:<br>
</div>
<blockquote
cite="mid:CADu1p_hfHCCiVpqCLFWeJpBjkVDRJAGfcApKv0TXnUP4iO8_Aw@mail.gmail.com"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:mrveceylan@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:mrveceylan@gmail.com">mrveceylan@gmail.com</a></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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://evolveum.com" target="_blank">evolveum.com</a> <a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:midPoint@lists.evolveum.com"
target="_blank">midPoint@lists.evolveum.com</a></span><br>
<span><a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://evolveum.com" target="_blank">evolveum.com</a> <a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
evolveum.com evolveum.com/blog/
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</body>
</html>