Serv-u Batch account management and application (access+asp) graphic method _ftp Server

1. First download ASP program, in the download contains serv-u required database, named Serv#u.mdb.
2. Establish the System data source: FTP, through ODBC database connection, connect to Serv#u.mdb. Steps as shown

3. After the successful establishment of ODBC, open the Serv-u software, set up the FTP domain. At step 4 o'clock Note Select store in ODBC database

4. Open the Servudaemon.ini file under the Serv-u installation directory and do the following:
(1) Use the following code to cover the original Odbcsource, Odbctables, Odbccolumns
------------------------------------------
odbcsource=ftp| |
Odbctables=user_accounts|group_accounts|user_access|group_access|user_ip_access|group_ip_access
odbccolumns=user|password|skey|homedir| | access|disable| | relpaths| | | changepass|quotaenable| | | | maxusers| | | ratioup|ratiodown|ratiocredit|quotacurrent|quotamax|expiration|privilege|passtype|ratiotype|groups|notes| Indexno
------------------------------------------
(2) The "Reloadsettings=true" statement is copied to the back of each node, such as [Glogal], [DOMAINS], [Domain1], [Domain2] after the following

5. Open serv-u FTP domain, click Reload Accounts from Database, as shown

6. Open the ASP program, modify the config.asp file

' Site name
Webname= "Huizhou Institute Xiao Wang Teacher's FTP station"
' Server IP Address
servuip= "172.17.21.211"
' Contact email
Webserveremail= "Whuab@163.com"
' Permissions for user directory
Servuaccess= "| RWAMLCDP "
' The absolute physical path of the user directory's storage must end with ' \ '.
User_folder= "E:\FTP\hzucs.cn.ftp\"
' Whether to temporarily stop user registration (prohibit: True, allow: false)
Regclosed=false
' The prompt that is displayed when the user registers is temporarily stopped.
regclosed_txt= "Warm tip: due to excessive number of users, the site has been suspended registration, thank you for your support and cooperation. "
' Password save type 0: rule password, 2:MD5 encryption
Asanpasstype=0
' Whether to limit space size: (yes: true, no: false),
Asanquotaenable=true
' Whether to limit the size of the space (in units: M). It is only valid when the limit space size function is turned on.
quotamax= 10
' Whether to limit the use time: (True,false),
Expirationtime=false
' Account expiration after processing: 0 for deletion, 1 for disabled. When the Limit usage time function is turned on, it is valid.
Asanexpirationtype=1
' Account number of days (units: Days) When the restrictions on the use of time function, only effective.
asanexpiration=365
' Database path
Dim Conn,connstr,datapath
DataPath = "DaTa/serv#u.mdb "' The relative path of the database directory
Connstr= "Provider=microsoft.jet.oledb.4.0;daTa source= "&server.mappath (datapath)
7. Configure IIS so that users can register their FTP account through the Web page.

8. Modify the index.asp in ASP program
<title><%=webname%>-Huizhou University Computer Department Wang teacher's FTP station-<%=title%></title>

9. Modify the bottom.asp in ASP program
<div align= "center" ><a href= "http://www.hzucs.cn" target= "_blank" >powered by Hzucs</a></div >

10. Access the FTP user application interface through IE, enter the Web server. http://172.17.21.211

11. Open Serv-u At this time, you can see in the users of the Hzucs account just requested, its home directory is E:\FTP\hzucs.cn.ftp\hzucs

12. At this time through IE, with Hzucs user login to the FTP server for testing.

13. Return to Serv-u to view Hzucs user's permissions, and config.asp servuaccess= "| RWAMLCDP "basically consistent

14. Use IE to log on to the Web to modify Hzucs password, the Microsoft JET Database Engine (0X80040E14), the UPDATE statement syntax error.

15. Open mycentre.asp, the password in the next sentence is the Access keyword, should add []

Conn.execute ("Update [user_accounts] Set Password = '" & Newdbpassword & "" Where [user]= ' "& UserName &" ")
To
Conn.execute ("Update [user_accounts] set [Password] = ' & Newdbpassword &" ' Where [user]= ' "& UserName & '] ")