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

TYPE

Number

Integer

0=Group, 1=User

PASSWORD_TYPE

Number

Integer

Standard, OTP_MD4, OTP_MD5: Differentiates Regular vs. SKEY (OTP) password type.

  • 0 = Standard 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=email password required

FULLNAME

Text

200

User's full name

EMAIL

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.