Articles in this section

Error - The user database is missing, inaccessible, or corrupt

Avatar
Mathias Balsløw
Updated
Follow

Foxtrot-logo-Automated-Employee-300x113.png

When attempting to log into the Foxtrot Administrator, you receive an error message that the user database is missing, inaccessible, or corrupt.

sa_2.png

Reasons for receiving this error message can include:
  1. The license path previously defined in the Foxtrot Administrator has changed, is misspelled, or does not exist
  2. The user does not have the appropriate permissions to the license path previously defined in the Foxtrot Administrator
  3. The user does not have the appropriate permissions to the Foxtrot Suite folder
  4. The user has the proper permissions to the Foxtrot Suite folder, but may not have the required permissions to the FTConfiguration.mdb file (located in the Foxtrot Suite directory)
Commonly, this will occur after reconfiguring the “Security Path”, which is the location of the FTConfiguration.mdb file, containing login information. After closing the Foxtrot Administrator, then attempting to login again, if one of the four permissions above are not properly configured, Foxtrot cannot access the tables needed to obtain the login information; thus causing the error message.

Resolution

Depending on the version of Foxtrot installed and the operating system, you will need to verify permissions in the following directories and their files created by Foxtrot. The user should have read, write, and modify permissions to the paths and files that apply below:
 
1. Locate the FTSessionControl.cfg file, which in standard installations will be in “C:\ProgramData\Foxtrot Suite”
 
2. Open the “FTSessionControl.cfg” file using Notepad, and locate the entries:
  • “UsersPath”= user directory
  • “MessageLogPath” = message directory
  • “MachinePath”= machine directory
  • “Server= server directory”

3. Inspect for possible spelling errors. This is the default values (of course, if you have customized your setup, the values will be different):

FTSession.png

4. Verify that you have read, write, and modify permissions to the paths above – you should be able to navigate to them manually.
  • Copy the paths and paste them into the Windows file browser, one by one.
  • If any warnings or error messages are displayed, make adjustments as necessary.
  • Verify your permissions in each path. An easy way to do this is to right click in the folder and create a New “Text Document”. If you can create, rename, and delete the file your permissions are set correctly.
5. Locate the FTConfiguration.mdb file and view the file properties, by right-clicking and selecting properties. Select the Security tab, and verify that the file has read, write, and modify permissions.
 
To set the folder permissions:
  • Navigate out to the correct path (above) and right click on the folder
  • Select Properties
  • Select the Security Tab
  • Set the users' group permissions to read, write and modify

User-Permissions.png

Comments

0 comments

Please sign in to leave a comment.