mod_authn_dbd.html.en revision 53463cef28766dd8c9cc3c5948569b7cc1d898c0
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /><!--
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte This file is generated from xml source: DO NOT EDIT
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<link title="Main stylesheet" type="text/css" media="all" rel="stylesheet" href="/style/css/manual.css" />
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<link title="No Sidebar - Default font size" type="text/css" media="all" rel="alternate stylesheet" href="/style/css/manual-loose-100pc.css" />
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<link type="text/css" media="print" rel="stylesheet" href="/style/css/manual-print.css" />
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<link rel="shortcut icon" href="/images/favicon.ico" /></head>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p class="menu"><a href="/mod/">Modules</a> | <a href="/mod/directives.html">Directives</a> | <a href="/faq/">FAQ</a> | <a href="/glossary.html">Glossary</a> | <a href="/sitemap.html">Sitemap</a></p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p class="apache">Apache HTTP Server Version 2.1</p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div class="up"><a href="./"><img src="/images/left.gif" alt="<-" title="<-" /></a></div>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<a href="http://www.apache.org/">Apache</a> > <a href="http://httpd.apache.org/">HTTP Server</a> > <a href="http://httpd.apache.org/docs-project/">Documentation</a> > <a href="../">Version 2.1</a> > <a href="./">Modules</a></div>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div id="preamble"><h1>Apache Module mod_authn_dbd</h1>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p><span>Available Languages: </span><a href="/en/mod/mod_authn_dbd.html" title="English"> en </a></p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<table class="module"><tr><th><a href="module-dict.html#Description">Description:</a></th><td>User authentication using an SQL database</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="module-dict.html#Status">Status:</a></th><td>Extension</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="module-dict.html#ModuleIdentifier">Module�Identifier:</a></th><td>authn_dbd_module</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="module-dict.html#SourceFile">Source�File:</a></th><td>mod_authn_dbd.c</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="module-dict.html#Compatibility">Compatibility:</a></th><td>Available in Apache 2.1 and later</td></tr></table>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <p>This module provides authentication front-ends such as
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="module"><a href="/mod/mod_auth_digest.html">mod_auth_digest</a></code> and <code class="module"><a href="/mod/mod_auth_basic.html">mod_auth_basic</a></code>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte to authenticate users by looking up users in SQL tables.
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte Similar functionality is provided by, for example,
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="module"><a href="/mod/mod_authn_file.html">mod_authn_file</a></code>.</p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <p>This module relies on <code class="module"><a href="/mod/mod_dbd.html">mod_dbd</a></code> to specify
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte the backend database driver and connection parameters, and
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte manage the database connections.</p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <p>When using <code class="module"><a href="/mod/mod_auth_basic.html">mod_auth_basic</a></code> or
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="module"><a href="/mod/mod_auth_digest.html">mod_auth_digest</a></code>, this module is invoked via the
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="directive"><a href="/mod/mod_auth_basic.html#authbasicprovider">AuthBasicProvider</a></code> or
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="directive"><a href="/mod/mod_auth_digest.html#authdigestprovider">AuthDigestProvider</a></code>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div id="quickview"><h3 class="directives">Directives</h3>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><img src="/images/down.gif" alt="" /> <a href="#authdbduserpwquery">AuthDBDUserPWQuery</a></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><img src="/images/down.gif" alt="" /> <a href="#authdbduserrealmquery">AuthDBDUserRealmQuery</a></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><code class="directive"><a href="/mod/core.html#authname">AuthName</a></code></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><code class="directive"><a href="/mod/core.html#authtype">AuthType</a></code></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="directive"><a href="/mod/mod_auth_basic.html#authbasicprovider">AuthBasicProvider</a></code>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <code class="directive"><a href="/mod/mod_auth_digest.html#authdigestprovider">AuthDigestProvider</a></code>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><code class="directive"><a href="/mod/mod_dbd.html#dbdriver">DBDriver</a></code></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<li><code class="directive"><a href="/mod/mod_dbd.html#dbdparams">DBDParams</a></code></li>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div class="top"><a href="#page-header"><img src="/images/up.gif" alt="top" /></a></div>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div class="directive-section"><h2><a id="AuthDBDUserPWQuery" name="AuthDBDUserPWQuery">AuthDBDUserPWQuery</a> <a id="authdbduserpwquery" name="authdbduserpwquery">Directive</a></h2>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Description">Description:</a></th><td>SQL query to look up a password for a user</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthDBDUserPWQuery <var>query</var></code></td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory, .htaccess</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Override">Override:</a></th><td>AuthConfig</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authn_dbd</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <p>The <code class="directive">AuthDBDUserPWQuery</code> specifies an
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte SQL query to look up a password for a specified user.
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte The query must take a single string (typically SQL varchar)
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte argument (username), and return a single value (encrypted password).
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte AuthDBDUserPWQuery "SELECT password FROM authn WHERE username = %s"
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div class="top"><a href="#page-header"><img src="/images/up.gif" alt="top" /></a></div>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<div class="directive-section"><h2><a id="AuthDBDUserRealmQuery" name="AuthDBDUserRealmQuery">AuthDBDUserRealmQuery</a> <a id="authdbduserrealmquery" name="authdbduserrealmquery">Directive</a></h2>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Description">Description:</a></th><td>SQL query to look up a password hash for a user and realm.
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthDBDUserRealmQuery <var>query</var></code></td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory, .htaccess</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Override">Override:</a></th><td>AuthConfig</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authn_dbd</td></tr>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte <p>The <code class="directive">AuthDBDUserRealmPWQuery</code> specifies an
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte SQL query to look up a password for a specified user and realm.
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte The query must take two string (typically SQL varchar) arguments
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte (username and realm), and return a single value (encrypted password).
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte AuthDBDUserRealmPWQuery "SELECT password FROM authn
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte WHERE username = %s AND realm = %s"
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p><span>Available Languages: </span><a href="/en/mod/mod_authn_dbd.html" title="English"> en </a></p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p class="apache">Copyright 1995-2005 The Apache Software Foundation or its licensors, as applicable.<br />Licensed under the <a href="http://www.apache.org/licenses/LICENSE-2.0">Apache License, Version 2.0</a>.</p>
fcf3ce441efd61da9bb2884968af01cb7c1452ccJohn Forte<p class="menu"><a href="/mod/">Modules</a> | <a href="/mod/directives.html">Directives</a> | <a href="/faq/">FAQ</a> | <a href="/glossary.html">Glossary</a> | <a href="/sitemap.html">Sitemap</a></p></div>