[midPoint] Midpoind connect mysql DB
Ivan Noris
ivan.noris at evolveum.com
Tue Jun 7 09:03:13 CEST 2016
Hi Merve,
I'm sorry, but if provisioning works for DB table and accounts are
created there, there is nothing I can suggest to do with the DB Table
versus Redmine. This seems to be beyond midPoint provisioning.
Regards,
Ivan
On 06/07/2016 08:33 AM, mceylan wrote:
> 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
> <mailto: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
>> <mailto: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 <mailto: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 <mailto: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>>
>>>> <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
>>>> <mailto: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
>>>>> <mailto: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 list
>>>>>>> midPoint at lists.evolveum.com
>>>>>>> <mailto:midPoint at lists.evolveum.com>
>>>>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>>>
>>>>>> --
>>>>>> Ing. Ivan Noris
>>>>>> Senior Identity Management Engineer & IDM Architect
>>>>>> evolveum.com <http://evolveum.com> evolveum.com/blog/ <http://evolveum.com/blog/>
>>>>>> ___________________________________________________
>>>>>> "Semper ID(e)M Vix."
>>>>>> _______________________________________________
>>>>>> midPoint mailing list
>>>>>> midPoint at lists.evolveum.com
>>>>>> <mailto:midPoint at lists.evolveum.com>
>>>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> midPoint mailing list
>>>>> midPoint at lists.evolveum.com
>>>>> <mailto:midPoint at lists.evolveum.com>
>>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>> --
>>>> Ing. Ivan Noris
>>>> Senior Identity Management Engineer & IDM Architect
>>>> evolveum.com <http://evolveum.com> evolveum.com/blog/ <http://evolveum.com/blog/>
>>>> ___________________________________________________
>>>> "Semper ID(e)M Vix."
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> midPoint at lists.evolveum.com
>>>> <mailto:midPoint at lists.evolveum.com>
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Merve CEYLAN
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> midPoint at lists.evolveum.com
>>>> <mailto:midPoint at lists.evolveum.com>
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>> --
>>> Ing. Ivan Noris
>>> Senior Identity Management Engineer & IDM Architect
>>> evolveum.com <http://evolveum.com> evolveum.com/blog/ <http://evolveum.com/blog/>
>>> ___________________________________________________
>>> "Semper ID(e)M Vix."
>>>
>>>
>>> _______________________________________________
>>> midPoint mailing list
>>> midPoint at lists.evolveum.com
>>> <mailto:midPoint at lists.evolveum.com>
>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>>
>>>
>>>
>>> --
>>> Merve CEYLAN
>>>
>>>
>>> _______________________________________________
>>> midPoint mailing list
>>> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>
>> --
>> Ing. Ivan Noris
>> Senior Identity Management Engineer & IDM Architect
>> evolveum.com <http://evolveum.com> evolveum.com/blog/ <http://evolveum.com/blog/>
>> ___________________________________________________
>> "Semper ID(e)M Vix."
>>
>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>
>>
>>
>>
>> --
>> Merve CEYLAN
>>
>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>
> --
> Ing. Ivan Noris
> Senior Identity Management Engineer & IDM Architect
> evolveum.com <http://evolveum.com> evolveum.com/blog/ <http://evolveum.com/blog/>
> ___________________________________________________
> "Semper ID(e)M Vix."
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>
>
>
> --
> Merve CEYLAN
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160607/95252d46/attachment.htm>
More information about the midPoint
mailing list