Platforma de hosting cu software liber, gratuit, open source.

mysql> CREATE DATABASE ftpusers;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON ftpusers.* TO 'ftpusers'@'localhost' IDENTIFIED BY 'ap2ngA';
mysql> FLUSH PRIVILEGES;

CREATE TABLE IF NOT EXISTS `users` (
  `User` VARCHAR(32) NOT NULL,
  `Password` VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `Uid` INT(11) NOT NULL DEFAULT '14',
  `Gid` INT(11) NOT NULL DEFAULT '101',
  `Dir` VARCHAR(256) NOT NULL,
  `QuotaFiles` INT(10) NOT NULL DEFAULT '5000',
  `QuotaSize` INT(10) NOT NULL DEFAULT '100',
  `ULBandwidth` INT(10) NOT NULL DEFAULT '256',
  `DLBandwidth` INT(10) NOT NULL DEFAULT '256',
  `Ipaddress` VARCHAR(15) NOT NULL DEFAULT '*',
  `Comment` tinytext,
  `Status` enum('0','1') NOT NULL DEFAULT '1',
  `ULRatio` SMALLINT(5) NOT NULL DEFAULT '0',
  `DLRatio` SMALLINT(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf

MYSQLServer     localhost
MYSQLSocket     /tmp/mysql.sock
MYSQLUser       ftpusers
MYSQLPassword   ap2ngA
MYSQLDatabase   ftpusers
MYSQLCrypt      md5
MYSQLGetPW      SELECT Password FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MYSQLGetUID     SELECT Uid FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MYSQLGetGID     SELECT Gid FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MYSQLGetDir     SELECT Dir FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetQTAFS  SELECT QuotaFiles FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetQTASZ  SELECT QuotaSize FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")

INSERT INTO `ftpusers`.`users` (
`User` ,
`Password` ,
`Uid` ,
`Gid` ,
`Dir` ,
`QuotaFiles` ,
`QuotaSize` ,
`ULBandwidth` ,
`DLBandwidth` ,
`Ipaddress` ,
`Comment` ,
`Status` ,
`ULRatio` ,
`DLRatio`
)
VALUES (
'lamp', '4c336e5111b965561840752a5f49b89c', '1234', '1234', '/var/www/www.lamp.ro', '5000', '100', '256', '256', '*', '', '1', '0', '0'
);