<div dir="ltr">Hi Ivan,<div><br></div><div>I don't know. Redmine being used at work. I just want users to director of the MidPoint of the Redmine. The construction work on the Redmine I do not knom too<div><br></div><div>Thanks,</div><div><br></div><div>Merve</div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-06-06 16:54 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>
what's the relationship between localhost DB table and redmine?<span class=""><br>
<br>
"mysqldb users tables creating users (merve). But redmine users
list not creating users(merve)."<br>
<br></span>
If provisioning to mysql table works, and you can see accounts
there, provision, modify and delete them, but "redmine users list
not creating users" it's probably outside something midPoint can do.
But please explain how mysql db table and redmine are connected
together..<br>
<br>
Thanks,<br>
Ivan<div><div class="h5"><br>
<br>
<div>On 06/06/2016 11:07 AM, mceylan wrote:<br>
</div>
<blockquote type="cite">
<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><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"></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"> 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"></a><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"></a><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" 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>