Einlog-Problem mit ProFTPD

Backup, Restore und Transfer von Daten
salnet
Posts: 50
Joined: 2002-07-14 00:59
Location: Bonn
 

Einlog-Problem mit ProFTPD

Post by salnet »

Hallo Leute,
ich habe hier ein Problem mit ProFTPD auf meiner Kiste.
Ich bekomme einfach keinen Login auf dem FTP-Server. proftpd läuft, bringt aber beim Starten eine Hinweismeldung mit sich:

Code: Select all

# /etc/init.d/proftpd restart
Stopping ftp server: proftpd.
Starting ftp server: proftpd - IPv6 getaddrinfo 'meinhostname.meintestserver.de' error: Name or service not known
.
ProFTPD ist dann aber trotzdem gestartet.

Code: Select all

Status:	Verbinden mit ftp.meintestserver.de...
Status:	Verbunden mit ftp.meintestserver.de. Warten auf Willkommens-Meldung...
Antwort:	220 ProFTPD 1.3.0 Server (Debian) [80.00.00.00]
Befehl:	USER meinftp@meintestserver.de
Antwort:	331 Password required for meinftp@meintestserver.de.
Befehl:	PASS ********
Antwort:	530 Login incorrect.
Fehler:	Verbindung kann nicht hergestellt werden!
Es geht weder vom integrierten Filemanager in VHCS noch vom FTP-Prog auf meinem Rechner.

Ich habe echt keinen Plan, was ich machen könnte.
Die proftpd.conf ist zwei mal vorhanden. Einmal die von vhcs geänderte /etc/proftp.conf und einmal die Originale von ProFTPD in /etc/proftpd/proftpd.conf
Ich habe schon beide proftpd.conf versucht zu benutzen, jedoch ohne Erfolg. ProFTPD ist mit mySQL-Support installiert.

/etc/proftpd.conf

Code: Select all

#
#       VHCS proftpd config file
#
#
#
# Includes required DSO modules. This is mandatory in proftpd 1.3
#
#Include /etc/proftpd/modules.conf

ServerName                      "meinhostname"
ServerType                      standalone
DeferWelcome                    off

ShowSymlinks                    on
MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on
AllowOverwrite                  on
UseReverseDNS                   off
IdentLookups                    off
AllowStoreRestart               on
AllowForeignAddress             on

LogFormat                       traff "%b %u"

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayFirstChdir               .message

#LsDefaultOptions                "-l"

DenyFilter                      *.*/

DefaultRoot                     ~

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd               off

# Port 21 is the standard FTP port.

Port                            21

# To prevent DoS attacks, set the maximum number of child processes
# to 30.  If you need to allow more than 30 concurrent connections
# at once, simply increase this value.  Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)

MaxInstances                    30

# Set the user and group that the server normally runs at.

User                            nobody
Group                           nogroup

# Normally, we want files to be overwriteable.

