关于Proftpd+Mysql+磁盘限额的问题

hhl00

我想，这不是我第一个提出这样的问题，我在论坛找过一遍，很多人都有这个问题，也都有答复，但是还是未能解决我的问题，我测试使用的操作系统版本是Redhat9和Trustix 2.1，Proftpd版本是：proftpd-1.2.9.tar.gz，Mysql系统自带，proftpd-mod-quotatab为：1.2.11版本。

我的问题是，当我不给quotalimits表添加在ftpuser里存在的用户限制记录时，能够正常登录，当然，就没有磁盘限额功能，一旦我向quotalimits添加ftpuser里存在的用户的限制记录后，就无法登录了，各个日志信息如下：

quota.log信息：
Jul 24 15:52:33 mod_quotatab/1.2.11[3725]: found limit entry for user 'test'
Jul 24 15:52:33 mod_quotatab/1.2.11[3725]: creating new tally entry to match limit entry

ftp.log信息：
Jul 24 15:52:25 dreamemail.meibu.com proftpd[3725] dreamemail.meibu.com (localhost.localdomain[127.0.0.1]): FTP session opened.
Jul 24 15:52:33 dreamemail.meibu.com proftpd[3725] dreamemail.meibu.com (localhost.localdomain[127.0.0.1]): USER test: Login successful.
Jul 24 15:52:33 dreamemail.meibu.com proftpd[3725] dreamemail.meibu.com (localhost.localdomain[127.0.0.1]): FTP session closed.


登录时信息：
[root@dreamemail etc]# ftp
ftp> open localhost
Connected to localhost (127.0.0.1).
220 dreamemail.meibu.com FTP server ready
Name (localhost:root): test
331 Password required for test.
Password:
421 Service not available, remote server has closed connection
Login failed.
No control connection for command: No such file or directory

真是很奇怪，登录验证都成功了，为什么会立即关闭session。请兄弟们指导指导！哎，已经搞了半个多月了，没有任何进展。晕啊！

hhl00

我顶

hhl00

等待中。。。

xiaohua

这东西就是不好搞。建议你用 pure-ftpd-1.0.20_1 轻松支持虚拟用户、磁盘配额等功能。还支持 AUTH TLS

xiaohua

我只花了 2 个小时，就基本清楚它的整个配置了。pure-ftpd-1.0.20_1 就是好

hhl00

有没有相关的配置文档

dancingpig

./proftpd -d -n9
启动看看什么情况

eTony

1. #
   
2. # Table structure for table 'ftpgroup'
   
3. #
   
4. 
   
5. CREATE TABLE ftpgroup (
   
6.   groupname varchar(16) NOT NULL default '',
   
7.   gid smallint(6) NOT NULL default '5500',
   
8.   members varchar(16) NOT NULL default '',
   
9.   KEY groupname (groupname)
   
10. ) TYPE=MyISAM;
    
11. 
    
12. 
    
13. 
    
14. #
    
15. # Dumping data for table 'ftpgroup'
    
16. #
    
17. 
    
18. INSERT INTO ftpgroup VALUES("ftpgroup", "5500", "ftpuser");
    
19. 
    
20. 
    
21. #
    
22. # Table structure for table 'ftpquotalimits'
    
23. #
    
24. 
    
25. CREATE TABLE ftpquotalimits (
    
26.   name varchar(30) default NULL,
    
27.   quota_type enum('user','group','class','all') NOT NULL default 'user',
    
28.   per_session enum('false','true') NOT NULL default 'false',
    
29.   limit_type enum('soft','hard') NOT NULL default 'soft',
    
30.   bytes_in_avail float NOT NULL default '0',
    
31.   bytes_out_avail float NOT NULL default '0',
    
32.   bytes_xfer_avail float NOT NULL default '0',
    
33.   files_in_avail int(10) unsigned NOT NULL default '0',
    
34.   files_out_avail int(10) unsigned NOT NULL default '0',
    
35.   files_xfer_avail int(10) unsigned NOT NULL default '0'
    
36. ) TYPE=MyISAM;
    
37. 
    
38. 
    
39. 
    
40. #
    
41. # Dumping data for table 'ftpquotalimits'
    
