LinuxSir.cn,穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
查看: 594|回复: 0

pureftp+mysql 无法使用

[复制链接]
发表于 2006-9-13 20:24:03 | 显示全部楼层 |阅读模式
我的系统是Debian unstable
apt-get install pure-ftpd-mysql

修改/etc/pure-ftpd/db/mysql.conf
-------------------------------------------------------
MYSQLServer   localhost
MYSQLPort       3306
MYSQLUser       pureftpd
MYSQLPassword   123456
MYSQLDatabase   pureftpd
MYSQLCrypt      password
MYSQLGetPW      SELECT Password FROM users WHERE User="\L"
MYSQLGetUID     SELECT Uid FROM users WHERE User="\L"
MYSQLGetGID     SELECT Gid FROM users WHERE User="\L"
MYSQLGetDir     SELECT Dir FROM users WHERE User="\L"
--------------------------------------------

mysql 下做以下几步
---------------------------------------------------
mysql -u root -p
CREATE DATABASE `pureftpd` ;
use pureftpd;
CREATE TABLE users (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;
_______________________________________

然后,添加了一条记录
/etc/init.d/pure-ftpd-mysql restart

怎么用ftp登录不上,提示如下:
[右] 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
[右] 220-You are user number 1 of 50 allowed.
[右] 220-Local time is now 04:39. Server port: 21.
[右] 220-This is a private system - No anonymous login
[右] 220-IPv6 connections are also welcome on this server.
[右] 220 You will be disconnected after 15 minutes of inactivity.
[右] USER user123
[右] 331 User user123 OK. Password required
[右] PASS (隐藏)
您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表