Hallo,
ich habe ein Problem mit den "quotatallies" über mysql, diese Tabelle wird leider nicht upgedated, wenn ich ein File up- oder downloade.
proftpd.conf
ServerName "test Proftpd Server"
ServerType Standalone
ServerAdmin test@test.de
# Hide as much as possible to outside users
ServerIdent on "Welcome to the Khoosys FTP server. Please login..."
DeferWelcome on
DefaultServer on
# Allow FTP resuming.
# Remember to set to off if you have an incoming ftp for upload.
AllowStoreRestart 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 ~
# Normally, we want files to be overwriteable.
AllowOverwrite on
# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes Plaintext Crypt
SQLAuthenticate users* groups*
# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo ftpdb@localhost ftp ftp
# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo ftpuser userid passwd uid gid homedir shell
# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo ftpgroup groupname gid members
# set min UID and GID - otherwise these are 999 each
SQLMinID 500
# create a user's home directory on demand if it doesn't exist
SQLHomedirOnDemand on
# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
# Update modified everytime user uploads or deletes a file
SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
# User quotas
# ===========
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" ftpquotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
RootLogin off
RequireValidShell off
SQLLogFile
Aug 26 10:21:31 mod_sql/4.2[14354]: defaulting to 'mysql' backend
Aug 26 10:21:31 mod_sql/4.2[14354]: backend module 'mod_sql_mysql/4.05'
Aug 26 10:21:31 mod_sql/4.2[14354]: backend api 'mod_sql_api_v2'
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_sess_init
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_defineconnection
Aug 26 10:21:31 mod_sql/4.2[14354]: name: 'default'
Aug 26 10:21:31 mod_sql/4.2[14354]: user: 'ftp'
Aug 26 10:21:31 mod_sql/4.2[14354]: host: 'localhost'
Aug 26 10:21:31 mod_sql/4.2[14354]: db: 'ftpdb'
Aug 26 10:21:31 mod_sql/4.2[14354]: port: '3306'
Aug 26 10:21:31 mod_sql/4.2[14354]: ttl: '0'
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_defineconnection
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' opened
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: backend successfully connected.
Aug 26 10:21:31 mod_sql/4.2[14354]: mod_sql engine : on
Aug 26 10:21:31 mod_sql/4.2[14354]: negative_cache : off
Aug 26 10:21:31 mod_sql/4.2[14354]: authenticate : users groups
Aug 26 10:21:31 mod_sql/4.2[14354]: usertable : ftpuser
Aug 26 10:21:31 mod_sql/4.2[14354]: userid field : userid
Aug 26 10:21:31 mod_sql/4.2[14354]: password field : passwd
Aug 26 10:21:31 mod_sql/4.2[14354]: uid field : uid
Aug 26 10:21:31 mod_sql/4.2[14354]: gid field : gid
Aug 26 10:21:31 mod_sql/4.2[14354]: homedir field : homedir
Aug 26 10:21:31 mod_sql/4.2[14354]: shell field : shell
Aug 26 10:21:31 mod_sql/4.2[14354]: homedirondemand : true
Aug 26 10:21:31 mod_sql/4.2[14354]: group table : ftpgroup
Aug 26 10:21:31 mod_sql/4.2[14354]: groupname field : groupname
Aug 26 10:21:31 mod_sql/4.2[14354]: grp gid field : gid
Aug 26 10:21:31 mod_sql/4.2[14354]: grp members field : members
Aug 26 10:21:31 mod_sql/4.2[14354]: SQLMinUserUID : 500
Aug 26 10:21:31 mod_sql/4.2[14354]: SQLMinUserGID : 500
Aug 26 10:21:31 mod_sql/4.2[14354]: SQLDefaultUID : 65533
Aug 26 10:21:31 mod_sql/4.2[14354]: SQLDefaultGID : 65533
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_sess_init
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_getgroups
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: cache miss for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftpuser WHERE (userid='test') LIMIT 1"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: cache miss for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: user 'test' cached
Aug 26 10:21:31 mod_sql/4.2[14354]: + pwd.pw_name : test
Aug 26 10:21:31 mod_sql/4.2[14354]: + pwd.pw_uid : 5500
Aug 26 10:21:31 mod_sql/4.2[14354]: + pwd.pw_gid : 5500
Aug 26 10:21:31 mod_sql/4.2[14354]: + pwd.pw_dir : /test
Aug 26 10:21:31 mod_sql/4.2[14354]: + pwd.pw_shell : /sbin/nologin
Aug 26 10:21:31 mod_sql/4.2[14354]: cache miss for gid '5500'
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT groupname FROM ftpgroup WHERE (gid = 5500) LIMIT 1"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (groupname = 'nogroup')"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: cache miss for group 'nogroup'
Aug 26 10:21:31 mod_sql/4.2[14354]: group 'nogroup' cached
Aug 26 10:21:31 mod_sql/4.2[14354]: + grp.gr_name : nogroup
Aug 26 10:21:31 mod_sql/4.2[14354]: + grp.gr_gid : 5500
Aug 26 10:21:31 mod_sql/4.2[14354]: + grp.gr_mem : nobody
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_getgroups
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_pre_pass
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_getgroups
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for group 'nogroup'
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_getgroups
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_pre_pass
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_getpwnam
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_getpwnam
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_gid2name
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for group 'nogroup'
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_gid2name
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_auth
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_check
Aug 26 10:21:31 mod_sql/4.2[14354]: checking auth_type Plaintext
Aug 26 10:21:31 mod_sql/4.2[14354]: 'Plaintext' auth handler reports success
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_check
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_auth
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> cmd_getpwnam
Aug 26 10:21:31 mod_sql/4.2[14354]: cache hit for user 'test'
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< cmd_getpwnam
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_escapestr
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_escapestr
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_lookup
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = 'test' AND quota_type = 'user'"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_lookup
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_escapestr
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_escapestr
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> sql_lookup
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: : entering mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "SELECT name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = 'test' AND quota_type = 'user'"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_select
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< sql_lookup
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> log_master
Aug 26 10:21:31 mod_sql/4.2[14354]: >>> _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_escapestring
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_update
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 2
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_open
Aug 26 10:21:31 mod_sql/4.2[14354]: query "UPDATE ftpuser SET count=count+1, accessed=now() WHERE userid='test'"
Aug 26 10:21:31 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: connection 'default' count is now 1
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:31 mod_sql/4.2[14354]: exiting mysql cmd_update
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< _process_named_query
Aug 26 10:21:31 mod_sql/4.2[14354]: <<< log_master
Aug 26 10:21:33 mod_sql/4.2[14356]: defaulting to 'mysql' backend
Aug 26 10:21:33 mod_sql/4.2[14356]: backend module 'mod_sql_mysql/4.05'
Aug 26 10:21:33 mod_sql/4.2[14356]: backend api 'mod_sql_api_v2'
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_sess_init
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_defineconnection
Aug 26 10:21:33 mod_sql/4.2[14356]: name: 'default'
Aug 26 10:21:33 mod_sql/4.2[14356]: user: 'ftp'
Aug 26 10:21:33 mod_sql/4.2[14356]: host: 'localhost'
Aug 26 10:21:33 mod_sql/4.2[14356]: db: 'ftpdb'
Aug 26 10:21:33 mod_sql/4.2[14356]: port: '3306'
Aug 26 10:21:33 mod_sql/4.2[14356]: ttl: '0'
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_defineconnection
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' opened
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: backend successfully connected.
Aug 26 10:21:33 mod_sql/4.2[14356]: mod_sql engine : on
Aug 26 10:21:33 mod_sql/4.2[14356]: negative_cache : off
Aug 26 10:21:33 mod_sql/4.2[14356]: authenticate : users groups
Aug 26 10:21:33 mod_sql/4.2[14356]: usertable : ftpuser
Aug 26 10:21:33 mod_sql/4.2[14356]: userid field : userid
Aug 26 10:21:33 mod_sql/4.2[14356]: password field : passwd
Aug 26 10:21:33 mod_sql/4.2[14356]: uid field : uid
Aug 26 10:21:33 mod_sql/4.2[14356]: gid field : gid
Aug 26 10:21:33 mod_sql/4.2[14356]: homedir field : homedir
Aug 26 10:21:33 mod_sql/4.2[14356]: shell field : shell
Aug 26 10:21:33 mod_sql/4.2[14356]: homedirondemand : true
Aug 26 10:21:33 mod_sql/4.2[14356]: group table : ftpgroup
Aug 26 10:21:33 mod_sql/4.2[14356]: groupname field : groupname
Aug 26 10:21:33 mod_sql/4.2[14356]: grp gid field : gid
Aug 26 10:21:33 mod_sql/4.2[14356]: grp members field : members
Aug 26 10:21:33 mod_sql/4.2[14356]: SQLMinUserUID : 500
Aug 26 10:21:33 mod_sql/4.2[14356]: SQLMinUserGID : 500
Aug 26 10:21:33 mod_sql/4.2[14356]: SQLDefaultUID : 65533
Aug 26 10:21:33 mod_sql/4.2[14356]: SQLDefaultGID : 65533
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_sess_init
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_getgroups
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: cache miss for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftpuser WHERE (userid='test') LIMIT 1"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: cache miss for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: user 'test' cached
Aug 26 10:21:33 mod_sql/4.2[14356]: + pwd.pw_name : test
Aug 26 10:21:33 mod_sql/4.2[14356]: + pwd.pw_uid : 5500
Aug 26 10:21:33 mod_sql/4.2[14356]: + pwd.pw_gid : 5500
Aug 26 10:21:33 mod_sql/4.2[14356]: + pwd.pw_dir : /test
Aug 26 10:21:33 mod_sql/4.2[14356]: + pwd.pw_shell : /sbin/nologin
Aug 26 10:21:33 mod_sql/4.2[14356]: cache miss for gid '5500'
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT groupname FROM ftpgroup WHERE (gid = 5500) LIMIT 1"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (groupname = 'nogroup')"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: cache miss for group 'nogroup'
Aug 26 10:21:33 mod_sql/4.2[14356]: group 'nogroup' cached
Aug 26 10:21:33 mod_sql/4.2[14356]: + grp.gr_name : nogroup
Aug 26 10:21:33 mod_sql/4.2[14356]: + grp.gr_gid : 5500
Aug 26 10:21:33 mod_sql/4.2[14356]: + grp.gr_mem : nobody
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_getgroups
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_pre_pass
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_getgroups
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for group 'nogroup'
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_getgroups
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_pre_pass
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_getpwnam
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_getpwnam
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_gid2name
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for group 'nogroup'
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_gid2name
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_auth
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_check
Aug 26 10:21:33 mod_sql/4.2[14356]: checking auth_type Plaintext
Aug 26 10:21:33 mod_sql/4.2[14356]: 'Plaintext' auth handler reports success
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_check
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_auth
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> cmd_getpwnam
Aug 26 10:21:33 mod_sql/4.2[14356]: cache hit for user 'test'
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< cmd_getpwnam
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_escapestr
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_escapestr
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_lookup
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = 'test' AND quota_type = 'user'"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_lookup
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_escapestr
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_escapestr
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> sql_lookup
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: : entering mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "SELECT name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = 'test' AND quota_type = 'user'"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_select
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< sql_lookup
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> log_master
Aug 26 10:21:33 mod_sql/4.2[14356]: >>> _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_update
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:33 mod_sql/4.2[14356]: query "UPDATE ftpuser SET count=count+1, accessed=now() WHERE userid='test'"
Aug 26 10:21:33 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:33 mod_sql/4.2[14356]: exiting mysql cmd_update
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< _process_named_query
Aug 26 10:21:33 mod_sql/4.2[14356]: <<< log_master
Aug 26 10:21:34 mod_sql/4.2[14356]: >>> sql_post_stor
Aug 26 10:21:34 mod_sql/4.2[14356]: <<< sql_post_stor
Aug 26 10:21:34 mod_sql/4.2[14356]: >>> log_master
Aug 26 10:21:34 mod_sql/4.2[14356]: >>> _process_named_query
Aug 26 10:21:34 mod_sql/4.2[14356]: entering mysql cmd_escapestring
Aug 26 10:21:34 mod_sql/4.2[14356]: exiting mysql cmd_escapestring
Aug 26 10:21:34 mod_sql/4.2[14356]: entering mysql cmd_update
Aug 26 10:21:34 mod_sql/4.2[14356]: entering mysql cmd_open
Aug 26 10:21:34 mod_sql/4.2[14356]: connection 'default' count is now 2
Aug 26 10:21:34 mod_sql/4.2[14356]: exiting mysql cmd_open
Aug 26 10:21:34 mod_sql/4.2[14356]: query "UPDATE ftpuser SET modified=now() WHERE userid='test'"
Aug 26 10:21:34 mod_sql/4.2[14356]: entering mysql cmd_close
Aug 26 10:21:34 mod_sql/4.2[14356]: connection 'default' count is now 1
Aug 26 10:21:34 mod_sql/4.2[14356]: exiting mysql cmd_close
Aug 26 10:21:34 mod_sql/4.2[14356]: exiting mysql cmd_update
Aug 26 10:21:34 mod_sql/4.2[14356]: <<< _process_named_query
Aug 26 10:21:34 mod_sql/4.2[14356]: <<< log_master
Aug 26 10:21:35 mod_sql/4.2[14354]: >>> cmd_gid2name
Aug 26 10:21:35 mod_sql/4.2[14354]: cache hit for group 'nogroup'
Aug 26 10:21:35 mod_sql/4.2[14354]: <<< cmd_gid2name
Aug 26 10:21:35 mod_sql/4.2[14354]: >>> cmd_uid2name
Aug 26 10:21:35 mod_sql/4.2[14354]: matched current user
Aug 26 10:21:35 mod_sql/4.2[14354]: <<< cmd_uid2name
Aug 26 10:21:36 mod_sql/4.2[14354]: entering mysql cmd_exit
Aug 26 10:21:36 mod_sql/4.2[14354]: entering mysql cmd_close
Aug 26 10:21:36 mod_sql/4.2[14354]: connection 'default' closed
Aug 26 10:21:36 mod_sql/4.2[14354]: connection 'default' count is now 0
Aug 26 10:21:36 mod_sql/4.2[14354]: exiting mysql cmd_close
Aug 26 10:21:36 mod_sql/4.2[14354]: exiting mysql cmd_exit
