Upgrade Guide › JBoss Version › Post-Upgrade Configuration › Update Relational Database User Stores

Update Relational Database User Stores

The sample directory.xml files for Relational Database user stores require an update so that group members appear.

Follow these steps:

1. In the Management Console, click Directories.
2. Click the name of the RDB directory to export.

   The Properties for the CA IdentityMinder directory window appear.

3. At the bottom of the properties window, click Export.
4. When prompted, save the XML file.
5. Edit the XML file.
6. Remove the following section:

   <Table name="tblUsers" primary="true" />
   <Table name="tblUserAddress">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserRoles">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserDelegators">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserPasswordhints">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserIdentityPolicy">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblOrganizations">
      <Reference childcol="id" primarycol="org"/>
   </Table>
   

7. Insert the following section where you removed the preceding section.

   <Table name="tblUsers" primary="true" />
   <Table name="tblUserAddress">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserRoles">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserDelegators">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserPasswordhints">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblUserIdentityPolicy">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblOrganizations">
      <Reference childcol="id" primarycol="org"/>
   </Table>
   <Table name="tblGroupMembers">
      <Reference childcol="userid" primarycol="id"/>
   </Table>
   <Table name="tblGroupAdmins">
   

         <Reference childcol="userid" primarycol="id"/>
   

   </Table>
   

8. Adapt this code to your specific table and column names to match your user store schema.
9. Save the XML file.
10. In the Management Console, import the updated XML file.