Remove SSO information for application in AppSelector database

Remove SSO information for application in AppSelector database

Problem:  The admin has created a webPass SSO tile that utilize Stoneware variables or hardcoded credentials.  This tile is showing the webPass key image indicating the user needs to set credentials, due to an existing webStore application that uses the same URL.


Database Connection object for the AppSelector database:

Connection Name: webNetworkAppselectorDB
Description: webNetwork Appselector Database
Database Type: Customized
Class Name: org.hsqldb.jdbcDriver
Connection String: jdbc:hsqldb:c:\stoneware\hsql\appselector
Record Fetch Size: leave default
Report Server: leave default
Report Editors: webNetworkAdminGroup

Solution:  Manually remove the SSO information from the AppSelector database that houses the webStore application information.

The following steps must be performed on each UW loader that you have in your system.  Each loader has it's own copy of the AppSelector database that is used by the webStore.
  1. Open Report Builder.
  2. Switch to Query Builder Mode.
  3. Select the webNetwork AppSelector database connection.
    Username: SA Password: (leave blank)
  4. Click the iSQL prompt button.

  5. Run the following SQL commands in the prompt:
    Enter select * from ssoform  and click the Execute button.
    (This will list all of the application names defined in the SSO database.)

  6. Scroll though the SSOID column for the ssoid of the application you want to disable.  To simplify the searching process, use Firefox and it's Find feature (Ctrl-F) to search for the possible application ssoid.

  7. Enter the following commands one at a time, clicking the Execute button to run them:
    delete from ssoform where ssoid = '<stringvalue>'
    delete from ssoinput where ssoid = '<stringvalue>'
    delete from ssoalturl where ssoid = '<stringvalue>'

    It is suggested to paste them in one at a time, and run them, just to make sure each one runs without error.

Once the definition is gone, when a user authenticates, they will no longer see any of they key indicators on the tile.  SSO should then function using the saved SSO form.

Note:  These steps must be followed after each update applied to UW, as the update will reset the database back to its default contents.

    • Related Articles

    • Database Pooling

      Issue The way UW connects to a Database to run queries, it uses a single connection for each DB object created.  Thus if you have multiple queries that are run against that connection, they are processed in order, one at a time.  A very long query ...
    • SSO methods explained

      Rundown of SSO Methods: Server Side webPass SSO - This is only available for Virtual web Applications. Uses webPass SSO engine / wizard to build an SSO form which is passed by modifying the form information as it passes through the webNetwork ...
    • Debug Client Side SSO

      The default action is : document.forms[0].submit(); A way to debug is to add an Alert : alert( ’form triggered’ ); document.forms[0].submit(); ---------------------------- If inputs are in script we don’t see them when the page comes through the ...
    • LanSchool Reporting Server Database

      The LanSchool Report Server database is a standard SQLite database. It is stored at C:\Program Files (x86)\LanSchool Report Server\reportserver.sqlite. You can use any standard SQLite client to view the database. For example, DB Browser for SQLite ...
    • Troubleshoot webPass SSO

      Issue Applications setup for webPass are no longer submitting credentials.  How do I go about troubleshooting? Solution Verify the Extension is installed in the browser and active. You should see the webPass "key" button on the browser's toolbar. ...
    • Popular Articles

    • Old Browser Versions

      Question: I am using an older browser version and am having problems. What can be done ? We are not able to upgrade the browser at this time.   This is a challenge for any company that makes software that utilizes a browser. Since Stoneware does not ...
    • LCS Redirection

      Problem: How to redirect the LCS in an environment with multiple LCSs and students connecting to them. Solution(s): Create an allow.cfg on all LCS(s) (including the Master) in the network, however, even if no allow.cfg is present on an LCS, machines ...
    • Time windows allows for Service Shutdown

      Issue: Can the time windows gives a service to shut down before it kills the service be increased? Solution: Yes, the following information comes from the Microsoft URL : To specify the wait time, do the ...
    • How to disable password saving - Internet Explorer

      Having multiple methods for saving a password in the browser can cause confusion for the user.   To disable password saving in Internet Explorer, launch Internet Explorer and perform the following steps. Click the blue Settings menu icon in the upper ...
    • How to disable password saving - Chrome

      Having multiple methods for saving a password in the browser can cause confusion for the user.  To disable password saving in Chrome, launch Chrome and perform the following steps. Click the Chrome menu button in the upper right corner of the Chrome ...
    • Recent Articles

    • SAML Service Provider

      Issue How can I use a 3rd Party service (such as ADFS, Office365, or OneLogin) to SSO into UW? Solution The SAML Service Provider (SP) features allows another Identity Provider (IDP) to single sign-on into Unified Workspace using SAML for a seamless ...
    • Lenovo Unified Workspace Released

      Highlights of Unified Workspace Before you install: Please view the installation notes here. Requires new 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace New Profile Style New Login ...
    • How to fix customized login and profile after upgrading to v7.0

      With the release of 7.0 the default login page has been modified to simplify the customization process.  If you are having an issue with the login page not displaying, after upgrading to v7.0, you will need to delete the custom CSS code and start ...
    • SAML SP - Sync Directory Password

      Login script to prompt for directory password Since the user does not login into Unified Workspace with a password, we cannot capture the password to use in the @@password@@ variable.  If you would like to use the Active Directory password for other ...
    • MySQL 8 SSL

      Issue Admin is making a database connection to a MySQL 8 database.  When clicking the Ping button on the DB Connection object, the following error is presented: WARN: Establishing SSL connection without server's identity verification is not ...