这个示例讲演示如何使用以上软件构架一个能够在线注册用户的FTP服务器.
软件环境列表
1.Microsoft Visual Studio .NET 2003
2.Microsoft SQL Server
3.Serv-U FTP Server
这个示例讲演示如何使用以上软件构架一个能够在线注册用户的FTP服务器.
软件环境列表
1.Microsoft Visual Studio .NET 2003
2.Microsoft SQL Server
3.Serv-U FTP Server
在进行操作以前请将IIS6.0的FTP服务停止。
首先使用在SQL中建立相关的SQL数据表。这里使用SQL数据查询器创建。SQL脚本如下:
![](/Images/OutliningIndicators/ContractedBlock.gif)
SQL CODE
1
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_groupAccess') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
2
DROP TABLE dbo.ftp_groupAccess
3
GO
4![](/Images/OutliningIndicators/None.gif)
5
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_groupIPs') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
6
DROP TABLE dbo.ftp_groupIPs
7
GO
8![](/Images/OutliningIndicators/None.gif)
9
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_groups') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
10
DROP TABLE dbo.ftp_groups
11
GO
12![](/Images/OutliningIndicators/None.gif)
13
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_userAccess') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
14
DROP TABLE dbo.ftp_userAccess
15
GO
16![](/Images/OutliningIndicators/None.gif)
17
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_userIPs') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
18
DROP TABLE dbo.ftp_userIPs
19
GO
20![](/Images/OutliningIndicators/None.gif)
21
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('dbo.ftp_users') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
22
DROP TABLE dbo.ftp_users
23
GO
24![](/Images/OutliningIndicators/None.gif)
25
CREATE TABLE dbo.ftp_groupAccess (
26
indexNo smallint NOT NULL,
27
ftpUserName varchar (50) NOT NULL,
28
accessRule varchar (200) NOT NULL
29
)
30
GO
31![](/Images/OutliningIndicators/None.gif)
32
CREATE TABLE dbo.ftp_groupIPs (
33
indexNo smallint NOT NULL,
34
ftpUserName varchar (50) NOT NULL,
35
accessRule varchar (80) NOT NULL
36
)
37
GO
38![](/Images/OutliningIndicators/None.gif)
39
CREATE TABLE dbo.ftp_groups (
40
id int IDENTITY (1, 1) NOT NULL,
41
ftpUserName varchar (50) NOT NULL,
42
accessRule varchar (200) NULL,
43
notes varchar (255) NULL
44
)
45
GO
46![](/Images/OutliningIndicators/None.gif)
47
CREATE TABLE dbo.ftp_userAccess (
48
indexNo smallint NOT NULL,
49
ftpUserName varchar (50) NOT NULL,
50
accessRule varchar (200) NOT NULL
51
)
52
GO
53![](/Images/OutliningIndicators/None.gif)
54
CREATE TABLE dbo.ftp_userIPs (
55
indexNo smallint NOT NULL,
56
ftpUserName varchar (50) NOT NULL,
57
accessRule varchar (80) NOT NULL
58
)
59
GO
60![](/Images/OutliningIndicators/None.gif)
61
CREATE TABLE dbo.ftp_users (
62
id int IDENTITY (1, 1) NOT NULL,
63
ftpUserName varchar (50) NOT NULL,
64
ftpPassword varchar (50) NOT NULL,
65
ftpPasswordType tinyint NULL,
66
changePassword bit NOT NULL,
67
sKey varchar (50) NOT NULL,
68
accessRule varchar (200) NULL,
69
dirHome varchar (200) NOT NULL,
70
privilege tinyint NULL,
71
loginMsgFile varchar (80) NULL,
72
disabled bit NOT NULL,
73
sessionEncryption bit NOT NULL,
74
dirHomeLock bit NOT NULL,
75
hideHidden bit NOT NULL,
76
alwaysAllowLogin bit NOT NULL,
77
maxUsersConcurrent smallint NOT NULL,
78
speedLimitUp int NULL,
79
speedLimitDown int NULL,
80
maxUsersLoginPerIP smallint NOT NULL,
81
timeOutIdle int NULL,
82
timeOutSession int NULL,
83
quotaEnable bit NOT NULL,
84
quotaCurrent bigint NULL,
85
quotaMax bigint NULL,
86
ratioType tinyint NULL,
87
ratioUp smallint NULL,
88
ratioDown smallint NULL,
89
ratioCredit float NULL,
90
expiration smalldatetime NULL,
91
groups varchar (80) NULL,
92
notes varchar (255) NOT NULL
93
)
94
GO
95![](/Images/OutliningIndicators/None.gif)
96
ALTER TABLE dbo.ftp_groups WITH NOCHECK ADD CONSTRAINT pk_ftp_groups PRIMARY KEY CLUSTERED (id)
97
GO
98![](/Images/OutliningIndicators/None.gif)
99
ALTER TABLE dbo.ftp_users WITH NOCHECK ADD CONSTRAINT pk_ftp_users PRIMARY KEY CLUSTERED (id)
100
GO
101![](/Images/OutliningIndicators/None.gif)
102
ALTER TABLE dbo.ftp_groupAccess ADD CONSTRAINT df_ftp_groupAccess_indexNo DEFAULT (2) FOR indexNo
103
GO
104![](/Images/OutliningIndicators/None.gif)
105
CREATE INDEX ix_ftp_groupAccess__ftpUserName ON dbo.ftp_groupAccess(ftpUserName, indexNo)
106
GO
107![](/Images/OutliningIndicators/None.gif)
108
ALTER TABLE dbo.ftp_groupIPs ADD CONSTRAINT df_ftp_groupIPs_indexNo DEFAULT (2) FOR indexNo
109
GO
110![](/Images/OutliningIndicators/None.gif)
111
CREATE INDEX ix_ftp_groupIPs__ftpUserName ON dbo.ftp_groupIPs(ftpUserName, indexNo)
112
GO
113![](/Images/OutliningIndicators/None.gif)
114
CREATE UNIQUE INDEX ix_ftp_groups__ftpUserName ON dbo.ftp_groups(ftpUserName)
115
GO
116![](/Images/OutliningIndicators/None.gif)
117
ALTER TABLE dbo.ftp_userAccess ADD CONSTRAINT df_ftp_userAccess_indexNo DEFAULT (2) FOR indexNo
118
GO
119![](/Images/OutliningIndicators/None.gif)
120
CREATE INDEX ix_ftp_userAccess__ftpUserName ON dbo.ftp_userAccess(ftpUserName, indexNo)
121
GO
122![](/Images/OutliningIndicators/None.gif)
123
ALTER TABLE dbo.ftp_userIPs ADD CONSTRAINT df_ftp_userIPs_indexNo DEFAULT (2) FOR indexNo
124
GO
125![](/Images/OutliningIndicators/None.gif)
126
CREATE INDEX ix_ftp_userIPs__ftpUserName ON dbo.ftp_userIPs(ftpUserName, indexNo)
127
GO
128![](/Images/OutliningIndicators/None.gif)
129
ALTER TABLE dbo.ftp_users ADD
130
CONSTRAINT df_ftp_users_changePassword DEFAULT (1) FOR changePassword,
131
CONSTRAINT df_ftp_users_sKey DEFAULT ('') FOR sKey,
132
CONSTRAINT df_ftp_users_disabled DEFAULT (0) FOR disabled,
133
CONSTRAINT df_ftp_users_sessionEncryption DEFAULT (0) FOR sessionEncryption,
134
CONSTRAINT df_ftp_users_dirHome DEFAULT ('') FOR dirHome,
135
CONSTRAINT df_ftp_users_dirHomeLock DEFAULT (1) FOR dirHomeLock,
136
CONSTRAINT df_ftp_users_hideHidden DEFAULT (1) FOR hideHidden,
137
CONSTRAINT df_ftp_users_alwaysAllowLogin DEFAULT (0) FOR alwaysAllowLogin,
138
CONSTRAINT df_ftp_users_maxUsersConcurrent DEFAULT (10) FOR maxUsersConcurrent,
139
CONSTRAINT df_ftp_users_speedLimitUp DEFAULT ((-1)) FOR speedLimitUp,
140
CONSTRAINT df_ftp_users_speedLimitDown DEFAULT ((-1)) FOR speedLimitDown,
141
CONSTRAINT df_ftp_users_maxUsersLoginPerIP DEFAULT (5) FOR maxUsersLoginPerIP,
142
CONSTRAINT df_ftp_users_timeOutSession DEFAULT ((-1)) FOR timeOutSession,
143
CONSTRAINT df_ftp_users_quotaEnable DEFAULT (1) FOR quotaEnable,
144
CONSTRAINT df_ftp_users_quotaCurrent DEFAULT (0) FOR quotaCurrent,
145
CONSTRAINT df_ftp_users_quotaMax DEFAULT (52428800) FOR quotaMax,
146
CONSTRAINT df_ftp_users_notes DEFAULT ('') FOR notes
147
GO
148![](/Images/OutliningIndicators/None.gif)
149
CREATE UNIQUE INDEX ix_ftp_users__ftpUserName ON dbo.ftp_users(ftpUserName)
150
GO
以上就是SQL脚本了。
然后在系统中创建相关的ODBC。这里我创建的ODBC为FTPSQL。
修改SERV-U的ServUDaemon.ini文件。需要修改的内容如下。
ODBCTables=ftp_users|ftp_groups|ftp_userAccess|ftp_groupAccess|ftp_userIPs|
ftp_groupIPs
ODBCColumns=ftpUserName|ftpPassword|sKey|dirHome|loginMsgFile|accessRule|
disabled|sessionEncryption|dirHomeLock|hideHidden|alwaysAllowLogin|
changePassword|quotaEnable|maxUsersLoginPerIP|speedLimitUp|speedLimitDown|
maxUsersConcurrent|timeOutIdle|timeOutSession|ratioUp|ratioDown|ratioCredit|
quotaCurrent|quotaMax|expiration|privilege|ftpPasswordType|ratioType|
groups|notes|indexNo
保存之后在重启服务器就可以了。