proftpd+mysql+quota的问题

5sky

装好后，客户端就是连不上.

1. 
   
2. # cat ftp.syslog
   
3. Jan 18 12:22:11 battle proftpd[396] battle (61.139.64.120[61.139.64.120]): FTP session closed.
   
4. Jan 18 12:23:17 battle proftpd[401] battle: ProFTPD 1.2.8 (stable) (built Fri Jan 16 11:05:30 CST 2004) standalone mode STARTUP
   
5. Jan 18 12:23:41 battle proftpd[402] battle (61.139.64.120[61.139.64.120]): FTP session closed.
   
6. Jan 18 12:24:33 battle proftpd[406] battle (61.139.64.120[61.139.64.120]): FTP session closed.
   
7. Jan 18 13:07:10 battle proftpd[424] battle (221.203.71.16[221.203.71.16]): FTP session closed.
   
8. Jan 18 15:10:45 battle proftpd[469] battle (203.236.81.8[203.236.81.8]): FTP session closed.
   

复制代码

1. 
   
2. [root@battle etc]# cat proftpd.conf
   
3. # This is a basic ProFTPD configuration file (rename it to
   
4. # 'proftpd.conf' for actual use.  It establishes a single server
   
5. # and a single anonymous login.  It assumes that you have a user/group
   
6. # "nobody" and "ftp" for normal operation and anon.
   
7. 
   
8. ServerName                      "ProFTPD Default Installation"
   
9. ServerType                      standalone
   
10. DefaultServer                   on
    
11. 
    
12. # Port 21 is the standard FTP port.
    
13. Port                            21
    
14. 
    
15. # Umask 022 is a good standard umask to prevent new dirs and files
    
16. # from being group and world writable.
    
17. Umask                           022
    
18. 
    
19. # To prevent DoS attacks, set the maximum number of child processes
    
20. # to 30.  If you need to allow more than 30 concurrent connections
    
21. # at once, simply increase this value.  Note that this ONLY works
    
22. # in standalone mode, in inetd mode you should use an inetd server
    
23. # that allows you to limit maximum number of processes per service
    
24. # (such as xinetd).
    
25. MaxInstances                    30
    
26. 
    
27. # Set the user and group under which the server will run.
    
28. User                            FTPUSR
    
29. Group                           FTPGRP
    
30. 
    
31. # To cause every FTP user to be "jailed" (chrooted) into their home
    
32. # directory, uncomment this line.
    
33. DefaultRoot ~
    
34. 
    
35. #put the proftpd log files in /var/log/ftp.syslog
    
36. SystemLog /var/log/ftp.syslog
    
37. 
    
38. #TransferLog log files
    
39. TransferLog /var/log/ftp.transferlog
    
40. 
    
41. # Normally, we want files to be overwriteable.
    
42. <Directory />
    
43.   AllowOverwrite                on
    
44. </Directory>
    
45. 
    
46. # A basic anonymous configuration, no upload directories.  If you do not
    
47. # want anonymous users, simply delete this entire <Anonymous> section.
    
48. <Anonymous ~ftp>
    
49.   User                          ftp
    
50.   Group                         ftp
    
51. 
    
52.   # We want clients to be able to login with "anonymous" as well as "ftp"
    
53.   UserAlias                     anonymous ftp
    
54. 
    
55.   # Limit the maximum number of anonymous logins
    
56.   MaxClients                    10
    
57. 
    
58.   # We want 'welcome.msg' displayed at login, and '.message' displayed
    
59.   # in each newly chdired directory.
    
60.   DisplayLogin                  welcome.msg
    
61.   DisplayFirstChdir             .message
    
62. 
    
63.   # Limit WRITE everywhere in the anonymous chroot
    
64.   <Limit WRITE>
    
65.     DenyAll
    
66.   </Limit>
    
67. </Anonymous>
    
68. 
    
69. <Global>
    
70. 
    
71. #设置MySQL认证：
    
72. #数据库联接的信息，DatabaseName是数据库名， HostName是主机名，
    
73. #Port是端口号，UserName是连接数据库的用户名，Password是密码。
    
74. SQLConnectInfo ftp@localhost:3306 FTP 12pps2@
    
75. 
    
76. #数据库认证的类型：
    
77. SQLAuthTypes Backend Plaintext
    
78. 
    
79. #指定用来做用户认证的表的有关信息。("FTPUSERS"和"FTPGRPS"是数据表名字)
    
80. SQLUserInfo FTPUSERS userid passwd uid gid home shell
    
81. 
    
82. SQLGroupInfo FTPGRPS grpname gid members
    
83. 
    
84. #设置如果shell为空时允许用户登录：
    
85. RequireValidShell on
    
86. 
    
87. #数据库的鉴别
    
88. SQLAuthenticate users groups usersetfast groupsetfast
    
89. 
    
90. #如果home目录不存在，则系统会为根据它的home项新建一个目录：
    
91. SQLHomedirOnDemand on
    
92. 
    
93. 
    
94. 
    
95. #磁盘限额部分
    
96. QuotaDirectoryTally on
    
97. 
    
98. #磁盘限额单位 b"|"Kb"|"Mb"|"Gb"
    
99. QuotaDisplayUnits "Kb"
    
100. 
     
101. QuotaEngine on
     
102. 
     
103. #磁盘限额日志记录
     
104. QuotaLog /var/log/Quota.log
     
105. 
     
106. # 打开磁盘限额信息，当登陆FTP帐户后，使用命令 "quote SITE QUOTA" 后可显示当前用户的磁盘限额
     
107. QuotaShowQuotas on
     
108. 
     
109. #以下是SQL调用语句
     
110. 
     
111. SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail,bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
     
112. 
     
113. SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used,bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
     
114. 
     
115. SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies
     
116. 
     
117. SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies
     
118. 
     
119. QuotaLimitTable sql:/get-quota-limit
     
120. QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
     
121. 
     
122. </Global>
     

复制代码

谁能告诉我是怎么回事？