Chinaunix

标题: 各位来看看, PROFTP+QUOTA+MYSQL,MYSQL认证不过. [打印本页]

作者: weizhishu 时间: 2003-12-23 16:49
标题: 各位来看看, PROFTP+QUOTA+MYSQL,MYSQL认证不过.
找不出原因, 编译安装都没问题。
这是出错信息
proxyserver (218.65.243.105[218.65.243.105]) - connected - local : 61.185.218.6:21
proxyserver (218.65.243.105[218.65.243.105]) - connected - remote : 218.65.243.105:26594
proxyserver (218.65.243.105[218.65.243.105]) - FTP session opened.
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'USER anonymous' to mod_core
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'USER anonymous' to mod_core
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'USER anonymous' to mod_auth
proxyserver (218.65.243.105[218.65.243.105]) - dispatching CMD command 'USER anonymous' to mod_auth
proxyserver (218.65.243.105[218.65.243.105]) - dispatching POST_CMD command 'USER anonymous' to mod_sql
proxyserver (218.65.243.105[218.65.243.105]) - dispatching LOG_CMD command 'USER anonymous' to mod_sql
proxyserver (218.65.243.105[218.65.243.105]) - dispatching LOG_CMD command 'USER anonymous' to mod_log
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
proxyserver (218.65.243.105[218.65.243.105]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
proxyserver (218.65.243.105[218.65.243.105]) - dispatching CMD command 'PASS (hidden)' to mod_auth
proxyserver (218.65.243.105[218.65.243.105]) - FTP session closed.
proftpd.conf里关于mysql 的配置是这样的.
#
SQLAuthTypes Backend Plaintext
SQLAuthenticate users groups usersetfast groupsetfast
#SQLAuthenticate users*
SQLConnectInfo ftp@192.168.0.1 ftpusr dirlyk1980
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserUID 1000

RequireValidShell off
SQLHomedirOnDemand on

SQLUserInfo ftpusr userid password uid gid homed shell
SQLGroupInfo ftpgrp groupname gid members

#

# aktive SQL Kommandos, ab hier passiert etwas

#

SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" users

# xfer Log in mysql

SQLLog RETR,STOR transfer1
SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'c', NULL" xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'i', NULL" xfer_stat
相应的表和列名在数据库里都已经建立好用户也加上了.
就是验证不过实在找不出原因.
各位帮忙找一下.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)