This topic has 3 replies, 3 voices, and was last updated 7 years, 1 month ago by Morten Lømo.

  • Author
    Posts
  • #4532
     Morten Lømo
    Participant

    I have configured OpenIDM to use MySQL as repository. I startup OpenIDM (./startup.sh). Then I login as openidm-admin into OpenIDM User UI and add a user. When I query the MySQL database I find the user that I just created. The column “Fullobject” in the managedobjects table contains:

    {
    “mail”:”[email protected]”,
    “sn”:”Lomo”,
    “passwordAttempts”:”0″,
    “lastPasswordAttempt”:”Sun Jun 14 2015 21:09:20 GMT+0200 (CEST)”,
    “address2″:””,
    “givenName”:”Morten”,
    “effectiveRoles”:[“openidm-authorized”],
    “password”:{“$crypto”:{“value”:{“data”:”5Emj3w1j0qDCkPTWpsOmUA==”,
    “cipher”:”AES/CBC/PKCS5Padding”,
    “iv”:”eyddmT0eez/soYYplawdyQ==”,
    “key”:”openidm-sym-default”},
    “type”:”x-simple-encryption”}},
    “country”:””,
    “city”:””,
    “_rev”:”0″,
    “lastPasswordSet”:””,
    “postalCode”:””,
    “_id”:”3d68f58f-a690-4f95-8f7f-320e58ad353f”,
    “accountStatus”:”active”,
    “roles”:[“openidm-authorized”],
    “telephoneNumber”:”12345678″,
    “effectiveAssignments”:{},
    “postalAddress”:””,
    “userName”:”morl”,
    “stateProvince”:””
    }

    and the managedobjectproperties table contains:

    mysql> select * from managedobjectproperties;
    +——————-+——————+——————+———————–+
    | managedobjects_id | propkey | proptype | propvalue |
    +——————-+——————+——————+———————–+
    | 1 | /mail | java.lang.String | [email protected] |
    | 1 | /sn | java.lang.String | Lomo |
    | 1 | /givenName | java.lang.String | Morten |
    | 1 | /lastPasswordSet | java.lang.String | |
    | 1 | /accountStatus | java.lang.String | active |
    | 1 | /roles/0 | java.lang.String | openidm-authorized |
    | 1 | /userName | java.lang.String | morl |
    +——————-+——————+——————+———————–+
    7 rows in set (0.00 sec)

    1. Where do you define which attributes that are stored in the Fullobject column in the managedobjects table? Can I modify this (add some more attributes)?

    2. Where do you define which attributes that are stored in the managedobjectproperties table?

    #4534
     Rogerio Rondini
    Participant

    Hi,

    That is the beauty of flexible data model.

    Attributes are defined in the sync.json for each mapping.

    At.
    Rogerio Rondini

    #4536
     Jake Feasel
    Moderator
    #4552
     Morten Lømo
    Participant

    Thanks. I will look more into this. Two more questions while I am at it:

    1. I find a sync.json file e.g. here: ../openidm/samples/usecase/usecase1/conf), but not here: ../openidm/conf). Is that because you get a default configuration if you leave the sync.json file out?

    2. Can I add attributes to the sync.json file and still use the OpenIDM User UI and the Open IDM Admin UI? Or are the two UIs very sensitive to the contents of the sync.json file so I must be very careful about what I do to the sync.json file if I want to use the two UIs?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?