9.8. Migrating Internal Databases for 6.1

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 new LDIF location, and rename the LDIF file to 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 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 unzip utility to the old_server_root/bin/cert/ directory so that the zip and unzip versions match.
3. Copy the package from the new server to the old server, and remove the package from the new server.
```
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 migration utility packaged with the old server will not be used, remove the current /bin/cert/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 old Certificate System migration directory.
```
cd old_server_root/bin/cert/migrate/61ToTxt
```
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 to the new Certificate System'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 new Certificate System migration directory.
```
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 the run.sh command to use the old.txt file 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's database directory.
```
cd /opt/redhat-ds/slapd-DS-instance/db
```
2. Use the ldif2db to import the old LDIF file into the new 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.8. Migrating Internal Databases for 6.1

NOTE

NOTE