用程序來自動建立FTP帳號（serv-u的odbc設置）

2024-07-21 02:21:22

字體：大中小

來源：轉載

供稿：網友

步驟：
1、建立數據庫（可以用任何數據庫sql server，access均可）
2、建立dns
3、安裝serv-u
4、建立域
5、完成了。呵呵~！
serv-u build 6.0.0.1版本

★ serv-u ftp server 6.0.0.1 final

非常好的ftp服務器軟件，它設置簡單，功能強大，性能穩定。
你現在就可以建立你自己的ftp服務器了。

漢化說明：

1、請先安裝原英文軟件。
2、退出 ftp serv-u 應用程序！包括系統欄圖標！
3、解壓縮后運行漢化包，填入你的安裝目錄進行漢化。
4、漢化包中另帶有企業版的破解補丁:
serv-u6001cr.exe，如需要，大家可自行破解，破解前請中
止系統中的servudaemon.exe進程，或中止serv-u 的服務。
然后將破解文件復制到 serv-u 安裝目錄進行破解。破解后
為永不過期的“企業版”，如果用了以前的破解版本，可能
會報告說你盜用了注冊碼，這時請在“本地服務器--許可”
中選擇“刪除密鑰”即可。
5、有些原英文版用戶漢化后可能會導致設置丟失，這可能是由
于漢化的資源與英文版不同所致，只能請大家重新設置一下
了。以前即用漢化版則無此問題。
6、如果以前使用過我的漢化補丁，請將原目錄下舊的“漢化說
明.txt”文件刪除后再使用新的漢化補丁。

建立數據庫的sql：

/****** object: database host script date: 2004-12-24 13:16:31 ******/
if exists (select name from master.dbo.sysdatabases where name = n'host')
drop database [host]
go

create database [host] on (name = n'host_data', filename = n'd:/wwwroot/host/database/host.mdf' , size = 2, filegrowth = 10%) log on (name = n'host_log', filename = n'd:/wwwroot/host/database/host_log.ldf' , size = 9, filegrowth = 10%)
collate chinese_prc_ci_as
go

exec sp_dboption n'host', n'autoclose', n'false'
go

exec sp_dboption n'host', n'bulkcopy', n'false'
go

exec sp_dboption n'host', n'trunc. log', n'false'
go

exec sp_dboption n'host', n'torn page detection', n'true'
go

exec sp_dboption n'host', n'read only', n'false'
go

exec sp_dboption n'host', n'dbo use', n'false'
go

exec sp_dboption n'host', n'single', n'false'
go

exec sp_dboption n'host', n'autoshrink', n'false'
go

exec sp_dboption n'host', n'ansi null default', n'false'
go

exec sp_dboption n'host', n'recursive triggers', n'false'
go

exec sp_dboption n'host', n'ansi nulls', n'false'
go

exec sp_dboption n'host', n'concat null yields null', n'false'
go

exec sp_dboption n'host', n'cursor close on commit', n'false'
go

exec sp_dboption n'host', n'default to local cursor', n'false'
go

exec sp_dboption n'host', n'quoted identifier', n'false'
go

exec sp_dboption n'host', n'ansi warnings', n'false'
go

exec sp_dboption n'host', n'auto create statistics', n'true'
go

exec sp_dboption n'host', n'auto update statistics', n'true'
go

use [host]
go

/****** object: table [dbo].[groupaccess] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[groupaccess]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[groupaccess]
go

/****** object: table [dbo].[groupaccounts] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[groupaccounts]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[groupaccounts]
go

/****** object: table [dbo].[groupipaccess] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[groupipaccess]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[groupipaccess]
go

/****** object: table [dbo].[useraccess] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[useraccess]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[useraccess]
go

/****** object: table [dbo].[useraccounts] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[useraccounts]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[useraccounts]
go

/****** object: table [dbo].[useripaccess] script date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[useripaccess]') and objectproperty(id, n'isusertable') = 1)
drop table [dbo].[useripaccess]
go

/****** object: table [dbo].[groupaccess] script date: 2004-12-24 13:16:34 ******/
create table [dbo].[groupaccess] (
[indexno] [int] null ,
[username] [nvarchar] (50) collate chinese_prc_ci_as null ,
[access] [nvarchar] (200) collate chinese_prc_ci_as null ,
[gaid] [int] identity (1, 1) not null
) on [primary]
go

