The default username and password for the BDRSuite Backup Server/ BDRSuite Offsite DR Server web console are "admin" and "admin," respectively. While customizing the username and password during server installation is an option, there may be cases where you need to create new credentials. This knowledge base article explains the steps to add a new username and password for your BDRSuite Backup Server/ BDRSuite Offsite DR Server

1. Stop BDRSuite Service:

Stop the BDRSuite service from the Windows Services panel (`services.msc`).

2. Access PostgreSQL:

Open a command prompt as an administrator and log in to PostgreSQL using the following command from 'C:\Program Files\Vembu\PostgreSQL\13\bin' location

Windows: psql.exe -Upostgres -p32010 

Linux: psql -Upostgres -p32010

You will be prompted to enter a password. Use the default password "admin" for PostgreSQL.

3. Connect to the Database:

Access the "SGDatabase" by typing the following command:

  \c SGDatabase

 4. Insert New User:

Insert a new user into the database using the following query:

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

The parameters in the query represent: user_id, role_id, user_name, and password, respectively.

1. You can replace 'vembu' with your preferred username.
   
2. The encrypted password 'admin' (21232f297a57a5a743894a0e4a801fc3) can be replaced with a custom password that has been encrypted using md5 encryption.
   

5. Update SG_GROUP_USER:

If you've inserted an additional user in the SG_USER table, update the SG_GROUP_USER table with the following query:

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

1. The first parameter ('10') should match the user_id you specified in the SG_USER table.
   
2. The other three parameters should be set as '1' by default.
   

6. Start BDRSuite/OffsiteDR Application:

Start the BDRSuite/OffsiteDR application.

7. Log In with New Credentials:

You can now log in to the BDRSuite web console using the username "vembu" and the password you specified.

8. Change Password:

After logging in, navigate to "Management" and then "User Management" to change the password to your desired value.

Note:

- Ensure that the user_id and user_name you add are unique. Duplicate entries will result in an error message.

- The provided example uses the default password "admin." You can replace it with a custom password as needed.