Creating Tables for Your ODBC Data Source
When upgrading from 7.4.x to 8.0.x, the ODBC schema has changed. If you are using ODBC as the authentication database, then you will need to consult with Globalscape Support so we can assist with the manual process necessary to get EFT updated and running.
The ODBC authentication database needs to have TLS 1.0, 1.1 enabled for connection to complete. These are disabled by default in v8.0.4 and later.
You must create two tables in the database for your data source. Scripts are provided that will create the necessary tables.
If users receive an error saying they are not logged in, make sure the "anonymous" row in the "ftpserver_users" table is set to "0" or "1"; it cannot be set to "Null".
The ftpserver_users table lists the user accounts and permissions groups in the Site. A user account uses the information from all fields. A permission group uses only the ID, Name, and Description fields and is used only for organizational purposes, not as a user login.
The ftpserver_ids organizes users into "groups" of permission levels. For each permission Group to which a user belongs there should be one entry in the table below.
Field Name |
Data Type |
Field Size |
Description |
---|---|---|---|
ID |
AutoNumber |
Long Integer |
Unique ID for the record (key field). |
USER_ID |
Number |
Long Integer |
This value refers to a user record in the ftpserver_users table. A corresponding ftpserver_users record (where ftpserver_ids.User_ID = ftpserver_users.ID) must exist with Type = 1. |
Group_ID |
Number |
Long Integer |
This value refers to the Settings Template to which the User_ID user record belongs. A corresponding ftpserver_users record (where ftpserver_ids.Group_ID = ftpserver_users.ID) must exist with Type = 0. |