If you are restoring a backup of the Velocity database to the same computer (a Velocity serverServer, data serverData Server, or standalone workstationStandalone Workstation) where the backup was made, follow the instructions in Moving a Velocity 3.8 Database.
Suppose you are restoring a backed-up Velocity database to a different computer other than the one where it initially backed up; you must perform the additional procedures mentioned after restoring the Velocity database to the new computer. The other tasks are:
Licensing Velocity during the restoration of the Velocity Database
Editing the data in the tables in the restored Velocity database
Importing the Velocity TLS certificate from one server to another
Licensing Velocity during the restoration of the Velocity Database
Contact the Identiv Sales department for licensing your the Velocity system.
The Velocity license mechanism uses attributes of your computer to form a unique System ID used to license your system, which is used to validate your the Velocity license.
Before Velocity 3v3.8.6, restoring your database on a new machine would invalidate your the existing Velocity licenses because the new machine's System ID would no longer match your the license stored in the restored Velocity database.
Starting with Velocity v3.8.5, the licensing mechanism provides a grace period of up to 30 days once you have restored your the Velocity database on the new hardware. The grace period follows the Demo License of the newly installed Velocity software on the new machine. Therefore you may continue to use your the new instance of Velocity (with the restored database) while you obtain your a new licenses (for the new hardware) from Identiv.
During Demo License period you will see the Velocity Demo License expiration reminder (as shown below) each time an operator logs in until you have obtained a new Velocity Licenses for the new hardware.
...
The following rules of the temporary license apply while migrating Velocity Application from one system to another,;
If the migrated system does not have a valid Velocity license (i.e., e… license for the new hardware), the 30 day demo license is used.
An expired Velocity license notification message is displayed when the original Velocity license has bot been replaced with a new license within the 30 day demo period
If the installation is less than 30 days, a pop-up message reminder asks the user to purchase the Velocity Licensed version.
Velocity licenses found in the database that do NOT match the Server ID of that machine will be removed.
All other license types (i.e. e… Velocity integrations) are not applied or extended.
Editing the Table Data
...
on the restored Velocity Database
After restoring the Velocity database to the new system, perform the following procedure to edit the data in the SQL tables of the Velocity database.
On Windows 10 Pro, to locate the computer name of your system:
Open Control Panel. Click , click System and Security → > System.
On the View basic information, see the Full computer name under the Computer name, domain, and workgroup settings section. Visit Windows Support to check the computer name for other types of Windows versions.
From the Windows desktop, select Start→ Start > Microsoft SQL Server Tools 18→18 > Microsoft SQL Server Management Studio 18.
The Microsoft SQL Server Management Studio opens.Log in to SQL Server using your credentials.
Expand the Databases folder to display the Velocity database in the Object Explorer navigation pane.
Expand the Velocity database to display the Tables branch.
Make the changes specified in the following table by right-clicking each database table and selecting Edit Top 200 Rows from the pop-up menu. ( After each change, click outside the edited row for the changes to take effect.)
Note: Be extra careful while editing the tables because accidentally editing the tables can corrupt the database.The table describes the modification of the SQL table properties and their value after a Database restoration. A set of table properties such as Server_Name, Remote Computer Name, Application path, Remote Server IP, and its value are replaced by the destination system name or target system name, for example, VEL1-LOCAL-SYSTEM.
In this table: | Select this column: | Enter this data: |
---|---|---|
MiscProperties | AuthenticationPath |
|
VelocityServicesGroupPath | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
UseDomainAuthentication |
| |
Organizational Unit (OU) (This column exists only if you selected an Organization Unit during the Velocity installation.) | For example: LDAP://OU=ENGINEERING,DC=SECURITY,DC=com | |
Operators | Name | If you are not logging in as Administrator for OperatorID=2, use your Windows user name. (If you are using the Administrator account, skip this step.) |
DirectorySource |
| |
Servers | Server_Name | Name of the new Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be VEL1-LOCAL-SYSTEM. |
ServerExtensions | RemoteComputerName | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. |
Registry | AppPath |
|
ComputerName | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
RemoteIP | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM | |
RemoteServerIP | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
SDServer | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
ServerName | New SQL Server Instance name. For example, VEL1-LOCAL-SYSTEM\SQL_Instance_name. | |
Workstations | WorkstationName | Name of the new Velocity Server for WorkstationID=1 (all UPPERCASE). For example, the workstation name is VEL1-LOCAL-SYSTEM. |
ScheduledServiceTasks | ComputerName | Name of the new Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM (only if scheduled service has been created). |
...
7. Restart all Velocity Services and launch the Velocity Application.
8. Click Velocity's menu button, then select Extensions → > Server Extensions.
...
9. The Velocity Server Extensions Manager appears.
...
The Server Extensions Manager lists the service extensions that need to update the computer’s name before they work on the new computer. Make a note of which server extensions Server Extensions you are using.
10. Click to highlight an existing service extensionServer Extension. The Uninstall button is activated.
11. Click Uninstall. The selected extension service Server Extension is removed from the system.
12. Reinstall the Server Extensions that are used.
To install a server extension:
Click Velocity's menu button, then select Extensions > Server Extensions.
The Velocity Server Extensions Manager appears.
Click Install.
The Find Server Extension dialog appears.Search for C:\Program Files (x86)\Identiv\Velocity root directory. Several HEX files are located here, as shown.
Select the extension you want to install and click Open.
The newly installed extension appears in the Server Extension list in the Velocity Server Extensions Manager. By default, the extension is enabled (checked,) and the word 'True' appears in the first column.Repeat steps 3 to 5 to install more extensions.
When you are finished .
A a message appears, prompting you to restart the Extension Service before the extension takes effect.Click OK.
For the service extension Service Extension to take effect, right-click on the Velocity Service Control Manager (SCM) in Windows to try stopping stop and restarting the extension service.restart the Extension Service
Start the Velocity DIGI*TRAC Network Service.
Tip |
---|
The extension services Extension Services are displayed in Velocity’s Interfaces Configuration folder after installing and restarting them. |
...
To delete the VelocityTLS certificate:
Open certmgr.msc, goto certificates →Current User→ Personal → Certificates.go to certificates > Current User > Personal > Certificates
In the Certificate Properties dialog box, go to the Details tab and look for the field called "Issuer" or "Issued by". This will tell you where the certificate came from. Note down this information.
If you want to remove the certificate permanently, select the certificate (VelocityTLS) and press the Delete key, or right-click on the certificate and select Delete.
...
Open a command prompt with Administrator privileges (i.e., e… Run as administrator).
Change the Directory to Velocity installation directory (i.e., e… cd C:\Program Files (x86)\Identiv\Velocity).
Run the GenerateVelocityTLSCertificate.exe with -import switch (i.e., .. C:\Program Files (x86)\Identiv\Velocity ->GenerateVelocityTLSCertificate > GenerateVelocityTLSCertificate -import).
Verify Velocity TLS certificate was imported to Current User → > Personal → > Certificates.
Sometimes after importing the Velocity TLS certificate, permission for VelocityServices is not set correctly even though VelocityServices displays as having permission. When this occurs, you can fix this problem by deleting and re-granting permission to VelocityServices.
Open certmgr with Administrator permissions and go to Current User → > Personal → > Certificates.
Right-click VelocityTLS certificate → > All Tasks → > Manage Private Keys...
Select the user VelocityServices and click the Remove button.
Click OK.
In order to perform the above actions, you need to have administrative rights on the computer.