[midPoint] Midpoind connect mysql DB

[Ivan Noris]

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">
                        <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 <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
>>> 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
> 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/84da6abd/attachment.htm>