未分類

架設 PureFTPd With MySQL 虛擬FTP帳號 On Fedora 9

如果跳出以下登入訊息,請輸入使用者 pureftpd,以及之前設定的pureftpd 密碼ftppassword

 image

登入成功畫面
image 

10.設定 PureFTPd
# vi /etc/pure-ftpd/pure-ftpd.conf
// 確認修改成如以下三行,ChrootEveryone 限制登入使用者不會切換目錄到別人家裡面去,CreateHomeDir 若是新一次登入的使用者這裡會自動建立使用者的家目錄,MySQLConfigFile 就重要了,這就是把 PureFTPd 與 MySQL 接起來的設定檔           
ChrootEveryone              yes
MySQLConfigFile               /etc/pure-ftpd/pureftpd-mysql.conf
CreateHomeDir               yes

11.先備份 pureftpd-mysql.conf 設定檔,再編輯 pureftpd-mysql.conf 設定檔
# cp /etc/pure-ftpd/pureftpd-mysql.conf /etc/pure-ftpd/pureftpd-mysql.conf_bk
# vi /etc/pure-ftpd/pureftpd-mysql.conf
MYSQLSocket     /var/lib/mysql/mysql.sock
MYSQLUser       pureftpd
MYSQLPassword   ftppassword  ← 之前設定的密碼
MYSQLDatabase   pureftpd
MYSQLCrypt      md5

MYSQLGetPW      SELECT Password FROM ftpd WHERE User=”\L” AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MYSQLGetUID     SELECT Uid FROM ftpd WHERE User=”\L” AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MYSQLGetGID     SELECT Gid FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MYSQLGetDir     SELECT Dir FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MySQLGetQTASZ  SELECT QuotaSize FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

MySQLGetQTAFS  SELECT QuotaFiles FROM ftpd WHERE User=”\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\R”)

 

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *