<?xml version="1.0" encoding="utf-8"?>
<!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="fr" xml:lang="fr">
<head>
<meta name="generator" content=
"HTML Tidy for Linux/x86 (vers 7 December 2008), see www.w3.org" />
<title>Lemonldap::NG documentation: 4.6-DBI-user-backend.html</title>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
<style type="text/css">
/*<![CDATA[*/
body{
background: #ddd;
font-family: sans-serif;
font-size: 11pt;
padding: 0 50px;
}
div.main-content{
padding: 10px;
background: #fff;
border: 2px #ccc solid;
}
a{
text-decoration: none;
}
p.footer{
text-align: center;
margin: 5px 0 0 0;
}
.heading-1{
text-align: center;
color: orange;
font-variant: small-caps;
font-size: 20pt;
}
.heading-1-1{
color: orange;
font-size: 14pt;
border-bottom: 2px #ccc solid;
}
pre{
background: #eee;
border: 2px #ccc solid;
padding: 5px;
border-left: 10px #ccc solid;
}
ul.star li{
list-style-type: square;
}
/*]]>*/
</style>
</head>
<body>
<div class="main-content">
<h2 class="heading-1"><span id="HDBIuserbackend">DBI user
backend</span></h2>
<p class="paragraph"></p>
<ul>
<li><a href="#HPresentation">Presentation</a></li>
<li>
<a href="#HConfiguration">Configuration</a>
<ul>
<li><a href="#HConnection">Connection</a></li>
<li><a href="#HSchema">Schema</a></li>
<li><a href="#HAttributes">Attributes</a></li>
</ul>
</li>
<li><a href="#HSeealso">See also</a></li>
</ul>
<h3 class="heading-1-1"><span id="HPresentation">Presentation</span></h3>
<p class="paragraph"></p>You can use any database to collect attributes
from authenticated user. All these attributes should be in only one table.
<h3 class="heading-1-1"><span id=
"HConfiguration">Configuration</span></h3>
<p class="paragraph"></p>All configuration is done in Manager, in DBI
parameters. First, choose "DBI" as user module.
<h4 class="heading-1-1-1"><span id="HConnection">Connection</span></h4>
<p class="paragraph"></p>Set how to reach the database:
<ul class="star">
<li><strong class="strong">dbiUserChain</strong>: connection chain,
example: dbi:mysql:database=lemonldapng;host=localhost</li>
<li><strong class="strong">dbiUserUser</strong>: connection user,
example: admin</li>
<li><strong class="strong">dbiUserPassword</strong>: connection
password, example: secret</li>
</ul>If you already use <span class="wikilink"><a href=
"4.5-DBI-authentication-backend.html">DBI as authentication
backend</a></span>, you can rely on its configuration and let previous
parameters empty.
<h4 class="heading-1-1-1"><span id="HSchema">Schema</span></h4>
<p class="paragraph"></p>Describe your database:
<ul class="star">
<li><strong class="strong">dbiUserTable</strong>: table name where to
find user attributes</li>
<li><strong class="strong">userPivot</strong>: column associated with
user login</li>
</ul>If you already use <span class="wikilink"><a href=
"4.5-DBI-authentication-backend.html">DBI as authentication
backend</a></span>, you can rely on its configuration and let previous
parameters empty (it will use the same table as authentication table).
<h4 class="heading-1-1-1"><span id="HAttributes">Attributes</span></h4>
<p class="paragraph"></p>Edit exported attributes to map local variables
with column names.
<h3 class="heading-1-1"><span id="HSeealso">See also</span></h3>
<ul class="star">
<li><span class="wikilink"><a href=
"4.5-DBI-authentication-backend.html">Auth DBI</a></span></li>
<li><span class="wikilink"><a href=
"4.7-DBI-password-backend.html">Password DBDBI</a></span></li>
</ul>
</div>
<p class="footer"><a href="index.html">Index</a></p>
</body>
</html>
