You must create two tables in the database for your data source. Scripts are provided that will create the necessary tables.
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 |
|
TYPE |
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=e-mail password required |
|
FULLNAME |
Text |
200 |
User's full name |
|
|
Text |
200 |
User's e-mail 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 |
|
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 (where ftpserver_ids.User_ID = ftpserver_users.ID) ftpserver_users record 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 (where ftpserver_ids.Group_ID = ftpserver_users.ID) ftpserver_users record must exist with Type = 0. |