9.9. Migrating Internal Databases for 6.2

Log into the Directory Server for the new Certificate System instance, and export the new internal database content to LDIF. The internal database name for the Certificate System instance is in the internaldb.database parameter in the CS.cfg file. For example:
```
cd /opt/redhat-ds/slapd-DS-instance/db

db2ldif -n server.example.com-rhpki-ca
```
The location and name of the LDIF file is shown once the conversion from the database to LDIF is complete.
```
ldif file: 
/opt/redhat-ds/slapd-DS-instance/ldif/dated_#_file.ldif
```

Open the given LDIF location, and rename the LDIF file new.ldif.

cd /opt/redhat-ds/slapd-DS-instance/ldif

mv dated_#_file.ldif new.ldif

Copy the newest version of the migration utility from the new Certificate System to the old Certificate System.

The migration utility is available as an independent RPM, which can be downloaded through the Certificate System Red Hat Network channel. The migration utilities are installed in the directory /usr/share/rhpki/migrate.
1. Open the migration directory.
```
cd /usr/share/rhpki
```
2. Package the latest version of the Certificate System migration utility using zip or tar.
```
tar -cvf migrate.tar migrate
```
  NOTE
  
  Regardless of the packaging tool used, the corresponding tool must be present on the old server machine. If the platforms are identical and the zip utility is used, copy the zip tool from the new server to the old server so that the zip and unzip versions match.
3. Copy the package from the new server to the old server, and then remove the package from the new Certificate System.
```
cp /usr/share/rhpki/migrate.tar old_server_root/bin/cert

rm /usr/share/rhpki/migrate.tar
```
4. Log into the old server as the Certificate System user for that machine, and open the Certificate System bin/cert/ directory.
```
cd old_server_root/bin/cert
```
5. Log in as root, and set the file user and group to the Certificate System user and group.
```
su
chown user:group migrate.tar
```
6. Log out as root. As the Certificate System user, change the permissions on the file.
```
chmod 00600 migrate.tar
```
7. Since the old Certificate System migration utility will not be used, remove the old Certificate System upgrade/ directory.
```
rm -rf old_server_root/bin/cert/upgrade
```
8. Unpackage the latest version of the migration utility using unzip or tar.
```
tar -xvf migrate.tar
```
9. Remove the migration utility package and any additional utilities, such as the unzip utility, that were copied to the old Certificate System server.
```
rm migrate.tar
```
Run the db2ldif command to export the database contents to LDIF.
```
cd old_server_root/slapd-old_instance-db

db2ldif -n userRoot
```
The location and name of the LDIF file is shown once the conversion from the database to LDIF is complete.
```
ldif file: 
old_server_root/slapd-old_instance-db/ldif/dated_#_file.ldif
```

Open the given LDIF location, and rename the LDIF file to old.ldif.

cd old_server_root/slapd-old_instance-db/ldif

mv dated_#_file.ldif old.ldif

Adjust the LDIF content of old.ldif.

NOTE

When using a text editor to perform the substitution instead of a script, use an editor that supports file sizes greater than 2 to 4 Gb such as vim because the LDIF files may be larger than 2 GB in some deployments.
1. Open the old Certificate System LDIF directory.
```
cd old_server_root/slapd-old_instance-db/ldif
```
2. Replace the following entry with the value for internaldb.basedn parameter in the CS.cfg file. For example:
```
cn=aclResources,dc=server.example.com-rhpki-ca
```
3. Add new groups for the the security domains.
```
cn=Security Domain Administrators,ou=groups,basedn
cn=Enterprise CA Administrators,ou=groups, basedn
cn=Enterprise KRA Administrators,ou=groups, basedn
cn=Enterprise OCSP Administrators,ou=groups, basedn
cn=Enterprise TKS Administrators,ou=groups, basedn
cn=Enterprise TPS Administrators,ou=groups, basedn
```
Convert the old.ldif file to a text file.
1. Open the version to text directory in the migration directory copied to the old Certificate System.
```
cd old_server_root/bin/cert/migrate/62ToTxt
```
2. Edit the run.sh script; uncomment and set the values for the following lines:
  - SERVER_ROOT=old_server_root
  - export SERVER_ROOT
  - INSTANCE=old_instance
  - export INSTANCE
3. Run the run.sh to use the old.ldif file to create a text file.
```
run.sh old_server_root/slapd-old_instance-db/ldif/old.ldif >
 old_server_root/slapd-old_instance-db/ldif/old.txt
```
Open the old Certificate System LDIF directory, and copy the old.txt file into the new Certificate System server instance's internal database LDIF directory.
```
cd old_server_root/slapd-old_instance-db/ldif

cp old_server_root/slapd-old_instance-db/ldif/old.txt
 /opt/redhat-ds/slapd-DS-instance/ldif
```
Log into the new server as the Certificate System user, and open the Certificate System ldif/ directory.
```
cd /opt/redhat-ds/slapd-DS-instance/ldif
```
Log in as root, and set the file user and group to the Certificate System user and group.
```
su

chown user:group old.txt
```
Log out as root. As the Certificate System user, change the permissions on the file.
```
chmod 00600 old.txt
```
Convert the old.txtfile to LDIF.
1. Open the text to version directory in the migration directory in the new Certificate System.
```
cd /usr/share/rhpki/migrate/TxtTo72
```
2. Edit the run.sh script; uncomment and set the values for the following lines. For example:
  - SERVER_ROOT=/var/lib
  - export SERVER_ROOT
  - INSTANCE=rhpki-ca
  - export INSTANCE
3. Run run.sh to use old.txt to create an LDIF file.
```
run.sh /opt/redhat-ds/slapd-DS-instance/ldif/old.txt >
 /opt/redhat-ds/slapd-DS-instance/ldif/old.ldif
```
Import the old.ldif LDIF file into this new Certificate System server instance's internal database.
1. Open the new Certificate System database directory.
```
cd /opt/redhat-ds/slapd-DS-instance/db
```
2. Run the ldif2db tool to import the LDIF file into the Certificate System database. The internal database name for the Certificate System instance is in the internaldb.database parameter in the CS.cfg file. For example:
```
ldif2db -n server.example.com-rhpki-ca
 -i /opt/redhat-ds/slapd-DS-instance/ldif/old.ldif
```
3. Force the virtual list views (VLV) indexes to be re-indexed.
```
db2index
```

9.9. Migrating Internal Databases for 6.2

NOTE

NOTE