[midPoint] Midpoind connect mysql DB

mceylan mrveceylan at gmail.com
Tue Jun 7 08:33:58 CEST 2016


Hi Ivan,

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

Thanks,

Merve

2016-06-06 16:54 GMT+03:00 Ivan Noris <ivan.noris at evolveum.com>:

> Hi Merve,
>
> what's the relationship between localhost DB table and redmine?
>
> "mysqldb users tables creating users (merve). But  redmine users list not
> creating users(merve)."
>
> 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..
>
> Thanks,
> Ivan
>
>
> On 06/06/2016 11:07 AM, mceylan wrote:
>
> Hi Ivan,
>
> I use to connect to localhost db-table on a redmine. Midpoint resource
> list Localhost DB table succesfull connect.
>
> Users-list users-select user (merve)- add projection-select Localhost
> DBTable add resources.
>
>
>
>   Localhost DBTable
> admin
>
> auth_source_id
>
> created_on
>
> First name
>
> id *
>
> identity_url
>
> language
>
> Last name
>
> last_login_on
>
> mail_notification
>
> must_change_passwd
>
> Name
>
> passwd_changed_on
>
> salt
>
> status *
>
> type
>
> updated_on
>
> association
>
>
>
>
>
> id and status filled and save. mysqldb users tables creating users
> (merve). But  redmine users list not creating users(merve).
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 2016-06-06 11:46 GMT+03:00 Ivan Noris <ivan.noris at evolveum.com>:
>
>> Hi Merve,
>>
>> 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...
>>
>> I don't know/use redmine, so I need to understand the environment.
>>
>> Regards,
>> Ivan
>>
>>
>> On 06/06/2016 10:09 AM, mceylan wrote:
>>
>>
>> Hi ivan,  no problem users add resources localhost db table. I  have a
>> problem mysql db in users creating redmine users list
>>
>>
>> idm. log
>>
>>
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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
>> 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.
>> 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
>> ~
>>
>>
>>
>> 2016-06-06 11:04 GMT+03:00 Ivan Noris < <ivan.noris at evolveum.com>
>> ivan.noris at evolveum.com>:
>>
>>> Please paste error exception from idm.log.
>>>
>>> Ivan
>>>
>>>
>>> On 06/06/2016 09:48 AM, mceylan wrote:
>>>
>>> Thanks Ivan. I connect midpoint mysql db. add users mysql db but i add
>>> user not creating redmine.
>>>
>>> Can you help me?
>>>
>>> 2016-06-06 10:24 GMT+03:00 Ivan Noris < <ivan.noris at evolveum.com>
>>> ivan.noris at evolveum.com>:
>>>
>>>> Hi Merve,
>>>>
>>>> Ah, so you are trying to connect midPoint to existing application
>>>> (redmine) with the DBTable connector, right?
>>>> This could work, if:
>>>>
>>>> 1) the existing application is using only one table
>>>> 2) if you have created technical user to connect using the connector
>>>> (as Test connection works for you, you have at least some permissions)
>>>> 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.
>>>>
>>>> Specifically it seems that your database has no "enable/disable" status
>>>> attribute. In our sample, we have two configuration elements for
>>>> enable/disable:
>>>>
>>>> 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.
>>>>                 <capabilities xmlns:cap=
>>>> <http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3>
>>>> "http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3"
>>>> <http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3>>
>>>>                         <configured>
>>>>                                 <cap:activation>
>>>>                                         <cap:status>
>>>>                                                 <cap:attribute>
>>>> *ri:disabled*</cap:attribute>
>>>>
>>>> <cap:enableValue></cap:enableValue>
>>>>
>>>> <cap:enableValue>false</cap:enableValue>
>>>>
>>>> <cap:disableValue>true</cap:disableValue>
>>>>                                         </cap:status>
>>>>                                 </cap:activation>
>>>>                         </configured>
>>>>                 </capabilities>
>>>>
>>>> 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:
>>>>
>>>>                                 <activation>
>>>>                                         <administrativeStatus>
>>>>                                                 <outbound/>
>>>>                                                 <inbound>
>>>>
>>>> <strength>weak</strength>
>>>>                                                 </inbound>
>>>>                                         </administrativeStatus>
>>>>                                 </activation>
>>>>
>>>> Best regards,
>>>> Ivan
>>>>
>>>>
>>>> On 06/04/2016 09:03 PM, <mrveceylan at gmail.com>mrveceylan at gmail.com
>>>> wrote:
>>>>
>>>> I dont now. I want to midpoint connection redmine
>>>>
>>>> iPhone'umdan gönderildi
>>>>
>>>> 3 Haz 2016 tarihinde 17:58 saatinde, Ivan Noris <
>>>> <ivan.noris at evolveum.com>ivan.noris at evolveum.com> şunları yazdı:
>>>>
>>>> Hi Merve,
>>>>
>>>> which SQL creation script have you used to create the MySQL table?
>>>> Ivan
>>>>
>>>> On 06/03/2016 03:40 PM, mceylan wrote:
>>>>
>>>> Hi,
>>>>
>>>> Midpoint connection mysql dbtable. I using file
>>>> locolhost-dbtable--advanced-sync.xml
>>>> Midpoint connection succesfull mysql db.
>>>>
>>>> Midpoint users add resource localhost DBTable
>>>>
>>>> stack tree
>>>>
>>>>
>>>> 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')
>>>>
>>>>
>>>>    -
>>>>
>>>> --
>>>>
>>>> can you help me?
>>>> Merve CEYLAN
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>> --
>>>>   Ing. Ivan Noris
>>>>   Senior Identity Management Engineer & IDM Architect
>>>>   evolveum.com                     evolveum.com/blog/
>>>>   ___________________________________________________
>>>>   "Semper ID(e)M Vix."
>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> <midPoint at lists.evolveum.com>midPoint at lists.evolveum.com
>>>> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>> --
>>>>   Ing. Ivan Noris
>>>>   Senior Identity Management Engineer & IDM Architect
>>>>   evolveum.com                     evolveum.com/blog/
>>>>   ___________________________________________________
>>>>   "Semper ID(e)M Vix."
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> midPoint at lists.evolveum.com
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>
>>>
>>> --
>>> Merve CEYLAN
>>>
>>>
>>> _______________________________________________
>>> midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>>
>>> --
>>>   Ing. Ivan Noris
>>>   Senior Identity Management Engineer & IDM Architect
>>>   evolveum.com                     evolveum.com/blog/
>>>   ___________________________________________________
>>>   "Semper ID(e)M Vix."
>>>
>>>
>>> _______________________________________________
>>> midPoint mailing list
>>> midPoint at lists.evolveum.com
>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>>
>>
>>
>> --
>> Merve CEYLAN
>>
>>
>> _______________________________________________
>> midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint
>>
>>
>> --
>>   Ing. Ivan Noris
>>   Senior Identity Management Engineer & IDM Architect
>>   evolveum.com                     evolveum.com/blog/
>>   ___________________________________________________
>>   "Semper ID(e)M Vix."
>>
>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>
>>
>
>
> --
> Merve CEYLAN
>
>
> _______________________________________________
> midPoint mailing listmidPoint at lists.evolveum.comhttp://lists.evolveum.com/mailman/listinfo/midpoint
>
>
> --
>   Ing. Ivan Noris
>   Senior Identity Management Engineer & IDM Architect
>   evolveum.com                     evolveum.com/blog/
>   ___________________________________________________
>   "Semper ID(e)M Vix."
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>


-- 
Merve CEYLAN
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160607/daf2af06/attachment.htm>


More information about the midPoint mailing list