Configuring the File Type Support (FTS) Server to use encrypted communication with Oracle databases

The FTS Server configuration for encrypted communication requires changes to the Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config file.

Before you begin

Before you start configuring the FTS Server, make sure that the connection between WorldServer and your Oracle database is working as expected.

Procedure

  1. Stop the FTS Server service.
  2. Go to the folder where you installed the FTS Server and open the Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config file with a text editor.
  3. Modify the connection string as in the following example:
    <add name="SystemDb" connectionString="Host=<host>; Port=<port>; ServiceName=<servicename>; EncryptionMethod=ssl;
    UserId=C##<dbuser>; Password=<dbpassword>;
    CertificateStoreLocation=<path-to-wallet-certificate>/ewallet.p12; CertificateStorePassword=<certificate-password>;
    Trace File=<path-to-wallet-certificate>/trace.txt;Enable Trace=1;
    EnableTLSNegotiations=true" providerName="DDTek.Oracle" />
    In this case:
    • <host> is the fully qualified domain name of your database server
    • <port> is the port on which your database server is running
    • <servicename> is the service name of your Oracle database
    • <dbuser> is the username that you use to connect to your database
    • <dbpassword> is the password that you use to connect to your database
    • <path-to-wallet-certificate> is the path to the certificate of your Oracle wallet
    • <certificate-password> is the password of your certificate
  4. Start the FTS Server service.
    The FTS Server should start and the trace.txt file should indicate a successful connection.
  5. (Optional, but recommended): At this point, the FTS Server has automatically added the certificate to the store, which means that you can remove the certificate path and the password. In case of a successful connection, you can remove the trace file as well.
    For example:
    <add name="SystemDb" connectionString="Host=<host>; Port=<port>; ServiceName=<servicename>; EncryptionMethod=ssl;
    UserId=C##<dbuser>; Password=<dbpassword>;
    EnableTLSNegotiations=true" providerName="DDTek.Oracle" />