www.ProFTPD.de

System:
-debian testing
-libmysqlauth ist install mysql client und server ebenfalls ;)

Configure option:
./configure  --with-modules=mod_sql:mod_sql_mysql  --with-includes=/usr/include/mysql  --with-libraries=/usr/lib/mysql

# proftpd -nd 9
.....
womb - ProFTPD 1.2.10rc3 (devel) (built Di Sep 14 16:42:18 CEST 2004) standalone mode STARTUP
.....
womb (localhost[127.0.0.1]) - ident lookup disabled
womb (localhost[127.0.0.1]) - ROOT PRIVS at main.c:1005
womb (localhost[127.0.0.1]) - SETUP PRIVS at main.c:1010
womb (localhost[127.0.0.1]) - FTP session requested from unknown class
womb (localhost[127.0.0.1]) - performing module session initializations
womb - FS: using system lstat()
womb (localhost[127.0.0.1]) - FTP session closed.

# ftp localhost
Connected to localhost.
421 Service not available, remote server has closed connection
ftp>

Config:
# main
ServerName                      "== Batspace =="
ServerType                      standalone
DeferWelcome                    off
DefaultRoot                     ~
MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on
AllowOverwrite                  on
AllowForeignAddress             on
AllowStoreRestart               on
AllowRetrieveRestart            on
WtmpLog                         off
IdentLookups                    off
RequireValidShell               off
ListOptions                     "-l"
DenyFilter                      \*.*/
Port                            21
MaxInstances                    30
User                            nobody
Group                           nogroup

<Directory /*>
  Umask                         022  022
  AllowOverwrite                on
  AllowRetrieveRestart          on
  AllowStoreRestart             on
</Directory>


# letz log
TransferLog /var/log/proftpd.xferlog
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
ExtendedLog /var/log/proftpd.paranoid_log ALL default

# sql
SQLAuthTypes            Plaintext
SQLAuthenticate         users groups
SQLConnectInfo          Db @localhost user pw
SQLUserInfo             proftpd_users username password uid gid homedir shell
SQLGroupInfo            proftpd_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'" proftpd_users

SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" proftpd_useers

SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" proftpd_users

Ideen?

mfg red

btw,
# proftpd -vv
 - ProFTPD Version: 1.2.10rc3 (devel)
 -   Scoreboard Version: 01040002
 -   Built: Di Sep 14 16:42:18 CEST 2004
 -     Module: mod_core.c
 -     Module: mod_xfer.c
 -     Module: mod_auth_unix.c
 -     Module: mod_auth_file.c
 -     Module: mod_auth.c
 -     Module: mod_ls.c
 -     Module: mod_log.c
 -     Module: mod_site.c
 -     Module: mod_auth_pam.c
 -     Module: mod_sql.c
 -     Module: mod_sql_mysql.c
 -     Module: mod_cap/1.0

red

1. Ich sehe keine richtige Frage ausser "Ideen?".
2. http://www.proftpd.de/forum2/viewtopic.php?t=1015

Die frage war erkennbar dachte ich :) Ok nun genau:
Proftpd laeuft ohne fehler...
#ftp localhost
421 Service not available, remote server has close.....

bums... und nu? die ausgaben usw siehe oben

zu 2. den thread kenne ich habs auch gemacht und bin zudem ergebnis mit 421 gekommen.

rdh

Mh da nix kam und ich so ungeduldig bin hab ich nochmal von vorn angefangen debian pkg 1.2.9 selbe config - funtz
keine ahnung an was es lag ;)

red