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 User Setting Level. |
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 User Setting Level that the User_ID user record belongs to. A corresponding (where ftpserver_ids.Group_ID == ftpserver_users.ID) ftpserver_users record must exist with Type = 0. |