Ubuntu Ϲ¹½¨»ùÓÚ mysql ¹ÜÀíµÄ pure ftpd

²ÎÕÕ : http://ubuntuing.javaeye.com/blog/65547
µÚ
Ò»²½£º°²×°pure-ftpdºÍpure-ftpd-mysql.
apt-get install pure-ftpd
apt-get
install pure-ftpd-mysql
µÚ¶þ²½£ºÐÞ¸Äpure-ftpdÁ´½ÓmysqlµÄÃÜÂë
vim
/etc/pure-ftpd/db/mysql.conf
ĬÈÏÅäÖãº
#MYSQLServer    
localhost
#MYSQLPort       3306
MYSQLSocket    
/tmp/mysql.sock
MYSQLUser       root
MYSQLPassword  
ÕâÀïÌîдÄãµÄÃÜÂë  
MYSQLDatabase   pureftpd
MYSQLCrypt     
cleartext
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”
µÚÈý²½´´½¨¹ÜÀíÊý¾Ý¿â£º
msyql -u root -p
Êä
ÈëmysqlÃÜÂë½øÈë
mysql>create database pureftpd;
mysql>use
pureftpd;
´´½¨users±í£º
CREATE TABLE users (
User
CHAR(32) BINARY NOT NULL,
Password CHAR(64) BINARY NOT NULL,
Uid
INT(11) NOT NULL default ‘-1′,
Gid INT(11) NOT NULL default
‘-1′,
Dir CHAR(256) BINARY NOT NULL,
PRIMARY KEY  (User)
);
µÚ
ËIJ½:´´½¨Óû§¼°Ä¿Â¼
groupadd www
useradd -g www www
mkdir
-p Ä¿Â¼Î»Öà (±ÈÈçÎÒµÄÊÇ /da
ta)
chown -R www:www Ŀ¼λÖà (±ÈÈçÎÒµÄÊÇ /data)
Ȗ
È¡Óû§id¼°ËùÔÚ×éµÄ×éid
id www
½á¹û£ºuid=1001(www) gid=1001(www)
groups=1001(www)
½«Óû§Êý¾Ý²åÈëµ½Êý¾Ý¿âÓÃÒÔÑéÖ¤
insert into users
values(’www’,'123456′,1001,1001,’/data’);
¼¸¸öÖµ·Ö±ð¶ÔÓ¦ Óû§Ãû ÃÜÂë uid
gid ²Ù×÷Ŀ¼
µÚÎå²½£ºÖØÆôpure-ftpd
/etc/init.d/pure-ftpd restart
Õâ
ÑùÒ»À´,ÄãµÄ·þÎñÆ÷¾ÍÖ§³ÖftpÁË…