让Serv-U使用ODBC的代码

2007-2-7　网友评论 0 条　点击进入论坛

在创建站点选择域类型时候选择存储与ODBC中，然后将下列代码再Serv_U的配置文件中相关的站点处替换掉。

ODBCSource=ODBC_NAME|ODBC_DB_NAME|ODBC_DB_PWD
ODBCTables=serv_u_user|serv_u_group|serv_u_user_dir

|serv_u_group_dir|serv_u_user_ip|serv_u_group_ip
ODBCColumns=name|password|skey|homedir|logmesfile

|access|disable|needsecure|relpaths|hidehidden|alwayslogin

|changepassword|quotaenable|maxipo|maxspeedup|maxspeeddown

|maxusers|idletimeout|sessiontimeout|ratioup|ratiodown

|ratiocredit|quotacurrent|qoutamax|expiration|privilege

|passwordtype|ratiotype|groups|notes|id|expirationtype

Serv_U的配置完成；下面是数据库代码(MS SQL)

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_group]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_group]

GO

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_group_dir]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_group_dir]

GO

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_group_ip]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_group_ip]

GO

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_user]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_user]

GO

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_user_dir]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_user_dir]

GO

if exists (select * from dbo.sysobjects where id =

object_id(N''[dbo].[serv_u_user_ip]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)

drop table [dbo].[serv_u_user_ip]

GO

CREATE TABLE [dbo].[serv_u_group] (

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,

[Notes] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,

[id] [int] IDENTITY (1, 1) NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[serv_u_group_dir] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[serv_u_group_ip] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[serv_u_user] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[passwordtype] [int] NULL ,

[changepassword] [bit] NOT NULL ,

[skey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[access] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[homedir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[privilege] [int] NULL ,

[logmesfile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[disable] [bit] NOT NULL ,

[needsecure] [bit] NOT NULL ,

[relpaths] [bit] NOT NULL ,

[hidehidden] [bit] NOT NULL ,

[alwayslogin] [bit] NOT NULL ,

[maxusers] [int] NULL ,

[maxspeedup] [int] NULL ,

[maxspeeddown] [int] NULL ,

[maxipo] [int] NULL ,

[idletimeout] [int] NULL ,

[sessiontimeout] [int] NULL ,

[quotaenable] [bit] NOT NULL ,

[quotacurrent] [int] NULL ,

[qoutamax] [int] NULL ,

[ratiotype] [int] NULL ,

[ratioup] [int] NULL ,

[ratiodown] [int] NULL ,

[ratiocredit] [int] NULL ,

[expiration] [smalldatetime] NULL ,

[expirationtype] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

[groups] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[notes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[serv_u_user_dir] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[serv_u_user_ip] (

[id] [smallint] IDENTITY (1, 1) NOT NULL ,

[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO>

今日推荐

• ·QQ邮箱新体验：容量自动翻倍，发送G级附件[组图]
• ·玩转科技奥运
• ·网络管理员必学手册
• ·从头学做网管系列教程: 如何合理规划局域网
• ·巧用QQ打开被网管隐藏的文件夹

• ·为何网管变成勤杂工
• ·网管严把服务器防火墙上"漏洞"
• ·初级网管的网络安全
• ·网管必读 教会用户自己给系统打补丁
• ·网络管理五大发展方向

重点推荐

领军企业技术文库

最新专题

电子杂志订阅

技术热点