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
- Stop the FTS Server service.
- 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.
- 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
- Start the FTS Server service.
The FTS Server should start and the trace.txt file should indicate a successful connection.
- (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" />
Note: Remember to restart the FTS Server after you have removed the data.