Tools

Unable to log in to WHD after enabling SSO

This article provides the information on how to disable SSO when users are unable to log in to WHD after setting up Single Sign-On (SSO). This is necessary when troubleshooting SSO and would need to update the configuration on Web Help Desk.

First published date

11/8/2018 3:37 PM

Last published date

6/8/2020 6:25 PM

Overview

Users are unable to log in to WHD after setting up Single Sign-On (SSO) and Internet Explorer does not indicate any errors except for a blank page. Other browsers show the ADFS page with an error.
 
  • WHD 12.4 to 12.7
  • Windows 2012
  • MS SQL 2008
  • Linux
  • PostgreSQL

Product section

Web Help Desk

Cause

This issue occurs when SSO is incorrectly configured.

Resolution

For MSSQL :

 

  1. Log in to the MS SQL server.
  2. Open MS SQL Management Studio.
  3. Run the following query: 
    -- 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 PREFERENCE SET EXTERNAL_AUTH_PARAM_TYPE=0;
    
 
  4. Restart WHD using the Start menu shortcuts.

 

For PostgreSQL in Linux Environment:

 

To disable SSO in the database:

 

  1. Login to the PostgreSQL interface 
/usr/local/webhelpdesk/bin/pgsql/usr/pgsql-9.2/bin/psql -h 127.0.0.1 -p 20293 -U whd whd

 
  1. Run the following SQL query
-- 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 PREFERENCE SET EXTERNAL_AUTH_PARAM_TYPE=0; 

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

NOTE: You can also use this URL to bypass the enabled SSO in the WHD http://127.0.0.1:8081/helpdesk/WebObjects/Helpdesk.woa/wa/login?username=admin&password=admin .