<div dir="ltr">Hi Ivan,<div><br></div><div>I use to connect to localhost db-table on a redmine. Midpoint resource list Localhost DB table succesfull connect. </div><div><br></div><div>Users-list users-select user (merve)- add projection-select Localhost DBTable add resources. </div><div><br></div><div><br></div><div><br></div><div><div> Localhost DBTable</div><div>admin</div><div><br></div><div>auth_source_id</div><div><br></div><div>created_on</div><div><br></div><div>First name </div><div><br></div><div>id *</div><div><br></div><div>identity_url</div><div><br></div><div>language</div><div><br></div><div>Last name </div><div><br></div><div>last_login_on</div><div><br></div><div>mail_notification</div><div><br></div><div>must_change_passwd</div><div><br></div><div>Name </div><div><br></div><div>passwd_changed_on</div><div><br></div><div>salt</div><div><br></div><div>status *</div><div><br></div><div>type</div><div><br></div><div>updated_on</div><div><br></div><div>association</div><div><br></div><div><br></div></div><div><br></div><div><br></div><div><br></div><div>id and status filled and save. mysqldb users tables creating users (merve). But redmine users list not creating users(merve).</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-06-06 11:46 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>
I would like to understand what are you trying to achieve, what were
your steps on redmine side and how you configured midPoint DBTable
resource. The idm.log you sent unfortunately does not contain
anything regarding DBTable connector/provisioning...<br>
<br>
I don't know/use redmine, so I need to understand the environment.<br>
<br>
Regards,<br>
Ivan<div><div class="h5"><br>
<br>
<div>On 06/06/2016 10:09 AM, mceylan wrote:<br>
</div>
<blockquote type="cite">
<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><font color="#888888"><br>
<br>
Ivan</font></span>
<div>
<div><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"></a><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"></a><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"></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" 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" 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>