<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body 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 class="moz-txt-link-rfc2396E" href="http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3">"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<br>
<br>
<div class="moz-cite-prefix">On 06/04/2016 09:03 PM,
<a class="moz-txt-link-abbreviated" href="mailto:mrveceylan@gmail.com">mrveceylan@gmail.com</a> wrote:<br>
</div>
<blockquote
cite="mid:77C4115E-66C7-47DA-AC4A-E789B0B1A042@gmail.com"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<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"><a class="moz-txt-link-abbreviated" href="mailto:ivan.noris@evolveum.com">ivan.noris@evolveum.com</a></a>>
şunları yazdı:<br>
<br>
</div>
<blockquote type="cite">
<div>
<meta content="text/html; charset=utf-8"
http-equiv="Content-Type">
Hi Merve,<br>
<br>
which SQL creation script have you used to create the MySQL
table?<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 06/03/2016 03:40 PM, mceylan
wrote:<br>
</div>
<blockquote
cite="mid:CADu1p_giYDRF_WLxNRS6UorW1gK7c4rbJ5t4j3n-AaqszazGVg@mail.gmail.com"
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 class=""
style="display:inline-block;padding-right:15px;color:rgb(185,74,72);font-family:'Source
Sans Pro','Helvetica
Neue',Helvetica,Arial,sans-serif;font-size:14px;font-weight:bold;line-height:20px;background-color:rgb(242,222,222)"><span
style="">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 style="color:rgb(185,74,72);font-family:'Source
Sans Pro','Helvetica
Neue',Helvetica,Arial,sans-serif;font-size:14px;font-weight:bold;line-height:20px;background-color:rgb(242,222,222)">
<div class=""
style="font-size:12px;display:inline-block;padding-right:15px;padding-top:5px;clear:both;width:981.344px;color:rgb(185,74,72);font-family:'Source
Sans Pro','Helvetica
Neue',Helvetica,Arial,sans-serif;background-color:rgb(242,222,222)">
<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 class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">Merve CEYLAN</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" 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
<a moz-do-not-send="true" href="http://evolveum.com">evolveum.com</a> <a moz-do-not-send="true" href="http://evolveum.com/blog/">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">midPoint@lists.evolveum.com</a></span><br>
<span><a moz-do-not-send="true"
href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a></span><br>
</div>
</blockquote>
<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>