Hallo

Ich habe einen Lamp Server mir Ubuntu 6.10

Nun wollte ich euren FTPServer installieren und ihn nach siedem HowTo:

http://www.howtoforge.com/proftpd_mysql_virtual_hosting

installiert nun habe ich ein Problem:

Ich kann mich zwar als Systemuser ( Root ) anmelden das geht aber als Virtueller aus dem Mysql nicht.

Es kommt nur:

[R] Retry attempt Aborted
[R] Connecting to 192.168.1.3 -> IP=192.168.1.3 PORT=21
[R] Connected to 192.168.1.3
[R] 220 ProFTPD 1.3.0 Server (Debian) [::ffff:192.168.1.3]
[R] USER test
[R] 331 Password required for test.
[R] PASS (hidden)
[R] 530 Login incorrect.
[R] Connection failed

Wo liegt der Fehler

.Conf:

DefaultRoot ~


# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes            Plaintext Crypt
SQLAuthenticate         users* groups*


# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo  ftp@localhost proftpd ***


# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo     ftpuser userid passwd uid gid homedir shell

# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo    ftpgroup groupname gid members

# set min UID and GID - otherwise these are 999 each
SQLMinID        500

# create a user's home directory on demand if it doesn't exist
SQLHomedirOnDemand on

# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser

# Update modified everytime user uploads or deletes a file
SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser

# 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_ou$

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 $

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 + %$

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

RootLogin off
RequireValidShell off

Mysql:

SQL-Abfrageergebnis

Host: localhost
Datenbank: ftp
Erstellungszeit: 01. Januar 1988 um 03:23
Erstellt von: phpMyAdmin 2.8.2-Debian-0.2 / MySQL 5.0.24a-Debian_9-log
SQL-Befehl: SELECT * FROM `ftpuser` LIMIT 0, 30 ;
Zeilen: 1
id    userid    passwd    uid    gid    homedir    shell    count    accessed    modified
1    test    Panzer    2001    2001    /var/www    /sbin/nologin    0    0000-00-00 00:00:00    0000-00-00 00:00:00

und

SQL-Abfrageergebnis

Host: localhost
Datenbank: ftp
Erstellungszeit: 01. Januar 1988 um 03:24
Erstellt von: phpMyAdmin 2.8.2-Debian-0.2 / MySQL 5.0.24a-Debian_9-log
SQL-Befehl: SELECT * FROM `ftpquotalimits` LIMIT 0, 30 ;
Zeilen: 1
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
test    user    true    hard    0    0    0    0    0    0