/****** object: table [dbo].[groupaccounts] script date: 2004-12-24 13:16:36 ******/
create table [dbo].[groupaccounts] (
[username] [nvarchar] (50) collate chinese_prc_ci_as null ,
[access] [nvarchar] (200) collate chinese_prc_ci_as null ,
[notes] [nvarchar] (200) collate chinese_prc_ci_as null ,
[gasid] [int] identity (1, 1) not null
) on [primary]
go

/****** object: table [dbo].[groupipaccess] script date: 2004-12-24 13:16:36 ******/
create table [dbo].[groupipaccess] (
[indexno] [int] null ,
[username] [nvarchar] (50) collate chinese_prc_ci_as null ,
[access] [nvarchar] (200) collate chinese_prc_ci_as null ,
[gipaid] [int] identity (1, 1) not null
) on [primary]
go

/****** object: table [dbo].[useraccess] script date: 2004-12-24 13:16:37 ******/
create table [dbo].[useraccess] (
[indexno] [int] null ,
[username] [nvarchar] (50) collate chinese_prc_ci_as null ,
[access] [nvarchar] (200) collate chinese_prc_ci_as null ,
[uaid] [int] identity (1, 1) not null
) on [primary]
go

/****** object: table [dbo].[useraccounts] script date: 2004-12-24 13:16:37 ******/
create table [dbo].[useraccounts] (
[id] [int] identity (1, 1) not null ,
[username] [nvarchar] (50) collate chinese_prc_ci_as not null ,
[password] [nvarchar] (50) collate chinese_prc_ci_as null ,
[disable] [bit] not null ,
[access] [nvarchar] (255) collate chinese_prc_ci_as null ,
[changepass] [bit] not null ,
[passtype] [tinyint] not null ,
[expiration] [smalldatetime] not null ,
[expirationtype] [tinyint] not null ,
[skey] [nvarchar] (50) collate chinese_prc_ci_as null ,
[relpaths] [bit] not null ,
[homedir] [nvarchar] (255) collate chinese_prc_ci_as null ,
[messagefile] [nvarchar] (255) collate chinese_prc_ci_as null ,
[maxusers] [int] not null ,
[maxup] [int] not null ,
[maxdown] [int] not null ,
[ratioup] [int] null ,
[ratiodown] [int] null ,
[ratiocredit] [float] null ,
[ratiotype] [tinyint] null ,
[quotaenable] [bit] not null ,
[quotamax] [int] not null ,
[quotacurrent] [int] not null ,
[groups] [nvarchar] (255) collate chinese_prc_ci_as null ,
[privilege] [tinyint] not null ,
[lockhomedir] [bit] not null
) on [primary]
go

/****** object: table [dbo].[useripaccess] script date: 2004-12-24 13:16:38 ******/
create table [dbo].[useripaccess] (
[indexno] [smallint] null ,
[username] [nvarchar] (50) collate chinese_prc_ci_as null ,
[access] [nvarchar] (200) collate chinese_prc_ci_as null ,
[uipaid] [int] identity (1, 1) not null
) on [primary]
go

alter table [dbo].[groupaccess] with nocheck add
constraint [pk_groupaccess] primary key clustered
(
[gaid]
) on [primary]
go

alter table [dbo].[groupaccounts] with nocheck add
constraint [pk_groupaccounts] primary key clustered
(
[gasid]
) on [primary]
go

