Creating Tables for Your ODBC Data Source
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.
Field Name |
Data Type |
Field Size |
Description |
---|---|---|---|
ID (Primary Key) |
AutoNumber |
Long Integer |
User ID |
NAME |
Text |
50 |
Login name for this user |
PASSWORD |
Text |
200 |
Password for this user (Stored in clear text; SHA-256 encrypted, if enabled; or optionally, using MD5.) |
DESCRIPTION |
Text |
200 |
Description for this user |
Number |
Integer |
0=Group, 1=User |
|
PASSWORD_TYPE |
Number |
Integer |
Standard, OTP_MD4, OTP_MD5: Differentiates Regular vs. SKEY (OTP) password type.
|
MD_ITER |
Number |
Long Integer |
Current MDX iteration - used by OTP accounts only |
OTP_SEED |
Text |
16 |
OTP Seed to be used for MDX Passwords - used by OTP accounts only. |
ANONYMOUS |
Number |
Long Integer |
0=Normal Password, 1=Any password |
ANONYMOUS_EMAIL |
Number |
Long Integer |
0=Any anonymous password, 1=email password required |
FULLNAME |
Text |
200 |
User's full name |
|
Text |
200 |
User's email address |
PHONE |
Text |
200 |
User's phone number |
PAGER |
Text |
200 |
User's pager number |
FAX |
Text |
200 |
User's fax number |
COMMENTS |
Text |
200 |
User comments |
ENABLED |
Number |
Integer |
0 = Account disabled 1 = Account enabled -2 = Inherited |
HOMEDIRECTORY |
Text |
512 |
Legacy field no longer used, but must be present in the database. |
SETTINGSLEVEL |
Text |
200 |
Name of user's Settings Template. |
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. |