<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>