alter table [dbo].[groupipaccess] with nocheck add
constraint [pk_groupipaccess] primary key clustered
(
[gipaid]
) on [primary]
go

alter table [dbo].[useraccess] with nocheck add
constraint [pk_useraccess] primary key clustered
(
[uaid]
) on [primary]
go

alter table [dbo].[useraccounts] with nocheck add
constraint [pk_useraccounts] primary key clustered
(
[id]
) on [primary]
go

alter table [dbo].[useripaccess] with nocheck add
constraint [pk_useripaccess] primary key clustered
(
[uipaid]
) on [primary]
go

alter table [dbo].[useraccounts] with nocheck add
constraint [df_useraccounts_disable] default (0) for [disable],
constraint [df_useraccounts_changepass] default (1) for [changepass],
constraint [df_useraccounts_passtype] default (0) for [passtype],
constraint [df_useraccounts_expirationtype] default (1) for [expirationtype],
constraint [df_useraccounts_relpaths] default (0) for [relpaths],
constraint [df_useraccounts_maxusers] default ((-1)) for [maxusers],
constraint [df_useraccounts_maxup] default (0) for [maxup],
constraint [df_useraccounts_maxdown] default (0) for [maxdown],
constraint [df_useraccounts_ratioup] default (1) for [ratioup],
constraint [df_useraccounts_ratiodown] default (1) for [ratiodown],
constraint [df_useraccounts_ratiocredit] default (0) for [ratiocredit],
constraint [df_useraccounts_ratiotype] default (0) for [ratiotype],
constraint [df_useraccounts_quotaenable] default (1) for [quotaenable],
constraint [df_useraccounts_quotamax] default (0) for [quotamax],
constraint [df_useraccounts_quotacurrent] default (0) for [quotacurrent],
constraint [df_useraccounts_privilege] default (0) for [privilege],
constraint [df_useraccounts_lockhomedir] default (1) for [lockhomedir],
constraint [ix_useraccounts] unique nonclustered
(
[username]
) on [primary]
go

exec sp_addextendedproperty n'ms_description', n'目錄權限', n'user', n'dbo', n'table', n'useraccounts', n'column', n'access'
go
exec sp_addextendedproperty n'ms_description', n'是否允許更改密碼', n'user', n'dbo', n'table', n'useraccounts', n'column', n'changepass'
go
exec sp_addextendedproperty n'ms_description', n'帳號是否禁用', n'user', n'dbo', n'table', n'useraccounts', n'column', n'disable'
go
exec sp_addextendedproperty n'ms_description', n'過期時間', n'user', n'dbo', n'table', n'useraccounts', n'column', n'expiration'
go
exec sp_addextendedproperty n'ms_description', n'過期類型', n'user', n'dbo', n'table', n'useraccounts', n'column', n'expirationtype'
go
exec sp_addextendedproperty n'ms_description', n'用戶組', n'user', n'dbo', n'table', n'useraccounts', n'column', n'groups'
go
exec sp_addextendedproperty n'ms_description', n'主目錄', n'user', n'dbo', n'table', n'useraccounts', n'column', n'homedir'
go
exec sp_addextendedproperty n'ms_description', n'是否鎖定在主目錄', n'user', n'dbo', n'table', n'useraccounts', n'column', n'lockhomedir'
go
exec sp_addextendedproperty n'ms_description', n'最大下載速率', n'user', n'dbo', n'table', n'useraccounts', n'column', n'maxdown'
go
exec sp_addextendedproperty n'ms_description', n'最大上傳速率', n'user', n'dbo', n'table', n'useraccounts', n'column', n'maxup'
go
exec sp_addextendedproperty n'ms_description', n'最大登陸用戶數', n'user', n'dbo', n'table', n'useraccounts', n'column', n'maxusers'
go
exec sp_addextendedproperty n'ms_description', n'消息文件', n'user', n'dbo', n'table', n'useraccounts', n'column', n'messagefile'
go
exec sp_addextendedproperty n'ms_description', n'密碼類型', n'user', n'dbo', n'table', n'useraccounts', n'column', n'passtype'
go
exec sp_addextendedproperty n'ms_description', n'密碼', n'user', n'dbo', n'table', n'useraccounts', n'column', n'password'
go
exec sp_addextendedproperty n'ms_description', n'管理權限', n'user', n'dbo', n'table', n'useraccounts', n'column', n'privilege'
go
exec sp_addextendedproperty n'ms_description', n'當前配額', n'user', n'dbo', n'table', n'useraccounts', n'column', n'quotacurrent'
go
exec sp_addextendedproperty n'ms_description', n'啟用磁盤配額', n'user', n'dbo', n'table', n'useraccounts', n'column', n'quotaenable'
go
exec sp_addextendedproperty n'ms_description', n'最大配額', n'user', n'dbo', n'table', n'useraccounts', n'column', n'quotamax'
go
exec sp_addextendedproperty n'ms_description', n'下載比率', n'user', n'dbo', n'table', n'useraccounts', n'column', n'ratiodown'
go
exec sp_addextendedproperty n'ms_description', n'上傳比率', n'user', n'dbo', n'table', n'useraccounts', n'column', n'ratioup'
go
exec sp_addextendedproperty n'ms_description', n'用戶名', n'user', n'dbo', n'table', n'useraccounts', n'column', n'username'

