Kleine Sache hab ich noch (bitte):
Ich kann auf dem Server nur mit der Standartkofniguration zugreifen.
Ich benutze folgende Konfig:
ServerName "SERVERNAME"
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User nobody
Group nogroup
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
# FXP Unterstuetzung
#AllowForeignAddress off
# Maximal Werte setzen
MaxClientsPerHost 2 "Nicht mehr als %m Verbindungen"
MaxClients 50 "Leider sind schon %m Clients verbunden"
MaxLoginAttempts 3
# Restart erlauben
#AllowStoreRestart on
#AllowRetrieveRestart on
# Jail all users into their virtual home dir
DefaultRoot ~
#RequireValidShell off
# Logging options
TransferLog /var/log/proftpd.xferlog
# Some logging formats
LogFormat auth "%v [%P] %h %t \"%r\" %s"
# Record all logins
ExtendedLog /var/log/proftpd.auth_log AUTH auth
#------------------------mysql Modul: 4.x
# Zugangskontrolle
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo ftpserver @localhost ftpserver SAGICHNICHT
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo users username password uid gid homedir shell
# aktive SQL Kommandos, ab hier passiert etwas :-)
SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" users
# 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
# mod_quota tab
QuotaEngine on
QuotaShowQuotas on
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
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 quotalimits 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 quotatallies 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}'" quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies
Der Server startet einwandfrei. Aber ich kann dann nicht mehr drauf zugreifen.
Folgende MySQL-Tabellen (in der Datenbank "ftpserver") sind angelegt:
# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 20. April 2004 um 13:30
# Server Version: 3.23.55
# PHP-Version: 4.3.1
# Datenbank: `ftpserver`
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `quotalimits`
#
CREATE TABLE quotalimits (
name varchar(30) default NULL,
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 'soft',
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'
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `quotatallies`
#
CREATE TABLE quotatallies (
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'
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `users`
#
CREATE TABLE users (
username varchar(60) binary default NULL,
uid int(11) default NULL,
gid int(11) default NULL,
password varchar(30) default NULL,
homedir varchar(250) default NULL,
count int(11) default NULL,
ui bigint(20) NOT NULL auto_increment,
shell varchar(60) default NULL,
letzter_zugriff datetime default NULL,
zugang char(1) default NULL,
PRIMARY KEY (ui)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xfer_stat`
#
CREATE TABLE xfer_stat (
username tinytext,
filename text,
size bigint(20) default NULL,
host tinytext,
ip tinytext,
aktion tinytext,
dauer tinytext,
zeit_lokal datetime default NULL,
success char(1) default NULL,
ui bigint(20) NOT NULL auto_increment,
PRIMARY KEY (ui)
) TYPE=MyISAM;
Woran kann das liegen?
