Angel4ever
14.12.08, 17:36
Und zwar habe ich folgendes problem, ich habe mir jetzt eine proftpd config zusammen gebastelt nur leider brauche ich noch die mysql datenbank. Jetzt reicht mein wissen leider nicht soweit das ich diese selbst erstellen könnte darum wollte ich mal fragen ob jemand von euch mir villeicht die befehle hier aufschreiben könnte die ich dann ausführen muss.
Hier erstmal die config:
# Server settings
ServerName "rmatthes.de FTP Server"
ServerType standalone
ServerIdent off
DefaultServer on
Port 21
MaxInstances 50
debugLevel 6
Serverlog /var/log/proftpd.debug.log
# General settings
DeferWelcome on
MultilineRFC2228 on
ShowSymlinks on
AllowOverwrite on
AllowStoreRestart on
AllowRetrieveRestart on
UseReverseDNS off
IdentLookups off
ListOptions "-al"
DisplayChdir .message
# Modules settings
#DelayEngine off
# Timeout settings
TimeoutLogin 120
TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 600
# Security settings
RootLogin off
RequireValidShell off
User proftpd
Group proftpd
Umask 133 022
DefaultRoot ~
DenyFilter \*.*/
# Per-Directory settings
<Directory /*>
Umask 133 022
AllowOverwrite on
</Directory>
# SQL settings
SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo ftp@localhost ftp PASSWD
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
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_users
# TLS settings
<IfModule mod_tls.c>
TLSEngine on
TLSLog /var/log/proftpd-tls.log
TLSProtocol SSLv23
TLSTimeoutHandshake 120
# Really important for WinClients
TLSOptions NoCertRequest
TLSRSACertificateFile /etc/ssl/server/rmatthes.de.crt
TLSRSACertificateKeyFile /etc/ssl/server/rmatthes.de.key
# Authenticate client that want to use FTP over TLS?
TLSVerifyClient off
# Uncomment the following line to force tls login
TLSRequired off
</IfModule>
# LOG settings
# Logging Formats
LogFormat default "%h %1 %u %t \"%r\" %s %b"
LogFormat auth "%v [%P] %h %t \"%r\" %s"
LogFormat write "%h %l %u %t \"%r\" %s %b"
# Activate Logging
# all logins
ExtendedLog /var/log/proftpd-auth.log AUTH auth
# file/dir access
ExtendedLog /var/log/proftpd-access.log WRITE,READ write
# everything (be careful, generates_ very_ big logfiles)
#ExtendedLog /var/log/proftpd-all.log ALL default
# make proftpd faster / do not perform ident and reverse dns lookup
UseReverseDNS off
IdentLookups off
#Anonymous ftp user
<Anonymous ~username>
User allftp
Group ftp
AnonRequirePassword on
MaxClients 1
DisplayLogin welcome.msg
# DisplayFirstChdir .message
<Limit WRITE>
Deny from all
</Limit>
<Directory incoming>
<Limit READ WRITE DIRS STOR CWD CDUP>
AllowAll
</Limit>
</Directory>
</Anonymous>
#Mysql config f�ftpd
# Art der Passw�r
SQLAuthTypes Plaintext
# Art der Authentifikation
SQLAuthenticate users*
# Information zur Verbindungsaufnahme mit der Datenbank.
# Format: database_name@server_address database_username database_password
SQLConnectInfo ftp@localhost ftp PASSWD
# Default-UID/GID. Den eigenen Bed�ssen anpassen.
SQLDefaultUID 5000
SQLDefaultGID 5000
# Mininum UID/GID. Den eigenen Bed�ssen anpassen.
SQLMinUserUID 1000
SQLMinUserGID 1000
# Datenbank-Anfrage. Format: ** Unten spezifiziert **
SQLUserInfo ftp username password uid gid ftpdir homedir
# Benutzer auf ftpdir beschr�en
DefaultRoot ~
Hier erstmal die config:
# Server settings
ServerName "rmatthes.de FTP Server"
ServerType standalone
ServerIdent off
DefaultServer on
Port 21
MaxInstances 50
debugLevel 6
Serverlog /var/log/proftpd.debug.log
# General settings
DeferWelcome on
MultilineRFC2228 on
ShowSymlinks on
AllowOverwrite on
AllowStoreRestart on
AllowRetrieveRestart on
UseReverseDNS off
IdentLookups off
ListOptions "-al"
DisplayChdir .message
# Modules settings
#DelayEngine off
# Timeout settings
TimeoutLogin 120
TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 600
# Security settings
RootLogin off
RequireValidShell off
User proftpd
Group proftpd
Umask 133 022
DefaultRoot ~
DenyFilter \*.*/
# Per-Directory settings
<Directory /*>
Umask 133 022
AllowOverwrite on
</Directory>
# SQL settings
SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo ftp@localhost ftp PASSWD
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
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_users
# TLS settings
<IfModule mod_tls.c>
TLSEngine on
TLSLog /var/log/proftpd-tls.log
TLSProtocol SSLv23
TLSTimeoutHandshake 120
# Really important for WinClients
TLSOptions NoCertRequest
TLSRSACertificateFile /etc/ssl/server/rmatthes.de.crt
TLSRSACertificateKeyFile /etc/ssl/server/rmatthes.de.key
# Authenticate client that want to use FTP over TLS?
TLSVerifyClient off
# Uncomment the following line to force tls login
TLSRequired off
</IfModule>
# LOG settings
# Logging Formats
LogFormat default "%h %1 %u %t \"%r\" %s %b"
LogFormat auth "%v [%P] %h %t \"%r\" %s"
LogFormat write "%h %l %u %t \"%r\" %s %b"
# Activate Logging
# all logins
ExtendedLog /var/log/proftpd-auth.log AUTH auth
# file/dir access
ExtendedLog /var/log/proftpd-access.log WRITE,READ write
# everything (be careful, generates_ very_ big logfiles)
#ExtendedLog /var/log/proftpd-all.log ALL default
# make proftpd faster / do not perform ident and reverse dns lookup
UseReverseDNS off
IdentLookups off
#Anonymous ftp user
<Anonymous ~username>
User allftp
Group ftp
AnonRequirePassword on
MaxClients 1
DisplayLogin welcome.msg
# DisplayFirstChdir .message
<Limit WRITE>
Deny from all
</Limit>
<Directory incoming>
<Limit READ WRITE DIRS STOR CWD CDUP>
AllowAll
</Limit>
</Directory>
</Anonymous>
#Mysql config f�ftpd
# Art der Passw�r
SQLAuthTypes Plaintext
# Art der Authentifikation
SQLAuthenticate users*
# Information zur Verbindungsaufnahme mit der Datenbank.
# Format: database_name@server_address database_username database_password
SQLConnectInfo ftp@localhost ftp PASSWD
# Default-UID/GID. Den eigenen Bed�ssen anpassen.
SQLDefaultUID 5000
SQLDefaultGID 5000
# Mininum UID/GID. Den eigenen Bed�ssen anpassen.
SQLMinUserUID 1000
SQLMinUserGID 1000
# Datenbank-Anfrage. Format: ** Unten spezifiziert **
SQLUserInfo ftp username password uid gid ftpdir homedir
# Benutzer auf ftpdir beschr�en
DefaultRoot ~