Gavrinis Open your mind | oui mais j'ai quand même pensé à vérifier la structure des tables avant de poster et elles ne sont pas les mêmes justement.
ProFTPd : Code :
- CREATE DATABASE `proftpd`;
- USE proftpd;
- --
- -- Table structure for table `ftpgroup`
- --
- 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='Table des groupes ProFTPD';
- --
- -- Table structure for table `ftpquotalimits`
- --
- CREATE TABLE `ftpquotalimits` (
- `name` varchar(30) default NULL,
- `quota_type` enum('user','group','class','all') NOT NULL default 'user',
- `par_session` enum('false','true') NOT NULL default 'false',
- `limit_type` enum('soft','hard') NOT NULL default 'soft',
- `bytes_up_limit` float NOT NULL default '0',
- `bytes_down_limit` float NOT NULL default '0',
- `bytes_transfer_limit` float NOT NULL default '0',
- `files_up_limit` int(10) unsigned NOT NULL default '0',
- `files_down_limit` int(10) unsigned NOT NULL default '0',
- `files_transfer_limit` int(10) unsigned NOT NULL default '0'
- ) TYPE=MyISAM COMMENT='Table des quotas ProFTPD';
- --
- -- Table structure for table `ftpquotatotal`
- --
- CREATE TABLE `ftpquotatotal` (
- `name` varchar(30) NOT NULL default '',
- `quota_type` enum('user','group','class','all') NOT NULL default 'user',
- `bytes_up_total` float NOT NULL default '0',
- `bytes_down_total` float NOT NULL default '0',
- `bytes_transfer_total` float NOT NULL default '0',
- `files_up_total` int(10) unsigned NOT NULL default '0',
- `files_down_total` int(10) unsigned NOT NULL default '0',
- `files_transfer_total` int(10) unsigned NOT NULL default '0'
- ) TYPE=MyISAM COMMENT='Table des compteurs des quotas ProFTPD';
- --
- -- Table structure for table `ftpuser`
- --
- 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 '/bin/false',
- `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',
- `LoginAllowed` enum('true','false') NOT NULL default 'true',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM COMMENT='Table des utlisateurs ProFTPD';
|
Ppmy : Code :
- --
- -- Table structure for table 'groups'
- --
- CREATE TABLE groups (
- groupid varchar(10) NOT NULL default '',
- gid int(10) unsigned NOT NULL auto_increment,
- members varchar(255) NOT NULL default '',
- PRIMARY KEY (gid)
- ) TYPE=MyISAM;
- --
- -- Table structure for table 'users'
- --
- CREATE TABLE users (
- userid varchar(10) NOT NULL default '',
- uid int(10) unsigned NOT NULL auto_increment,
- gid int(10) unsigned NOT NULL default '0',
- passwd varchar(255) NOT NULL default '',
- homedir varchar(255) NOT NULL default '',
- description varchar(255) NOT NULL default '',
- disabled int(10) unsigned NOT NULL default '0',
- shell varchar(20) NOT NULL default '',
- expires datetime NOT NULL default '0000-00-00 00:00:00',
- email varchar(255) NOT NULL default '',
- name varchar(255) NOT NULL default '',
- ul_bytes bigint(20) NOT NULL default '0',
- dl_bytes bigint(20) NOT NULL default '0',
- login_count bigint(20) NOT NULL default '0',
- dl_count bigint(20) NOT NULL default '0',
- ul_count bigint(20) NOT NULL default '0',
- last_login datetime default NULL,
- PRIMARY KEY (uid)
- ) TYPE=MyISAM;
- INSERT INTO users (uid) VALUES (10000);
- INSERT INTO groups (gid) VALUES (10000);
- DELETE FROM users WHERE uid=10000;
- DELETE FROM groups WHERE gid=10000;
- GRANT ALL ON users TO proftpd@localhost IDENTIFIED BY 'proftpd';
- GRANT ALL ON groups TO proftpd@localhost IDENTIFIED BY 'proftpd';
|
|