<?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.5-DBI-authentication-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="HDBIauthenticationbackend">DBI authentication 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="#HPassword">Password</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>This backend relies on Perl DBI modules to connect any supported database product (MySQL, PostGRESQL, Oracle, etc.) <p class="paragraph"></p>We suppose there is a table containing a login column and a password column. Password can use a hash mechanism, compatible with an SQL function (example: sha(), sha1(), md5()). <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 authentication 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">dbiAuthChain</strong>: connection chain, example: dbi:mysql:database=lemonldapng;host=localhost</li> <li><strong class="strong">dbiAuthUser</strong>: connection user, example: admin</li> <li><strong class="strong">dbiAuthPassword</strong>: connection password, example: secret</li> </ul> <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">dbiAuthTable</strong>: table name where to find logins and passwords</li> <li><strong class="strong">dbiAuthLoginCol</strong>: login field name</li> <li><strong class="strong">dbiAuthPasswordCol</strong>: password field name</li> </ul> <h4 class="heading-1-1-1"><span id="HPassword">Password</span></h4> <p class="paragraph"></p>Set the hash mechanism to use: <ul class="star"> <li><strong class="strong">dbiAuthPasswordHash</strong>: hash function, example: md5</li> </ul> <h3 class="heading-1-1"><span id="HSeealso">See also</span></h3> <ul class="star"> <li><span class="wikilink"><a href="4.6-DBI-user-backend.html">User DBDBI</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>