proftpd + sql

[George Barbounis]

estisa to proftpd + sql module
me to parakato proftpd.conf

ServerName                      "localhost"
ServerType                      standalone
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 that the server normally runs at.
User                            nobody
Group                           nogroup


SQLAuthTypes Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo ftp at localhost username passwd
SQLUserInfo users username passwd uid gid homedir NULL
SQLGroupInfo groups groupname id username
SQLUserWhereClause "valid = 1"
#SQLDefaultGID 100
#SQLDefaultUID 500
SQLHomedirOnDemand on
RequireValidShell off
SQLLog PASS updatelogin
SQLNamedQuery updatelogin UPDATE "count=count+1, lastlogin=NOW() WHERE
username = '%u'" users


### Log trafic (STOR, RETR commands)
SQLLog RETR,STOR logtrafic
SQLNamedQuery logtrafic FREEFORM "INSERT INTO history (username, filename,
transfertype, transfersize, transferhost, transfertime, transferdate)

### Log user error events (ERR_* commands)
SQLLog ERR_* logevents
SQLNamedQuery logevents FREEFORM "INSERT INTO userevents (username,
eventtype, description, eventdate) VALUES ('%u', '%m', '%r', NOW())"

to problhma einai to ekseis, o xrhsths kanei login alla, den pernei uid kai
gid apo thn database,
ops p.x pernei to homedir. alla pernei Owner name   65533 Group name  nobody
mipos kserei kanenas ti lathos exei ginei
__________________________________
http://www.homekit.net