You must create two tables in the database for your data source. A SQL script is 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 |
|
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 (One-Time Password; intended to make it more difficult to gain unauthorized access. By constantly altering the password, as is done with a one-time password, this risk can be greatly reduced)) password type. 0 = standard FTP password, 1=MD4 OTP, 2=MD5 OTP. |
|
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. |