www.ProFTPD.de
13. März 2007, 19:05:07 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
  Übersicht Hilfe Suche Login Registrieren  
  Zeige Beiträge
Seiten: 1 2 [3]
31  ProFTPD / ProFTPD - Deutsch / mal wieder mod_sql am: 25. November 2003, 13:23:54
ich konnte den ftp server ohne fehlermeldung kompilieren und auch starten, ich hab dieses php script (proftpd tools) heruntergeladen und damit auch mal nen user angelegt, aber der ftp login funzt nicht.
alle user logins (ausser anonymous) geben mir ein OFFLINE zurück. ich hab null plan wie sich der verhalten (kann). kann mir einer nen tip geben? hier noch mal die conf:
Code:
# 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 "RZH FTP Server"
ServerType standalone
ServerIdent on "Server bereit"
DeferWelcome on
DefaultServer on

# Port 21 is the standard FTP port.
Port 21

# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022

# 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 under which the server will run.
User nobody
Group nogroup

# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
DefaultRoot ~

# Messages

AccessGrantMsg "Willkommen auf dem FTP Server vom RZH"
AccessDenyMsg "Zugriff verweigert"

# MySQL Kram Start



   ################################################
   ############### mysql Modul: 4.x ###############
   ################################################
   SQLAuthTypes                    Plaintext
   SQLAuthenticate                 users* groups*
   SQLConnectInfo                  ftp@localhost:17777 root passwort
   SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'i', NULL" xfer_stat
   SQLUserInfo   ftp username password uid gid homedir shell
   SQLGroupInfo                    groups groupname gid members
   SQLUserWhereClause              "login_enabled = 'y'"
   
   SQLLog PASS counter
   SQLNamedQuery counter UPDATE "last_login_ftp=now(), login_count_ftp=login_count_ftp+1 WHERE username='%u'" stat_users
   
   #####stat_xfer_stor in mysql#####
   SQLLog STOR,APPE transfer1
   SQLNamedQuery  transfer1 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_stor
   
   SQLLOG ERR_STOR,ERR_APPE transfer2
   SQLNamedQuery  transfer2 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_stor
   
   #####stat_xfer_retr in mysql#####
   SQLLog RETR transfer3
   SQLNamedQuery  transfer3 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_retr
   
   SQLLOG ERR_RETR transfer4
   SQLNamedQuery  transfer4 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_retr
   
   #####up-/downloads#####
   SQLLog RETR           dlbytescount
   SQLNamedQuery         dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE username='%u'" stat_users
   
   SQLLog RETR           dlcount
   SQLNamedQuery         dlcount UPDATE "dl_count=dl_count+1 WHERE username='%u'" stat_users
   
   SQLLog STOR           ulbytescount
   SQLNamedQuery         ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE username='%u'" stat_users
   
   SQLLog STOR           ulcount
   SQLNamedQuery         ulcount UPDATE "ul_count=ul_count+1 WHERE username='%u'" stat_users
   
   ################################################





# MySQL Kram Ende

# Normally, we want files to be overwriteable.
<Directory />
  AllowOverwrite on
</Directory>

# A basic anonymous configuration, no upload directories.  If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
<Anonymous ~ftp>
  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

  # Limit WRITE everywhere in the anonymous chroot
  <Limit WRITE>
    DenyAll
  </Limit>
</Anonymous>
32  ProFTPD / ProFTPD - Deutsch / mod_sql und mySQL 4.0.16? am: 24. November 2003, 16:39:31
shit, hatte vergessen mich einzuloggen, aber vom configure fehlt eh die hälfte Smiley

also hier nochmal:

Code:
./configure --prefix=/usr/local/proftpd --with-modules=mod_tls --with-modules=mod_sql:mod_sql_mysql --with-includes=/usr/local/mysql/include/mysql/ --with-libraries=/usr/local/mysql/lib/mysql/lib
Seiten: 1 2 [3]
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.06 Sekunden mit 15 Zugriffen.