Troubleshooting BDRSuite Backup Server Upgrade Failure Due to Database Connection Issue
Failed attempt to upgrade Vembu BDR Server due to encountering a database connection problem.
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.
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 ...