Prerequisites for Automatically Adding Database (Microsoft SQL/MySQL/PostgreSQL) Servers in Windows and Linux Environments

Prerequisites for Automatically Adding Database (Microsoft SQL/MySQL/PostgreSQL) Servers in Windows and Linux Environments

KB ID: 115214

Overview

This article outlines the prerequisites for adding Microsoft SQL, MySQL, and PostgreSQL database servers on Windows and Linux environments to BDRSuite for seamless backup and data protection.

Supported Environments

ApplicationSupported version
Microsoft SQL ServerMicrosoft SQL Server 2022 - CU7, Microsoft SQL Server 2019 - CU22, Microsoft SQL Server 2017 - CU31, Microsoft SQL Server 2016 (SP3), Microsoft SQL Server 2014 (SP3) - CU4, Microsoft SQL Server 2012 (SP4)
MySQLMySQL 8.1, MySQL 8.0, MySQL 5.7
PSQLPSQL 15.x, PSQL 14.x, PSQL 13.x, PSQL 13.x

Supported Operating System

Operting SystemSupported version
WindowsWindows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2
, Windows Server 2012, Windows 11, Windows 10, Windows 8.1
LinuxDebian Linux 10.0 & Above, CentOS 7.4 & Above, CloudLinux 7.0 & Above, Fedora 34.0, Red Hat Enterprise Linux v8.0, SUSE Linux Enterprise Server, 12 SP5 & Above,
Ubuntu 18.04 LTS & Above

System Requirements

Memory:At least 2 GB
CPU:Dual-Core Processor or higher

Prerequisites for Adding a Database Server in Windows

1. Installation of BDRSuite Backup Agent (BBA)

Ensure that the BDRSuite Delegation Service (BBA) is installed and running with the name "BDRSuite Backup Agent (BBA)." This component is essential for backup operations on the Windows backup host.

2. Access Privileges for Microsoft Windows

When adding Windows machines (Backup Host) for backup, ensure that the provided credentials have one of the following privileges:
  1. Administrator
  2. User with administrator privileges
Note: For Windows Workstations, it's recommended to create a user account with administrator privileges and use its credentials during the backup host addition.

3. Access Privilege in the Backup Server

In the backup server, make sure the "BDRSuite Backup Server for Virtual Physical Workloads" Windows service runs under an administrator user account. To set this up:
  1. Open the Run window by pressing ‘Win + R’ keys.
  2. Type ‘services.msc’ and click OK.
  3. Right-click on "BDRSuite Backup Server for Virtual Physical Workloads" service, select 'Properties.'
  4. Go to the 'Logon' tab, choose the 'This account' radio button.
  5. Provide the administrator user privilege in the format ".\username" and password, then click OK.
  6. Stop and restart the service to apply the changes.

4. Access to the "Admin$" Folder

Ensure that the backup server has access to the "Admin$" folder of the backup host.
  1. If accessible, proceed to Prerequisite 5.
  2. If not accessible, follow the provided steps to allow Windows Management Instrumentation function through the firewall and ensure that the necessary services are running.

5. Access to Windows Management Instrumentation

  1. Allow remote connections to Windows Management Instrumentation on the backup host through the firewall.
  2. Ensure that the "Windows Management Instrumentation" service is running on the backup host.

6. Access to Remote Registry

Ensure that the "Remote Registry" service is running on the Windows backup host.

7. WBEMTest Verification

After fulfilling the prerequisites, verify remote connectivity to the backup host from the backup server using WBEMTest. Follow the steps provided for successful verification before proceeding to add the Windows machine for backup.

Prerequisites for Adding a Database Server in a Linux Machine

1. User Account with Root Privileges

Ensure that the user account you intend to use to add the Linux machine has root privileges. If you plan to add a non-root account, make sure you have access to the root password.

2. User Account Credentials

You can provide user account credentials using either of the following methods:
  1. Linux Account Option: Directly connect to the Linux machine using the username and password of the specified user account.
  2. Linux Private Key Option: Connect to the Linux machine using the Identity/Pubkey authentication method. Follow the provided steps to generate a public-private key pair if needed. 
Key Generation Steps
Step 1: Generate a pair of keys - a public key and a private key using the following command:
ssh-keygen -t rsa
Step 2: Specify the location and filename in the format .ppk or .pem to save the key. For example, keys can be generated in the .ppk format:
Example: /home/key.ppk
Step 3: Enter a passphrase or leave it empty. The private key can be protected with a passphrase.
Step 4: The private key (.ppk) and public key (.pub) will be saved to the specified location and file.
Example:
Your identification has been saved in /home/key.ppk
Your public key has been saved in /home/key.ppk.pub
Step 5: Change the file permissions of the private and public keys using the following command:
chmod 755 <private key filename>
chmod 755 <public key filename>
Step 6: On the target Linux machine, the public key needs to be kept in a special authorized_keys file containing a list of public keys using the following command:
ssh-copy-id -i <public key filename> <username>@<Host IP Address>
Example: `ssh-copy-id -i key.ppk.pub admin@192.168.102.11`
Step 7: Copy the Private Key file to the backup server using any FTP tools. You should now have the Public key on the Linux machine and the Private key on the backup server.
3. Ports:
  1. Ensure that the SSH Port is open, allowing remote access to the machine. The default SSH port is 22, but if you are running the SSH server on a different port, ensure that the port is accessible.
  2. Vembu BDR for Linux uses port 42005 to communicate with the Backup Server, so make sure your firewall rules allow port 42005 to be open for communication.
By satisfying these prerequisites, you can successfully add both Windows and Linux machines to the BDRSuite, ensuring efficient backup and data protection.