©
This document usesPHP Chinese website manualRelease
| 说明 | 使用SQL数据库为认证提供支持 |
|---|---|
| 状态 | 扩展(E) |
| 模块名 | authn_dbd_module |
| 源文件 | mod_authn_dbd.c |
| 兼容性 | 仅在 Apache 2.1 及以后的版本中可用 |
This module provides authentication front-ends such asmod_auth_digest和mod_auth_basicto authenticate users by looking up users in SQL tables. Similar functionality is provided by, for example,mod_authn_file.
This module relies onmod_dbdto specify the backend database driver and connection parameters, and manage the database connections.
When usingmod_auth_basic或mod_auth_digest, this module is invoked via theAuthBasicProvider或AuthDigestProviderwith thedbdvalue.
This simple example shows use of this module in the context of the Authentication and DBD frameworks.
#Database Management #Use the PostgreSQL driverDBDriver pgsql#Connection string: database name and login credentialsDBDParams "dbname=htpasswd user=apache pass=xxxxxx"#Parameters for Connection Pool ManagementDBDMin 1 DBDKeep 2 DBDMax 10 DBDExptime 60#Authentication Section#mod_auth configuration for authn_dbdAuthType Basic AuthName "My Server" AuthBasicProvider dbd#authz configurationRequire valid-user#SQL query to verify a user #(note: DBD drivers recognise both stdio-like %s and native syntax)AuthDBDUserPWQuery "select password from authn where username = %s"
| 说明 | SQL query to look up a password for a user |
|---|---|
| 语法 | AuthDBDUserPWQueryquery |
| 作用域 | directory |
| 覆盖项 | AuthConfig |
| 状态 | 扩展(E) |
| 模块 | mod_authn_dbd |
AuthDBDUserPWQueryspecifies an SQL query to look up a password for a specified user. The query must take a single string (typically SQL varchar) argument (username), and return a single value (encrypted password).
AuthDBDUserPWQuery "SELECT password FROM authn WHERE username = %s"
| 说明 | SQL query to look up a password hash for a user and realm. |
|---|---|
| 语法 | AuthDBDUserRealmQueryquery |
| 作用域 | directory |
| 覆盖项 | AuthConfig |
| 状态 | 扩展(E) |
| 模块 | mod_authn_dbd |
AuthDBDUserRealmPWQueryspecifies an SQL query to look up a password for a specified user and realm. The query must take two string (typically SQL varchar) arguments (username and realm), and return a single value (encrypted password).
AuthDBDUserRealmPWQuery "SELECT password FROM authn WHERE username = %s AND realm = %s"
