#--------------------installas-------------------------------------
apt-get install pure-ftpd-mysql

#config diras /etc/pure-ftpd

####ftpuser

groupadd ftp
useradd -s /bin/false -d /home/ftp -m -c "anonymous ftp" -g ftp ftp


####anonymous foldzheris
mkdir /home/ftp/incoming
chown ftp:nogroup /home/ftp/incoming/
#useriai gali tik atsiust failus, kad galetu ir skaityt reikia adminui perkelt failus i /home/ftp/
#arba nustatyt permissionus an 555
chmod 311 /home/ftp/incoming/


chmod 555 /home/ftp/

#--------MySQL

CREATE TABLE `ftpd` (
`user` varchar(16) NOT NULL default '',
`enabled` tinyint(1) default '1',
`pass` varchar(64) NOT NULL default '',
`uid` varchar(11) NOT NULL default '2001',
`gid` varchar(11) NOT NULL default '2001',
`dir` varchar(128) NOT NULL default '/home/<userdir>',
`ulbandwidth` smallint(5) NOT NULL default '0',
`dlbandwidth` smallint(5) NOT NULL default '0',
`comment` tinytext NOT NULL,
`ipaccess` varchar(15) NOT NULL default '*',
`quotasize` smallint(5) NOT NULL default '0',
`quotafiles` int(11) NOT NULL default '0',
PRIMARY KEY (`user`),
UNIQUE KEY `user` (`user`),
KEY `enabled` (`enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii;



#pure-ftd uzeris
CREATE DATABASE pureftpd;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO 'pureftpd'@'localhost' IDENTIFIED BY 'PAAAAAAAAAASSWWWWWWWWWWWWWOOOOOOOORRRRRRRRDAS';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO 'pureftpd'@'localhost.localdomain' IDENTIFIED BY 'PAAAAAAAAAASSWWWWWWWWWWWWWOOOOOOOORRRRRRRRDAS';
FLUSH PRIVILEGES;

#--useriai
INSERT INTO `ftpd` VALUES ('test', 1, MD5('test'), '2001', '2001', '/home/test', 3000, 40, '', '*', 500, 0);

#-------------------------------------------------------------------------
#
echo "
MYSQLSocket /var/run/mysqld/mysqld.sock
#MYSQLServer localhost
#MYSQLPort 3306
MYSQLUser pureftpd
MYSQLPassword PAAAAAAAAAASSWWWWWWWWWWWWWOOOOOOOORRRRRRRRDAS
MYSQLDatabase pureftpd


#MYSQLCrypt md5, cleartext, crypt() or password() - md5 is VERY RECOMMENDABLE uppon cleartext
MYSQLCrypt md5

MYSQLGetPW SELECT pass FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT uid FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT gid FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT dir FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ulbandwidth FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT dlbandwidth FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ SELECT quotasize FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTAFS SELECT quotafiles FROM ftpd WHERE user="\L" AND enabled="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")

/// galim per kabliataski pridet antra uzklausa tarkim UPDATE ftpd SET logintry=logintry+1 WHERE user="\L"
" > /etc/pure-ftpd/db/mysql.conf


-----------------------------------------------------------------------

#sitas reikalingas nes kitaip visa laik rodys pilna kelia
echo "yes" > /etc/pure-ftpd/conf/ChrootEveryone
#nustatys kad gali jungtis anonimusai
echo "no" > /etc/pure-ftpd/conf/NoAnonymous
#
echo "yes" > /etc/pure-ftpd/conf/AnonymousCanCreateDirs
#<max sessions per user>:<max anonymous sessions> // paleidimo paramsas -y 3:20
echo "3 20" > /etc/pure-ftpd/conf/PerUserLimits
# Maximum number of sim clients with the same IP address
echo "8" > /etc/pure-ftpd/conf/MaxClientsPerIP

#-------------------------------------------------
# Maximum bandwidth for anonymous users in KB/s
echo "40" > /etc/pure-ftpd/conf/AnonymousBandwidth
#-------------------------------------------------
Papildomi nustatymai

#ziureti pagal failus
http://uostas.net/repository/linux/pure-ftpd/pure-config.pl
http://uostas.net/repository/linux/pure-ftpd/pure-ftpd.conf

--------------DEBUGINIMAS------------------------------------



#JEIGU SERVERIS UZ NAT
#pirma problema gali but kad nepraleidzia routeris aukstu portu
#ant ruteriu daznai buna opcija "enable ftp helper"


#ziureti logus
cat /var/log/messages | grep pure-ftpd
cat /var/log/syslog | grep pure-ftpd

#zet mysql uzklausas

nano /etc/mysql/my.cnf

#ties cia nuimt "#" nuo sitos eilutes "#log=/var/log/mysql/mysql.log"
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log


/etc/init.d/pure-ftpd-mysql restart
#jeigu
#nebus sito : -l mysql:/etc/pure-ftpd/db/mysql.conf
#ftpd nekontaktuos su mysql serveriu
# Running: /usr/sbin/pure-ftpd-mysql -l mysql:/etc/pure-ftpd/db/mysql.conf -B



buvo problema kazkotais nesuveikdavo
tai padariau
apt-get remove pure-ftpd-mysql
apt-get install pure-ftpd-mysql
ir suveike
greiciausiai del to kad
/etc/pure-ftpd/auth viduje turi but
linkas 30mysql su location ../conf/MySQLConfigFile
:P lameris...

linkai
http://www.howtoforge.org/virtual-hosting-with-pureftpd-and-mysql-ubuntu-7.10
http://www.pureftpd.org/project/pure-ftpd
http://uostas.net/repository/linux/pure-ftpd/mano%20etc-pure-ftpd/

aciu