playskool | godjc a écrit :
PlaySkool, pourrais tu s il te plait me ettre une copie de tes fichiers proftpd.conf et db_structure.sql ?
Sa fait trois semaine que je rame pour installer proftpd_admin! Mon probleme doit etre réduit a une simple erreur de casse ou de config;
merci par avance.
|
Proftpd.conf (tu dois adapter la ligne SQLConnectInfo nomBaseDeDonnée@localhost utilisateurBD motdepasse):
(Fait bien attention aux modules lancés avec proftpd si le mod_sql est pas lancé, ca va déconner...
Code :
- ServerName "KuroFTPServer"
- ServerType standalone
- ServerIdent on "Servers identifying string"
- DeferWelcome off
- MultilineRFC2228 on
- DefaultServer on
- ShowSymlinks on
- DisplayLogin .welcome # Textfile to display on login
- #DisplayConnect .connect # Textfile to display on connection
- #DisplayFirstChdir .firstchdir # Textfile to display on first changedir
- #UseReverseDNS off
- #IdentLookups off
- Port 21
- Umask 022
- PassivePorts 49000 49100
- MasqueradeAddress greg-web.no-ip.org
- TimeoutNoTransfer 3000
- TimeoutStalled 3000
- TimeoutIdle 5000
- MaxInstances 15
- MaxClientsPerHost 2 "Seulement %m connexions simultanées par utilisateur"
- MaxClients 5 "Seulement %m utilisateurs connectés simultanéement"
- #MaxHostsPerUser 1
- User nobody
- Group nogroup
- ScoreboardFile /var/log/scoreboard
- # Some logging formats
- LogFormat default "%h %l %u %t \"%r\" %s %b"
- LogFormat auth "%v [%P] %h %t \"%r\" %s"
- LogFormat write "%h %l %u %t \"%r\" %s %b"
- # Define log-files to use
- TransferLog /var/log/proftpd.xferlog
- ExtendedLog /var/log/proftpd.access_log WRITE,READ write
- ExtendedLog /var/log/proftpd.auth_log AUTH auth
- ExtendedLog /var/log/proftpd.paranoid_log ALL default
- SQLLogFile /var/log/proftpd.mysql
- QuotaLog /var/log/proftpd.quota
- # Set up authentication via SQL
- # ===========
- AuthOrder mod_sql.c
- SQLAuthTypes Backend
- SQLConnectInfo proftpd_admin@localhost proftpd motdepasse
- SQLUserInfo usertable userid passwd uid gid homedir shell
- SQLGroupInfo grouptable groupname gid members
- SQLUserWhereClause "disabled=0 and (NOW()<=expiration or expiration=-1 or expiration=0)"
- # Log the user logging in
- SQLLog PASS counter
- SQLNamedQuery counter UPDATE "lastlogin=now(), count=count+1 WHERE userid='%u'" usertable
- # logout log
- SQLLog EXIT time_logout
- SQLNamedQuery time_logout UPDATE "lastlogout=now() WHERE userid='%u'" usertable
- # display last login time when PASS command is given
- SQLNamedQuery login_time SELECT "lastlogin from usertable where userid='%u'"
- SQLShowInfo PASS "230" "Last login was: %{login_time}"
- # xfer Log in mysql
- SQLLog RETR,STOR transfer1
- SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL" xfer_stat
- SQLLOG ERR_RETR,ERR_STOR transfer2
- SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL" xfer_stat
- # User quotas
- # ===========
- QuotaEngine on
- QuotaDirectoryTally on
- QuotaDisplayUnits Mb
- QuotaShowQuotas on
- SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
- SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
- SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" ftpquotatallies
- SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
- QuotaLimitTable sql:/get-quota-limit
- QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
- AllowStoreRestart on
- AllowRetrieveRestart on
- RequireValidShell off
- PathDenyFilter "\\.ftp)|\\.ht)[a-z]+$"
- DefaultRoot ~
- DenyFilter \*.*/
- <Directory /ftp/*>
- AllowOverwrite off
- HideNoAccess off
- <Limit READ>
- AllowAll
- </Limit>
- <Limit WRITE>
- DenyGroup !admins
- </Limit>
- </Directory>
-
- <Directory />
- AllowOverwrite off
- HideNoAccess off
- <Limit READ>
- DenyGroup users
- </Limit>
- <Limit STOR MKD>
- DenyGroup !admins
- </Limit>
- </Directory>
-
- <Directory /ftp/incoming/*>
- AllowOverwrite on
- HideNoAccess on
- <Limit READ>
- DenyGroup !admins
- </Limit>
- <Limit STOR MKD>
- AllowAll
- </Limit>
- </Directory>
|
Par contre j'ai plus le fichier db_structure alors je te mets une extraction avec phpmyadmin :
Code :
- -- phpMyAdmin SQL Dump
- -- version 2.8.0.3-Debian-1
- -- http://www.phpmyadmin.net
- --
- -- Serveur: localhost
- -- Généré le : Jeudi 03 Août 2006 à 07:34
- -- Version du serveur: 5.0.22
- -- Version de PHP: 5.1.2-1+b1
- --
- -- Base de données: `proftpd_admin`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `ftpquotalimits`
- --
- DROP TABLE IF EXISTS `ftpquotalimits`;
- CREATE TABLE `ftpquotalimits` (
- `name` varchar(30) NOT NULL default '',
- `quota_type` enum('user','group','class','all') NOT NULL default 'user',
- `per_session` enum('false','true') NOT NULL default 'false',
- `limit_type` enum('soft','hard') NOT NULL default 'hard',
- `bytes_in_avail` float NOT NULL default '0',
- `bytes_out_avail` float NOT NULL default '0',
- `bytes_xfer_avail` float NOT NULL default '0',
- `files_in_avail` int(10) unsigned NOT NULL default '0',
- `files_out_avail` int(10) unsigned NOT NULL default '0',
- `files_xfer_avail` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`name`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Structure de la table `ftpquotatallies`
- --
- DROP TABLE IF EXISTS `ftpquotatallies`;
- CREATE TABLE `ftpquotatallies` (
- `name` varchar(30) NOT NULL default '',
- `quota_type` enum('user','group','class','all') NOT NULL default 'user',
- `bytes_in_used` float NOT NULL default '0',
- `bytes_out_used` float NOT NULL default '0',
- `bytes_xfer_used` float NOT NULL default '0',
- `files_in_used` int(10) unsigned NOT NULL default '0',
- `files_out_used` int(10) unsigned NOT NULL default '0',
- `files_xfer_used` int(10) unsigned NOT NULL default '0'
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Structure de la table `grouptable`
- --
- DROP TABLE IF EXISTS `grouptable`;
- CREATE TABLE `grouptable` (
- `groupname` text,
- `gid` int(11) NOT NULL auto_increment,
- `members` text,
- `description` tinytext,
- PRIMARY KEY (`gid`),
- UNIQUE KEY `gid_2` (`gid`),
- KEY `gid` (`gid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Structure de la table `usertable`
- --
- DROP TABLE IF EXISTS `usertable`;
- CREATE TABLE `usertable` (
- `userid` text,
- `passwd` text,
- `homedir` text,
- `shell` text,
- `uid` int(11) NOT NULL auto_increment,
- `gid` int(11) default NULL,
- `count` int(11) NOT NULL default '0',
- `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
- `lastlogout` datetime NOT NULL default '0000-00-00 00:00:00',
- `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
- `disabled` tinyint(4) default '0',
- `det_name` tinytext,
- `det_mail` tinytext,
- `det_adress` tinytext,
- `det_notes` tinytext,
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Structure de la table `xfer_stat`
- --
- DROP TABLE IF EXISTS `xfer_stat`;
- CREATE TABLE `xfer_stat` (
- `userid` text,
- `file` text,
- `size` bigint(20) default '0',
- `address_full` text,
- `address_ip` text,
- `command` text,
- `timespent` text,
- `time` text,
- `cmd` text,
- `dunno` text
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
---------------
See More | Hear More | Feel More | Play More ...
|
). Par contre proftpd est très complet, donc j'utilise pas 5% de ses capacitées (que je ne connais pas bien d'ailleurs).
