[midPoint] Midpoind connect mysql DB
mceylan
mrveceylan at gmail.com
Mon Jun 6 10:09:42 CEST 2016
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>:
> 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>:
>
>> 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>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>
>> ş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
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160606/6f1cd5ea/attachment.htm>
More information about the midPoint
mailing list