{"id":44,"date":"2008-08-26T09:24:06","date_gmt":"2008-08-26T07:24:06","guid":{"rendered":"http:\/\/wp1.fredptitgars.net\/index.php\/2008\/08\/26\/installation-de-proftp\/"},"modified":"2008-08-26T09:24:06","modified_gmt":"2008-08-26T07:24:06","slug":"installation-de-proftp","status":"publish","type":"post","link":"https:\/\/fredptitgars.ovh\/?p=44","title":{"rendered":"Installation de proftp"},"content":{"rendered":"

comme d’hab:<\/p>\n


\napt-get install proftpd proftpd-mysql
\n<\/code><\/p>\n

le lancement se fait par inetd<\/p>\n

la cr\u00e9ation des tables:<\/p>\n


\nCREATE DATABASE `proftpd`;
\nUSE proftpd;<\/p>\n

— 
\n
— Table structure for table `ftpgroup`
\n
— 
\nCREATE TABLE `ftpgroup` (
\n`groupname` varchar(16) NOT NULL DEFAULT '',
\n`gid` smallint(6) NOT NULL DEFAULT '5500',
\n`members` varchar(16) NOT NULL DEFAULT '',
\nKEY `groupname` (`groupname`)
\n) TYPE=MyISAM COMMENT='Table des groupes ProFTPD';<\/p>\n

— 
\n
— Table structure for table `ftpquotalimits`
\n
— 
\nCREATE TABLE `ftpquotalimits` (
\n`name` varchar(30) DEFAULT NULL,
\n`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
\n`par_session` enum('false','true') NOT NULL DEFAULT 'false',
\n`limit_type` enum('soft','hard') NOT NULL DEFAULT 'soft',
\n`bytes_up_limit` float NOT NULL DEFAULT '0',
\n`bytes_down_limit` float NOT NULL DEFAULT '0',
\n`bytes_transfer_limit` float NOT NULL DEFAULT '0',
\n`files_up_limit` int(10) UNSIGNED NOT NULL DEFAULT '0',
\n`files_down_limit` int(10) UNSIGNED NOT NULL DEFAULT '0',
\n`files_transfer_limit` int(10) UNSIGNED NOT NULL DEFAULT '0'
\n) TYPE=MyISAM COMMENT='Table des quotas ProFTPD';<\/p>\n

— 
\n
— Table structure for table `ftpquotatotal`
\n
— 
\nCREATE TABLE `ftpquotatotal` (
\n`name` varchar(30) NOT NULL DEFAULT '',
\n`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
\n`bytes_up_total` float NOT NULL DEFAULT '0',
\n`bytes_down_total` float NOT NULL DEFAULT '0',
\n`bytes_transfer_total` float NOT NULL DEFAULT '0',
\n`files_up_total` int(10) UNSIGNED NOT NULL DEFAULT '0',
\n`files_down_total` int(10) UNSIGNED NOT NULL DEFAULT '0',
\n`files_transfer_total` int(10) UNSIGNED NOT NULL DEFAULT '0'
\n) TYPE=MyISAM COMMENT='Table des compteurs des quotas ProFTPD';<\/p>\n

— 
\n
— Table structure for table `ftpuser`
\n
— 
\nCREATE TABLE `ftpuser` (
\n`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
\n`userid` varchar(32) NOT NULL DEFAULT '',
\n`passwd` varchar(32) NOT NULL DEFAULT '',
\n`uid` smallint(6) NOT NULL DEFAULT '5500',
\n`gid` smallint(6) NOT NULL DEFAULT '5500',
\n`homedir` varchar(255) NOT NULL DEFAULT '',
\n`shell` varchar(16) NOT NULL DEFAULT '\/bin\/false',
\n`count` int(11) NOT NULL DEFAULT '0',
\n`accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
\n`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
\n`LoginAllowed` enum('true','false') NOT NULL DEFAULT 'true',
\nPRIMARY KEY (`id`)
\n) TYPE=MyISAM COMMENT='Table des utlisateurs ProFTPD';
\n<\/code><\/p>\n

La config de proftp dans le fichier \/etc\/proftpd\/proftpd.conf:<\/p>\n

on d\u00e9commente:<\/p>\n


\nDefaultRoot  
\nRequireValidShell off
\n
\n SQLBackend mysql
\n<\/IfModule>
\n<\/code><\/p>\n

on ajoute \u00e0 la fin: <\/p>\n


\n# Mod MySQL
\n# =========
\n# Les mots de passe sont cryptes dans la base avec la fonction ENCRYPT (MySQL)
\nSQLAuthTypes Crypt
\nSQLAuthenticate users* groups*<\/p>\n

# Modifiez cette ligne selon l'utilisateur et le mot de passe definit plutot
\nSQLConnectInfo proftpd@localhost proftpd proftpd<\/p>\n

# On donne a ProFTPd le nom des colonnes de la table usertable
\nSQLUserInfo ftpuser userid passwd uid gid homedir shell
\nSQLUserWhereClause \"LoginAllowed = 'true'\"<\/p>\n

# On donne a ProFTPd le nom des colonnes de la table \"grouptable\"
\nSQLGroupInfo ftpgroup groupname gid members<\/p>\n

# Creer le repertoire home de l'utilisateur si il n'existe pas
\nSQLHomedirOnDemand on<\/p>\n

# Met a jour les compteurs a chaque connection d'un utilisateur
\nSQLLog PASS updatecount
\nSQLNamedQuery updatecount UPDATE \"count=count+1, accessed=now() WHERE userid='%u'\" ftpuser<\/p>\n

#Met a jour les compteurs a chaque upload ou download d'un utilisateur
\nSQLLog STOR,DELE modified
\nSQLNamedQuery modified UPDATE \"modified=now() WHERE userid='%u'\" ftpuser<\/p>\n

# Mod quota
\n# =========
\nQuotaEngine on
\nQuotaDirectoryTally on
\nQuotaDisplayUnits Mb
\nQuotaShowQuotas on<\/p>\n

# Definit les requetes SQL pour que ProFTPd recupere les infos sur les quotas
\nSQLNamedQuery get-quota-limit SELECT \"name, quota_type, par_session, limit_type, bytes_up_limit, bytes_down_limit, bytes_transfer_limit, files_up_limit, files_down_limit, files_transfer_limit FROM ftpquotalimits WHERE name = '%0<\/em>' AND quota_type = '%1<\/em>'\"
\nSQLNamedQuery get-quota-tally SELECT \"name, quota_type, bytes_up_total, bytes_down_total, bytes_transfer_total, files_up_total, files_down_total, files_transfer_total FROM ftpquotatotal WHERE name = '%0<\/em>' AND quota_type = '%1<\/em>'\"
\nSQLNamedQuery update-quota-tally UPDATE \"bytes_up_total = bytes_up_total + %0<\/em>, bytes_down_total = bytes_down_total + %1<\/em>, bytes_transfer_total = bytes_transfer_total + %2<\/em>, files_up_total = files_up_total + %3<\/em>, files_down_total = files_down_total + %4<\/em>, files_transfer_total = files_transfer_total + %5<\/em> WHERE name = '%6<\/em>' AND quota_type = '%7<\/em>'\" ftpquotatotal
\nSQLNamedQuery insert-quota-tally INSERT \"%0<\/em>, %1<\/em>, %2<\/em>, %3<\/em>, %4<\/em>, %5<\/em>, %6<\/em>, %7<\/em>\" ftpquotatotal<\/p>\n

QuotaLimitTable sql:\/get-quota-limit
\nQuotaTallyTable sql:\/get-quota-tally\/update-quota-tally\/insert-quota-tally<\/p>\n

# Gestion des logs
\n# ================
\n# Enregistre les requetes SQL dans \/var\/log\/proftpd\/mysql.log
\nSQLLogFile \/var\/log\/proftpd\/mysql.log<\/p>\n

# Enregistre les authentifications
\nLogFormat auth \"%v [%P] %h %t \\\"%r\\\" %s\"
\nExtendedLog \/var\/log\/proftpd\/auth.log AUTH auth<\/p>\n

# Enregistre les acces aux fichiers
\nLogFormat write \"%h %l %u %t \\\"%r\\\" %s %b\"
\nExtendedLog \/var\/log\/proftpd\/access.log WRITE,READ write<\/p>\n

<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

comme d’hab: apt-get install proftpd proftpd-mysql le lancement se fait par inetd la cr\u00e9ation des tables: CREATE DATABASE `proftpd`; USE proftpd; —  — Table structure for table `ftpgroup` —  CREATE TABLE `ftpgroup` ( `groupname` varchar(16) NOT NULL DEFAULT \u00a0\u00bb, `gid` smallint(6) NOT NULL DEFAULT ‘5500’, `members` varchar(16) NOT NULL DEFAULT \u00a0\u00bb, KEY `groupname` (`groupname`) ) TYPE=MyISAM […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-poweredge-t105"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/posts\/44","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=44"}],"version-history":[{"count":0,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions"}],"wp:attachment":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}