[教學]HTTP 認證使用 MYSQL (mod_auth_mysql)

bqsc

请教一下：

我的httpd.conf文件定义是：
<Directory /home1/mrtg/>
    Options Indexes FollowSymLinks
    AllowOverride AuthConfig
    Order Deny,Allow
    Deny from all
    Allow from 192.168.0.0/24
    require valid-user
    satisfy any
</Directory>

我现在的
.htaccess文件设定是
AuthName "Mysql Admin"

AuthType Basic

AuthMySQLEnable On

AuthMySQLHost localhost

AuthMySQLPort 3306

AuthMySQLUser vpopmail

AuthMySQLPassword 123456

AuthMySQLDB vpopmail

AuthMySQLUserTable vpopmail

AuthMySQLNameField  pw_name

AuthMySQLPasswordField  pw_clear_passwd
#AuthMySQLPwTable vpopmail
AuthMySQLPwEncryption none

AuthMySQLAuthoritative  On

vpopmail表中的定义：
pw_name 类型varchar(32)

pw_clear_passwd 类型varchar(16)

用vpopmail用户可以登陆到mysql中。
现在打开进行登陆验证的窗口，任何密码和用户都不能成功验证，提示：
This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required.

怎么确定问题出在哪里？

abel

去看你的 error_log 說什麼

bqsc

日志里提示的是：
[client 192.168.1.226] File does not exist: /home1/html/mrtg
[client 192.168.1.226] MySQL ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client
[client 192.168.1.226] MySQL user LIWEI not found: /mrtg/
目录找不到，这是什么意思呢？