Graffougna.net

apt-get install mysql-server mysql-client libmysqlclient12-dev phpmyadmin 

Enable suExec? -- Yes
Configuring mysql-server (Install Hints) -- OK   
Which web server would you like to reconfigure automatically? -- apache, apache2   
Do you want me to restart apache now? -- Yes

emerge mysql phpmyadmin

mysqladmin -u root password votrepass

apt-get install proftpd-mysql  Run proftpd from inetd or standalone? -- standalone

USE="mysql softquota" emerge proftpd 

groupadd -g 2001 ftpgroup  useradd -u 2001 -s /bin/false -d /bin/null -c "proftpd user" -g ftpgroup ftpuser 

mysql -u root -p

create database ftp; 
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost' IDENTIFIED BY 'password'; 
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost.localdomain' IDENTIFIED BY 'password'; 
FLUSH PRIVILEGES; 

USE ftp;  
CREATE TABLE ftpgroup ( 
groupname varchar(16) NOT NULL default '', 
gid smallint(6) NOT NULL default '5500', members varchar(16) NOT NULL default '', 
KEY groupname (groupname)) 
TYPE=MyISAM COMMENT='ProFTP group table'; 
 
CREATE TABLE ftpquotalimits ( 
name varchar(30) default NULL, 
quota_type enum('user','group','class','all') NOT NULL default 'user', 
per_session enum('false','true') NOT NULL default 'false', 
limit_type enum('soft','hard') NOT NULL default 'soft', bytes_in_avail int(10) unsigned NOT NULL default '0',
bytes_out_avail int(10) unsigned NOT NULL default '0', 
bytes_xfer_avail int(10) unsigned NOT NULL default '0', 
files_in_avail int(10) unsigned NOT NULL default '0', 
files_out_avail int(10) unsigned NOT NULL default '0',
files_xfer_avail int(10) unsigned NOT NULL default '0') 
TYPE=MyISAM;  
 
CREATE TABLE ftpquotatallies ( 
name varchar(30) NOT NULL default '', 
quota_type enum('user','group','class','all') NOT NULL default 'user', 
bytes_in_used int(10) unsigned NOT NULL default '0', 
bytes_out_used int(10) unsigned NOT NULL default '0', 
bytes_xfer_used int(10) unsigned NOT NULL default '0', 
files_in_used int(10) unsigned NOT NULL default '0', 
files_out_used int(10) unsigned NOT NULL default '0', 
files_xfer_used int(10) unsigned NOT NULL default '0' ) 
TYPE=MyISAM;  
 
CREATE TABLE ftpuser ( 
id int(10) unsigned NOT NULL auto_increment, 
userid varchar(32) NOT NULL default '', 
passwd varchar(32) NOT NULL default '', 
uid smallint(6) NOT NULL default '5500', 
gid smallint(6) NOT NULL default '5500', 
homedir varchar(255) NOT NULL default '', 
shell varchar(16) NOT NULL default '/sbin/nologin', 
count int(11) NOT NULL default '0', 
accessed datetime NOT NULL default '0000-00-00 00:00:00', 
modified datetime NOT NULL default '0000-00-00 00:00:00', 
PRIMARY KEY (id), UNIQUE KEY userid (userid) ) 
TYPE=MyISAM COMMENT='ProFTP user table';  
 
quit; 

# This is a basic ProFTPD configuration file (rename it to 
# 'proftpd.conf' for actual use.  It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName "ProFTPD Default Installation"
ServerType standalone
DefaultServer on
# Port 21 is the standard FTP port.
Port 21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# To prevent DoS attacks, set the maximum number of child processes
# to 30.  If you need to allow more than 30 concurrent connections
# at once, simply increase this value.  Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd).
MaxInstances 30
# Set the user and group under which the server will run.
User nobody
Group nogroup
DefaultRoot ~
# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes Plaintext Crypt
SQLAuthenticate users* groups*
# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo ftp@localhost proftpd password
# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo ftpuser userid passwd uid gid homedir shell
# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo ftpgroup groupname gid members
# set min UID and GID - otherwise these are 999 each
SQLMinID 500
# create a user's home directory on demand if it doesn't exist
SQLHomedirOnDemand on
# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
# Update modified everytime user uploads or deletes a file
SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
# User quotas
# ===========
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" ftpquotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
RootLogin off
RequireValidShell off

/etc/init.d/proftpd restart

mysql -u root -p
USE ftp;

INSERT INTO `ftpgroup` (`groupname`, `gid`, `members`) VALUES ('ftpgroup', 2001, 'ftpuser');

INSERT INTO `ftpquotalimits` (`name`, `quota_type`, `per_session`, `limit_type`, `bytes_in_avail`, `bytes_out_avail`, `bytes_xfer_avail`, `files_in_avail`, `files_out_avail`, `files_xfer_avail`) VALUES ('exampleuser', 'user', 'true', 'hard', 15728640, 0, 0, 0, 0, 0);
INSERT INTO `ftpuser` (`id`, `userid`, `passwd`, `uid`, `gid`, `homedir`, `shell`, `count`, `accessed`, `modified`) VALUES (1, 'exampleuser', 'secret', 2001, 2001, '/home/www.example.com', '/sbin/nologin', 0, '', '');
 
quit;

ls -l /home

quit;

groupadd -g 2002 anonymous_ftp
useradd -u 2002 -s /bin/false -d /home/anonymous_ftp -m -c "Anonymous FTP User" -g anonymous_ftp anonymous_ftp

mkdir /home/anonymous_ftp/incoming
chown anonymous_ftp:nogroup /home/anonymous_ftp/incoming

<Anonymous ~anonymous_ftp>
User anonymous_ftp   
Group nogroup   
# We want clients to be able to login with "anonymous" as well as "ftp"   
UserAlias anonymous anonymous_ftp   
# Cosmetic changes, all files belongs to ftp user   
DirFakeUser on anonymous_ftp
DirFakeGroup on anonymous_ftp   
RequireValidShell off   
# Limit the maximum number of anonymous logins   
MaxClients 10   
# We want 'welcome.msg' displayed at login, and '.message' displayed   
# in each newly chdired directory.   
DisplayLogin welcome.msg   
DisplayFirstChdir .message   
# Limit WRITE everywhere in the anonymous chroot   
<Directory *>     
<Limit WRITE>       
DenyAll     
</Limit>   
</Directory>   
# Uncomment this if you're brave.   
<Directory incoming>     
# Umask 022 is a good standard umask to prevent new files and dirs     
# (second parm) from being group and world writable.     
Umask 022  022
<Limit READ WRITE>              
DenyAll              
</Limit>             
<Limit STOR>
AllowAll
</Limit>   
</Directory> 
</Anonymous>

/etc/init.d/proftpd restart