Serv-U用SQL Server作为存储源的安装说明
来源:互联网 发布:d3.js api 中文 编辑:程序博客网 时间:2024/06/02 04:03
1、运行MSSQL企业管理器,新加数据库ServU,新建SQL登录账号ServU,密码xxxx,指定为数据库的dbowner,指定默认数据库为ServU
2、在企业管理器中选中数据库ServU,进入顶部菜单 工具——查询分析器,将下面"建表SQL语句"后面的所有内容复制到查询分析器中运行
4、创建系统DSN,名称为ServU,指向SQL Server的数据库ServU
5、在Serv-U Administrator里面新建域Simple Domain,使用ODBC存储,在树形菜单中选中Simple Domain,点击右侧控制面板上部的'ODBC'
选项卡,在下面第1、2、3格中分别填入系统DSN的名字、使用的账号、密码,点应用。
6、停止Serv-U服务,到Serv-u安装目录下打开ServUDaemon.ini,将[Domain1]小节下的两行设置"ODBCTables" and "ODBCColumns",替换为
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
7、启动Serv-U服务,OK了
注意:上面所有的名称均可更改;[DomainXX]中的XX应为新建的域对应的数字
建表SQL语句
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_groupAccess') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_groupAccess
GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_groupIPs') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_groupIPs
GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_groups') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_groups
GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_userAccess') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_userAccess
GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_userIPs') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_userIPs
GOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =
object_id('dbo.ftp_users') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE dbo.ftp_users
GOCREATE TABLE dbo.ftp_groupAccess (
indexNo smallint NOT NULL,
ftpUserName varchar (50) NOT NULL,
accessRule varchar (200) NOT NULL
)
GOCREATE TABLE dbo.ftp_groupIPs (
indexNo smallint NOT NULL,
ftpUserName varchar (50) NOT NULL,
accessRule varchar (80) NOT NULL
)
GOCREATE TABLE dbo.ftp_groups (
id int IDENTITY (1, 1) NOT NULL,
ftpUserName varchar (50) NOT NULL,
accessRule varchar (200) NULL,
notes varchar (255) NULL
)
GOCREATE TABLE dbo.ftp_userAccess (
indexNo smallint NOT NULL,
ftpUserName varchar (50) NOT NULL,
accessRule varchar (200) NOT NULL
)
GOCREATE TABLE dbo.ftp_userIPs (
indexNo smallint NOT NULL,
ftpUserName varchar (50) NOT NULL,
accessRule varchar (80) NOT NULL
)
GOCREATE TABLE dbo.ftp_users (
id int IDENTITY (1, 1) NOT NULL,
ftpUserName varchar (50) NOT NULL,
ftpPassword varchar (50) NOT NULL,
ftpPasswordType tinyint NULL,
changePassword bit NOT NULL,
sKey varchar (50) NOT NULL,
accessRule varchar (200) NULL,
dirHome varchar (200) NOT NULL,
privilege tinyint NULL,
loginMsgFile varchar (80) NULL,
disabled bit NOT NULL,
sessionEncryption bit NOT NULL,
dirHomeLock bit NOT NULL,
hideHidden bit NOT NULL,
alwaysAllowLogin bit NOT NULL,
maxUsersConcurrent smallint NOT NULL,
speedLimitUp int NULL,
speedLimitDown int NULL,
maxUsersLoginPerIP smallint NOT NULL,
timeOutIdle int NULL,
timeOutSession int NULL,
quotaEnable bit NOT NULL,
quotaCurrent bigint NULL,
quotaMax bigint NULL,
ratioType tinyint NULL,
ratioUp smallint NULL,
ratioDown smallint NULL,
ratioCredit float NULL,
expiration smalldatetime NULL,
groups varchar (80) NULL,
notes varchar (255) NOT NULL
)
GOALTER TABLE dbo.ftp_groups WITH NOCHECK ADD
CONSTRAINT pk_ftp_groups PRIMARY KEY CLUSTERED (id)
GOALTER TABLE dbo.ftp_users WITH NOCHECK ADD
CONSTRAINT pk_ftp_users PRIMARY KEY CLUSTERED (id)
GOALTER TABLE dbo.ftp_groupAccess ADD
CONSTRAINT df_ftp_groupAccess_indexNo DEFAULT (2) FOR indexNo
GOCREATE INDEX ix_ftp_groupAccess__ftpUserName ON
dbo.ftp_groupAccess(ftpUserName, indexNo)
GOALTER TABLE dbo.ftp_groupIPs ADD
CONSTRAINT df_ftp_groupIPs_indexNo DEFAULT (2) FOR indexNo
GOCREATE INDEX ix_ftp_groupIPs__ftpUserName ON
dbo.ftp_groupIPs(ftpUserName, indexNo)
GOCREATE UNIQUE INDEX ix_ftp_groups__ftpUserName ON
dbo.ftp_groups(ftpUserName)
GOALTER TABLE dbo.ftp_userAccess ADD
CONSTRAINT df_ftp_userAccess_indexNo DEFAULT (2) FOR indexNo
GOCREATE INDEX ix_ftp_userAccess__ftpUserName ON
dbo.ftp_userAccess(ftpUserName, indexNo)
GOALTER TABLE dbo.ftp_userIPs ADD
CONSTRAINT df_ftp_userIPs_indexNo DEFAULT (2) FOR indexNo
GOCREATE INDEX ix_ftp_userIPs__ftpUserName ON
dbo.ftp_userIPs(ftpUserName, indexNo)
GOALTER TABLE dbo.ftp_users ADD
CONSTRAINT df_ftp_users_changePassword DEFAULT (1) FOR changePassword,
CONSTRAINT df_ftp_users_sKey DEFAULT ('') FOR sKey,
CONSTRAINT df_ftp_users_disabled DEFAULT (0) FOR disabled,
CONSTRAINT df_ftp_users_sessionEncryption DEFAULT (0) FOR sessionEncryption,
CONSTRAINT df_ftp_users_dirHome DEFAULT ('') FOR dirHome,
CONSTRAINT df_ftp_users_dirHomeLock DEFAULT (1) FOR dirHomeLock,
CONSTRAINT df_ftp_users_hideHidden DEFAULT (1) FOR hideHidden,
CONSTRAINT df_ftp_users_alwaysAllowLogin DEFAULT (0) FOR alwaysAllowLogin,
CONSTRAINT df_ftp_users_maxUsersConcurrent DEFAULT (10) FOR maxUsersConcurrent,
CONSTRAINT df_ftp_users_speedLimitUp DEFAULT ((-1)) FOR speedLimitUp,
CONSTRAINT df_ftp_users_speedLimitDown DEFAULT ((-1)) FOR speedLimitDown,
CONSTRAINT df_ftp_users_maxUsersLoginPerIP DEFAULT (5) FOR maxUsersLoginPerIP,
CONSTRAINT df_ftp_users_timeOutSession DEFAULT ((-1)) FOR timeOutSession,
CONSTRAINT df_ftp_users_quotaEnable DEFAULT (1) FOR quotaEnable,
CONSTRAINT df_ftp_users_quotaCurrent DEFAULT (0) FOR quotaCurrent,
CONSTRAINT df_ftp_users_quotaMax DEFAULT (52428800) FOR quotaMax,
CONSTRAINT df_ftp_users_notes DEFAULT ('') FOR notes
GOCREATE UNIQUE INDEX ix_ftp_users__ftpUserName ON dbo.ftp_users(ftpUserName)
GO
- Serv-U用SQL Server作为存储源的安装说明
- Serv-U使用SQL Server作为存储源的安装说明
- Serv-U使用SQL Server作为存储源的安装说明
- Serv-U的安装和基本设置
- Win2003 + IIS6.0 + Serv-U + SQL Server 安全设置
- Serv-u安装注意事项
- Serv-U FTP Server 中文版 11.0.0.4安装及使用说明
- Serv-U的虚拟目录
- Serv-U 的乱码
- Serv-U的使用说明
- 用Serv-U FTP Server构建自己的强力FTP服务器 ②
- ASP+MS SQL在线修改Serv-u的密码教程
- ftp服务器: Serv-u的安装和使用
- serv-u的安装和使用【个人笔记,仅供参考】
- 使用Serv-U 作为服务器进行编程,FTP上传 文件名显示乱码的解决
- Serv-U配置文件用户密码存储算法
- 配置Serv-U的数据库连接
- Serv-U碰到的问题
- tar 压缩命令的最有用的一个选项了
- 最全的2007年度流行语
- 声明:dlutcat不是大连理工的猫!
- nfs服务的服务器端配置简例
- prototype1.4.0.js ajax 的应用
- Serv-U用SQL Server作为存储源的安装说明
- u-boot(免费开源的)移植工具
- 如何设置对话框、控件的背景色、文字颜色
- 三剑客SN
- 分析ASP.NET服务器控件开发-控件生命周期
- U-Boot简介
- 关于SIPp的一些信息
- acm程序调试过程中freopen函数的使用
- SIPp的几个疑惑过我的地方