[midPoint] Midpoind connect mysql DB
Ivan Noris
ivan.noris at evolveum.com
Mon Jun 6 10:46:42 CEST 2016
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
> 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/20160606/7a212b23/attachment.htm>
More information about the midPoint
mailing list