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
