Unlock and reset a WHD Tech account

11/8/2018 4:20 PM

4/6/2022 8:52 AM

There are two ways to login into the Web Help Desk: 

1. A local account
2. Linked client using their AD/LDAP connection

If you attempt to log in multiple times or your account is deactivated, you can reset your local password from the database.

Web Help Desk

Login multiple attempts.

Perform the following steps to manually unlock a Tech account in a PostgreSQL database:
 

1. Stop Web Help Desk Service
2. Browse to:
   ...\WebHelpDesk\pgsql9\bin
3. Run pgAdmin3. 
4. In the pgAdmin III window, go to File > Add Server
5. Add the following:
   • Name: WHDDB
   • Host: localhost (or the IP Address)
   • Port: 20293
   • Maintenance DB: postgres
   • Username: whd
   • Password: whd
6. Click OK.
7. Expand Databases.
   You should see the whd database.
8. Select WHD database and click on SQL.
   You should now have the SQL Query window to type your queries.
9. Unlock or reset the Tech account through your Web Help Desk database by executing the following statements:

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   ========================================================================
   
   UPDATE TECH
   SET USE_LDAP_AUTHENTICATION=0,
   INCORRECT_AUTH_ATTEMPTS=0,
   INACTIVE = 0,
   PASSWORD='admin'
   WHERE USER_NAME='<Enter_TechUserName_Here>';

10. Save your changes.
11. Start Web Help Desk
12. Log in to Web Help Desk using the account credentials.

NOTE: If Web Help Desk Database already exist, no need to add another one.

 

Disclaimer:

Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.