[질문]proftpd와 mysql 연결하기

proftpd를 mysql을 이용하여 사용자 인증하는 방법을 구현하려고 하는데 ftp접
속을 하면 접속이 안됩니다.
서버쪽의 세팅과 screen dump는 아래와 같습니다. 같은 경험이 있으신 분이나
해법을 아시는 분들의 친절한 답변 부탁드립니다.
************************************************************************
Version proftpd-1.2.4, mod_sql/3.2.4, mod_sql_mysql/3.2,
mysqld Ver 3.23.43 for pc-linux-gnu on i686

[root@log etc]# cat proftpd.conf
ServerName "ProFTPD"
ServerType standalone
DefaultServer on
ServerAdmin ftpadmin@localhost
UseReverseDNS off
IdentLookups off
ServerIdent On "Welcome to LCS.."
RootLogin off
Port 21

Umask 022
AuthPAMAuthoritative off
TimesGMT off
DenyFilter \*.*/

MaxClients 10 MaxClientsPerHost 3 "Sorry, %m connection allow per one host" MaxHostsPerUser 1 "Sorry, %m hosts allow per one user" TimeoutIdle 600 TimeoutNoTransfer 600 TimeoutLogin 0 DeferWelcome on DisplayLogin /etc/proftpd/welcome.msg DisplayFirstChdir .message #MaxInstances 30 # Set the user and group that the server normally runs at. User ftpadmin Group adm AllowOverwrite on LsDefaultOptions "-a"

SQLDoAuth on
SQLAuthoritative on
SQLConnectInfo membership@localhost3306 membership
test123
SQLAuthTypes Backend
SQLUserTable tbl_member_basic
SQLUsernameField userid
SQLPasswordField passwd
SQLUidField uid
SQLGidField gid
SQLHomedirField homedir
SQLMinID 1
SQLDefaultGID 1000
SQLDoGroupAuth Off

[root@log proftpd-1.2.4-kr]# ./proftpd -l
Compiled-in modules
mod_core.c
mod_auth.c
mod_xfer.c
mod_site.c
mod_ls.c
mod_unixpw.c
mod_log.c
mod_pam.c
mod_sql.c
mod_mysql.c
[root@log /root]# /usr/local/sbin/proftpd -
c /usr/local/etc/proftpd.conf -n -d 5
- Compiling deny regex '\*.*/'.
- Allocated deny regex at location 0x8094698.
log.foo.com -
log.foo.com - Config for ProFTPD For Korean
log.foo.com - /*
log.foo.com - AllowOverwrite
log.foo.com - MaxClients
log.foo.com - MaxClientsPerHost
log.foo.com - MaxHostsPerUser
log.foo.com - DisplayLogin
log.foo.com - DisplayFirstChdir
log.foo.com - SQLDoAuth
log.foo.com - SQLAuthoritative
log.foo.com - SQLConnectInfo
log.foo.com - SQLAuthTypes
log.foo.com - SQLMinID
log.foo.com - SQLDefaultGID
log.foo.com - SQLDoGroupAuth
log.foo.com - Umask
log.foo.com - TimesGMT
log.foo.com - DenyFilter
log.foo.com - DefaultServer
log.foo.com - IdentLookups
log.foo.com - ServerIdent
log.foo.com - RootLogin
log.foo.com - MaxClients
log.foo.com - MaxClientsPerHost
log.foo.com - MaxHostsPerUser
log.foo.com - DeferWelcome
log.foo.com - DisplayLogin
log.foo.com - DisplayFirstChdir
log.foo.com - User
log.foo.com - UserName
log.foo.com - Group
log.foo.com - GroupName
log.foo.com - LsDefaultOptions
log.foo.com - SQLDoAuth
log.foo.com - SQLAuthoritative
log.foo.com - SQLConnectInfo
log.foo.com - SQLAuthTypes
log.foo.com - SQLUserTable
log.foo.com - SQLUsernameField
log.foo.com - SQLPasswordField
log.foo.com - SQLUidField
log.foo.com - SQLGidField
log.foo.com - SQLHomedirField
log.foo.com - SQLMinID
log.foo.com - SQLDefaultGID
log.foo.com - SQLDoGroupAuth
log.foo.com - Umask
log.foo.com - AuthPAMAuthoritative
log.foo.com - TimesGMT
log.foo.com - DenyFilter
log.foo.com - ProFTPD 1.2.4 (release) (built Fri Nov 30 165615 KST
2001)
standalone mode START
UP
log.foo.com (127.0.0.1[127.0.0.1]) - connected - local 127.0.0.121
log.foo.com (127.0.0.1[127.0.0.1]) - connected - remote 127.0.0.155975
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 configured
membership@localhost3306 fo
r membership
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 entering sql_getconf
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 entering
fixup_SQLAuthTypes
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 exiting
fixup_SQLAuthTypes
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 open [1] for
mod_sql/3.2.4
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 connect OK
3.23.43 ->
3.23.43 (membershi
p@localhost)
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 backend successfully
connected.
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLDoAuth
true
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 authoritative
true
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 usertable
tbl_member_basic
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 userid field
userid
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 password field
passwd
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 uid field
uid
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 gid field
gid
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 shell field
shell
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 homedir field
homedir
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 default homedir
(none)
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 homedirondemand
false
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLDoGroupAuth
false
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 group table
groups
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 groupname field
groupname
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 grp gid field
gid
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 grp members field
members
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 processgrent
true
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 processpwent
true
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLMinUserUID 1
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLMinUserGID 1
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLDefaultUID
65533
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 SQLDefaultGID
1000
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 exiting sql_getconf
log.foo.com (127.0.0.1[127.0.0.1]) - FTP session opened.
log.foo.com (127.0.0.1[127.0.0.1]) - dispatching PRE_CMD command 'USER
test' to
mod_core
log.foo.com (127.0.0.1[127.0.0.1]) - dispatching PRE_CMD command 'USER
test' to
mod_auth
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 entering
auth_cmd_endpwent
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 exiting
auth_cmd_endpwent
log.foo.com (127.0.0.1[127.0.0.1]) - dispatching CMD command 'USER test'
to
mod_auth
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 entering
auth_cmd_getpwnam
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 no cache hit for
user 'test'
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 select OK
[membership]
"SELECT userid,
uid, gid, shell, homedir, passwd FROM tbl_member_basic WHERE
(userid='test')
LIMIT 1"
log.foo.com (127.0.0.1[127.0.0.1]) - ProFTPD terminating (signal 11)
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql/3.2.4 closing backend
connection
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 close [1] for
mod_sql/3.2.4
log.foo.com (127.0.0.1[127.0.0.1]) - mod_sql_mysql/3.2 disconnecting
Uptime
23757 Threads 1
Questions 15 Slow queries 0 Opens 7 Flush tables 1 Open
tables 1
Queries per second avg
0.001