KB ID : 115101
Products :
Published : Jan. 14, 2019
Created : Jan. 14, 2019
Last Modified : Jan. 14, 2019

Cause

This error occurs only when there is an issue in connecting database, possible reasons:

1) Database service might be stopped

2) Database password in the configuration file(SGConf) is not encoded

Solution

a) Database service might be stopped

In order to make sure your database service status, follow below steps:

Step 1: Go to “RUN” and open “Services.msc”

Step 2: Search for SGMySQL55 / PostgreSQL [PostgreSQL Server 9.6 / VembuPostgreSQL]

Step 3: Make sure service is running, if not click “Start” to start the Service manually

b) Database Password in the configuration file(SGConf) is not encoded

Applicable version: Vembu BDR 3.9.1 & 3.9.1 Update 1

Step 1: Navigate to Server Installation location

Example: C:\Program Files\Vembu\Vembu BDR\Conf

Step 2: Open for “SGConfiguration.conf”

Step 3: Search for Database Tag below:

     <Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password="admin" ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" />

Step 4: If you happen to see Password of your Database in readable format then your password is to be replaced with an encoded format.

Caution: Before making any changes in SGConfiguration.conf, make an additional copy of SGConfiguration.conf in the same location. It would be helpful to revert back in case of any failure.

Step 5:Use the following link to encode your password: https://www.base64encode.org/

Provide the password in encode text box and click encode. Results of the encoded password will be listed in the below available text box.

Example: If the password is “admin” then your encoded password is “YWRtaW4=”

Step 6: Replace the encoded password in SGConfiguration.conf, in ODBC tag and restart the Service [VembuBDR / VembuODR] to reflect the configuration changes made.

     Example: <Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password=“YWRtaW4=” ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" />

Step 7: Now proceed with upgrading your current build.

edit retag flag offensive close merge delete