cancel
Showing results for 
Search instead for 
Did you mean: 

The user database is missing, inaccessible, or corrupt

Issue

When attempting to log into the Foxtrot Administrator, you receive an error message that the user database is missing, inaccessible, or corrupt.
This is a article attached imageThis is a article attached image

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 table needed to obtain the login information; thus causing the error message.

 

Resolution

 

Option 1:

 

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 intallations 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
  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
This is a article attached imageThis is a article attached image
 

Option 2:

 

It is possible one or more of these files are corrupted. To determine which one, you will need to rename the following file FTSessionControl to FTSessionControl_old, which sets (Security Path, Global Defaults Path, and Activity Log Path) back to default. You can find this file here:

 

C:\ProgramData\Foxtrot Suite or at the shared location “ UNC Path”

 

Once Foxtrot Admin is opened you can set your license path back to the correct path. To see which file is corrupt you will then need to set the paths for Security Path, Global Defaults Path and Activity Log Path back to the same as the license path. Only set one at a time and save Foxtrot Admin. After you change one path close Foxtrot Admin and try getting back into it. If you can you know that file is not corrupt.

 

In your license path you will find the following files:

 

Security Path: FTConfiguration.mdb
Global Defaults Path: FTGlobals.mdb
Activity Log Path: FTSystem.mdb

 

Once you find out the path that stops you from accessing Foxtrot admin you will then know the corrupt file. You can rename/replace the corrupt file from a backup or if you do not have a backup file you can rename the file like you did earlier to the FTSessionControl file and Foxtrot will recreate the file.

 

Labels: (1)
Version history
Revision #:
23 of 23
Last update:
‎11-05-2020 08:52 AM
Updated by:
 
Contributors