<Directory /*>
  # Umask 022 is a good standard umask to prevent new files and dirs
  # (second parm) from being group and world writable.
  Umask                         022  022

  AllowOverwrite                on
  HideNoAccess                  on

</Directory>

<Limit ALL>
  IgnoreHidden                  on
</Limit>

<Global>
  RootLogin                     off
  TransferLog                   /var/log/xferlog
  ExtendedLog                   /var/log/ftp_traff.log read,write traff
  PathDenyFilter                ".quota$"
</Global>

<IfModule mod_delay.c>
        DelayEngine off
</IfModule>

#
# VHCS2 Managment;
#
#SQLBackend                     mysql           # Enable for Proftpd >= 1.3
SQLAuthTypes                    Crypt
SQLAuthenticate                 on
SQLConnectInfo                  vhcs2@localhost vftp
SQLUserInfo                     ftp_users userid passwd uid gid homedir shell
SQLGroupInfo                    ftp_group groupname gid members
SQLMinID                        2000

#
# VHCS2 Quota management;
#

QuotaEngine                     on
QuotaShowQuotas                 on
QuotaDisplayUnits               Mb

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_av
ail, 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 quot
atallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, b
ytes_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}, f
iles_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

QuotaLock                       /var/run/proftpd/tally.lock
QuotaLimitTable                 sql:/get-quota-limit
QuotaTallyTable                 sql:/get-quota-tally/update-quota-tally/insert-q
uota-tally

#
# SSL via TLS
#
#<IfModule mod_tls.c>
#  TLSEngine                    on
#  TLSLog                       /var/log/proftp/ftp_ssl.log
#  TLSProtocol                  SSLv23
#  TLSOptions                   NoCertRequest
#  TLSRSACertificateFile                /etc/apache2/ssl/ylabs.de.crt
#  TLSRSACertificateKeyFile     /etc/apache2/ssl/ylabs.de.key
#  TLSVerifyClient              off
#</IfModule>


Die Logdateien und /var/log/proftpd haben alle 0 Byte.

Der Rest vom Geraffel funktioniert. E-Mail, Webserver, Datenbank - ohne Probleme.

Das System:
VHCS 2.4.8-rc1
Debian Etch
ProFTPD 1.3.0

Hat jemand eine Idee, wo ich zur Fehlerbehebung ansetzen könnte?
timeless2
Posts: 415
Joined: 2005-03-04 14:45
Location: Paris
 

Re: Einlog-Problem mit ProFTPD

Post by timeless2 »

gib doch beim Servernamen deinen richtigen Servernamen ein.
Wenn du dann nicht weiterkommst, kannst du das Loglevel des Proftp ändern, damit er mehr mitprotokolliert bzw. bei Mysql die Anfragen, dann siehst du, was der Proftp abfragt.
salnet
Posts: 50
Joined: 2002-07-14 00:59
Location: Bonn
 

Re: Einlog-Problem mit ProFTPD

Post by salnet »

Der richtige Hostname ist schon eingetragen; ich hab ihn hier halt nur anonymisiert.
rolobiz
Posts: 3
Joined: 2007-04-22 13:08
Location: Nürnberg
 

Re: Einlog-Problem mit ProFTPD

Post by rolobiz »

Hallo,

ab proftpd musst Du in der proftpd.conf den Eintrag SQLBackend mysql nicht auskommentieren (Steht ja auch dahinter!).
#
# VHCS2 Managment;
#
SQLBackend mysql # Enable for Proftpd >= 1.3


Schreibe folgendes in die conf Datei damit PROFTP nicht ipv6 nimmt:
UseIPv6 off


Danach sollte es funktionieren.
mikexxl
Posts: 3
Joined: 2007-04-24 21:29
 

Re: Einlog-Problem mit ProFTPD

Post by mikexxl »

Hi

habe folgendes in der /etc/proftpd.conf geändert

"UseIPv6 off", den SQL Zusatz habe ich nicht gefunden.

Leider habe ich als Fehlermeldung immer noch
220 ProFTPD 1.3.0 Server (Debian) [::ffff:192.168.2.231

d.h. die FTP Benutzer können sich nicht einloggen

Debianx86 etch, vhcs2.4.7.1 mit mysql5

Benutzer/Reseller kann ich alles anlegen, leider funzt FTP nicht

Für hilfe wäre ich dankbar
rolobiz
Posts: 3
Joined: 2007-04-22 13:08
Location: Nürnberg
 

Re: Einlog-Problem mit ProFTPD

Post by rolobiz »

MikeXXL wrote:Hi

habe folgendes in der /etc/proftpd.conf geändert

"UseIPv6 off", den SQL Zusatz habe ich nicht gefunden.

Leider habe ich als Fehlermeldung immer noch
220 ProFTPD 1.3.0 Server (Debian) [::ffff:192.168.2.231

d.h. die FTP Benutzer können sich nicht einloggen

Debianx86 etch, vhcs2.4.7.1 mit mysql5

Benutzer/Reseller kann ich alles anlegen, leider funzt FTP nicht

Für hilfe wäre ich dankbar

Für VHCS gibt es eine eigene proftpd.conf.
Normalerweise wird bei der Installation diese Datei auch in den Pfad /etc/proftpd kopiert.

Damit die User sich anmelden können, müssen Sie gegen die SQL Datenbank von VHCS verifiziert werden.

In der proftpd.conf sollte am Ende der Datei der Eintrag für das VHCS SQL Backend eingetragen sein.

Ist dies bei Dir nicht der Fall, so ergänze die proftpd.conf mit folgenden Zeilen:
(Ersetze Datenbanknamen und Passwort für die Datenbank;
der Datenbankname lautet normalerweise vhcs2)
#
# VHCS2 Managment;
#
SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo <DATENBANKNAME>@localhost vftp <PASSWORT>
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinID 2000

#
# VHCS2 Quota management;
#

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb

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

QuotaLock /var/run/proftpd/tally.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
mikexxl
Posts: 3
Joined: 2007-04-24 21:29
 

Re: Einlog-Problem mit ProFTPD

Post by mikexxl »

Welche proftpd.conf muss ich ändern ??
a) /etc/
b) /etc/vhcs2/proftpd/
c) /etc/proftpd/

Ich habe auch eine proftpd.conf für Omega im Internet entdeckt dabei war folgendes:

Include /etc/proftpd/modules.conf
diverse pfadanpassungen für proftpd (logfiles sind z.b. bei a) xferlog und ftp_traff.log)

es fehlt natürlich SQL Backend mysql

Die omega.conf
#
# ispCP OMEGA ProFTPd config file
#
#
#
# Includes required DSO modules. This is mandatory in proftpd 1.3
#
Include /etc/proftpd/modules.conf

ServerName "xxxxxxxxxxxxx.xxx"
ServerType standalone
DeferWelcome off

ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on
UseReverseDNS off
IdentLookups off
AllowStoreRestart on
AllowForeignAddress on

LogFormat traff "%b %u"

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayFirstChdir message

#LsDefaultOptions "-l"

DenyFilter *.*/

