[问题]PROFTPD+MYSQL启动后无法通过验证模块。

golden76

只要带上MYSQL模块启动，就无法通过验证模块。
这试什么问题？ 麻烦做过的朋友帮我一下。谢谢。

下面是PROFTPD的调试信息。
   

bs.localhost - Config for ProFTPD Default Installation:
bs.localhost - ~ftp/
bs.localhost -  Limit
bs.localhost -   DenyAll
bs.localhost -  UserName
bs.localhost -  GroupName
bs.localhost -  UserAlias
bs.localhost -  MaxClients
bs.localhost -  DisplayLogin
bs.localhost -  DisplayFirstChdir
bs.localhost -  Umask
bs.localhost -  SQLAuthenticate
bs.localhost -  SQLConnectInfo
bs.localhost -  SQLAuthTypes
bs.localhost -  RequireValidShell
bs.localhost - /
bs.localhost -  AllowOverwrite
bs.localhost -  Umask
bs.localhost -  SQLAuthenticate
bs.localhost -  SQLConnectInfo
bs.localhost -  SQLAuthTypes
bs.localhost -  RequireValidShell
bs.localhost - DefaultServer
bs.localhost - Umask
bs.localhost - SQLAuthenticate
bs.localhost - SQLConnectInfo
bs.localhost - SQLAuthTypes
bs.localhost - SQLUserTable
bs.localhost - SQLUsernameField
bs.localhost - SQLPasswordField
bs.localhost - SQLUidField
bs.localhost - SQLGidField
bs.localhost - SQLHomedirField
bs.localhost - RequireValidShell
bs.localhost - UserID
bs.localhost - UserName
bs.localhost - GroupID
bs.localhost - GroupName
bs.localhost - DefaultRoot
bs.localhost - ProFTPD 1.2.9rc1 (devel) (built Sun Sep 7 04:44:48 CST 2003) standalone mode STARTUP
bs.localhost (192.168.1.25[192.168.1.25]) - connected - local  : 192.168.1.50:21
bs.localhost (192.168.1.25[192.168.1.25]) - connected - remote : 192.168.1.25:3418
bs.localhost (192.168.1.25[192.168.1.25]) - FTP session opened.
bs.localhost (192.168.1.25[192.168.1.25]) - dispatching PRE_CMD command 'USER test' to mod_core
bs.localhost (192.168.1.25[192.168.1.25]) - dispatching PRE_CMD command 'USER test' to mod_core
bs.localhost (192.168.1.25[192.168.1.25]) - dispatching PRE_CMD command 'USER test' to mod_auth
bs.localhost (192.168.1.25[192.168.1.25]) - dispatching CMD command 'USER test' to mod_auth
bs.localhost (192.168.1.25[192.168.1.25]) - FTP session closed.

下面是PROFTPD的初步配置

SQLConnectInfo proftpd@localhost:3306 root xxxxxx     
SQLAuthTypes Plaintext
SQLUserInfo FTPUSERS userid passwd uid gid homedir NULL
RequireValidShell off
SQLAuthenticate users groups usersetfast groupsetfast

netkiller

用PUREFTPD.吧。它可以同时支持四种认证。
我比较喜欢LDAP

golden76

老大，你没看到我发的另外两个说PUREFTPD再BSD 5.1上很不稳定的帖子？

netkiller

编译内核。与TXXXX什么的。。。
不是PUREFTPD不稳定。。而是BSD内核问题。。。。

jedi-k

SQLConnectInfo proftpd@localhost:3306 root xxxxxx
SQLAuthTypes Plaintext  （默认的？我没改动这条）
SQLUserInfo FTPUSERS userid passwd uid gid homedir NULL （NULL改成shell）
RequireValidShell off  （默认的，看到了）
SQLAuthenticate users groups usersetfast groupsetfast （默认的我看到了）

jedi-k

你的MYSQL表我没有见到，所以我不能帮你排错
你有空把你建的MYSQL库结构贴给我看
bs.localhost (192.168.1.25[192.168.1.25]) - dispatching CMD command 'USER test' to mod_auth
八过话讲回来，你是跑到这里被CLOSED掉的
ftp (192.168.0.191[192.168.0.191]) - ROOT PRIVS at inet.c:456
ftp (192.168.0.191[192.168.0.191]) - RELINQUISH PRIVS at inet.c:470
ftp (192.168.0.191[192.168.0.191]) - ROOT PRIVS at main.c:937
ftp (192.168.0.191[192.168.0.191]) - SETUP PRIVS at main.c:942
ftp (192.168.0.191[192.168.0.191]) - performing module session initializations
ftp (192.168.0.191[192.168.0.191]) - ROOT PRIVS at mod_auth.c:129
ftp (192.168.0.191[192.168.0.191]) - RELINQUISH PRIVS at mod_auth.c:132
ftp (192.168.0.191[192.168.0.191]) - connected - local  : 192.168.0.199:21
ftp (192.168.0.191[192.168.0.191]) - connected - remote : 192.168.0.191:3022
ftp (192.168.0.191[192.168.0.191]) - FTP session opened.
ftp (192.168.0.191[192.168.0.191]) - dispatching PRE_CMD command 'USER ftp' to mod_core
ftp (192.168.0.191[192.168.0.191]) - dispatching PRE_CMD command 'USER ftp' to mod_core
ftp (192.168.0.191[192.168.0.191]) - dispatching PRE_CMD command 'USER ftp' to mod_auth
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endpwent" to module mod_sql
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endpwent" to module mod_auth_file
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endpwent" to module mod_auth_unix
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endgrent" to module mod_sql
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endgrent" to module mod_auth_file
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "endgrent" to module mod_auth_unix
ftp (192.168.0.191[192.168.0.191]) - dispatching CMD command 'USER ftp' to mod_auth
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "getgroups" to module mod_sql（这条都没跑到）
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "getgroups" to module mod_auth_file
ftp (192.168.0.191[192.168.0.191]) - dispatching auth request "getgroups" to module mod_auth_unix
你真的确定你装好了吗？