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

proftpd serveur ftp
\n
le fichier de configuration se trouve l\u00e0:
\n
\/etc\/proftpd\/proftpd.conf (en document joint)<\/p>\n

La config est faite pour se connecter et s’identifier \u00e0 une base mysql.<\/p>\n

la doc compl\u00e8te est l\u00e0: doc ubuntu<\/a><\/p>\n

Nom de la base : proftpd
\n
mot de passe : password<\/p>\n

cr\u00e9ation de la base:<\/p>\n


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

cr\u00e9ation es tables<\/p>\n


\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

Cr\u00e9ation d’un utilisateur avec les droit en lecture\/ecriture:<\/p>\n


\nGRANT SELECT, INSERT, UPDATE, DELETE ON proftpd.* TO 'proftpd'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
\n<\/code><\/p>\n

Ajouter un utilisteur:
\n
\nINSERT INTO `ftpuser` ( `id`, `userid`, `passwd`, `uid`, `gid`, `homedir`, `shell`, `count`, `accessed` , `modified`, `LoginAllowed` ) VALUES ('', 'test', ENCRYPT('pwd'), '5500', '5500', '\/home\/ftp\/test', '\/bin\/false', '', '', '', 'true' );
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

proftpd serveur ftp le fichier de configuration se trouve l\u00e0: \/etc\/proftpd\/proftpd.conf (en document joint) La config est faite pour se connecter et s’identifier \u00e0 une base mysql. la doc compl\u00e8te est l\u00e0: doc ubuntu Nom de la base : proftpd mot de passe : password cr\u00e9ation de la base: CREATE DATABASE `proftpd`; USE proftpd; cr\u00e9ation […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","hentry","category-config_pc"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/posts\/34","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=34"}],"version-history":[{"count":0,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=\/wp\/v2\/posts\/34\/revisions"}],"wp:attachment":[{"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredptitgars.ovh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}