go

ftp.cs代碼：

using system;
using system.web.security;
using system.configuration;
using system.data;
using system.data.sqlclient;

namespace host
{
/// <summary>
/// ftp 的摘要說明。
/// </summary>
public class ftp
{
private sqlconnection conhost;

public string username;//用戶名
public string password;//密碼
public bool disable;//禁用帳號 true：禁用帳號 false：啟用帳號
public string access;//目錄/ip訪問規則
public byte passtype;//密碼類型 0：規則密碼 1：otp s/key md4 2：otp s/key md5
public bool changepass;//允許修改密碼 true：允許 false：禁止
public datetime expiration;//過期時間
public byte expirationtype;//過期類型 1：刪除 2：禁用
public string skey;
public bool relpaths;//需要安全連接 true：需要 false：不需要
public string homedir;//主目錄
public string messagefile;//消息文件
public int maxusers;//最大用戶數
public int maxup;//最大上傳速率
public int maxdown;//最大下載速率
public byte ratiotype;//比率類型
public int ratioup;//上傳率
public int ratiodown;//下載率
public float ratiocredit;//比率信任
public bool quotaenable;//允許配額 true：允許 false：禁止
public int quotamax;//最大配額
public int quotacurrent;//當前配額
public string groups;//用戶組
public byte privilege;//管理權限 0：沒有權限 1：系統管理員 2：組管理員 3：域管理員 4：只讀管理員
public bool lockhomedir;//鎖定于主目錄 true：鎖定 false：不鎖定

public ftp()
{
//
// tod 在此處添加構造函數邏輯
//
username = "guest";
password = "guest";
disable = false;
access = "";
passtype = 0;
changepass = true;
expiration = datetime.now.date;
expirationtype = 1;
skey = "";
relpaths = false;
homedir = "";
messagefile = "";
maxusers = 1;
maxup = 100 * 1024;//100k
maxdown = 100 * 1024;//100k
ratiotype = 0;
ratioup = 1;
ratiodown = 1;
ratiocredit = 0;
quotaenable = true;
quotamax = 10 * 1024 * 1024;//10m
quotacurrent = 0;
groups = "";
privilege = 0;
lockhomedir = true;

conhost = new sqlconnection( configurationsettings.appsettings["constring"] );
conhost.open();
}

~ftp()
{
conhost.close();
}

public void add()
{
//添加帳號
sqlcommand cmdadd = new sqlcommand( "insert into useraccounts (username,password,disable,access,changepass,passtype,expiration,expirationtype,skey,relpaths,homedir,messagefile,maxusers,maxup,maxdown,ratioup,ratiodown,ratiocredit,ratiotype,quotaenable,quotamax,quotacurrent,groups,privilege,lockhomedir) values(@username,@password,@disable,@access,@changepass,@passtype,@expiration,@expirationtype,@skey,@relpaths,@homedir,@messagefile,@maxusers,@maxup,@maxdown,@ratioup,@ratiodown,@ratiocredit,@ratiotype,@quotaenable,@quotamax,@quotacurrent,@groups,@privilege,@lockhomedir)", conhost );

cmdadd.parameters.add( "@username", username );
cmdadd.parameters.add( "@password", pass() );
cmdadd.parameters.add( "@disable", disable );
cmdadd.parameters.add( "@access", access );
cmdadd.parameters.add( "@changepass", changepass );
cmdadd.parameters.add( "@passtype", passtype );
cmdadd.parameters.add( "@expiration", expiration );
cmdadd.parameters.add( "@expirationtype", expirationtype );
cmdadd.parameters.add( "@skey", skey );
cmdadd.parameters.add( "@relpaths", relpaths );
cmdadd.parameters.add( "@homedir", homedir );
cmdadd.parameters.add( "@messagefile", messagefile );
cmdadd.parameters.add( "@maxusers", maxusers );
cmdadd.parameters.add( "@maxup", maxup );
cmdadd.parameters.add( "@maxdown", maxdown );
cmdadd.parameters.add( "@ratioup", ratioup );
cmdadd.parameters.add( "@ratiodown", ratiodown );
cmdadd.parameters.add( "@ratiocredit", ratiocredit );
cmdadd.parameters.add( "@ratiotype", ratiotype );
cmdadd.parameters.add( "@quotaenable", quotaenable );
cmdadd.parameters.add( "@quotamax", quotamax );
cmdadd.parameters.add( "@quotacurrent", quotacurrent );
cmdadd.parameters.add( "@groups", groups );
cmdadd.parameters.add( "@privilege", privilege );
cmdadd.parameters.add( "@lockhomedir", lockhomedir );
//cmdadd.parameters.add( "@", );

cmdadd.executenonquery();
}

public string pass()
{
//密碼加密
random rnm = new random();
char a = (char)(rnm.next( 97, 123 ));
char b = (char)(rnm.next( 97, 123 ));
string password = string.format("{0}{1}{2}", a, b, password );
password = formsauthentication.hashpasswordforstoringinconfigfile( password, "md5" );
password = string.format( "{0}{1}{2}", a, b, password.toupper() );
return password;
}

public bool modifypass( string oldpass, string newpass )
{
//修改密碼
return true;
}
}
}

例子webform1.aspx.cs：

using system;
using system.collections;
using system.componentmodel;
using system.data;
using system.drawing;
using system.web;
using system.web.sessionstate;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.htmlcontrols;
using system.web.security;

namespace host
{
/// <summary>
/// webform1 的摘要說明。
/// </summary>
public class webform1 : system.web.ui.page
{
protected system.web.ui.webcontrols.label label1;

private void page_load(object sender, system.eventargs e)
{
// 在此處放置用戶代碼以初始化頁面
ftp test = new ftp();
test.username = "t";
test.password = "t";
test.access = "d://wwwroot//test|rwamlcdp";
test.homedir = "d://wwwroot//test";
test.groups = "test";
test.add();
label1.text = "成功";
}

#region web 窗體設計器生成的代碼
override protected void oninit(eventargs e)
{
//
// codegen: 該調用是 asp.net web 窗體設計器所必需的。
//
initializecomponent();
base.oninit(e);
}

/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void initializecomponent()
{
this.load += new system.eventhandler(this.page_load);

}
#endregion
}
}
相關圖片：
建立dns：

2、建立域：

3、配制serv-u:

上一篇：幾種調用WebService的方法

下一篇：Web Service隨筆1