Users missing from display

From Swivel Knowledgebase Wiki

Contents 1 Overview 2 Prerequisites 3 Symptoms 4 Solution

Overview

This solution resolves a problem whereby some usernames are missing from the list displayed in User Administration, even though they exist and can authenticate successfully.

Prerequisites

The patch listed below is for PINsafe version 3.7.3474 only. A second release of PINsafe 3.8 will be released shortly that will include the fix.

The problem does not manifest itself when using the Internal database.

Symptoms

The problem described here is that not all existing users are listed in the User Administration screen. This refers to users which should be shown within the body of the list. It does not cover users not being displayed because of the limit on the number of users displayed.

This problem occurs under the following circumstances:

• A database other than Internal (or Shipping) is being used.
• Usernames are stored in the repository with inconsistent case: some names starting with upper case, some with lower case. Typically, it is the lower-case names that are missing.
• There are more users in the repository than will fit on one page.

Solution

The solution for this problem is a patch for PINsafe. Note that this patch is only relevant for version 3.7.3474. Do not use it with any other version. The patch can be found here.

To apply the patch, see the following instructions:

1. Stop Tomcat.
2. Open WinSCP and browse to /usr/local/tomcat/webapps/pinsafe/WEB-INF/classes/com/swiveltechnologies/pinsafe/server/user/database.
3. Take backup copies of all files beginning with AbstractJDBCDatabaseImpl.
4. Unzip the attached files and copy them to this folder, replacing the existing files.
5. Ensure that the owner of these files is "swivel" (it should be, if you replaced the existing files, rather than removed the old ones first).
6. Restart Tomcat.

All users should now be shown in the correct order, with no omissions.