ProMA
ProMA is a PHP-based system for administrating a ProFTPd server that stores users in a MySQL database. Its features include support for multiple administrators, mail notifications when new users register and when accounts are approved, closing of accounts temporarily, and a notepad per user for the admins.
| Tags | Database Front-Ends |
|---|---|
| Licenses | GPL |
| Operating Systems | OS Independent |
| Implementation | PHP |
Recent releases
- 25 Oct 2007 16:23
Changes: This release includes minor changes to support PHP 5.
- 27 Jul 2004 03:26
Changes: This release adds support for setting user-specific home directories. The update also includes a couple of bugfixes, some code cleanups, and aesthetic changes.
- 25 Nov 2003 16:48
Changes: This version fixes a minor bug so accounts are no longer closed when the change form is submitted.
- 23 Aug 2003 21:26
Changes: A rewrite of some parts so that no extra database tables are needed, and new mail notifiers.
- 19 Sep 2002 22:23
Changes: A fix for a minor bug in an SQL query.
- All comments
Recent commentsRe: Invalid INSTALL instructions
> The issue is, the text() type is not
> supported under mySQL, only longtext,
> mediumtext, and tinytext are, and
> without the parenthesis.
text is fully supported according to http://www.mysql.com/doc/en/BLOB.html
The paranthesis are not, and are to be considered a bug. Please mail me with further bug reports. Don't post them here.
Invalid INSTALL instructions
In the INSTALL file of proma v0.7.3, it includes the following instructions on creating a table for proma with mySQL:
CREATE TABLE users (
userid varchar(255) NOT NULL,
name varchar(255) NULL,
mail varchar(255) NULL,
uid int(11) NULL default '65534',
gid int(11) NULL default '65534',
passwd varchar(255) NOT NULL,
shell varchar(255) NOT NULL default '/bin/nonexistent',
homedir varchar(255) NOT NULL default '/some/fancy/homedir',
note text() NULL default '',
count int(11) NOT NULL default 0,
admin int(1) NOT NULL default 0
);
The issue is, the text() type is not supported under mySQL, only longtext, mediumtext, and tinytext are, and without the parenthesis.