Configure the WebSphere Commerce database when using customized DNs
Follow the steps on this page if you use customized DNs.Prerequisite
- You have installed Member Manager.
- DB2 UDB V8.1 FixPak 11 (also known as V8.2 FixPak 4) or higher is installed. This fix pack is required to fix a problem that is encountered when a replacement string is longer than the original string. For example, if the DN that represents your Root Organization or your Default Organization is longer than the default value.
You must update your database if at least one of the following conditions are true:
- If you use DNs other than o=root organization, and o=default organization to represent Root Organization and Default Organization.
- If user DNs begin with a prefix other than "uid=". For example, if you use the "cn=" prefix.
The relationship of the user to its parent organizations is defined in the MBRREL table and also mirrored in the DN for the user.
- AIX|Linux|Solaris: Log on as the WebSphere Application Server user. For example, wasuser.
- Navigate to the following location: WC_installdir/schema/ db_type/ldap/
- Back up the updatedbforldap _ldap_type.sql file. For example, if you use Active Directory, the ldap_type is represented by "ad" while all other LDAP servers use the "default" type.
- Open the appropriate updatedbforldap _ldap_type.sql file in a text editor.
- Complete one of the following steps
- If you are not using o=root organization, and o=default organization to represent Root Organization and Default Organization, search and replace the following parameters:
Variable Value @WcsRootOrgDN@ Replace @WcsRootOrgDN@ with the root org DN. For example, dc=domain,dc=ibm,dc=com
@WcsDefaultOrgDN@ Replace @WcsDefaultOrgDN@ with the default org RDN. For example, cn=users.
update users set dn=replace(dn,'uid=', ' desired_prefix=');
Where:
For example, if the desired_prefix is "cn" then run the following command: update users set dn=replace(dn,'uid=','cn=');
db2 -tvf updatedbforldap _ldap_type.sql
@ updatedbforldap _ldap_type.sql
After you run the command, commit the database. For information on committing the database, refer to Oracle documentation.
Run the following SQL script to update your database:
db2 -tvf updatedbforldap _ldap_type.sql
sqlplus dbusername/dbuserpw@dbname
@ updatedbforldap _ldap_type.sql
After you run the command, commit the database. For information on committing the database, refer to Oracle documentation.
Configure WebSphere Commerce Developer and Member Manager.