
      ppum - PureFTPD PHP User Manager
      --------------------------------

This is a tiny web-based frontend written in PHP, to easily add, 
edit or delete ftp users stored and authenticated by pureftpd's sql backend.

REQUIREMENTS
-------------

- webserver (I recommend apache)
- php (at least version 4)
- an sql server (MySQL or PGSQL)
- pureftpd configured properly with an sql auth
- pear packages:  MDB2, MDB2_Driver_MySQL, MDB2_Driver_PGSQL

NOTES
-----

Ppum should work also with pgsql servers, since it uses PEAR::MDB2 as
database layer, but it wasn't tested, only on MySQL.


INSTALL
-------

Just unpack the tar.gz to your webfolder and configure your webserver
properly.


shell:~$ mv ppum-x.y.tar.gz /var/www
shell:~$ cd /var/www
shell:/var/www$ tar xvzf ppum-x.y.tar.gz


Check create.sql and pureftpd.sql in sql/. If you have already a 'users'
table for your ftp users, you can ignore pureftpd.sql, but check if you
have the same sql table structure, if not, ppum will not work properly.
Next step is to create the database, if you don't have already one:


mysql> CREATE DATABASE pureftpd;
Query OK, 1 row affected (0.02 sec)


Now we're gonna make the user, that'll have access to this database (and
only to this):


mysql> GRANT ALL PRIVILEGES ON pureftpd.* TO 'pureftpd'@'localhost'
     > IDENTIFIED BY 'yourpass';
	  > FLUSH PRIVILEGES;


Note: On MySQL version 5 you have to use OLD_PASSWORD('yourpass')
otherwise pureftpd isn't able to connect. You're done with the
privileges. Next, import the create.sql to your sql server, for mysql:


shell:~$ mysql -u user -p < create.sql


Import pureftpd.sql the same way, if needed.
You're done with the mysql part, now edit config.php and fill the
required fields to get a connection to your sql db.
