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
Change Reset Password Button Text
Change the text of the "Reset Password" button on the UW Login Page How to change the text of the Reset Password button on the Login Page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants ...Remove Reset Password Button From Login Page
Remove the Reset Password Button from the Login Page How to remove the Reset Password button from the Unified Workspace login page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants Expand ...Lenovo Unified Workspace End-of-Life Questions and Answers
As of January 31st 2024, Lenovo Unified Workspace (formerly Stoneware WebNetwork) is no longer supported. This means that we no longer provide licenses, downloads, updates, patches, or technical assistance for this product. If you have any questions ...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 ...
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 ...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. ...How to setup Google SSO without using webStore or SAML
Problem: You do not want to deploy Google Apps SSO with SAML or using webStore tiles. The below solution will show how to manually make SSO definitions, so you can change the default input values to LDAP attributes or allow you to have tiles ...