Accueil > Informatique > Config_PC > proftpd

proftpd

mardi 26 août 2008, par frederic

proftpd serveur ftp
le fichier de configuration se trouve là :
/etc/proftpd/proftpd.conf (en document joint)

La config est faite pour se connecter et s’identifier à une base mysql.

la doc complète est là : doc ubuntu

Nom de la base : proftpd
mot de passe : password

création de la base :

CREATE DATABASE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cHJvZnRwZDwvY29kZT4="></span>;
USE proftpd;

création es tables

-- 
-- Table structure for table <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwZ3JvdXA8L2NvZGU+"></span>
-- 
CREATE TABLE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwZ3JvdXA8L2NvZGU+"></span> (
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z3JvdXBuYW1lPC9jb2RlPg=="></span> varchar(16) NOT NULL DEFAULT '',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z2lkPC9jb2RlPg=="></span> smallint(6) NOT NULL DEFAULT '5500',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bWVtYmVyczwvY29kZT4="></span> varchar(16) NOT NULL DEFAULT '',
KEY <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z3JvdXBuYW1lPC9jb2RlPg=="></span> (<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z3JvdXBuYW1lPC9jb2RlPg=="></span>)
) TYPE=MyISAM COMMENT='Table des groupes ProFTPD';
 
-- 
-- Table structure for table <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwcXVvdGFsaW1pdHM8L2NvZGU+"></span>
-- 
CREATE TABLE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwcXVvdGFsaW1pdHM8L2NvZGU+"></span> (
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bmFtZTwvY29kZT4="></span> varchar(30) DEFAULT NULL,
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cXVvdGFfdHlwZTwvY29kZT4="></span> enum('user','group','class','all') NOT NULL DEFAULT 'user',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cGFyX3Nlc3Npb248L2NvZGU+"></span> enum('false','true') NOT NULL DEFAULT 'false',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bGltaXRfdHlwZTwvY29kZT4="></span> enum('soft','hard') NOT NULL DEFAULT 'soft',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfdXBfbGltaXQ8L2NvZGU+"></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfZG93bl9saW1pdDwvY29kZT4="></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfdHJhbnNmZXJfbGltaXQ8L2NvZGU+"></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfdXBfbGltaXQ8L2NvZGU+"></span> int(10) UNSIGNED NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfZG93bl9saW1pdDwvY29kZT4="></span> int(10) UNSIGNED NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfdHJhbnNmZXJfbGltaXQ8L2NvZGU+"></span> int(10) UNSIGNED NOT NULL DEFAULT '0'
) TYPE=MyISAM COMMENT='Table des quotas ProFTPD';
 
-- 
-- Table structure for table <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwcXVvdGF0b3RhbDwvY29kZT4="></span>
-- 
CREATE TABLE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwcXVvdGF0b3RhbDwvY29kZT4="></span> (
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bmFtZTwvY29kZT4="></span> varchar(30) NOT NULL DEFAULT '',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cXVvdGFfdHlwZTwvY29kZT4="></span> enum('user','group','class','all') NOT NULL DEFAULT 'user',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfdXBfdG90YWw8L2NvZGU+"></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfZG93bl90b3RhbDwvY29kZT4="></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Ynl0ZXNfdHJhbnNmZXJfdG90YWw8L2NvZGU+"></span> float NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfdXBfdG90YWw8L2NvZGU+"></span> int(10) UNSIGNED NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfZG93bl90b3RhbDwvY29kZT4="></span> int(10) UNSIGNED NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZmlsZXNfdHJhbnNmZXJfdG90YWw8L2NvZGU+"></span> int(10) UNSIGNED NOT NULL DEFAULT '0'
) TYPE=MyISAM COMMENT='Table des compteurs des quotas ProFTPD';
 
-- 
-- Table structure for table <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwdXNlcjwvY29kZT4="></span>
-- 
CREATE TABLE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwdXNlcjwvY29kZT4="></span> (
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+aWQ8L2NvZGU+"></span> int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+dXNlcmlkPC9jb2RlPg=="></span> varchar(32) NOT NULL DEFAULT '',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cGFzc3dkPC9jb2RlPg=="></span> varchar(32) NOT NULL DEFAULT '',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+dWlkPC9jb2RlPg=="></span> smallint(6) NOT NULL DEFAULT '5500',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z2lkPC9jb2RlPg=="></span> smallint(6) NOT NULL DEFAULT '5500',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+aG9tZWRpcjwvY29kZT4="></span> varchar(255) NOT NULL DEFAULT '',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+c2hlbGw8L2NvZGU+"></span> varchar(16) NOT NULL DEFAULT '/bin/false',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Y291bnQ8L2NvZGU+"></span> int(11) NOT NULL DEFAULT '0',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+YWNjZXNzZWQ8L2NvZGU+"></span> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bW9kaWZpZWQ8L2NvZGU+"></span> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+TG9naW5BbGxvd2VkPC9jb2RlPg=="></span> enum('true','false') NOT NULL DEFAULT 'true',
PRIMARY KEY (<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+aWQ8L2NvZGU+"></span>)
) TYPE=MyISAM COMMENT='Table des utlisateurs ProFTPD';

Création d’un utilisateur avec les droit en lecture/ecriture :

GRANT SELECT, INSERT, UPDATE, DELETE ON proftpd.* TO 'proftpd'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Ajouter un utilisteur :

INSERT INTO <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZnRwdXNlcjwvY29kZT4="></span> ( <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+aWQ8L2NvZGU+"></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+dXNlcmlkPC9jb2RlPg=="></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+cGFzc3dkPC9jb2RlPg=="></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+dWlkPC9jb2RlPg=="></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Z2lkPC9jb2RlPg=="></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+aG9tZWRpcjwvY29kZT4="></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+c2hlbGw8L2NvZGU+"></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+Y291bnQ8L2NvZGU+"></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+YWNjZXNzZWQ8L2NvZGU+"></span> , <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bW9kaWZpZWQ8L2NvZGU+"></span>, <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+TG9naW5BbGxvd2VkPC9jb2RlPg=="></span> ) VALUES ('', 'test', ENCRYPT('pwd'), '5500', '5500', '/home/ftp/test', '/bin/false', '', '', '', 'true' );

Voir en ligne : site proftpd