Resolving BDRSuite Backup Server Upgrade Failure Caused by Database Connection Issue

Troubleshooting BDRSuite Backup Server Upgrade Failure Due to Database Connection Issue

KB ID: 115101
Issue:
Failed attempt to upgrade Vembu BDR Server due to encountering a database connection problem.
Possible Causes:
This error occurs when there are difficulties in connecting to the database. Potential reasons include:
1. The database service might be stopped.
2. The database password in the configuration file (SGConf) is not encoded.
Solution:
a) Database Service Stopped:
To ensure the proper status of your database service, follow these steps:
1. Navigate to the "RUN" dialog and open "Services.msc".
2. Search for the relevant service: SGMySQL55 / PostgreSQL [PostgreSQL Server 9.6 / VembuPostgreSQL].
3. Confirm that the service is running; if not, manually start the service by clicking "Start".
b) Database Password Encoding:
(Applicable to Vembu BDR versions 3.9.1 and 3.9.1 Update 1)
1. Locate the installation directory of the Vembu BDR Server (Example: C:\Program Files\Vembu\Vembu BDR\Conf).
2. Open the "SGConfiguration.conf" file.
3. Search for the Database Tag section, which appears as follows:
<Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password="admin" ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" /> 
4. If the password is visible in readable format, replace it with an encoded version.
   Caution: Create a backup copy of SGConfiguration.conf before making changes.
5. Encode the password using a tool like https://www.base64encode.org/.
6. Replace the password in encoded format in the SGConfiguration.conf file within the ODBC tag.
Example:
<Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password="YWRtaW4=" ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" />  
7. Restart the appropriate service (VembuBDR / VembuODR) to apply the configuration changes.
Proceed with Upgrade:
After completing the above steps, you can proceed with upgrading your current BDRSuite Backup Server build.
For additional support or assistance, please contact BDRSuite technical support.

    • Related Articles

    • Connection Failure with BDRSuite Backup Server

      KB ID: 101008 Cause: The error of connection failure with the BDRSuite Backup Server occurs when the BDRSuite Client for File & Application Backup, BDRSuite Client for VMware/Hyper-V Backup/Windows/Linux is unable to establish a connection with the ...
    • Connection Failure with BDRSuite Backup Server

      KB ID: 101008 Issue: When attempting to establish a connection with the BDRSuite Backup Server, users may encounter a connection failure error. This prevents the BDRSuite Client for File & Application Backup, and BDRSuite Client for ...
    • Troubleshooting Database/Instance Connection Issues

      KB ID: 231001 Summary: Error code 231001 indicates a connection issue between the Database/Instance and the backup server. This critical error message reads, "Unable to establish the connection between the Database/Instance and the backup server." ...
    • Backup aborted

      KB ID: 101005 Product: BDRSuite Backup Server Cause This will occur due to the following reasons: Backup configuration stored in the server and client is incompatible. When the Backup storage location is inaccessible to the backup server. If you ...
    • Configuring ODBC Connection Manually to Resolve 'ODBC Permission Issue' for BDRSuite Backup Server\BDRSuite Offsite DR Server with PostgreSQL Database

      KB ID: 115047 Cause: Users may encounter an ODBC permission issue with the BDRSuite Backup Server\BDRSuite Offsite DR server that utilizes PostgreSQL as the database. This KB provides step-by-step instructions to manually configure the ODBC ...