How do I reset the users in the built in EventSentry database?

Article ID: 227
Category: Database
Applies to: 2.93 and newer
Updated: 2020-12-15

Method A: If you know the "postgres" user password, you can use the pgAdmin utility:

1A. Open pgAdmin by going through the Start Menu -> EventSentry -> Database -> pgAdmin

2A. Double click on "EventSentry" under the "Servers" category.

3A. Enter the "postgres" user password (this was set during installation) and click OK.

4A. Expand "Login Roles" at the bottom.

5A. Right click on the user (eventsentry_svc or eventsentry_web) whose password you'd like to change and click "Properties..."

6A. Click on the "Definition" tab, enter and confirm the new password, then click OK.

7A. Update the passwords in your EventSentry instance (article is linked at the bottom of this page)

Method B: If you do not know the "postgres" user password and need to reset it:

1B. Edit the "pg_hba.conf" file in the "C:\Program Files (x86)\EventSentry\data96" folder. If you still use Postgres 9.1 it will be in the "C:\Program Files (x86)\EventSentry\data" folder instead. You can make a copy of it before editing, since will be changed back after the password reset.

2B. Change the "password" (or "md5") text at the end of the "local connections" lines for both IPv4 and IPv6 to "trust".

Example:

3B. Restart the "EventSentry Database v9.6" service. If you sill use Postgres 9.1, instead you will restart the "EventSentry Database" service.

4B. Open pgAdmin by going through the Start Menu -> EventSentry -> Database -> pgAdmin. You can now connect in pgAdmin III with the "postgres" user and a blank password. If you receive the "fe_sendauth no password specified" error when attempting to use the blank password, please ensure that pgAdmin is configured to use the correct port. The port can be found by clicking your database action in the EventSentry console and clicking the Create button in the upper right corner to view the connection settings and see the current port number. You can change the port in pgAdmin by choosing Edit > Properties in the pgAdmin menu bar.

5B. Double click on "EventSentry" under the "Servers" category.

6B. Leave password blank for the "postgres" user and click OK.

7B. Expand "Login Roles" at the bottom.

8B. Right click on the user "postgres" and click "Properties..."

9B. Click on the "Definition" tab, enter and confirm the new password, then click OK.

10B. IMPORTANT! Be sure to put the "pg.hba.conf" lines back to "password" (or "md5") instead of "trust". If you make a copy of the file you can replace it back.

11B. Restart the "EventSentry Database v9.6" service. If you sill use Postgres 9.1, instead you will restart the "EventSentry Database" service.

12B. You can now use the new password that you created in step 7B whenever you need to connect as the "postgres" user.

13B. Update the passwords in your EventSentry instance (article is linked at the bottom of this page)