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 ...

    • Troubleshooting SNAPSHOT_FAILURE: Snapshot Initialization Issue in BDRSuite

      KB ID: 115121 Cause: BDRSuite backup server relies on the Volume Shadow Copy Service (VSS) to create snapshots. The alert is usually generated when VSS is unable to start due to an ongoing VSS process. Microsoft's native snapshot manager can only ...