KB ID : 115081
Products :
Published : July 18, 2018
Created : July 18, 2018

The default username and password for the Vembu BDR and OffsiteDR server webconsole is “admin” and “admin” respectively. We can also customize the username & password by choosing the custom option during server installation. In case if the password is forgotten, recovery option is not available in UI and we need to follow below steps to create new credentials:

1) Stop the VembuBDR service from services.msc

2) Run command prompt as administrator and login to PostgreSQL using below command:

      psql -Upostgres -p32010

**Example:** C:\>  psql -Upostgres -p32010


Once you enter the above command, you will be prompted for a password. Proceed to give "admin" which is the default password for the PostgreSQL.

3) Access the database "SGDatabase" by typing the below command to connect:

      \c SGDatabase

**Example:** c:> \c SGDatabase


Once you type the above command, you will be connected to SGDatabase.

4) Now Insert an additional user to the database using the following query:

insert into SG_USER values (10,1,'vembu','21232f297a57a5a743894a0e4a801fc3');

Where the 4 entries stand for user_id, role_id, user_name and password respectively. We can replace ‘vembu’ with preferred user_name and the encrypted password ‘admin’(21232f297a57a5a743894a0e4a801fc3) can also be replaced with a custom password which can be encrypted using md5 encryption.

The first parameter(user_id) and the third parameter(user_name) should be unique and users are requested to execute the below query to list the existing list of user credentials:

Select * from SG_USER;

Note:

If the user_id or user_name to be added contains an already existing entry value, an error message ‘Duplicate entry...’ will be thrown.

5) If we insert an additional user in SG_USER table, we also need to update the SG_GROUP_USER table by executing the following query to insert additional user

**insert into SG_GROUP_USER values(10,1,1,1);**

Please note that in the above command the first parameter('10') should be same as user_id we specified in SG_USER table and the other three parameters should be set by default as '1';

5) Start the VembuBDR/OffsiteDR application.