DefaultRoot ~

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd off

# Port 21 is the standard FTP port.

Port 21

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)

MaxInstances 30

# Set the user and group that the server normally runs at.

User nobody
Group nogroup

# Normally, we want files to be overwriteable.

<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask 022 022

AllowOverwrite on
HideNoAccess on

</Directory>

<Limit ALL>
IgnoreHidden on
</Limit>

<Global>
RootLogin off
# proFTPd >= 1.3: change log dirs to /var/log/proftpd
TransferLog /var/log/proftpd/
ExtendedLog /var/log/proftpd/ftp_traff.log read,write traff
PathDenyFilter ".quota$"
</Global>

<IfModule mod_delay.c>
DelayEngine off
</IfModule>

#
# ISPCP Managment;
#
SQLBackend mysql # enable for proFTPd >= 1.3
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo ispcp@localhost vftp
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinID 2000

#
# ISPCP Quota management;
#

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb

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

QuotaLock /var/run/proftpd/tally.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally

#
# SSL via TLS
#
#<IfModule mod_tls.c>
# TLSEngine off # on for use of TLS
# TLSLog /var/log/proftpd/ftp_ssl.log # where to log to
# TLSProtocol SSLv23 # SSLv23 or TLSv1
# TLSOptions NoCertRequest # either to request the certificate or not
# TLSRSACertificateFile /etc/proftpd/ssl.crt # SSL certfile
# TLSRSACertificateKeyFile /etc/proftpd/ssl.key # SSL keyfile
# TLSVerifyClient off # client verification
#</IfModule>

welche .conf muss ich denn nun anpassen ???
anschliessend natürlich etc/init.d/proftpd restart
Danke
rolobiz
Posts: 3
Joined: 2007-04-22 13:08
Location: Nürnberg
 

Re: Einlog-Problem mit ProFTPD

Post by rolobiz »

Hallo,

>Welche proftpd.conf muss ich ändern ??

Seit protpd v1.3.0 immer die /etc/proftpd.conf

Besser ist es einen symlink auf die /etc/proftpd/proftpd.conf zu setzen
vorher die Datei /etc/proftpd.conf löschen

ln -s /etc/proftpd/proftpd.conf /etc/proftpd.conf

Danach kopierst Du den unteren Abschnitt in die Datei /etc/proftpd/proftpd.conf.

Jetzt nur noch folgende Parameter ersetzen (steht in den eckigen Klammern <>)

1.)
ServerName "<rechnername>"
z.B. ServerName "host1.example.com"

