Ich habe es mitlerweile geschafft, das mein Anonymous-ZUgang funktioniert. Nur meine MySQL-Authentification klappt noch nicht. Meine proftpd.conf sieht jetzt so aus :
ServerName "BIS-Programmierung ProFTPD-Server"
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User nobody
Group nogroup
DefaultRoot ~
TransferLog /var/log/proftpd/xferlog.legacy
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"
ExtendedLog /var/log/proftpd/access.log WRITE,READ write
ExtendedLog /var/log/proftpd/auth.log AUTH auth
UseReverseDNS off
IdentLookups off
<Directory /ftp/*>
AllowOverwrite on
</Directory>
<Limit LOGIN>
Order allow,deny
AllowGroup ftpd
</Limit>
<Global>
SQLConnectInfo ftpdb@localhost ftp
SQLAuthenticate users* groups*
SQLAuthTypes Crypt Backend Plaintext Empty
SQLUserInfo users userid passwd uid gid homedir shell
SQLGroupInfo groups groupid gid members
SQLHomedirOnDemand on
SQLLog PASS logincount
SQLNamedQuery logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users
SQLLog PASS lastlogin
SQLNamedQuery lastlogin UPDATE "last_login=now() WHERE userid='%u'" users
SQLLog RETR dlbytescount
SQLNamedQuery dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE userid='%u'" users
SQLLog RETR dlcount
SQLNamedQuery dlcount UPDATE "dl_count=dl_count+1 WHERE userid='%u'" users
SQLLog STOR ulbytescount
SQLNamedQuery ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE userid='%u'" users
SQLLog STOR ulcount
SQLNamedQuery ulcount UPDATE "ul_count=ul_count+1 WHERE userid='%u'" users
SQLLogFile /var/log/proftpd/sql.log
RequireValidShell off
SQLUserWhereClause "disabled!=1 and (NOW()<=expires or expires=-1)"
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,f$
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 ftpquota$
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}$
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
DirFakeGroup on ~
DirFakeUser on ~
MaxClients 3 "There are too many connections"
MaxClientsPerHost 3 "There are too many connections from your host"
ServerIdent on "You have connected"
DefaultRoot ~
UseFtpUsers on
CreateHome on 755 skel /ftp dirmode 755
</Global>
TimeoutLogin 60
TimeoutStalled 30
<Anonymous /ftp/anonymous>
User ftp
Group ftp
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous ftp
# Limit the maximum number of anonymous logins
MaxClients 10
# We want 'welcome.msg' displayed at login, and '.message' displayed
# in each newly chdired directory.
DisplayLogin welcome.msg
DisplayFirstChdir .message
<Directory /ftp/anonymous/uploads>
<LIMIT STOR WRITE>
AllowAll
</LIMIT>
</Directory>
</Anonymous>
Nur bleibt es jetzt noch ein Rätsel, warum ich mit einem User der in der Datenbank steht mich nicht anmelden kann ? Das Passwort des Users steht in der Datenbank im klartext drin.
