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