42. #
    
43. 
    
44. INSERT INTO ftpquotalimits VALUES("ftpuser", "user", "true", "hard", "1e+06", "1e+06", "1e+06", "3", "3", "3");
    
45. 
    
46. 
    
47. #
    
48. # Table structure for table 'ftpquotatallies'
    
49. #
    
50. 
    
51. CREATE TABLE ftpquotatallies (
    
52.   name varchar(30) NOT NULL default '',
    
53.   quota_type enum('user','group','class','all') NOT NULL default 'user',
    
54.   bytes_in_used float NOT NULL default '0',
    
55.   bytes_out_used float NOT NULL default '0',
    
56.   bytes_xfer_used float NOT NULL default '0',
    
57.   files_in_used int(10) unsigned NOT NULL default '0',
    
58.   files_out_used int(10) unsigned NOT NULL default '0',
    
59.   files_xfer_used int(10) unsigned NOT NULL default '0'
    
60. ) TYPE=MyISAM;
    
61. 
    
62. 
    
63. 
    
64. #
    
65. # Dumping data for table 'ftpquotatallies'
    
66. #
    
67. 
    
68. INSERT INTO ftpquotatallies VALUES("ftpuser", "user", "1e+06", "1e+06", "1e+06", "3", "3", "3");
    
69. 
    
70. 
    
71. #
    
72. # Table structure for table 'ftpuser'
    
73. #
    
74. 
    
75. CREATE TABLE ftpuser (
    
76.   id int(10) unsigned NOT NULL auto_increment,
    
77.   userid varchar(32) NOT NULL default '',
    
78.   passwd varchar(32) NOT NULL default '',
    
79.   uid smallint(6) NOT NULL default '5500',
    
80.   gid smallint(6) NOT NULL default '5500',
    
81.   homedir varchar(255) NOT NULL default '',
    
82.   shell varchar(16) NOT NULL default '/sbin/nologin',
    
83.   count int(11) NOT NULL default '0',
    
84.   accessed datetime NOT NULL default '0000-00-00 00:00:00',
    
85.   modified datetime NOT NULL default '0000-00-00 00:00:00',
    
86.   PRIMARY KEY  (id)
    
87. ) TYPE=MyISAM;
    
88. 
    
89. 
    
90. 
    
91. #
    
92. # Dumping data for table 'ftpuser'
    
93. #
    
94. 
    
95. INSERT INTO ftpuser VALUES("1", "ftpuser", "ftppasswd", "5501", "5500", "/tony/ftp", "/sbin/nologin", "4", "2004-07-17 18:09:47", "2004-07-17 18:11:20");
    
96.   

复制代码

1.   ########################################
   
2. DefaultRoot ~
   
3. SQLAuthTypes Plaintext Crypt
   
4. SQLAuthenticate users* groups*
   
5. SQLConnectInfo ftpdb@192.168.0.2 root
   
6. SQLUserInfo ftpuser userid passwd uid gid homedir shell
   
7. SQLGroupInfo ftpgroup groupname gid members
   
8. SQLMinID 500
   
9. SQLHomedirOnDemand on
   
10. SQLLog PASS updatecount
    
11. SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
    
12. SQLLog STOR,DELE modified
    
13. SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
    
14. 
    
15. # User quotas
    
16. # ===========
    
17. QuotaEngine on
    
18. QuotaDirectoryTally on
    
19. QuotaDisplayUnits Mb
    
20.   QuotaShowQuotas on
    
21. 
    
22. SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_$
    
23. SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_$
    
24. SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_$
    
25. SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
    
26. QuotaLimitTable sql:/get-quota-limit
    
27. QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
    
28. 
    
29. DeferWelcome on
    
30. RootLogin off
    
31. RequireValidShell off
    
32. ########################################
    

复制代码

xiaohua

没什么必要用到 mysql 这么复杂吧？
你的用户是多少？1K？1W？10W？还是100？，甚至，更多？

hhl00

之所以用到Mysql，是因为学校的实际需要。我向建立一个自动建站的虚拟主机系统。
谢谢各位兄弟，我这就试试！什么情况明天再反馈给大家！