Hi!
Nachdem ich jetzt stundenlang das Forum durchsucht habe, und trotzdem keine Lösung gefunden hab, stell ich jetzt selbst die Frage:
Ich hab proftpd mit mod_mysql installiert. Hab bei der Inst. alle Libaries etc.pp eingebunden. Bei der Installation läuft alles glatt.
Jetzt wenn ich aber proftpd starten will bekomme ich folgende Fehlermeldung:
"Fatal: SQLUserInfo: Missing parameters on line 62..."
Hab auch schon mit SQLLOGFILE versucht mir den mySQL error in ne Datei zu schreiben. Aber leider steht da nix drinnen. Hoffe ihr könnt mir helfen. Hier mal meine Config:
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName "meine.ip.adresse"
ServerType standalone
DeferWelcome off
ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on
TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200
DisplayLogin welcome.msg
DisplayFirstChdir .message
#LsDefaultOptions "-l"
ListOptions "-l"
DenyFilter \*.*/
# 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
</Directory>
DefaultRoot ~
RequireValidShell off
<global>
SQLAuthTypes Crypt Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo syscp@localhost syscp meinpasswort
SQLUserInfo ftp_users username password uid gid homedir shell login_enabled
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
SQLLOGFILE /var/log/proftpd.sql.log
</global>
SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users
SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users
SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_user
Danke schon einmal im Voraus!
