Typically, all database user passwords change periodically. When the external database is subject to such changes, the Database Security server will not be able to connect to the external database. The back-end migration tool provides a way to change the configured password. This process is also useful for checking connectivity to the external database.
Make sure that you have administrator rights to run the migration tool.
The Database Security server must be stopped before you try to set up the external database.
The Database Security back-end migration tool's validation option is intended to create an encrypted password for accessing the external database. The resulting encrypted value is displayed on the standard output. This value can then be copied into the Database Security server, server-custom.properties file, to change the authentication password to connect to the external database.
Note
The process for validating connectivity depends on the target platform where the server is installed.
The following task applies to Windows platforms.
Start the migration tool in one of these ways:
On a Windows system, open a command prompt, then go to the bin directory under the root install directory.
For example,
C:\Program Files\Mcafee\Trellix Database Security\binThen, run the bat file, migration_tool.bat.
On a Linux system, run:
/etc/init.d/mfe-dbs-server db-migrate
Select an action, type
validate. This loads the properties specified in the file server-custom.properties.Type the user name and password. If validating an Oracle database, type in the second user name and password when prompted.
Type the database driver or press enter to accept the default.
For example,
<com.microsoft.sqlserver.jdbc.SQLServerDriver>Type the URL or press enter to accept the default.
After the validation process completes, a message is displayed indicating whether the properties are correct and listing a summary of the properties.
When prompted, indicate if you want to save the connection properties to the configuration file.
If you choose not to save the new configuration, you can do so later by editing the server-custom.properties file located in the following location:
<Trellix Database Security Server install dir>/confIf you are working with an Oracle database, copy the last two lines of the summary and replace the corresponding lines in the server-custom.properties file. The properties are database.password and database.backup.password.
If you are working with an MSSQL database, copy the last line of the summary and replace the corresponding line in the server-custom.properties file. The property is database.password.
Note
The exact order of the properties in the server-custom.properties file can vary.