proftp真的很爱出问题!最典型的421错误!

zhengwei_zw

proftp真的很爱出问题!最典型的421错误!
我新架一台proftp服务器,系统是bsd6.2 通过ports安装,make config选择好sql 已经限额模块
现在装好了,版本是

1. sk# pkg_info |grep proftp
   
2. proftpd-1.3.1.r2_3  Highly configurable ftp daemon
   
3. sk#

复制代码

现在我将另外一台服务器的proftpd.conf 粘贴过来

1. 
   
2. # This is a basic ProFTPD configuration file (rename it to
   
3. # 'proftpd.conf' for actual use.  It establishes a single server
   
4. # and a single anonymous login.  It assumes that you have a user/group
   
5. # "nobody" and "ftp" for normal operation and anon.
   
6. 
   
7. #ServerName                        "ProFTPD Default Installation"
   
8. ServerName                        "sk's ftp"
   
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. MaxLoginAttempts                 3
    
27. 
    
28. # Set the user and group under which the server will run.
    
29. User                                nobody
    
30. #Group                                nogroup
    
31. Group                                nobody
    
32. 
    
33. 
    
34. # To cause every FTP user to be "jailed" (chrooted) into their home
    
35. # directory, uncomment this line.
    
36. #DefaultRoot ~
    
37. DefaultRoot ~  
    
38. #put the proftpd log files in /var/log/ftp.syslog
    
39. #SystemLog /var/log/ftp.syslog
    
40. SystemLog /var/log/ftp.syslog
    
41. 
    
42. #TransferLog log files
    
43. #TransferLog /var/log/ftp.transferlog
    
44. 
    
45. MaxHostsPerUser 5 "Sorry, you may not connect more than one time 1."
    
46. MaxClientsPerUser 13 "Only one such user at a time 2."
    
47. MaxClientsPerHost 20 "Sorry, you may not connect more than one time 3."
    
48. 
    
49. #setup the Restart
    
50. AllowRetrieveRestart on
    
51. UseReverseDNS off                                    
    
52. IdentLookups off
    
53. PassivePorts 5555 6666
    
54. RootLogin off
    
55. RequireValidShell off
    
56. TimeoutStalled 600
    
57. MaxClients 20
    
58. AllowForeignAddress on
    
59. AllowStoreRestart on
    
60. ServerIdent off
    
61. DefaultRoot ~ ftpgroup
    
62. 
    
63. # Normally, we want files to be overwriteable.
    
64. AllowOverwrite                on
    
65. 
    
66. TimeoutIdle 600
    
67. 
    
68. SQLAuthTypes Backend Plaintext
    
69. 
    
70. SQLAuthenticate users* groups*
    
71. 
    
72. # databasename@host database_user user_password
    
73. #SQLConnectInfo ftpdb@localhost proftpd password
    
74. SQLConnectInfo proftp@localhost proftp proftp
    
75. 
    
76. SQLUserInfo ftpuser userid passwd uid gid homedir shell
    
77. SQLGroupInfo ftpgroup groupname gid members
    
78. SQLHomedirOnDemand on
    
79. 
    
80. # Update count every time user logs in
    
81. SQLLog PASS updatecount
    
82. SQLNamedQuery updatecount UPDATE "count=count+1,accessed=now() WHERE userid='%u'" ftpuser
    
83. # Update modified everytime user uploads or deletes a file
    
84. SQLLog STOR,DELE modified
    
85. SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
    
86. 
    
87. QuotaEngine on
    
88. QuotaDirectoryTally on
    
89. QuotaDisplayUnits kb
    
90. QuotaShowQuotas on
    
91. QuotaLog "/var/log/quota"
    
92. 
    
93. 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 ftpquotalimits WHERE name = '%{0}'AND quota_type = '%{1}'"
    
94. 
    
95. 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 ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
    
96. 
    
97. 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}'" ftpquotatallies
    
98. 
    
99. SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
    
100. 
     
101. QuotaLimitTable sql:/get-quota-limit
     
102. QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
     
103. 
     
104. 
     
105. <Directory /home/user>
     
106. <Limit WRITE>
     
107. </Limit>
     
108. </Directory>

复制代码

数据库也是另外一台生产服务器的结构,现在也将vipw中的ftpuser 和group 的数据添加到了新服务器.然后

1. #echo "proftpd_enable="yes" > /etc/rc.conf"
   
2. #sh /etc/rc

复制代码

现在

1. #netstat -an|grep 21

复制代码

可以看到ftp已经启动了,但是:

1. sk# ftp 127.0.0.1
   
2. Connected to 127.0.0.1.
   
3. 421 Service not available, remote server has closed connection.
   
4. ftp>
   

复制代码

1. ipfw list
   
2. 65535 allow ip from any to any
   

复制代码

不知道这是啥原因,根据个人经验觉得是mysql没有连接上,但是我用proftp 的用户又能登陆!分析了里面的数据结构也是对的.真的找不到原因了!希望有高手帮忙!

1. 
   
2. #more /var/log/ftp.syslog
   
3. Apr 25 01:20:57 sk.com proftpd[938] sk.com (127.0.0.1[127.0.0.1]): ProFTPD terminating (signal 11)
   
4. Apr 25 01:20:57 sk.com proftpd[938] sk.com (127.0.0.1[127.0.0.1]): FTP session closed.
   
5. #more proftpd.system.log
   
6. Apr 24 21:26:30 sk.com proftpd[20163] sk.com (localhost.com[127.0.0.1]): ProFTPD terminating (signal 11)
   
7. Apr 24 21:26:30 sk.com proftpd[20163] sk.com (localhost.com[127.0.0.1]): FTP session closed.
   
8. Apr 24 23:16:25 sk.com proftpd[20161] sk.com: ProFTPD killed (signal 15)
   
9. Apr 24 23:16:25 sk.com proftpd[20161] sk.com: ProFTPD 1.3.1rc2 standalone mode SHUTDOWN
   
10. Apr 24 23:16:31 sk.com proftpd[20832] sk.com: ProFTPD 1.3.1rc2 (devel) (built Tue Apr 24 01:30:34 CST 2007) standalone mode S
    
11. TARTUP
    

复制代码

[ 本帖最后由 zhengwei_zw 于 2007-4-24 17:23 编辑 ]

davex

我也遇到同样问题，正在尝试换mysql 4.1系列的数据库试试，估计是高版本数据库不太兼容

tinging

我是MYSQL5，将配置文件的连接数据库的用户名使用root的，就可以正常登陆了！