请高人指教，vsftp登陆出错

one7th

freebsd5.4+vsftpd+mysql+pam_mysql

错误信息：

Password:
Aug 11 09:13:57 one7th vsftpd: pam_mysql: error: sqllog set but logtable not set

530 Login incorrect.
ftp: Login failed.
ftp>; Aug 11 09:13:57 one7th vsftpd: pam_mysql: error: sqllog set but logmsgcolum
n not set
Aug 11 09:13:57 one7th vsftpd: pam_mysql: error: sqllog set but logusercolumn no
t set
Aug 11 09:13:57 one7th vsftpd: pam_mysql: error: sqllog set but loghostcolumn no
t set
Aug 11 09:13:57 one7th vsftpd: pam_mysql: error: sqllog set but logtimecolumn no
t set

附 /etc/pam.d/ftpd

#
# $FreeBSD: src/etc/pam.d/ftpd,v 1.18 2003/04/30 21:57:54 markm Exp $
#
# PAM configuration for the "ftpd" service
#

# auth
auth                required        pam_nologin.so                no_warn
auth                sufficient        pam_opie.so                no_warn no_fake_prompts
auth                requisite        pam_opieaccess.so        no_warn allow_local
#auth                sufficient        pam_krb5.so                no_warn
#auth           sufficient      pam_ssh.so                no_warn try_first_pass
auth                required        pam_unix.so                no_warn try_first_pass
auth required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0

# account
#account         required        pam_krb5.so
account                required        pam_unix.so
account required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0

# session
session                required        pam_permit.so


/etc/vsftpd.conf


listen=YES
listen_port=21
tcp_wrappers=YES
local_max_rate=500000
local_root=/var/ftp

anonymous_enable=NO
anon_upload_enable=NO
anon_mkdir_write_enable=NO
anon_other_write_enable=YES

local_enable=YES
write_enable=NO
local_umask=022

dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
xferlog_file=/var/log/vsftpd.log
xferlog_std_format=YES
idle_session_timeout=600
data_connection_timeout=120
accept_timeout=60
max_clients=20
max_per_ip=2
nopriv_user=nobody
#chroot_list_enable=YES
#chroot_list_file=/etc/vsftpd.chroot_list
#chroot_local_user=NO
ls_recurse_enable=NO
hide_ids=YES
text_userdb_names=YES
#userlist_enable=YES
#userlist_file=/etc/vsftpd.user_list
#userlist_deny=NO

guest_enable=YES
guest_username=ftpd
virtual_use_local_privs=YES
pam_service_name=ftpd
[/code]

wolfg

auth required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0 sqllog=0

account required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0  sqllog=0

one7th

非常感谢，搞定。

原来
auth required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0 sqllog=0

account required /usr/lib/pam_mysql.so user=ftpd passwd=fnho228 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0  sqllog=0

要放在单独的文件里