Pure-FTPd WebUI README
======================

Pure-FTPd WebUI Homepage: 
http://pure-ftpd-webui.org/

Table of contents
-----------------
A. Requirements
B. Installation

A. Requirements
---------------

Pure-FTPd WebUI system requirements:

    * Apache webserver
    * PHP 5 or higher, php-mysql
    * MySQL
    * Pure-FTPd ftp daemon

/etc/pure-ftpd/db/mysql.conf
MYSQLSocket      /var/run/mysqld/mysqld.sock
#MYSQLServer     localhost
#MYSQLPort       3306
MYSQLUser       pureftpd
MYSQLPassword   "passwod"
MYSQLDatabase   pureftpd
#MYSQLCrypt md5, cleartext, crypt() or password() - md5 is VERY RECOMMENDABLE uppon cleartext
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")


B. Installation
----------------------

1. Download and unpack
Download and unpack the Pure-FTPd WebUI archive to your webserver's document root folder. 

2. Set permissions
Make sure the Pure-FTPd WebUI directory are writable to your webserver user.

3. Configure pure-ftpd
Configure pure-ftpd to use "ftpd" as table for credentials in your pure-ftpd mysql.conf 
and make sure it uses md5 as encryption for the password.

4. Run installation
Go to http://your_server/pure-ftpd-webui/install.php