关于mysql+proftp+quota的问题！
我按例子：http://chinaunix.net/jh/4/399323.html
做好后，登录：
[root@server1 proftpd]# ftp localhost
Connected to localhost (127.0.0.1).
220 server1 FTP server ready
Name (localhost:root): test
331 Password required for test.
Password:
230 User test logged in.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp>; quote site quota
202 No quotas in effect
这是为什么啊？
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
顶下！
文档绝对没有问题，我也是那么做的，你再仔细查一下，看看哪里做错了，或者马虎了，或者理解的不对的地方
ftpuser表中的用户是要自己加吗？
当然是啊！
那个是用户列表数据库，文档里也有写
mysql>; insert into ftpuser (id,userid,passwd,uig,gid,homedir shell accessed,modified) values (1,'test','test',504,504,'/var/ftp','/sbin/nologin',0,'0000-00-00 00:00:00','0000-00-00 00:00:00');
出错！
请问这里面的id字段有什么用啊？
ID是一个序号，没什么用，我就是顺着写的，第一个写1，第二个写2
mysql>; insert into ftpuser (id,userid,passwd,uid,gid,homedir,shell,count,accessed,modified) values (1,'test','test',504,504,'/var/ftp','/sbin/nologin',1,'0000-00-00 00:00:00','0000-00-00 00:00:00');
Query OK, 1 row affected (0.03 sec)
mysql>; selece * from ftpuser;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'selece * from ftpuser' at line 1
mysql>; select * from ftpuser;
+----+--------+--------+-----+-----+----------+---------------+-------+---------------------+---------------------+
| id | userid | passwd | uid | gid | homedir | shell | count | accessed | modified |
+----+--------+--------+-----+-----+----------+---------------+-------+---------------------+---------------------+
| 1 | test | test | 504 | 504 | /var/ftp | /sbin/nologin | 2 | 2004-10-18 14:11:56 | 0000-00-00 00:00:00 |
+----+--------+--------+-----+-----+----------+---------------+-------+---------------------+---------------------+
1 row in set (0.00 sec)
mysql>; insert into ftpquotalimits (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) values ('test','user','false','soft','10240000','0','2048000','500','0','10');
Query OK, 1 row affected (0.00 sec)
mysql>; select * from ftpquotalimits;
+------+------------+-------------+------------+----------------+-----------------+------------------+----------------+-----------------+------------------+
| 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 |
+------+------------+-------------+------------+----------------+-----------------+------------------+----------------+-----------------+------------------+
| test | user | false | soft | 1.024e+07 | 0 | 2.048e+06 | 500 | 0 | 10 |
+------+------------+-------------+------------+----------------+-----------------+------------------+----------------+-----------------+------------------+
1 row in set (0.00 sec)
我都做完了，重启FTP服务后，可还是这样啊！
ftp>; quote site quota
202 No quotas in effect
这是QUOTA日志：
Oct 18 15:01:09 mod_quotatab/1.2.13[11654]: SITE QUOTA requested by user test
Oct 18 15:11:34 mod_quotatab/1.2.13[11659]: notice: no QuotaLimitTable configured
Oct 18 15:11:34 mod_quotatab/1.2.13[11659]: error: unable to open QuotaLimitTable: No such file or directory
Oct 18 15:11:34 mod_quotatab/1.2.13[11659]: notice: no QuotaTallyTable configured
Oct 18 15:11:34 mod_quotatab/1.2.13[11659]: error: unable to open QuotaTallyTable: No such file or directory
Oct 18 15:11:39 mod_quotatab/1.2.13[11659]: turning QuotaEngine off
http://bbs.chinaunix.net/forum/viewtopic.php?t=423609&show_type=new&sid=c78a4646f32458a74f34c9dd43c766fd
俺照这个来.安装了N编都成功。
放软件包的服务器已经停了。需要的话我发给你。