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.
Prerequisite:
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.
- Open Report Builder.
- Switch to Query Builder Mode.
- Select the webNetwork AppSelector database connection.
Username: SA Password: (leave blank) - Click the iSQL prompt button.
- 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.) - 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.
- 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.
Can't find the KB
Unable to find the KB to address your issue ?
Recent Articles
Lenovo Unified Workspace End-of-Life Questions and Answers
Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...How do I determine my Unified Workspace license expiration date?
The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...Lenovo Unified Workspace 7.0.2.13 Released
Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...LanSchool Documentation Guides
LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...Lenovo Unified Workspace 7.0.1.41 Released
Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...
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 ...Create a Terminal Server application
How do I set up a terminal server application in webNetwork? If you go to the manual, the link is under your Admin menu. Or you can go to https://customer.lenovosoftware.com/help/index.html Go under Services, Web Applications, Web Application Types, ...How to remove/break clustering.
How to remove Clustering: 1. On Loader 2 Leave the Cluster 1.1. Login to the 8090 Management console 1.2. On the Services tab, right click on Cluster Services and select Properties 1.3. Select the Leave button 1.4. Close the Cluster Services ...