2.)
SQLConnectInfo <datenbankname>@localhost vftp <passwort>
z.B. SQLConnectInfo vhcs2@localhost vftp password

abspeichern und fertig.

Inhalt der proftpd.conf nach > /etc/proftpd/proftpd.conf kopieren:
###########################################################
#
# PROFTPD.CONF geändert 22.04.2007 rolobiz
#
Include /etc/proftpd/modules.conf
#IPv6 sperren
UseIPv6 off
#
# VHCS proftpd config file
#
#

ServerName "<rechnername>"
ServerType standalone
DeferWelcome off

ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on

LogFormat traff "%b %u"

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayFirstChdir .message
#ListOptions "-l"

DenyFilter *.*/

DefaultRoot ~
#IdentLookups off
#ServerIdent on "FTP Server ready."

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd off

# Port 21 is the standard FTP port.

Port 21

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)

MaxInstances 30

# Set the user and group that the server normally runs at.

User nobody
Group nogroup

# Normally, we want files to be overwriteable.

<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask 022 022

AllowOverwrite on
HideNoAccess on

</Directory>

<Limit ALL>
IgnoreHidden on
</Limit>

#<Global>
TransferLog /var/log/proftpd/xferlog
SystemLog /var/log/proftpd/proftpd.log
PathDenyFilter ".quota$"
#</Global>

<IfModule mod_tls.c>
TLSEngine off
</IfModule>

<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ratio.c>
Ratios on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine on
ControlsMaxClients 2
ControlsLog /var/log/proftpd/controls.log
ControlsInterval 5
ControlsSocket /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine on
</IfModule>

#
# VHCS2 Managment;
#
SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo <datenbankname>@localhost vftp <passwort>
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinID 2000

#
# VHCS2 Quota management;
#

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb

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

QuotaLock /var/run/proftpd/tally.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
mikexxl
Posts: 3
Joined: 2007-04-24 21:29
 

Re: Einlog-Problem mit ProFTPD

Post by mikexxl »

Hi,
habe nach deiner Anleitung die /etc/proftpd.conf gelöscht, den symlink gesetzt und den Inhalt der /etc/proftpd/proftpd.conf mit dem geposteten Inhalt ersetzt. Dann die Systemspezifieschen Änderungen gemacht.

beim restart bekomme ich folgende Fehlermeldung:
Starting ftp server: proftpd - Fatal: <IfModule>: unclosed <IfModule> context on line 137 of '/etc/proftpd/proftpd.conf'
failed!


hier meine proftpd.conf:
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes reload proftpd after modifications.
#
#
# PROFTPD.CONF geändert 22.04.2007 rolobiz Steinert
#
Include /etc/proftpd/modules.conf
#IPv6 sperren
UseIPv6 off
#
# VHCS proftpd config file
#
#

ServerName "Homer"
ServerType standalone
DeferWelcome off

ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on

LogFormat traff "%b %u"

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayFirstChdir .message
#ListOptions "-l"

DenyFilter *.*/

DefaultRoot ~
#IdentLookups off
#ServerIdent on "FTP Server ready."

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd off

# Port 21 is the standard FTP port.

Port 21

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)

MaxInstances 30

# Set the user and group that the server normally runs at.

User nobody
Group nogroup

# Normally, we want files to be overwriteable.

<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask 022 022

AllowOverwrite on
HideNoAccess on

</Directory>

<Limit ALL>
IgnoreHidden on
</Limit>

#<Global>
TransferLog /var/log/proftpd/xferlog
SystemLog /var/log/proftpd/proftpd.log
PathDenyFilter ".quota$"
#</Global>

<IfModule mod_tls.c>
TLSEngine off
</IfModule>

<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ratio.c>
Ratios on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine on
ControlsMaxClients 2
ControlsLog /var/log/proftpd/controls.log
ControlsInterval 5
ControlsSocket /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine on
</IfModule>

#
# VHCS2 Managment;
#
SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo vhcs2@localhost vftp
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinID 2000

#
# VHCS2 Quota management;
#
QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb

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
QuotaLock /var/run/proftpd/tally.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally


Woher kommt der Fehler, directories sind doch geschlossen, oder bin ich blind ??