[midPoint] Midpoind connect mysql DB

[mceylan]

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 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160606/b90682e1/attachment.htm>