Graphical User Interface for ProFTPd with MySQL and sqlite3 support
This GUI for ProFTPd was written to support a basic user management feature
when using the SQL module. Originally written by Lex Brugmann in 2004,
updated by Christian Beer
in 2012 to support the latest PHP version.
2017 updated by Michael Keck with build-in login for
the admin user, secure the directories configs/
and includes
and moved
tables*.sql
to install/tables*.sql
.
Added install/config-examples
for OS specific configurations.
It's possible to use either of SHA1 and pbkdf2 with either of MySQL/MariaDB and sqlite3. pbkdf2 is supported since ProFTPd 1.3.5.
You can look at some screenshots to see if this is the tool you need.
Note:
Please use, if available, a secured connection to your webserver via https
.
You can do this by your webserver configurations or simple set in the
config.php
:
/**
* Force SSL usage
*
* Important: You should change this to true on live systems or configure
* your webserver to use SSL!
*/
$cfg['force_ssl'] = true; // default was false
Please notice that you need a SSL-certificate to use secured connection.
- Install ProFTPd with MySQL support
- Create a MySQL database, for example: "proftpd".
- Use the file install/tables.sql to populate the database.
- Add the following to your
proftpd.conf
andsql.conf
(edit to your needs):
CreateHome on 775
AuthOrder mod_sql.c
SQLBackend mysql
SQLEngine on
SQLPasswordEngine on
SQLAuthenticate on
SQLAuthTypes SHA1
SQLConnectInfo database@localhost username password
SQLUserInfo users userid passwd uid gid homedir shell
SQLGroupInfo groups groupname gid members
SQLUserWhereClause "disabled != 1"
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "login_count=login_count+1, last_login=now() WHERE userid='%u'" users
# Used to track xfer traffic per user (without invoking a quota)
SQLLog RETR bytes-out-count
SQLNamedQuery bytes-out-count UPDATE "bytes_out_used=bytes_out_used+%b WHERE userid='%u'" users
SQLLog RETR files-out-count
SQLNamedQuery files-out-count UPDATE "files_out_used=files_out_used+1 WHERE userid='%u'" users
SQLLog STOR bytes-in-count
SQLNamedQuery bytes-in-count UPDATE "bytes_in_used=bytes_in_used+%b WHERE userid='%u'" users
SQLLog STOR files-in-count
SQLNamedQuery files-in-count UPDATE "files_in_used=files_in_used+1 WHERE userid='%u'" users
- Extract all files to your webspace (into a subdirectory like
proftpdadmin
). - Copy the
configs/config_example.php
toconfig.php
and edit the new copied file to your needs.
Notice: Change the default login settings!
/**
* Login data
*
* Important: Please change this values in
* live systems!
*/
$cfg['login'] = array(
/* Username. Please use any username you want */
'username' => 'admin',
/* Password. CHANGE IT and use secure password! */
'password' => 'password',
/* Blowfish secret key (22 chars). CHANGE IT! */
'blowfish' => 'XBu5pjOTa8H7UIwYSzMZxD'
);
- Optional remove or secure the folder
install
. - Start ProFTPd.
- Go to
http://your.server.com/proftpdadmin/
and start using it!
- Install ProFTPd with sqlite3 support
- Use install/tables-sqlite3.sql to create an sqlite3 database:
sqlite3 auth.sqlite3 < install/tables-sqlite3.sql
- Add the following to your
proftpd.conf
andsql.conf
(edit to your needs):
CreateHome on 775
AuthOrder mod_sql.c
SQLBackend sqlite3
SQLEngine on
SQLPasswordEngine on
SQLAuthenticate on
SQLAuthTypes pbkdf2
SQLPasswordPBKDF2 sha1 5000 20
SQLPasswordUserSalt name Prepend
SQLPasswordEncoding hex
SQLConnectInfo /path/to/auth.sqlite3
SQLUserInfo users userid passwd uid gid homedir shell
SQLGroupInfo groups groupname gid members
SQLUserWhereClause "disabled != 1"
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "login_count=login_count+1, last_login=now() WHERE userid='%u'" users
# Used to track xfer traffic per user (without invoking a quota)
SQLLog RETR bytes-out-count
SQLNamedQuery bytes-out-count UPDATE "bytes_out_used=bytes_out_used+%b WHERE userid='%u'" users
SQLLog RETR files-out-count
SQLNamedQuery files-out-count UPDATE "files_out_used=files_out_used+1 WHERE userid='%u'" users
SQLLog STOR bytes-in-count
SQLNamedQuery bytes-in-count UPDATE "bytes_in_used=bytes_in_used+%b WHERE userid='%u'" users
SQLLog STOR files-in-count
SQLNamedQuery files-in-count UPDATE "files_in_used=files_in_used+1 WHERE userid='%u'" users
- Extract all files to your webspace (into a subdirectory like
proftpdadmin
). - Copy the
configs/config_example.php
toconfig.php
and edit the new copied file to your needs.
Notice: Change the default login settings!
/**
* Login data
*
* Important: Please change this values in
* live systems!
*/
$cfg['login'] = array(
/* Username. Please use any username you want */
'username' => 'admin',
/* Password. CHANGE IT and use secure password! */
'password' => 'password',
/* Blowfish secret key (22 chars). CHANGE IT! */
'blowfish' => 'XBu5pjOTa8H7UIwYSzMZxD'
);
- Optional remove or secure the folder
install
. - Start ProFTPd.
- Go to
http://your.server.com/proftpdadmin/
and start using it!
If you want to upgrade the hashing algorithm you have to change all passwords after changing the configs (both ProFTPd and ProFTPd Admin).
-
Add postgresql support
» Issue #26 / Feature request -
Add default user settings to groups so it is easier to create a new user with default values
» Issue #28 / Feature request -
Send e-mail to new users with their password
» Issue #35 / Feature request
- Lex Brugman for initiating this project
- Justin Vincent for the ezSQL library
- Ricardo Padilha for implementing sqlite3, pbkdf2 and bootstrap support
- Christian Beer for his update to support the latest PHP version
- Robert Tulke for the Debian Jessie example
- © 2004 The Netherlands, Lex Brugman; lex_brugman@users.sourceforge.net
- © 2012 Christian Beer; djangofett@gmx.net
- © 2015 Ricardo Padilha; ricardo@droboports.com
- © 2017 Robert Tulke; https://github.com/rtulke/
- © 2017 Michael Keck; https://github.com/mkkeck
Published under the GPLv2 License (see LICENSE for details)
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2, as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, download from http://www.gnu.org/licenses/gpl-2.0.txt