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-06-01

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.

2B. Change the "md5" text at the end of the "local connections" lines for both IPv4 and IPv6 to "trust". Example is pictured below.

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

4B. You can now connect in pgAdmin III (step 1A and 2A) 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. Follow the steps 4A through 6A to select the "postgres" user and reset its password, and close pgAdmin when finished.

6B. IMPORTANT! Be sure to put the "pg.hba.conf" lines back to "md5" instead of "trust"

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

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

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

Reset