[求助]proftpd+mysql登錄問題

[求助]proftpd+mysql登錄問題

版本：rhel5.4；proftpd-1.3.3；mysql-5.1.44； 源碼包安裝
一直按照網上流行的proftpd+mysql安裝的方式在rhel4u6上安裝都沒有問題，在rhel5.4上卻出現了問題；
加-nd 9 啟動proftpd，debug 信息見下面：127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at main.c:1086
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - SETUP PRIVS at main.c:1091
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - session requested from client in unknown class
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - performing module session initializations
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - mod_cap/1.0: adding CAP_AUDIT_WRITE capability
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_quotatab.c:396
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_quotatab.c:398
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_quotatab.c:3540
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_quotatab.c:3547
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_quotatab.c:3556
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_quotatab.c:3563
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - mod_sql/4.2.4: defaulting to 'mysql' backend
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - mod_ident/1.0: ident lookup disabled
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_delay.c:1447
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_delay.c:1452
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - mod_log: opening ExtendedLog '/var/log/proftplog/proftpd.log'
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_log.c:1390
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_log.c:1392
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_auth.c:133
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - opening scoreboard '/usr/local/var/proftpd.scoreboard'
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_auth.c:135
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - connected - local  : ::ffff:192.168.118.138:21
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - connected - remote : ::ffff:192.168.118.137:45488
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - FTP session opened.
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'AUTH GSSAPI' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'AUTH GSSAPI' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching POST_CMD_ERR command 'AUTH GSSAPI' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD_ERR command 'AUTH GSSAPI' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD_ERR command 'AUTH GSSAPI' to mod_log
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'AUTH KERBEROS_V4' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'AUTH KERBEROS_V4' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching POST_CMD_ERR command 'AUTH KERBEROS_V4' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD_ERR command 'AUTH KERBEROS_V4' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD_ERR command 'AUTH KERBEROS_V4' to mod_log
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'USER li' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'USER li' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'USER li' to mod_delay
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'USER li' to mod_auth
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching CMD command 'USER li' to mod_auth
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching POST_CMD command 'USER li' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching POST_CMD command 'USER li' to mod_delay
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD command 'USER li' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching LOG_CMD command 'USER li' to mod_log
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - dispatching CMD command 'PASS (hidden)' to mod_auth
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - no supplemental groups found for user 'li'
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ROOT PRIVS at mod_auth_pam.c:312
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - RELINQUISH PRIVS at mod_auth_pam.c:482
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - user 'li' authenticated by mod_sql.c
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ProFTPD terminating (signal 11)
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - ProFTPD terminating (signal 11)
127.0.0.1 (::ffff:192.168.118.137[::ffff:192.168.118.137]) - FTP session closed.總是到mod_sql.c認證時，連接就斷了；
請教各位大牛，這是怎麼回事啊？

看到這些密密麻麻的數字和字母，我頭都暈死了~！

回復 2# yc1001aaa


    呵呵，我也暈，其實看信息就是mod_sql這塊卡住了，正常情況下，這個模塊過去了，下面是mod_auth模塊，不知道是哪個模塊的問題，但是在4u6上安裝就沒有問題，覺得也有可能跟操作系統的配置有關，哪位大牛行行好，幫助一下我這個菜鳥吧:em03:

回復 3# liyang234567


    歷史是在重複上演么？一年前，我安裝proftpd+mysql遇到了這個問題，一年後，我同樣在rhel5u4 64位上安裝proftpd+mysql時遇到了這個問題，而我使用的解決方式還是一模一樣，同樣使用了debug，複製錯誤信息，查詢，意外的發現，google的第一條竟然是我一年前發的同樣的帖子，真是令我太激動了！
   不過在今天，我已經把問題解決了，一年的時間，鍛煉了自己的能力，也增長了知識和經驗，問題還是那個問題，但我已不再是原來的我啦！:emn10:
     說下原因吧：在proftpd的配置里加上 SQLAuthenticate on 。因為在rhel4u6上，不添加此條也正常使用，而在rhel5u4上，不添加此條就不行了。

liyang234567 發表於 2011-05-26 14:58 static/image/common/back.gif
回復 3# liyang234567




一年後的今天，我也碰到了同樣的問題。 有幸搜到LZ的帖子，問題得以解決。多謝多謝~:handshake  
生活就是1年接著另一個1年:wink:

Tags: