docs/manual/mod/mod_authz_dbd.html.en - httpd - Git at Google

 <?xml version="1.0" encoding="ISO-8859-1"?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"><head><!--
         XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
               This file is generated from xml source: DO NOT EDIT
         XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
       -->
 <title>mod_authz_dbd - Apache HTTP Server</title>
 <link href="../style/css/manual.css" rel="stylesheet" media="all" type="text/css" title="Main stylesheet" />
 <link href="../style/css/manual-loose-100pc.css" rel="alternate stylesheet" media="all" type="text/css" title="No Sidebar - Default font size" />
 <link href="../style/css/manual-print.css" rel="stylesheet" media="print" type="text/css" />
 <link href="../images/favicon.ico" rel="shortcut icon" /></head>
 <body>
 <div id="page-header">
 <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>
 <p class="apache">Apache HTTP Server Version 2.3</p>
 <img alt="" src="../images/feather.gif" /></div>
 <div class="up"><a href="./"><img title="&lt;-" alt="&lt;-" src="../images/left.gif" /></a></div>
 <div id="path">
 <a href="http://www.apache.org/">Apache</a> &gt; <a href="http://httpd.apache.org/">HTTP Server</a> &gt; <a href="http://httpd.apache.org/docs/">Documentation</a> &gt; <a href="../">Version 2.3</a> &gt; <a href="./">Modules</a></div>
 <div id="page-content">
 <div id="preamble"><h1>Apache Module mod_authz_dbd</h1>
 <div class="toplang">
 <p><span>Available Languages: </span><a href="../en/mod/mod_authz_dbd.html" title="English">&nbsp;en&nbsp;</a></p>
 </div>
 <table class="module"><tr><th><a href="module-dict.html#Description">Description:</a></th><td>Group Authorization and Login using SQL</td></tr>
 <tr><th><a href="module-dict.html#Status">Status:</a></th><td>Extension</td></tr>
 <tr><th><a href="module-dict.html#ModuleIdentifier">Module Identifier:</a></th><td>authz_dbd_module</td></tr>
 <tr><th><a href="module-dict.html#SourceFile">Source File:</a></th><td>mod_authz_dbd.c</td></tr>
 <tr><th><a href="module-dict.html#Compatibility">Compatibility:</a></th><td>Available in Apache 2.4 and later</td></tr></table>
 <h3>Summary</h3>

     <p>This module provides authorization capabilities so that
        authenticated users can be allowed or denied access to portions
        of the web site by group membership.  Similar functionality is
        provided by <code class="module"><a href="../mod/mod_authz_groupfile.html">mod_authz_groupfile</a></code> and
        <code class="module"><a href="../mod/mod_authz_dbm.html">mod_authz_dbm</a></code>, with the exception that
        this module queries a SQL database to determine whether a
        user is a member of a group.</p>
     <p>This module can also provide database-backed user login/logout
        capabilities.  These are likely to be of most value when used
        in conjunction with <code class="module"><a href="../mod/mod_authn_dbd.html">mod_authn_dbd</a></code>.</p>
     <p>This module relies on <code class="module"><a href="../mod/mod_dbd.html">mod_dbd</a></code> to specify
        the backend database driver and connection parameters, and
        manage the database connections.</p>
 </div>
 <div id="quickview"><h3 class="directives">Directives</h3>
 <ul id="toc">
 <li><img alt="" src="../images/down.gif" /> <a href="#authzdbdlogintoreferer">AuthzDBDLoginToReferer</a></li>
 <li><img alt="" src="../images/down.gif" /> <a href="#authzdbdquery">AuthzDBDQuery</a></li>
 <li><img alt="" src="../images/down.gif" /> <a href="#authzdbdredirectquery">AuthzDBDRedirectQuery</a></li>
 </ul>
 <h3>Topics</h3>
 <ul id="topics">
 <li><img alt="" src="../images/down.gif" /> <a href="#login">Database Login</a></li>
 <li><img alt="" src="../images/down.gif" /> <a href="#client">Client Login</a></li>
 <li><img alt="" src="../images/down.gif" /> <a href="#example">Configuration Example</a></li>
 </ul><h3>See also</h3>
 <ul class="seealso">
 <li><code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code></li>
 <li>
   <code class="directive"><a href="../mod/mod_authn_dbd.html#authdbduserpwquery">AuthDBDUserPWQuery</a></code>
 </li>
 <li><code class="directive"><a href="../mod/mod_dbd.html#dbdriver">DBDriver</a></code></li>
 <li><code class="directive"><a href="../mod/mod_dbd.html#dbdparams">DBDParams</a></code></li>
 </ul></div>
 <div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="section">
 <h2><a name="login" id="login">Database Login</a></h2>

 <p>
 In addition to the standard authorization function of checking group
 membership, this module can also provide server-side user session
 management via database-backed login/logout capabilities.
 Specifically, it can update a user's session status in the database
 whenever the user visits designated URLs (subject of course to users
 supplying the necessary credentials).</p>
 <p>This works by defining two special
 <code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code> types:
 <code>Require dbd-login</code> and <code>Require dbd-logout</code>.
 For usage details, see the configuration example below.</p>
 </div><div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="section">
 <h2><a name="client" id="client">Client Login</a></h2>

 <p>Some administrators may wish to implement client-side session
 management that works in concert with the server-side login/logout
 capabilities offered by this module, for example, by setting or unsetting
 an HTTP cookie or other such token when a user logs in or out.
 To support such integration, <code class="module"><a href="../mod/mod_authz_dbd.html">mod_authz_dbd</a></code> exports an
 optional hook that will be run whenever a user's status is updated in
 the database.  Other session management modules can then use the hook
 to implement functions that start and end client-side sessions.</p>
 </div><div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="section">
 <h2><a name="example" id="example">Configuration Example</a></h2>

 <div class="example"><pre>
 # mod_dbd configuration
 DBDriver pgsql
 DBDParams "dbname=apacheauth user=apache pass=xxxxxx"

 DBDMin  4
 DBDKeep 8
 DBDMax  20
 DBDExptime 300

 &lt;Directory /usr/www/my.site/team-private/&gt;
   # mod_authn_core and mod_auth_basic configuration
   # for mod_authn_dbd
   AuthType Basic
   AuthName Team
   AuthBasicProvider dbd

   # mod_authn_dbd SQL query to authenticate a logged-in user
   AuthDBDUserPWQuery \
     "SELECT password FROM authn WHERE user = %s AND login = 'true'"

   # mod_authz_core configuration for mod_authz_dbd
   Require dbd-group team

   # mod_authz_dbd configuration
   AuthzDBDQuery "SELECT group FROM authz WHERE user = %s"

   # when a user fails to be authenticated or authorized,
   # invite them to login; this page should provide a link
   # to /team-private/login.html
   ErrorDocument 401 /login-info.html

   &lt;Files login.html&gt;
     # don't require user to already be logged in!
     AuthDBDUserPWQuery \
       "SELECT password FROM authn WHERE user = %s"

     # dbd-login action executes a statement to log user in
     Require dbd-login
     AuthzDBDQuery \
       "UPDATE authn SET login = 'true' WHERE user = %s"

     # return user to referring page (if any) after
     # successful login
     AuthzDBDLoginToReferer On
   &lt;/Files&gt;

   &lt;Files logout.html&gt;
     # dbd-logout action executes a statement to log user out
     Require dbd-logout
     AuthzDBDQuery \
       "UPDATE authn SET login = 'false' WHERE user = %s"
   &lt;/Files&gt;
 &lt;/Directory&gt;
 </pre></div>
 </div>
 <div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="directive-section"><h2><a name="AuthzDBDLoginToReferer" id="AuthzDBDLoginToReferer">AuthzDBDLoginToReferer</a> <a name="authzdbdlogintoreferer" id="authzdbdlogintoreferer">Directive</a></h2>
 <table class="directive">
 <tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Determines whether to redirect the Client to the Referring
 page on successful login or logout if a <code>Referer</code> request
 header is present</td></tr>
 <tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDLoginToReferer On|Off</code></td></tr>
 <tr><th><a href="directive-dict.html#Default">Default:</a></th><td><code>AuthzDBDLoginToReferer Off</code></td></tr>
 <tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
 <tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
 <tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
 </table>
     <p>In conjunction with <code>Require dbd-login</code> or
     <code>Require dbd-logout</code>, this provides the option to
     redirect the client back to the Referring page (the URL in
     the <code>Referer</code> HTTP request header, if present).
     When there is no <code>Referer</code> header,
     <code>AuthzDBDLoginToReferer On</code> will be ignored.</p>

 </div>
 <div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="directive-section"><h2><a name="AuthzDBDQuery" id="AuthzDBDQuery">AuthzDBDQuery</a> <a name="authzdbdquery" id="authzdbdquery">Directive</a></h2>
 <table class="directive">
 <tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Specify the SQL Query for the required operation</td></tr>
 <tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDQuery <var>query</var></code></td></tr>
 <tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
 <tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
 <tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
 </table>
     <p>The <code class="directive">AuthzDBDQuery</code> specifies an SQL
     query to run.  The purpose of the query depends on the
     <code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code> directive in
     effect.</p>
     <ul>
     <li>When used with a <code>Require dbd-group</code> directive,
     it specifies a query to look up groups for the current user.  This is
     the standard functionality of other authorization modules such as
     <code class="module"><a href="../mod/mod_authz_groupfile.html">mod_authz_groupfile</a></code> and <code class="module"><a href="../mod/mod_authz_dbm.html">mod_authz_dbm</a></code>.
     The first column value of each row returned by the query statement
     should be a string containing a group name.  Zero, one, or more rows
     may be returned.
     <div class="example"><h3>Example</h3><pre>
 Require dbd-group
 AuthzDBDQuery \
   "SELECT group FROM groups WHERE user = %s"
 </pre></div>
     </li>
     <li>When used with a <code>Require dbd-login</code> or
     <code>Require dbd-logout</code> directive, it will never deny access,
     but will instead execute a SQL statement designed to log the user
     in or out.  The user must already be authenticated with
     <code class="module"><a href="../mod/mod_authn_dbd.html">mod_authn_dbd</a></code>.
     <div class="example"><h3>Example</h3><pre>
 Require dbd-login
 AuthzDBDQuery \
   "UPDATE authn SET login = 'true' WHERE user = %s"
 </pre></div>
     </li>
     </ul>
     <p>In all cases, the user's ID will be passed as a single string
     parameter when the SQL query is executed.  It may be referenced within
     the query statement using a <code>%s</code> format specifier.</p>

 </div>
 <div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
 <div class="directive-section"><h2><a name="AuthzDBDRedirectQuery" id="AuthzDBDRedirectQuery">AuthzDBDRedirectQuery</a> <a name="authzdbdredirectquery" id="authzdbdredirectquery">Directive</a></h2>
 <table class="directive">
 <tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Specify a query to look up a login page for the user</td></tr>
 <tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDRedirectQuery <var>query</var></code></td></tr>
 <tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
 <tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
 <tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
 </table>
     <p>Specifies an optional SQL query to use after successful login
     (or logout) to redirect the user to a URL, which may be
     specific to the user.  The user's ID will be passed as a single string
     parameter when the SQL query is executed.  It may be referenced within
     the query statement using a <code>%s</code> format specifier.</p>
     <div class="example"><h3>Example</h3><pre>
 AuthzDBDRedirectQuery \
   "SELECT userpage FROM userpages WHERE user = %s"
 </pre></div>
     <p>The first column value of the first row returned by the query
     statement should be a string containing a URL to which to redirect
     the client.  Subsequent rows will be ignored.  If no rows are returned,
     the client will not be redirected.</p>
     <p>Note that <code class="directive">AuthzDBDLoginToReferer</code> takes
     precedence if both are set.</p>

 </div>
 </div>
 <div class="bottomlang">
 <p><span>Available Languages: </span><a href="../en/mod/mod_authz_dbd.html" title="English">&nbsp;en&nbsp;</a></p>
 </div><div id="footer">
 <p class="apache">Copyright 2011 The Apache Software Foundation.<br />Licensed under the <a href="http://www.apache.org/licenses/LICENSE-2.0">Apache License, Version 2.0</a>.</p>
 <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>
 </body></html>
	<?xml version="1.0" encoding="ISO-8859-1"?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"><head><!--
	XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
	This file is generated from xml source: DO NOT EDIT
	XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
	-->
	<title>mod_authz_dbd - Apache HTTP Server</title>
	<link href="../style/css/manual.css" rel="stylesheet" media="all" type="text/css" title="Main stylesheet" />
	<link href="../style/css/manual-loose-100pc.css" rel="alternate stylesheet" media="all" type="text/css" title="No Sidebar - Default font size" />
	<link href="../style/css/manual-print.css" rel="stylesheet" media="print" type="text/css" />
	<link href="../images/favicon.ico" rel="shortcut icon" /></head>
	<body>
	<div id="page-header">
	<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>
	<p class="apache">Apache HTTP Server Version 2.3</p>
	<img alt="" src="../images/feather.gif" /></div>
	<div class="up"><a href="./"><img title="<-" alt="<-" src="../images/left.gif" /></a></div>
	<div id="path">
	<a href="http://www.apache.org/">Apache</a> > <a href="http://httpd.apache.org/">HTTP Server</a> > <a href="http://httpd.apache.org/docs/">Documentation</a> > <a href="../">Version 2.3</a> > <a href="./">Modules</a></div>
	<div id="page-content">
	<div id="preamble"><h1>Apache Module mod_authz_dbd</h1>
	<div class="toplang">
	<p><span>Available Languages: </span><a href="../en/mod/mod_authz_dbd.html" title="English"> en </a></p>
	</div>
	<table class="module"><tr><th><a href="module-dict.html#Description">Description:</a></th><td>Group Authorization and Login using SQL</td></tr>
	<tr><th><a href="module-dict.html#Status">Status:</a></th><td>Extension</td></tr>
	<tr><th><a href="module-dict.html#ModuleIdentifier">Module Identifier:</a></th><td>authz_dbd_module</td></tr>
	<tr><th><a href="module-dict.html#SourceFile">Source File:</a></th><td>mod_authz_dbd.c</td></tr>
	<tr><th><a href="module-dict.html#Compatibility">Compatibility:</a></th><td>Available in Apache 2.4 and later</td></tr></table>
	<h3>Summary</h3>

	<p>This module provides authorization capabilities so that
	authenticated users can be allowed or denied access to portions
	of the web site by group membership. Similar functionality is
	provided by <code class="module"><a href="../mod/mod_authz_groupfile.html">mod_authz_groupfile</a></code> and
	<code class="module"><a href="../mod/mod_authz_dbm.html">mod_authz_dbm</a></code>, with the exception that
	this module queries a SQL database to determine whether a
	user is a member of a group.</p>
	<p>This module can also provide database-backed user login/logout
	capabilities. These are likely to be of most value when used
	in conjunction with <code class="module"><a href="../mod/mod_authn_dbd.html">mod_authn_dbd</a></code>.</p>
	<p>This module relies on <code class="module"><a href="../mod/mod_dbd.html">mod_dbd</a></code> to specify
	the backend database driver and connection parameters, and
	manage the database connections.</p>
	</div>
	<div id="quickview"><h3 class="directives">Directives</h3>
	<ul id="toc">
	<li><img alt="" src="../images/down.gif" /> <a href="#authzdbdlogintoreferer">AuthzDBDLoginToReferer</a></li>
	<li><img alt="" src="../images/down.gif" /> <a href="#authzdbdquery">AuthzDBDQuery</a></li>
	<li><img alt="" src="../images/down.gif" /> <a href="#authzdbdredirectquery">AuthzDBDRedirectQuery</a></li>
	</ul>
	<h3>Topics</h3>
	<ul id="topics">
	<li><img alt="" src="../images/down.gif" /> <a href="#login">Database Login</a></li>
	<li><img alt="" src="../images/down.gif" /> <a href="#client">Client Login</a></li>
	<li><img alt="" src="../images/down.gif" /> <a href="#example">Configuration Example</a></li>
	</ul><h3>See also</h3>
	<ul class="seealso">
	<li><code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code></li>
	<li>
	<code class="directive"><a href="../mod/mod_authn_dbd.html#authdbduserpwquery">AuthDBDUserPWQuery</a></code>
	</li>
	<li><code class="directive"><a href="../mod/mod_dbd.html#dbdriver">DBDriver</a></code></li>
	<li><code class="directive"><a href="../mod/mod_dbd.html#dbdparams">DBDParams</a></code></li>
	</ul></div>
	<div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="section">
	<h2><a name="login" id="login">Database Login</a></h2>

	<p>
	In addition to the standard authorization function of checking group
	membership, this module can also provide server-side user session
	management via database-backed login/logout capabilities.
	Specifically, it can update a user's session status in the database
	whenever the user visits designated URLs (subject of course to users
	supplying the necessary credentials).</p>
	<p>This works by defining two special
	<code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code> types:
	<code>Require dbd-login</code> and <code>Require dbd-logout</code>.
	For usage details, see the configuration example below.</p>
	</div><div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="section">
	<h2><a name="client" id="client">Client Login</a></h2>

	<p>Some administrators may wish to implement client-side session
	management that works in concert with the server-side login/logout
	capabilities offered by this module, for example, by setting or unsetting
	an HTTP cookie or other such token when a user logs in or out.
	To support such integration, <code class="module"><a href="../mod/mod_authz_dbd.html">mod_authz_dbd</a></code> exports an
	optional hook that will be run whenever a user's status is updated in
	the database. Other session management modules can then use the hook
	to implement functions that start and end client-side sessions.</p>
	</div><div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="section">
	<h2><a name="example" id="example">Configuration Example</a></h2>

	<div class="example"><pre>
	# mod_dbd configuration
	DBDriver pgsql
	DBDParams "dbname=apacheauth user=apache pass=xxxxxx"

	DBDMin 4
	DBDKeep 8
	DBDMax 20
	DBDExptime 300

	<Directory /usr/www/my.site/team-private/>
	# mod_authn_core and mod_auth_basic configuration
	# for mod_authn_dbd
	AuthType Basic
	AuthName Team
	AuthBasicProvider dbd

	# mod_authn_dbd SQL query to authenticate a logged-in user
	AuthDBDUserPWQuery \
	"SELECT password FROM authn WHERE user = %s AND login = 'true'"

	# mod_authz_core configuration for mod_authz_dbd
	Require dbd-group team

	# mod_authz_dbd configuration
	AuthzDBDQuery "SELECT group FROM authz WHERE user = %s"

	# when a user fails to be authenticated or authorized,
	# invite them to login; this page should provide a link
	# to /team-private/login.html
	ErrorDocument 401 /login-info.html

	<Files login.html>
	# don't require user to already be logged in!
	AuthDBDUserPWQuery \
	"SELECT password FROM authn WHERE user = %s"

	# dbd-login action executes a statement to log user in
	Require dbd-login
	AuthzDBDQuery \
	"UPDATE authn SET login = 'true' WHERE user = %s"

	# return user to referring page (if any) after
	# successful login
	AuthzDBDLoginToReferer On
	</Files>

	<Files logout.html>
	# dbd-logout action executes a statement to log user out
	Require dbd-logout
	AuthzDBDQuery \
	"UPDATE authn SET login = 'false' WHERE user = %s"
	</Files>
	</Directory>
	</pre></div>
	</div>
	<div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="directive-section"><h2><a name="AuthzDBDLoginToReferer" id="AuthzDBDLoginToReferer">AuthzDBDLoginToReferer</a> <a name="authzdbdlogintoreferer" id="authzdbdlogintoreferer">Directive</a></h2>
	<table class="directive">
	<tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Determines whether to redirect the Client to the Referring
	page on successful login or logout if a <code>Referer</code> request
	header is present</td></tr>
	<tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDLoginToReferer On\|Off</code></td></tr>
	<tr><th><a href="directive-dict.html#Default">Default:</a></th><td><code>AuthzDBDLoginToReferer Off</code></td></tr>
	<tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
	<tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
	<tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
	</table>
	<p>In conjunction with <code>Require dbd-login</code> or
	<code>Require dbd-logout</code>, this provides the option to
	redirect the client back to the Referring page (the URL in
	the <code>Referer</code> HTTP request header, if present).
	When there is no <code>Referer</code> header,
	<code>AuthzDBDLoginToReferer On</code> will be ignored.</p>

	</div>
	<div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="directive-section"><h2><a name="AuthzDBDQuery" id="AuthzDBDQuery">AuthzDBDQuery</a> <a name="authzdbdquery" id="authzdbdquery">Directive</a></h2>
	<table class="directive">
	<tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Specify the SQL Query for the required operation</td></tr>
	<tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDQuery <var>query</var></code></td></tr>
	<tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
	<tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
	<tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
	</table>
	<p>The <code class="directive">AuthzDBDQuery</code> specifies an SQL
	query to run. The purpose of the query depends on the
	<code class="directive"><a href="../mod/mod_authz_core.html#require">Require</a></code> directive in
	effect.</p>
	<ul>
	<li>When used with a <code>Require dbd-group</code> directive,
	it specifies a query to look up groups for the current user. This is
	the standard functionality of other authorization modules such as
	<code class="module"><a href="../mod/mod_authz_groupfile.html">mod_authz_groupfile</a></code> and <code class="module"><a href="../mod/mod_authz_dbm.html">mod_authz_dbm</a></code>.
	The first column value of each row returned by the query statement
	should be a string containing a group name. Zero, one, or more rows
	may be returned.
	<div class="example"><h3>Example</h3><pre>
	Require dbd-group
	AuthzDBDQuery \
	"SELECT group FROM groups WHERE user = %s"
	</pre></div>
	</li>
	<li>When used with a <code>Require dbd-login</code> or
	<code>Require dbd-logout</code> directive, it will never deny access,
	but will instead execute a SQL statement designed to log the user
	in or out. The user must already be authenticated with
	<code class="module"><a href="../mod/mod_authn_dbd.html">mod_authn_dbd</a></code>.
	<div class="example"><h3>Example</h3><pre>
	Require dbd-login
	AuthzDBDQuery \
	"UPDATE authn SET login = 'true' WHERE user = %s"
	</pre></div>
	</li>
	</ul>
	<p>In all cases, the user's ID will be passed as a single string
	parameter when the SQL query is executed. It may be referenced within
	the query statement using a <code>%s</code> format specifier.</p>

	</div>
	<div class="top"><a href="#page-header"><img alt="top" src="../images/up.gif" /></a></div>
	<div class="directive-section"><h2><a name="AuthzDBDRedirectQuery" id="AuthzDBDRedirectQuery">AuthzDBDRedirectQuery</a> <a name="authzdbdredirectquery" id="authzdbdredirectquery">Directive</a></h2>
	<table class="directive">
	<tr><th><a href="directive-dict.html#Description">Description:</a></th><td>Specify a query to look up a login page for the user</td></tr>
	<tr><th><a href="directive-dict.html#Syntax">Syntax:</a></th><td><code>AuthzDBDRedirectQuery <var>query</var></code></td></tr>
	<tr><th><a href="directive-dict.html#Context">Context:</a></th><td>directory</td></tr>
	<tr><th><a href="directive-dict.html#Status">Status:</a></th><td>Extension</td></tr>
	<tr><th><a href="directive-dict.html#Module">Module:</a></th><td>mod_authz_dbd</td></tr>
	</table>
	<p>Specifies an optional SQL query to use after successful login
	(or logout) to redirect the user to a URL, which may be
	specific to the user. The user's ID will be passed as a single string
	parameter when the SQL query is executed. It may be referenced within
	the query statement using a <code>%s</code> format specifier.</p>
	<div class="example"><h3>Example</h3><pre>
	AuthzDBDRedirectQuery \
	"SELECT userpage FROM userpages WHERE user = %s"
	</pre></div>
	<p>The first column value of the first row returned by the query
	statement should be a string containing a URL to which to redirect
	the client. Subsequent rows will be ignored. If no rows are returned,
	the client will not be redirected.</p>
	<p>Note that <code class="directive">AuthzDBDLoginToReferer</code> takes
	precedence if both are set.</p>

	</div>
	</div>
	<div class="bottomlang">
	<p><span>Available Languages: </span><a href="../en/mod/mod_authz_dbd.html" title="English"> en </a></p>
	</div><div id="footer">
	<p class="apache">Copyright 2011 The Apache Software Foundation.<br />Licensed under the <a href="http://www.apache.org/licenses/LICENSE-2.0">Apache License, Version 2.0</a>.</p>
	<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>
	</body></html>