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

Article ID: 227
Category: Database
Applies to: 2.93 and newer
Updated: 2024-09-06

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\EventSentry\data14" folder. If you still use Postgres 9.6 it will be in the "C:\Program Files (x86)\EventSentry\data96" folder or 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 this file before editing if you wish, since after the password reset you will revert this file back to its original configuration.

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

Example:

3B. Restart the "EventSentry Database v 14" service. If you still use Postgres 9.6 or 9.1, instead you will restart the "EventSentry Database v9.6" or the "EventSentry Database" service.

4B. Open pgAdmin by going through the Start Menu -> EventSentry -> pgAdmin4. You can now connect in pgAdmin 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 Database" under the "Servers" category. If you have an older version installed, this may just be named "EventSentry."

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 made a copy of the file you can replace it back.

11B. Restart the "EventSentry Database v 14" service. If you still use Postgres 9.6 or 9.1, instead you will restart the "EventSentry Database v9.6" or 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)




Try EventSentry on-premise

FREE 30-day evaluation

Download Now